 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Data Warehousing / February 2005The query could not be processed
Hello, I have 2 cubes, one runs smootly and another one has an error message 'The query could not be processed : The data provider didn't supply any further error information' Anyone know how to solve it, please let me know. Your advice would be appreciated. Thank you and Have a nice day! Kit What is the data source for the cube that returns an error? SQL Server 2000? Oracle? or what?  SignatureDave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. > Hello, > [quoted text clipped - 8 lines] > > Kit Hi Dave, The data source is SQL Server 2000. And the OS is Windows Server 2003. Thank you. Kit >-----Original Message----- >What is the data source for the cube that returns an error? [quoted text clipped - 13 lines] > >. We can certainly load from SQL Server -- we do it all of the time. There must be some other configuration which is different between the two. Are they running the same MDAC stack? Can you provide more specifics? SignatureDave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. > Hi Dave, > [quoted text clipped - 26 lines] > > > >. Hi Dave, Yes, they are running the same MDAC stack. I would like to tell you that all pcs that process the same cube use Windows XP, Office XP (by Pivot Table) and has installed OWC10 already. The trouble cube can be viewed in other pcs normally. So, I'm not sure some configuration in OS has some discrepancy. Please advice. Have a nice day, Kit >-----Original Message----- >We can certainly load from SQL Server -- we do it all of the time. [quoted text clipped - 33 lines] > >. In your original posting you said "I have 2 cubes, one runs smootly and another one has an error message 'The query could not be processed : The data provider didn't supply any further error information' Can you tell me more about the conditions when the error occurs on the second cube? For example, does the second cube return the same error regardless of what PCs query it? Can a PC which has an error on the second cube, can same PC query the first cube? SignatureDave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. > Hi Dave, > [quoted text clipped - 55 lines] > > > >. Hi Dave, Sorry, I did not explain you clearly due to my English is limited. Please let me to attempt to re-explain. 2 Cubes that I have are run under the same database. I don't have any special conditions. I accessed cubes using Pivot Table on a client site. The first cube has been processed well. On the other hand, when I tried to process the second cube, the error that is 'The query could not be processed : The data provider didn't supply any further error information' has been appeared. After that, I changed to other client pcs, there are no any errors for both cubes. All client pcs have been installed OWC10.exe, IE Version 6 as well as MS Office XP. And Cubes' Database Role Manager in AM are set for Guests. Thank you for your assistance. Kit >-----Original Message----- >In your original posting you said "I have 2 cubes, one runs smootly and [quoted text clipped - 68 lines] > >. Are the errors returned when you "process" the cube using Analysis Manager or when you "query" the cube using OWC? SignatureDave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. > Hi Dave, > [quoted text clipped - 109 lines] > > > >. The errers returned when I "query" the cube on IE (Pivot Table) using OWC. >-----Original Message----- >Are the errors returned when you "process" the cube using Analysis Manager [quoted text clipped - 114 lines] > >. From the PCs that are getting errors, can you see and query other cubes, e.g. Foodmart? Or is this error only being returned for this one cube? SignatureDave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. > The errers returned when I "query" the cube on IE (Pivot > Table) using OWC. [quoted text clipped - 141 lines] > > > >. I can see and query other cubes except the cube that returned the error. >-----Original Message----- >From the PCs that are getting errors, can you see and query other cubes, [quoted text clipped - 146 lines] > >. Very strange. What is different about that cube? Other PCs can access it, but some can't. They are all running the same version of PTS (all ran the SP3 version of ptslite.exe from the SP3 distribution in the \msolap\install\pts folder). All are running the same version of OWC. I assume that all of these are on the same domain and the same user is accessing the cube -- you might check the security setups if this isn't the case. SignatureDave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. > I can see and query other cubes except the cube that > returned the error. [quoted text clipped - 176 lines] > > > >. Those cubes are built from the same database. Anyway, I will check the security setups and inform you the result. Dave, Thank you for your help. Kit >-----Original Message----- >Very strange. What is different about that cube? Other PCs can access it, [quoted text clipped - 186 lines] > >. Hi, I am also running with the same issue.It is working fine most of the PCs but failing in only one PC with the same error. But when i have try to access same cube in Excel it works fine. Any solution?? Thanks Robert -- POST BY: http://www.dotNET.us - Need .NET? Just ask, Please dotNET.us |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.