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.