dbTalk Databases Forums  

Deadlocks Processing Cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Deadlocks Processing Cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
programmer_mike
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.