|
Home > Archive > MS SQL Server OLAP > January 2006 > ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ADOMD cellset throws "Internal error" when runing long mdx, under IIS/COM+
|
|
|
| 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.
| |
| Vladimir Chtepa 2006-01-24, 9:24 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@retalix.com> schrieb im Newsbeitrag
news:1138004558.934396.249680@g14g2000cwa.googlegroups.com...
> 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.
>
| |
|
| I don't think so, since smaller MDX's run just fine under asp.net.
| |
| Vladimir Chtepa 2006-01-26, 4:58 pm |
| 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@retalix.com> schrieb im Newsbeitrag
news:1138188122.610965.238150@g44g2000cwa.googlegroups.com...
>I don't think so, since smaller MDX's run just fine under asp.net.
>
| |
|
| 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
|
|
|
|
|