3711950 - Tasks fail intermittently with BW Target Datastore Load Balancing enabled

• Tasks with BW target data store experience intermittent failures
• Error message may differ depending on customer environment, product versions, and when the failure occurs.
• Load balancing is configured in BW Target Data Store
• Connection test in BW Target is successful
• Sample Error messages from task failure:

SQL submitted to ODBC data source <dsod_agent_repo> resulted in error <[SAP][ODBC Driver][SQL Anywhere]Primary key for table 'AL_BW_REQUEST' is not unique: Primary key value ('''')>. The SQL submitted is <INSERT INTO AL_BW_REQUEST (REQUESTID,TYPE,VALUE,DF_NAME,CREATION_TIME) VALUES ( '', 4 , '123451',  'taskname', '2026-02-04 13:30:12')> 

• Sample error messages from BW InfoPackage Monitor in RSA1

Ex=1 Error when opening an RFC connection (CPIC-CA LL: 'ThSAPOCMINIT', communication rc: CM_ALLOCATE_ FAILURE_RETRY (cmRc=2)). 

• SAP Cloud Integration for data services
• SAP BW

KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem