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

Environment

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

Product

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

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