SAP Knowledge Base Article - Public

3401215 - Error opening the cursor for the remote database Agent is shutting down - SAP Datasphere

Symptom

When persisting view in Datasphere, it failed with errors: 

  • An error occurred. The process to persist the view has been stopped and changes have been rolled back.
  • Unable to persist data for the view. 

When preview the data in Data Builder, it failed with error: 

  • No data found before viewer timeout (three minutes). To improve response times, you should consider persisting the view data and/or persisting or replicating its poor performing sources.

Error details:

  • Error opening the cursor for the remote database Agent is shutting down.

Environment

SAP Datasphere

Cause

Data Provision Agent out of memory. Data volume of the table is too large for the memory.

Resolution

  1. Create partitioning for remote table replication like mentioned in Partitioning Remote Table Data Loads.
  2. Switch on the [Streaming Read] feature so that it can use ABAP RFC streaming for loading tables based on small batches.
          *The Streaming Read is only for table, not for extractor.

Keywords

Streaming Read; persisting view; partitioning , KBA , DS-DI-RT , Remote Tables , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions