dbTalk Databases Forums  

ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+

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


Discuss ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+ in the microsoft.public.sqlserver.olap forum.



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

Default ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+ - 01-23-2006 , 02:22 AM






Hello,
I'm runing Analysis services on an XP machine, with AS SP4.
I have a very long MDX query (don't ask why).
When i'm runing this query using ADOMD CellSet object from an asp.net
page (IIS),
I get "internal error" or "unexpected error".

If i'm runing a small MDX queries from the same asp.net page, it runs
fine.

When i'm runing the long MDX query from an EXE application or the
SampleApplication,
It runs fine.

Any help will be wellcome.


Reply With Quote
  #2  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+ - 01-24-2006 , 09:03 AM






Hi

Could it depend on the fact that asp.net uses unicode and the MDX Sample
Application uses single byte charachter?

Chtepa



"yaniv" <yaniv.inbar (AT) retalix (DOT) com> schrieb im Newsbeitrag
news:1138004558.934396.249680 (AT) g14g2000cwa (DOT) googlegroups.com...
Quote:
Hello,
I'm runing Analysis services on an XP machine, with AS SP4.
I have a very long MDX query (don't ask why).
When i'm runing this query using ADOMD CellSet object from an asp.net
page (IIS),
I get "internal error" or "unexpected error".

If i'm runing a small MDX queries from the same asp.net page, it runs
fine.

When i'm runing the long MDX query from an EXE application or the
SampleApplication,
It runs fine.

Any help will be wellcome.




Reply With Quote
  #3  
Old   
yaniv
 
Posts: n/a

Default Re: ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+ - 01-25-2006 , 05:22 AM



I don't think so, since smaller MDX's run just fine under asp.net.


Reply With Quote
  #4  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+ - 01-25-2006 , 06:15 AM



It is clear.
There is restriction 64K for MDX Query size.
You don't get error with small query, but a bigger query runs without error
through MDX Sample Application (single byte char) and don't run through
asp.net (unicode).

"yaniv" <yaniv.inbar (AT) retalix (DOT) com> schrieb im Newsbeitrag
news:1138188122.610965.238150 (AT) g44g2000cwa (DOT) googlegroups.com...
Quote:
I don't think so, since smaller MDX's run just fine under asp.net.




Reply With Quote
  #5  
Old   
yaniv
 
Posts: n/a

Default Re: ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+ - 01-25-2006 , 01:17 PM



Tnx allot - i didn't know there was a 64K MDX limit and i didn't
thought about the unicode option..
I'll try it right a way.

Tnx again


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.