SAP Knowledge Base Article - Preview

2581851 - ODP extraction: Deadlock on table ODQREQQUE


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



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


SAP BW/4HANA all versions ; SAP ERP Central Component all versions ; SAP ERP all versions ; SAP NetWeaver all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions


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 on 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 for Me (Login required).

Search for additional results

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