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.
SAP Knowledge Base Article - Preview