dbTalk Databases Forums  

Error 80004005 An unexpected internal error has occured

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Error 80004005 An unexpected internal error has occured in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Terry
 
Posts: n/a

Default Error 80004005 An unexpected internal error has occured - 10-21-2003 , 10:09 AM






Hi all,

I'm trying to open a cellset and this error message returns after a
certain amount of time (~20 secs). The MDX I'm executing is:

SELECT NON EMPTY([Measures].Members) ON COLUMNS, NON EMPTY
(Descendants ([Company].[All Company], [Company].[(All)], AFTER) *
Descendants ([Counterparty].[All Counterparty],
[Counterparty].[(All)], AFTER) * Descendants ([Account].[All Account],
[Account].[Parent Accounts], AFTER)* Descendants ([Currency].[All
Currency], [Currency].[(All)], AFTER)) ON ROWS FROM ChildTemp WHERE
([Period].[Jan 03])


Admittedly I have a lot of dimensions on one axis, but I do need them
there.

I'm presuming that this is some problem with the amount of data I'm
trying to return. Any ideas of how to get around this problem? Will I
have to try and split up my MDX so as not to crossjoin so many
dimensions on the rows?

Regards

Terry Maguire

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.