3686377 - Error opening the cursor for the remote database Time limit exceeded - SAP Datasphere

Below error happens during data loading from remote table or data flow which use remote table as target.

• DBS-070407: |Reader LoadMapper_<xxxxxx>_producer1 SQL submitted to database <> resulted in error <General error;403 internal error: Error opening the cursor for the remote database <REMOTE_DB> Time limit exceeded.

• SAP Datasphere

The <REMOTE_DB> part in the error message is a Connection. Prefix is the space ID followed by connection technical ID.

Check this connection if DP Agent is used for Remote Table feature, if so, please check below KBAs:

• 2363544 - Remote execution error Prefetch timed out - SAP HANA Smart Data Integration
• 3555348 - Error: "Error opening the cursor for the remote database Prefetch timed out" while extracting from ODP extractor through ABAPAdapter remote source - SAP HANA Smart Data Integration

• 2461391 - Where to find DP Agent Log Files - SAP HANA Smart Data Integration
• 2807852 - How to create DP agent FullSystemDump - Smart Data Integration

"Error opening the cursor for the remote database" "DBS-070407" "Time limit exceeded" , KBA , DS-DI-RT , Remote Tables , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem