Invalid column name 'nodeID

Document ID : KB000071583
Last Modified Date : 11/07/2018
Show Technical Document Details
Issue:
Two node clsuter Process Auto 4.3.2 on Windows Server 2008 R2 
jdk1.7.0_67 
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 
Resolution:
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.