MS SQL Server OLAP - Cryptic error in AS 2005 processing

Author

Cryptic error in AS 2005 processing

James

2005-11-25, 7:24 am

I'm getting the "Internal error: An unexpected exception occured" message
when processing a dimension in AS 2005.
In the "Process Progress" window, all hierarchies say "Completed
successfully", all the queries seem to have worked, at least there is no
error message next to them, and when I run them in QA they work fine.

But at the bottom, under "Errors and Warnings from Response", I get the
"Internal error ...", several times.
I did set up a processing error log in the Change Settings dialog of the
Process Dimension dialog, but the log files stays empty.

Where can I start looking for the cause? Is there a log file where I could
see what AS was trying to do and which error it got?

The error occurs when I replace the test database with the live database (it
has more fact rows) in the data source of the solution. I get no errors with
the test database. So, There must be something wrong with the live database.
I'd just like to know where to start looking.

Both databases are on SQL Server 2005, in 8.0 compatibility mode.

James

2005-11-25, 8:23 pm

Problem disappeared after I processed all dimensions one by one in Management
Studio, and then full processed the cube.
No idea why it didn't work in Visual Studio.

Peter Yang [MSFT]

2005-11-28, 3:24 am

Hello,

Nice to see the issue is resolved.

This internal error might be locking conflict occurs during processing of
the cube. This problem may occur if processing starts before locks are
acquired on objects.

Since error log is empty, to find out the root cause of this issue we may
need to analyze memory dumps, this work has to be done by contacting
Microsoft Product Support Services. Therefore, we probably will not be able
to resolve the issue through the newsgroups.I recommend that you open a
Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

====================
====================
=============

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>Thread-Topic: Cryptic error in AS 2005 processing
>thread-index: AcXyBAW5FfBZdiP7T4OV
LEj4ry6ZbQ==
>X-WBNR-Posting-Host: 84.56.32.28
>From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@nospam.nospam>
>References: <84C5A0BC-C3E3-4118-965F- 45514ECF7C5E@microso
ft.com>
>Subject: RE: Cryptic error in AS 2005 processing
>Date: Fri, 25 Nov 2005 13:05:53 -0800
>Lines: 3
>Message-ID: <44119272-27C7-4636-938C- B5B07E87FC1C@microso
ft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.olap
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:64883
>X-Tomcat-NG: microsoft.public.sqlserver.olap
>
>Problem disappeared after I processed all dimensions one by one in
Management
>Studio, and then full processed the cube.
>No idea why it didn't work in Visual Studio.
>

Akshai Mirchandani [MS]

2005-11-29, 8:24 pm

Btw James, if possible it would be great if you could configure the server
to allow sending error dumps using Watson -- this way the dump file will get
automatically uploaded to the Watson database and we can try to address
commonly hit issues in service packs.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
news:tBgKpt88FHA.4000@TK2MSFTNGXA02.phx.gbl...
> Hello,
>
> Nice to see the issue is resolved.
>
> This internal error might be locking conflict occurs during processing of
> the cube. This problem may occur if processing starts before locks are
> acquired on objects.
>
> Since error log is empty, to find out the root cause of this issue we may
> need to analyze memory dumps, this work has to be done by contacting
> Microsoft Product Support Services. Therefore, we probably will not be
> able
> to resolve the issue through the newsgroups.I recommend that you open a
> Support incident with Microsoft Product Support Services so that a
> dedicated Support Professional can assist with this case. If you need any
> help in this regard, please let me know.
>
> For a complete list of Microsoft Product Support Services phone numbers,
> please go to the following address on the World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ====================
====================
=============
>
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --------------------
> Management
>

Sponsored Links