Fixing error in Publishing Document Builder due to large resources size

When you upload large-size resource (more than 20 MB) to Publishing Document Builder, resource upload fails. It happens because the default column size in databases is too small to store the large resource. This issue is observed in Db2® or Derby database.

About this task

To fix the error on WebSphere Liberty, do the following steps:

Procedure

Stop the WebSphere Liberty 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_ASSET_UPLOAD_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 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