Deadlocks Processing Cube -
12-27-2006
, 04:01 AM
I have an analysis services 2005 cube that is built every night as part of my
data warehousing processes.
All of the ETL jobs are finished when the cube is being processed, but
intermitently I get process failiures because of deadlock errors.
I can't find anything related to these sorts of errors, so does any kind
soul out there have any pointers for me?
I have attached the full error output at the bottom of the mail, but it is
regularly differant measures or dimensions that are involved in the error.
Thanks in advance for any assistance,
Message
Executed as user: ISD-NR\sqlservice. ...sults
xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root
xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception
xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages
xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error
ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error:
Transaction (Process ID 59) was deadlocked on thread | communication buffer
resources with another process and has been chosen as the deadlock victim.
Rerun the transaction.; 40001." Source="Microsoft SQL Server 2005 Analysis
Services" HelpFile="" /><Error ErrorCode="3240034318" Description="Errors in
the OLAP storage engine: An error occurred while processing the 'Uvw Fact
Order Lines' partition of the 'Orders' measure group for the 'IsdFinanceMain'
cube from the IsdFinanceMain database." Source="Microsoft SQL Server 2005
Analysis Services" HelpFile="" /></Messages></root></results></return>. The
step succeeded. |