3505987 - Task fails with "Primary key is not unique" error message in Cloud Integration for data services

• A task in CI-DS fails with one or more of the following error messages:
  • DBS-70404       |Data flow XXXXX SQL submitted to ODBC data source <XXXXX> resulted in error <[SAP][ODBC Driver][SQL Anywhere]Primary key for table 'XXXXX' is not unique: Primary key value ('''')>. The SQL submitted is <INSERT INTO AL_BW_REQUEST (REQUESTID,TYPE,VALUE,DF_NAME,CREATION_TIME) VALUES ( '', X , 'XXXXX', 'XXXXX', 'XXXXX')>.
  • BAP-220301      |Data flow XXXXX BAPI returned message <Error 518 (RSM): Request number is invalid> from method <BAPI_DSOURCE_SEND_CHAR>.
  • BIW-230108      |Data flow XXXXX Load data to BW failed: RequestID = <XXXXX>, Packet Number = <>, Error = Schedule Status is <Planned>.
• The task writes to a BW system.

SAP Cloud Integration for data services

CI-DS, BW, Business Warehouse, cloud integration, data services, IBP, primary key, not unique, odbc data source, sql subimitted, BAPI returned message, request number is invalid, schedule status, planned, infopackage, infopackages , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , LOD-HCI-DS-AGNT , On-Premise Agent, Connectivity, Task Run errors , LOD-HCI-DS-CLD , Cloud Server, UI, Task Promotion, Web Services , Problem