Process Automation upgrade to 4.2.2 fails with alter table errors

Document ID : KB000029375
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

After upgrading to PAM 4.2.2 my Process Automation logs return the following error

 

Sample of error:

2015-01-13 15:04:26,204 ERROR
[com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [           main] Error in
generating DBDefinition Invalid state, the Connection object is closed.
2015-01-13 15:04:26,204 ERROR
[com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [           main] Error
occurred while adjusting DB definitionjava.lang.Exception: Error occurred
while adjusting DB
2015-01-13 15:04:26,204 ERROR [com.optinuity.c2o.server.ServerController] [
        main] Failed to initialize DDL
java.lang.Exception: Error occurred while adjusting DB

 

2015-01-13 09:05:42,733 ERROR
[com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [           main] Error
occurred while executing ALTER Table C2ORuntimeObjects ADD
contentPackageReleaseVersion NVARCHAR(255):I/O Error: Read timed out
2015-01-13 09:05:42,733 ERROR
[com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [           main] Error
occurred while updating Table definition
java.sql.SQLException: Invalid state, the Connection object is closed.
 at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)

 

Cause:

When using SQL server,  Process Automation 4.2 uses SQL jdbc driver jtds1-3.jar.  However, you will be given the oppurtunity to select the old sqljdbc.jar which was previously installed on your PAM system when upgrading to 4.2.2.  If you select the older sqljdbc.jar the upgrade will fail with ALTER table and DB errors.

Resolution:

To correct this issue please rerun the upgrade and only select jtds1-3.jar.  Complete the upgrade and start the PAM orchestrator service.