IBM Support

Engineering Lifecycle Optimization Document Builder reports fail to generate.

Troubleshooting


Problem

When attempting to run reports from Document Builder an error is received and the report fails to generate. 

Persistence error Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.ibm.db2.jcc.am.SqlDataException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=4.33.31

Error Code: -302

Symptom

20-10-2025T17:26:35:213-0400 [Default Executor-thread-28] [TID: dw3d30ac6a] - Persistence error Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.db2.jcc.am.SqlDataException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=4.33.31
Error Code: -302
Call: INSERT INTO RESULTS (ID, DATABLOB, LASTMODIFIEDON) VALUES (?, ?, ?)
    bind => [3 parameters bound]
com.ibm.rpe.web.service.resources.common.exceptions.RPEServiceException: Persistence error Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.db2.jcc.am.SqlDataException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=4.33.31
Error Code: -302
Call: INSERT INTO RESULTS (ID, DATABLOB, LASTMODIFIEDON) VALUES (?, ?, ?)
    bind => [3 parameters bound]
    at com.ibm.rpe.web.service.resources.dao.orm.ORMResultDAO.createResult(ORMResultDAO.java:44) ~[com.ibm.rpe.web.service.resources.impl_7.0.3.202507032008.jar:?]
    at com.ibm.rpe.web.service.resources.impl.ResultServiceImpl.createResult(ResultServiceImpl.java:27) ~[com.ibm.rpe.web.service.resources.impl_7.0.3.202507032008.jar:?]
    at com.ibm.rpe.web.service.resources.servlet.DGaaSResultServlet.storeFile(DGaaSResultServlet.java:91) ~[classes/:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]

Cause

The document's size that is being generated is larger than the maximum allowed for the report builder JVM. 

Diagnosing The Problem

Review the rpeng.log for the Document Builder application for the above exception. 

Resolving The Problem

  1. Stop the application server that hosts the document builder (dgaas.war) application

  2. Modify the following parameters within the server.startup for the application server which is located within the <install directory>\server directory. 

    1. -DMAX_DOCUMENT_SIZE_ALLOWED=52428800

    2. This value is in bytes which is to ~50mb. Update the size to accommodate the document that you are attempting to generate. Adjust as necessary. 

  3. Restart the server and attempt to generate the report. 

     

Reference: https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-optimization-publishing/7.0.3?topic=SS6RHZ_7.0.3/com.ibm.rational.pe.reference.doc/topics/t_issues_large_input_file_db.htm

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSUBFB","label":"IBM Engineering Lifecycle Optimization - Publishing"},"ARM Category":[{"code":"a8m50000000CjHjAAK","label":"ELO Publishing-\u003EDocument Builder"}],"ARM Case Number":"TS020574570","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"and future releases;7.0.3;7.1.0"}]

Document Information

Modified date:
30 March 2026

UID

ibm17249279

Page Feedback