Hi,

I migrated couple of cubes from MSAS 2000 to MSAS 2005. The first cube
processed fine with MSAS 2005. When i try to process the 2nd cube (10
Partitions), after couple of hours, it comes with the following error.

Parser Error 'Diag'
Parser Error 'Paid'.

I am not sure what is wrong. One thing i observed is, couple of my Measure
names includes the words 'Paid' & 'Diag'.

Then i eliminated those 2 words from the measure names to see if that fixes
the problem. To my surprise it came with the same exact error when i re
processed.

Can you please tell me what this error is?

Thanks,

Prasad.

Do you have all the error messages? Did you try processing the partitions one at a time?

My guess is that you have a named query to a relational database for that partition and that named query may be somehow invalid. Take a look at the query generated by AS against the relational database and see if there is a problem with it...

HTH,
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.


-----Original Message-----
From: Prasad (AT) discussions (DOT) microsoft.com
Posted At: Tuesday, November 08, 2005 1:22 PM
Posted To: microsoft.public.sqlserver.olap
Conversation: MSAS 2005: Parser Error
Subject: MSAS 2005: Parser Error



Hi,

I migrated couple of cubes from MSAS 2000 to MSAS 2005. The first cube processed fine with MSAS 2005. When i try to process the 2nd cube (10 Partitions), after couple of hours, it comes with the following error.

Parser Error 'Diag'
Parser Error 'Paid'.

I am not sure what is wrong. One thing i observed is, couple of my Measure names includes the words 'Paid' & 'Diag'.

Then i eliminated those 2 words from the measure names to see if that fixes the problem. To my surprise it came with the same exact error when i re processed.

Can you please tell me what this error is?

Thanks,

Prasad.