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.