December 9, 2013 at 2:17 am
Hi Guys
I am trying to process TFS_Analysis in Analysis services of SQL databases.
When i start to add any role like 'Tfs DatawarehouseReader' in to ROLE portion of TFS_Analysis ,
The following service get stop. 'I think There is data corruption in the Analysis Services database.'
SQL Server Analysis Services (MSSQLSERVER)
Similarly , when i go into event logs it looks like below:::::
Log Name: Application
Source: MSSQLServerOLAPService
Date: 12/9/2013 2:03:08 AM
Event ID: 22
Task Category: (256)
Level: Error
Keywords: Classic
User: N/A
Computer: CMDLHRTFS02.curemd.com
Description:
The description for Event ID 22 from source MSSQLServerOLAPService cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
Errors in the encryption library: Failed to decrypt sensitive data. Possibly the encryption key does not match or is inaccessible because of improper service account change.
the message resource is present but the message is not found in the string/message table
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLServerOLAPService" />
<EventID Qualifiers="49408">22</EventID>
<Level>2</Level>
<Task>256</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-12-09T07:03:08.000Z" />
<EventRecordID>1259826</EventRecordID>
<Channel>Application</Channel>
<Computer>CMDLHRTFS02.curemd.com</Computer>
<Security />
</System>
<EventData>
<Data>Errors in the encryption library: Failed to decrypt sensitive data. Possibly the encryption key does not match or is inaccessible because of improper service account change.</Data>
</EventData>
</Event>
Moreover , I have to start this ervice again and again but there is something getting out of the box stopping my Service periodically.
WHY??
Thanks
Waseem Bukhari
December 9, 2013 at 6:54 am
Pls explain your query?
December 9, 2013 at 8:26 am
Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: Snapshot isolation transaction failed in database 'Tfs_Warehouse' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.; 42000.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Previous State' attribute of the 'Work Item' dimension from the 'Tfs_analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: The server failed to resume the transaction. Desc:7d00000001.; 42000; The transaction active in this session has been committed or aborted by another session.; 01000.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'System_AssignedTo' attribute of the 'Work Item' dimension from the 'Tfs_analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: The server failed to resume the transaction. Desc:7d00000001.; 42000; The transaction active in this session has been committed or aborted by another session.; 01000.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'System_WorkItemType' attribute of the 'Work Item' dimension from the 'Tfs_analysis' database was being processed.
Server: The operation has been cancelled.
OLE DB error: OLE DB or ODBC error: The server failed to resume the transaction. Desc:7d00000001.; 42000; The transaction active in this session has been committed or aborted by another session.; 01000.
and bla bla bla ....
December 9, 2013 at 8:45 am
Your problem is described and diagnosed here: http://stackoverflow.com/questions/9668615/cant-reload-our-tfs-analysis-cube-due-to-snapshot-isolation
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply