3012269 - "Error opening the cursor for the remote database Prefetch timed out" during initial load for BW datasource which uses SDI PostgreSQL remote source connection

• 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)"

• SAP HANA Smart Data Integration
• PostgreSQL  

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