BAM – The query could not be processed

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BAM – The query could not be processed

Viewing 4 reply threads
  • Author
    Posts
    • August 25, 2006 at 2:45 PM #15464
      community-content

        I have deploy successfully an activity-view to my BAM. I am using BTS2006 with SQL2005.

        On the BAM portal, I receive the following error when trying to access the aggregation section (pivot table):

        The query could not be processed. Cannot connect to the server ‘servername’. The server is either not started or too busy.

        The connection string and permission should be fine since a have no problem with the search section of my view.

        Did someone already had this problem. Thanks for your help.

      • August 25, 2006 at 5:38 PM #15465
        community-content

          More Information on how the error occur:

          I click on aggregation, then pivot table 1. The I get a popup from MS Office Web Component saying:

          This website uses a data rpovider that may be unsafe. If you trust the website, click ok. Otherwise click cancel.

          When I click ok I receive the error explained in previous post. It appears directly inside the OWC pivot table. Maybe this is caused by some security setting I need to do on server or client ?

          Fred

        • September 7, 2006 at 12:21 PM #15606
          community-content

            I am still having this problem.

            "The query could not be processed. Cannot connect to the server 'servername'. The server is either not started or too busy"

             I know for sure that my cubes/dimensions are set properly since I can browse them through analysys services and also from the excel live file generated by BM -deploy statement.

            It is probably not a version problem since I use the last version of OWC (version 11) with SQL 2005.

            It migth be a permission error. Do we have to grant some permission in order to make the BAM working? I have already grant the permission to the view with the … BM add-account -AccountName:<account name> -View:MyView

            Do I have to set other permissions?

             Thanks.

          • September 21, 2006 at 6:32 AM #15781
            community-content

              I have found the solution.

               I had to install oledb9.0 for analysis servises on the client (where the browser runs). That means I have to do this install on all the potential BAM users 🙁

            • March 1, 2007 at 6:43 AM #17829
              community-content

                I got the same problem and have no idea how to fix it. I tried to give full permission on every related databases but it didn't  cha,ge anything.

                Does anybody have any idea?

                Thanks for your help.

                • March 1, 2007 at 6:46 AM #17830
                  community-content

                    I got it!! My database is an IBM one… So i fixed it with the DB2OLEDB9…

                     

              • Author
                Posts
              Viewing 4 reply threads
              • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.