Monday, March 19, 2012

Errors in the OLAP storage engine (first deployment using AdventureWorksDW)

Here are a few of the 24 errors. I looked for missing foreign keys but didn't find any. Any help would be appreciated.
Error 2 OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect.. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 4 Errors in the OLAP storage engine: An error occurred while the 'English Month Name' attribute of the 'Time' dimension from the 'Analysis Services Tutorial' database was being processed. 0 0

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>Analysis Services Tutorial</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Database 'Analysis Services Tutorial' failed.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
Processing Dimension 'Time' failed.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:54 AM; Duration: 0:00:00
Processing Dimension Attribute 'Calendar Year' failed.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[T_0].[CalendarYear] AS [mTime0_0]
FROM [dbo].[DimTime] AS [T_0]
Error Messages 1
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Processing Dimension Attribute 'Calendar Semester' failed.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[T_0].[CalendarSemester] AS [mTime0_0]
FROM [dbo].[DimTime] AS [T_0]
Error Messages 1
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Processing Dimension Attribute 'Calendar Quarter' failed.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[T_0].[CalendarQuarter] AS [mTime0_0]
FROM [dbo].[DimTime] AS [T_0]
Error Messages 1
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Processing Dimension Attribute 'English Month Name' failed.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[T_0].[EnglishMonthName] AS [mTime0_0]
FROM [dbo].[DimTime] AS [T_0]
Error Messages 1
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Processing Dimension Attribute 'Full Date Alternate Key' completed successfully.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
Processing Dimension 'Customer' completed successfully.
Start time: 2/28/2007 10:40:54 AM; End time: 2/28/2007 10:40:55 AM; Duration: 0:00:01
Errors and Warnings from Response
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Calendar Quarter' attribute of the 'Time' dimension from the 'Analysis Services Tutorial' database was being processed.
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Calendar Semester' attribute of the 'Time' dimension from the 'Analysis Services Tutorial' database was being processed.
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'English Month Name' attribute of the 'Time' dimension from the 'Analysis Services Tutorial' database was being processed.
OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Calendar Year' attribute of the 'Time' dimension from the 'Analysis Services Tutorial' database was being processed.

Try copy failing query from the processing log and sending it directly to the relational database.

Looks like it is the first one :

T_0].[CalendarYear] AS [mTime0_0]
FROM [dbo].[DimTime] AS [T_0]

See if you get the same error. It is possible you are not connecting to the same data source, or some of the tables have changed since you've created a project.

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

No comments:

Post a Comment