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