Details
Major Description
The installation scripts for SQLSERVER are missing the following tables: PM_APPROVALS, PM_PROJECT_REQUEST, PM_APPROVALS_PARAMS
Porting from Oracle was successful but subsequent attempts to create an approval via the webclient were unsuccessful - throwing a null pointer exception.
10:27:08,557 ERROR [STDERR] org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into pm_approvals (approval_id, approval_name, approval_description, approval_activation_date, approval_expiration_date, object_cd, change_date, entry_date, changeby_char, status_cd) values (?,?,?,?,?,?,?,?,?,?)]; SQL state [null]; error code [0]; Error; - nested throwable: (java.lang.NullPointerException); nested exception is org.jboss.util.NestedSQLException: Error; - nested throwable: (java.lang.NullPointerException)
10:27:08,558 ERROR [STDERR] at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:127)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.dao.PMDbDao.setApproval(Unknown Source)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.delegate.ServicesHandler.runSetApproval(Unknown Source)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.delegate.ServicesHandler.execute(Unknown Source)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.ws.ExecutorRunnable.run(Unknown Source
Porting from Oracle was successful but subsequent attempts to create an approval via the webclient were unsuccessful - throwing a null pointer exception.
10:27:08,557 ERROR [STDERR] org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into pm_approvals (approval_id, approval_name, approval_description, approval_activation_date, approval_expiration_date, object_cd, change_date, entry_date, changeby_char, status_cd) values (?,?,?,?,?,?,?,?,?,?)]; SQL state [null]; error code [0]; Error; - nested throwable: (java.lang.NullPointerException); nested exception is org.jboss.util.NestedSQLException: Error; - nested throwable: (java.lang.NullPointerException)
10:27:08,558 ERROR [STDERR] at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:127)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.dao.PMDbDao.setApproval(Unknown Source)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.delegate.ServicesHandler.runSetApproval(Unknown Source)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.delegate.ServicesHandler.execute(Unknown Source)
10:27:08,558 ERROR [STDERR] at edu.harvard.i2b2.pm.ws.ExecutorRunnable.run(Unknown Source