Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fredforfree
Starting Member
49 Posts |
 Posted - 2009-07-10 : 12:01:29
|
| Hi, hoping someone can helpI have the server and databaes set correctly in solutions explorer but keep getting all this error when i process and deploy cube.<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" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2"> <Object> <DatabaseID>TartgetDataMart</DatabaseID> <CubeID>Target Data Mart</CubeID> </Object> <Type>ProcessFull</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel></Batch> Processing Dimension 'Dim Target Category' completed successfully. Start time: 07-10-2009 11:57:29 AM; End time: 07-10-2009 11:57:29 AM; Duration: 0:00:00 Processing Dimension Attribute '(All)' completed successfully. Start time: 07-10-2009 11:57:29 AM; End time: 07-10-2009 11:57:29 AM; Duration: 0:00:00 Processing Dimension Attribute 'Target Category' completed successfully. Start time: 07-10-2009 11:57:29 AM; End time: 07-10-2009 11:57:29 AM; Duration: 0:00:00 Processing Dimension Attribute 'ETL Date Hour Import' completed successfully. Start time: 07-10-2009 11:57:29 AM; End time: 07-10-2009 11:57:29 AM; Duration: 0:00:00 Processing Dimension 'Dim Time' completed successfully. Start time: 07-10-2009 11:57:29 AM; End time: 07-10-2009 11:57:29 AM; Duration: 0:00:00 Processing Dimension Attribute '(All)' completed successfully. Start time: 07-10-2009 11:57:29 AM; End time: 07-10-2009 11:57:29 AM; Duration: 0:00:00Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.; 28000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Target Data Mart', Name of 'Target Data Mart'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Target Category', Name of 'Dim Target Category' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Target Category' attribute of the 'Dim Target Category' dimension from the 'TartgetDataMart' database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.; 28000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Target Data Mart', Name of 'Target Data Mart'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Target Category', Name of 'Dim Target Category' was being processed. Errors in the OLAP storage engine: An error occurred while the 'ETL Date Hour Import' attribute of the 'Dim Target Category' dimension from the 'TartgetDataMart' database was being processed.Anybody understand what is happeningFredforfreeFred |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-10 : 13:15:02
|
| the error message suggests its problme with Dim Target Category. did you have a look at the dimension data to spot any problemsalso was the dimension Dim Target Category changed lately? |
 |
|
|
|
|
|
Process Deploy Errors