all groups > sql server data warehouse > january 2005 >
You're in the

sql server data warehouse

group:

The query could not be processed


The query could not be processed Kit
1/27/2005 7:37:20 PM
sql server data warehouse:
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!

Re: The query could not be processed Dave Wickert [MSFT]
1/27/2005 11:44:32 PM
What is the data source for the cube that returns an error?
SQL Server 2000? Oracle? or what?
--
Dave 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.

[quoted text, click to view]

Re: The query could not be processed Kit
1/28/2005 2:40:25 AM
Hi Dave,

The data source is SQL Server 2000. And the OS is
Windows Server 2003.

Thank you.

Kit

[quoted text, click to view]
Re: The query could not be processed Dave Wickert [MSFT]
1/31/2005 1:12:54 PM
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?
--
Dave 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.

[quoted text, click to view]

Re: The query could not be processed Kit
1/31/2005 8:50:25 PM
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



[quoted text, click to view]
Re: The query could not be processed Dave Wickert [MSFT]
2/1/2005 10:25:08 PM
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?

--
Dave 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.

[quoted text, click to view]

Re: The query could not be processed Kit
2/2/2005 12:42:13 AM
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

[quoted text, click to view]
Re: The query could not be processed Dave Wickert [MSFT]
2/2/2005 9:29:33 AM
Are the errors returned when you "process" the cube using Analysis Manager
or when you "query" the cube using OWC?
--
Dave 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.

[quoted text, click to view]

Re: The query could not be processed Kit
2/3/2005 11:37:48 PM
The errers returned when I "query" the cube on IE (Pivot
Table) using OWC.


[quoted text, click to view]
Re: The query could not be processed Dave Wickert [MSFT]
2/4/2005 6:14:59 AM
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?
--
Dave 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.

[quoted text, click to view]

Re: The query could not be processed Kit
2/6/2005 6:43:50 PM
I can see and query other cubes except the cube that
returned the error.


[quoted text, click to view]
Re: The query could not be processed Dave Wickert [MSFT]
2/8/2005 10:49:51 AM
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.
--
Dave 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.

[quoted text, click to view]
Re: The query could not be processed Kit
2/11/2005 1:15:38 AM
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


[quoted text, click to view]
Re: The query could not be processed Robert
2/18/2005 8:57:44 AM
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
--
AddThis Social Bookmark Button