Overview

You attempt to deploy an Aurea Process (formerly known as CX Process, Savvion and SBM) BizLogic application using BPM Studio and App Deployer to your Aurea Process server and are encountering the following errors from BPM Studio and App Deployer:

BPM Studio Error

A server error "Exception from service object: BizLogic server exception of type "java.rmi.RemoteException" has occurred.
The message is "The bean encountered a non-application exception; nested exception is: 
    com.savvion.sbm.bizlogic.util.BizLogicException: (517) Problem while importing the Process Definition. Process-Import failed for XML file "CLMPlaceModeration.xml".; context(ProcessControl.createProcessTemplate)(642) The total size of process template data slots "8,324" exceeds the maximum limit "8,192" of the database record size.; context(WFimportProcess.endElement)"" has occurred

App Deployer Error

zipandDeploy:
     [echo] In zip and deploy
      [zip] Building zip: C:\Aurea\CXProcess2020T\SBM\appPackager\build\deploy\ALL_NON_CR.zip\BizLogic\CLMContentModeration.zip
     [echo] hasBizPulse =false
  [xmltask] server count = 1
  [xmltask] Server Url = http://clm2:18793/sbm/deployment
  [xmltask] Service connectreturned [name=return] [type=boolean] [value=true] [encodingStyleURI=null]
  [xmltask] Successfully connect to BizLogic server.
  [xmltask] Service commonAppNameExistsreturned [name=return] [type=boolean] [value=false] [encodingStyleURI=null]
  [xmltask] Service setAppTypereturned [name=return] [type=boolean] [value=true] [encodingStyleURI=null]
  [xmltask] Service setAppFlagsreturned [name=return] [type=boolean] [value=true] [encodingStyleURI=null]
  [xmltask] Service transferAppreturned [name=return] [type=boolean] [value=true] [encodingStyleURI=null]
  [xmltask] Transfered application
  [xmltask] Fault generated Exception from service object: BizLogic server exception of type "java.rmi.RemoteException" has occurred.
  [xmltask] The message is "The bean encountered a non-application exception; nested exception is:
  [xmltask]     com.savvion.sbm.bizlogic.util.BizLogicException: (517) Problem while importing the Process Definition. Process-Import failed for XML file "CLMContentModeration.xml".; context(ProcessControl.createProcessTemplate)(642) The total size of process template data slots "8,320" exceeds the maximum limit "8,192" of the database record size.; context(WFimportProcess.endElement)"
  [xmltask] Error while installing App:com.savvion.tools.deployment.common.DeploymentException: A server error "Exception from service object: BizLogic server exception of type "java.rmi.RemoteException" has occurred.
  [xmltask] The message is "The bean encountered a non-application exception; nested exception is:
  [xmltask]     com.savvion.sbm.bizlogic.util.BizLogicException: (517) Problem while importing the Process Definition. Process-Import failed for XML file "CLMContentModeration.xml".; context(ProcessControl.createProcessTemplate)(642) The total size of process template data slots "8,320" exceeds the maximum limit "8,192" of the database record size.; context(WFimportProcess.endElement)"" has occurred.
      [for] C:\Aurea\CXProcess2020T\SBM\appPackager\build\deploy\ALL_NON_CR.zip\ALL_NON_CR.xml: The following error occurred while executing this line:
      [for] C:\Aurea\CXProcess2020T\SBM\appPackager\appbuild.xml:384: The following error occurred while executing this line:
      [for] C:\Aurea\CXProcess2020T\SBM\appPackager\appbuild.xml:442: SBM App deployment failed.SBMAPPDeployer could not deploy the archive.

BUILD FAILED
C:\Aurea\CXProcess2020T\SBM\appPackager\appbuild.xml:330: The following error occurred while executing this line:
C:\Aurea\CXProcess2020T\SBM\appPackager\appbuild.xml:374: Keepgoing execution: 1 of 1 iterations failed.

Prerequisites

• Permissions to start and stop the Aurea Process server
• Permissions to modify the DatabaseMapping.xml located in the SBM_HOME/conf/resources/common directory.

Solution

Diagnosis

This issue occurs when the total size of the process template data slots results in a record that exceeds the record size specified for your database in the DatabaseMapping.xml file. 

Solution Steps

1. Stop all of the Aurea Process servers.
2. Modify the DatabaseMapping.xml file to increase the record-size value for the database you have installed Aurea Process on.  The following are the entries in the DatabaseMapping.xml file that need to be updated for each of the databases supported by Aurea Process:
   • IBM DB2
     

     <data-source name="ibmdb2">
       <max-table-name>30</max-table-name>
       <record-size>8039</record-size>

   • Microsoft SQL Server
     

     <data-source name="mssqlserver">
       <max-table-name>128</max-table-name>
       <record-size>8039</record-size>

   • Oracle
     

     <data-source name="oracle">
       <max-table-name>30</max-table-name>
       <record-size>128000</record-size>

   • PostgreSQL
     

     <data-source name="postgresql">
       <max-table-name>63</max-table-name>
       <record-size>8192</record-size>

   Note: If you are running Aurea Process in a clustered environment, the DatabaseMapping.xml file will need to be modified on each of the Aurea Process cluster nodes.
3. Start all of the Aurea Process servers.
4. Try to deploy the application using BPM Studio and App Deployer.

Testing

Once the change is made to increase the record-size value, the BizLogic process can be deployed using the SBM Studio and App Deployer.