SAP Knowledge Base Article - Preview

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

Symptom

  • DS Business Warehouse Job is throwing the below Duplicate Key Error:

    DBS-070404: |Data flow <dataflow 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__<numbers and letters>'. 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 AL_BW_REQUEST (REQUESTID,TYPE,VALUE,DF_NAME,CREATION_TIME) VALUES ( '', # , '####', '<dataflow name>', CONVERT(DATETIME2, '', 121))>.

  • All BW jobs were working, and now are not in one environment.
  • Other environments are working fine.


Read more...

Environment

SAP Data Services

Product

SAP Data Services all versions

Keywords

EIM-DS-SAP, BW, authorization, PRIMARY KEY, PK__AL_BW_RE, AL_BW_REQUES , 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.