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.
SAP Knowledge Base Article - Preview