SAP Knowledge Base Article - Preview

1640918 - BI 4.0 において、MS SQL Server に接続する CMS DB でデッドロックが頻繁に発生する

Symptom

  • Central Management Server (CMS) データベースでデッドロックが頻繁に発生します。
  • SQL Server データベースにエラー "Transaction (Process ID ##) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." が表示されます。
  • データベースに以下のクエリが表示されることがあります。

SELECT LOCKTABLE.PARENTID, LOCKTABLE.CHILDID,0,LOCKTABLE.ISMEMBER FROM dbo.CMS_LOCKS7 LOCKTABLE WHERE LOCKTABLE.CHILDID IN (******)


Read more...

Environment

  • Crystal Reports Server 2011
  • SAP BusinessObjects Business Intelligence (BI) プラットフォーム 4.0
  • Windows Server 2008 R2 x64
  • SQL Server 2005 SP4/Microsoft SQL Server 2008

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP Crystal Server 2011 ; SAP Crystal Server 2011, feature pack 3

Keywords

deadlock, cms db, ms sql server, bi 4.0, business objects, デッドロック, CMS データベース , KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.