Symptom
You face an error when using SWPM to prepare an export of the database instance.
Failed with memory issue:
Database access error: SAP DBTech JDBC: [4]: cannot allocate enough memory: Out of memory on query fetch
In the jload traces, you may see errors like:
com.sap.inst.dbtools [Thread[pool-1-thread-2,5,main]] Fatal: DB Error during export of BC_SLD_CHANGELOG
com.sap.inst.dbtools [Thread[pool-1-thread-2,5,main]] Fatal: Database access error: SAP DBTech JDBC: [4]: cannot allocate enough memory: Out of memory on query fetch
OpenSQLExceptionCategories: [NON_TRANSIENT, DB_ADMINISTRATOR_REQUIRED] (SQLState: HY000, ErrorCode: 4)
com.sap.inst.dbtools [Thread[pool-1-thread-2,5,main]] Fatal: com.sap.sql.exception.OpenSQLException: SAP DBTech JDBC: [4]: cannot allocate enough memory: Out of memory on query fetch
Read more...
Environment
- SAP HANA Platform Edition 1.0
- SAP HANA Platform Edition 2.0
Product
Keywords
System Copy, Export, Maxheap, Outofmemory, Jload, Software Provisioning Manager, SWPM, Migration, Exporting, Migrating, Import, Database, java.lang.OutOfMemoryError: Java heap space, Out of memory, OOM, BC_SLD_CHANGELOG, SAP DBTech JDBC, database , KBA , HAN-DB , SAP HANA Database , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview