2235091 - Error: “A database error has occured. The database error text is: (CS) "Unexpected behavior: Java heap space" . (WIS 10901) ” on refreshing Web Intelligence reports for large volume of data.

• Error: “A database error has occured. The database error text is: (CS) "Unexpected behavior: Java heap space" (WIS 10901) ” on refreshing Web Intelligence reports for large volume of data.
• Users also gets error "Database Error: (CS) "Unexpected behavior : Java heap space (failed to allocate 24 bytes)" .(IES 10901) (Error: INF)". 
• Refreshing same report for less less number of rows has no problem.

Below entries are recorded in Webi server traces:

|||||||||CS||EXCEPTION [JDBC |MySQL 5 |ID:2101111381]com.sap.connectivity.cs.java.RDBMSJob{com.businessobjects.connectionserver.ProcedureJob}.Describe: [com.sap.connectivity.cs.core.CSError: Java heap space (failed to allocate 64 bytes)
 at com.sap.connectivity.cs.core.OpenJob.Describe(OpenJob.java:77)
 at com.sap.connectivity.cs.api.trace.JobLogger.Describe(JobLogger.java:194)
Caused by: java.lang.OutOfMemoryError: Java heap space (failed to allocate 64 bytes)

 
| | |webiserver_app01_rh_cluster10_pitbpa1.WebIntelligenceProcessingServer|18776|  62|Thread-49       | ||||||||||||||||||||CS||EXIT [JDBC |MySQL 5 |ID:27f8a93f]com.mysql.jdbc.StatementImpl@48072f8c{java.sql.Statement}.close

 
|E| |webiserver_app01_rh_cluster10_pitbpa1.WebIntelligenceProcessingServer|18776|  62|Thread-49       | ||||||||||||||||||||CS||EXCEPTION [JDBC |MySQL 5 |ID:27f8a93f]com.mysql.jdbc.JDBC4Connection@58ce9a12{java.sql.Connection}.rollback: [com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.

Read more...

SAP BusinessObjects Business Intelligence platform 4.3

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

java, heap, webi, schedule, refresh, create, xmx, application, report, size, heapsize, BI Launchpad, bi launchpad, jdbc, memory, cs.cfg, Option, 4096 , KBA , BI-RA-WBI , Web Intelligence , BI-RA-WBI-BE , Back End/Server , Problem