Two node clsuter Process Auto 4.3.2 on Windows Server 2008 R2
MS SQLServer 2005
connection OK between PAM server and SQL DB using "SQL enterprise manager"
PROBLEM seen on node1 after upgrading -node 2 stopped-
Error message seen on c2o.log on every process we launch:
org.hibernate.exception.SQLGrammarException: could not insert: [com.optinuity.c2o.commandobject.flowchart.C2OWorkFlowInstanceRefObjectArchive]
Caused by: java.sql.SQLException: Invalid column name 'nodeID'.
-Also important, when starting up PAM services we may see this message:
org.hibernate.util.JDBCExceptionReporter Invalid column name
Reviewed the “C2ODBDefinition.xml” and database.
C2ODBDefinition.xml contains the table definition properly but database doesn’t have the “nodeID” column for c2oworkflowsArchive which is causing for this issue.
Stopped PAM server and restarted. It created the required column automatically.
Looks like the root case was because node2 was not yet upgraded.
After both nodes upgraded, all is working as expected.