MS SQL Data Warehousing - Parsing error processing cube in SQL 2000 AS SP 3

Author

Parsing error processing cube in SQL 2000 AS SP 3

Andy S.

2006-02-25, 9:28 am

I am trying to process a cube built off 4 smaller cubes in a snowflake
schema. The Design Storage process successfully about 1500 aggregations. I
get all the way in processing to where partitions are going to be built, and
then I get "Relational data provider reported error: [Parsing error occurred
prior to......" followed by links between all the cubes. This error shows
up in NT Event Log as event id 124. All the smaller individual cubes have
been reprocessed successfully. Any ideas?

--
********************
********************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@noreply.yahoo.com
Please remove "noreply" before replying.
********************
********************
*********

Ashok

2006-03-31, 1:23 pm

I am also getting 124 Error "Relational data provider reported error:
[Unspecified error]." I guess it has to do with repository server but don't
know how to fix. I am using SQL Server 2000. AS 2000 SP-4.

Thank you - Ashok

"Andy S." wrote:

> I am trying to process a cube built off 4 smaller cubes in a snowflake
> schema. The Design Storage process successfully about 1500 aggregations. I
> get all the way in processing to where partitions are going to be built, and
> then I get "Relational data provider reported error: [Parsing error occurred
> prior to......" followed by links between all the cubes. This error shows
> up in NT Event Log as event id 124. All the smaller individual cubes have
> been reprocessed successfully. Any ideas?
>
> --
> ********************
********************
*********
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@noreply.yahoo.com
> Please remove "noreply" before replying.
> ********************
********************
*********
>
>
>

Sponsored Links