SAP Knowledge Base Article - Preview

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

Symptom

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

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.