SAP Knowledge Base Article - Preview

2637982 - Cannot insert duplicate key in object dbo. AL_BW_REQUEST - Data Services


  • DS Business Warehouse Job Throwing Duplicate Key Error
  •  DBS-070404: |Data flow <df_name>
     SQL submitted to ODBC data source <datasource> resulted in error <[Microsoft][SQL Server Native Client 11.0][SQL
     Server]Violation of PRIMARY KEY constraint 'PK__AL_BW_RE__xxxxxxxx'. Cannot insert duplicate key in object
     'dbo.AL_BW_REQUEST'. The duplicate key value is ().
     [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.>. The SQL submitted is <INSERT INTO
     'dataflow name', CONVERT(DATETIME2, '', 121))>.
  • All BW jobs were working, and now are not in one environment.
  • Other environments are working fine.



SAP Data Services


SAP Data Services all versions


KBA , EIM-DS-SAP , SAP Interfaces , 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.