SAP Knowledge Base Article - Preview

2581851 - ODP extraction: Deadlock on table ODQREQQUE

Symptom

You're extracting BW datasource by ODP. The extraction failed and error below is displayed in the ODQR* job in ODP source system:

Exception DBIF_RSQL_SQL_ERROR occurred in line 227 of include CL_ODQ_DELTA_REQUEST_TASK=====CM002 (program CL_ODQ_DELTA_REQUEST_TASK=====CP)

Also the following details occur in the developer trace file of the corresponding background work process (Transaction SM50 or ST11):

B ***LOG BY4=> sql error 1205 performing UPD on table ODQREQQUE
B ***LOG BY0=> Transaction (Process ID XXX) was deadlocked on lock resources with another process and has been chosen as the deadlock


Read more...

Environment

  • Source system for ODP extraction using BW datasource
  • Source system is based on SQL Server

Keywords

KBA , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , BC-EIM-ODP , Operational Data Provisioning (ODP) in Search&Analytics , BW-SYS-DB-MSS , BW Microsoft SQL Server , Problem

About this page

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

Search for additional results

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