Symptom
CPA cache fills causing the system to fail.
The bellow error can be found in the default traces:
SQL error occurred on connection xxxxx:xxxx:xxxxxx: code=4, state="HY000", message="SAP DBTech JDBC: [4]: cannot allocate enough memory: Allocation failed $REASON$";
SQL statement is "SELECT "VSE"."VERSIONSETID",COUNT(*) "RECORDCOUNT" FROM "XI_PVSETELEMENT" "VSE" INNER JOIN "XI_PVERSIONEDOBJ" "VO" ON "VSE"."OBJECTID" = "VO"."OBJECTID" WHERE "VSE"."VERSIONSETID" = ? AND "VO"."PROPCONFINEMENT" < ? GROUP BY "VSE"."VERSIONSETID"".
[EXCEPTION]
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [4]: cannot allocate enough memory: Allocation failed $REASON$
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:209)
.... 58 more
The database used is a HANA database
Read more...
Environment
SAP NetWeaver all versions
Product
Keywords
CPA cache, SAP DBTech JDBC: [4]: cannot allocate enough memory: Allocation failed $REASON, SQL statement is "SELECT "VSE"."VERSIONSETID",COUNT(*) "RECORDCOUNT" FROM "XI_PVSETELEMENT" "VSE" INNER JOIN "XI_PVERSIONEDOBJ" "VO" ON "VSE"."OBJECTID" = "VO"."OBJECTID" WHERE "VSE"."VERSIONSETID" = ? AND "VO"."PROPCONFINEMENT" < ? GROUP BY "VSE"."VERSIONSETID"", HANA DB , KBA , BC-XI-IBF-COR , DB - OR mapping, Server Framework, HMI, SQL layer , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-DB-ORA , Oracle , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.