SAP Knowledge Base Article - Preview

3012269 - Error: "Error opening the cursor for the remote database Prefetch timed out" when executing initial load for BW datasource which use SDI remote source connection

Symptom

  • Execute initial load for BW datasource which use SDI PostgreSQL remote source connection failed
  • Error from BW : "internal error: Error opening the cursor for the remote database Prefetch timed out. for query ***"
  • Error from framework.trc file on DP agent machine 
    "DPFramework | WorkerThread.processRequest  - com.sap.hana.dp.adapter.sdk.AdapterException: org/postgresql/util/PSQLState : cannot initialize class because prior
    initialization attempt failed Context: java.lang.NoClassDefFoundError: org/postgresql/util/PSQLState : cannot initialize class because prior initialization attempt failed"
    "[FATAL] AdapterUncaughtExceptionHandler | AdapterUncaughtExceptionHandler.uncaughtException  - Thread[FrameworkAsyncThread,5,main] was stopped due to
    uncaught exception.java.lang.OutOfMemoryError: GC overhead limit exceeded (max heap: 4096 MB)"


Read more...

Environment

  • SAP HANA Smart Data Integration
  • PostgreSQL  

Product

SAP BW/4HANA 2.0 ; SAP HANA smart data integration 2.0

Keywords

OutOfMemoryError, SDI, initial load, PostgreSQL , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.