Fixing document-style report generation error in Publishing Document Builder due to large output document size

Edit online

When Publishing Document Builder generates output of large sizes, document-style report generation fails. It happens because the default column size in databases is too small to store the large output document-style reports. This issue is observed in Db2® or Derby database.

About this task

To fix the error on WebSphere® Liberty server, complete the following steps:

Procedure

Stop the WebSphere Liberty server server that is packaged with Publishing Document Builder, go to the command line and stop the server from:
  • Windows icon: Document_Builder_InstallDir\server\server.shutdown.bat

    For example, C:\Program Files\IBM\DocumentBuilder\server\server.shutdown.bat

  • Linux icon: Document_Builder_InstallDir/server/server.shutdown

    For example, /opt/IBM/DocumentBuilder/server/server.shutdown

  1. Open jvm.options file from Document_Builder_InstallDir\server\liberty\servers\clm.
  2. Add the following flags, save, and close the file:
    • -DENABLE_ALTER_TABLE=true
    • -DMAX_DOCUMENT_SIZE_ALLOWED=52428800
    Note: The mentioned value is in bytes, which is equivalent to 50 MB. Set the appropriate value based on requirement.
  3. Start the WebSphere Liberty server server that is packaged with Publishing Document Builder, go to the command line and start the server from:
    • Windows icon: Document_Builder_InstallDir\server\server.startup.bat

      For example, C:\Program Files\IBM\DocumentBuilder\server\server.startup.bat

    • Linux icon: Document_Builder_InstallDir/server/server.startup

      For example, /opt/IBM/DocumentBuilder/server/server.startup