August 19, 2014 at 7:50 am
Hello,
I just finished migrating SQL 2005 - 2012 and I am having issues processing my cubes. I included the error message below with generic names, but I think it should be transparent. I seem to be having an issue with one of the logins, but I have no idea which one. The error message points to "domain_name\server_name$" with a $ at the end. I am assuming this is a SQL login?
I have included the error message below and thanks for your time!
<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" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300">
<Object>
<DatabaseID>SSAS_DB</DatabaseID>
<CubeID>1</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Dimension 'Company Activities Applications' completed.
Start time: 8/19/2014 9:20:46 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed.
Start time: 8/19/2014 9:20:46 AM; End time: 8/19/2014 9:20:46 AM; Duration: 0:00:00
Processing Dimension Attribute 'Application ID' completed.
Start time: 8/19/2014 9:20:48 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:01
Processing Dimension Attribute 'Application Name' completed.
Start time: 8/19/2014 9:20:46 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute 'Software Access' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute 'Software Source' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension 'Company Activities Assertions' completed.
Start time: 8/19/2014 9:20:46 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed.
Start time: 8/19/2014 9:20:46 AM; End time: 8/19/2014 9:20:46 AM; Duration: 0:00:00
Processing Dimension Attribute 'Assertion' completed.
Start time: 8/19/2014 9:20:46 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute 'Assertion Text' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension 'Company Activities Ctrl Objectives' completed.
Start time: 8/19/2014 9:20:48 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:01
Processing Dimension 'Company Activities Documents' completed.
Start time: 8/19/2014 9:20:46 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:47 AM; Duration: 0:00:00
Processing Dimension Attribute 'Document Text' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute 'URL' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension 'Company Activity Assessments' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:49 AM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed.
Start time: 8/19/2014 9:20:47 AM; End time: 8/19/2014 9:20:48 AM; Duration: 0:00:01
Errors and Warnings from Response
Server: The current operation was cancelled because another operation in the transaction failed.
Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Applications All', Name of 'Company Activities Applications' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Application Name' attribute of the 'Company Activities Applications' dimension from the 'SSAS_DB' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Documents All', Name of 'Company Activities Documents' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'URL' attribute of the 'Company Activities Documents' dimension from the 'SSAS_DB' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Applications All', Name of 'Company Activities Applications' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Software Source' attribute of the 'Company Activities Applications' dimension from the 'SSAS_DB' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Applications All', Name of 'Company Activities Applications' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Application ID' attribute of the 'Company Activities Applications' dimension from the 'SSAS_DB' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Documents All', Name of 'Company Activities Documents' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Document Text' attribute of the 'Company Activities Documents' dimension from the 'SSAS_DB' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Applications All', Name of 'Company Activities Applications' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Software Access' attribute of the 'Company Activities Applications' dimension from the 'SSAS_DB' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Assertions All', Name of 'Company Activities Assertions' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Assertion' attribute of the 'Company Activities Assertions' dimension from the 'SSAS_DB' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'domain_name\server_name$'.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '1', Name of '1'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Vw Company Activities With Assertions All', Name of 'Company Activities Assertions' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Assertion Text' attribute of the 'Company Activities Assertions' dimension from the 'SSAS_DB' database was being processed.
Everyone has a plan until they get punched in the mouth. --Mike Tyson
August 20, 2014 at 5:32 pm
Maybe your server was over utilized at that time and you exceeded number of Max Threads. See if changing “ThreadPool \ Process \ MaxThreads” and “ThreadPool \ Query \ MaxThreads” parameters on the SSAS server ( I am still on 2008 SSAS) to control number or threads queries can generate and then rebuilt the cube.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply