2641527 - Write back to SAP BW fails: Task completes successfully but BW InfoPackage shows red - Cloud Platform Integration for Data Services

***Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.***

• "Ex=1 Error when opening an RFC connection (CPIC-CA LL: 'ThSAPOCMINIT', communication rc: CM_ALLOCATE_ FAILURE_RETRY (cmRc=2)). "
• "Ex=1 Error when opening an RFC connection (CPIC-CA LL: 'ThSAPOCMINIT' : cmRc=2 thRc=679 Transaction program not registered."
• CPI-DS task shows it completed successfully
• BW Infopackage (DI-generated)
• Data is loaded to PSA, but status is not complete (green)
• Function BAPI_ISOURCE_DP_REQUEST not found
• Primary key for table 'AL_BW_REQUEST' is not unique: Primary key value ('''')>. The SQL submitted is <INSERT INTO AL_BW_REQUEST
• BAPI returned message <Error 518 (RSM): Request number is invalid> from method <BAPI_DSOURCE_SEND_CHAR>
• The internal session was terminated with a runtime error (see ST22)

• SAP Cloud Platform Integration for Data Services 1.0
• SAP BW/APO as target

LOD-HCI-DS, IPAK, APO, DSoD, HCI, SYSTEM_NO_ROLL , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , EIM-HCI , SAP HANA Cloud Integration (Data Services) , Problem