Details
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
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Fix Version/s | 1.6.01 [ 10053 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Resolved [ 5 ] |
Workflow | classic default workflow [ 10143 ] | i2b2 Issues [ 10367 ] |
Component/s | Data [ 10024 ] | |
Component/s | Install [ 10020 ] |
Status | Resolved [ 5 ] | Closed [ 6 ] |
Workflow | i2b2 Issues [ 10367 ] | i2b2 Issues Workflow [ 10539 ] |
Component/s | Data [ 10050 ] | |
Component/s | Install [ 10053 ] | |
Component/s | PM Cell [ 10055 ] | |
Component/s | PM Cell [ 10002 ] | |
Component/s | Install [ 10020 ] | |
Component/s | Data [ 10024 ] | |
Fix Version/s | 1.6.01 [ 10142 ] | |
Fix Version/s | 1.6.01 [ 10053 ] | |
Key |
|
|
Project | i2b2 [ 10000 ] | i2b2 Core Project [ 10034 ] |
Affects Version/s | 1.6.00-RC2 [ 10137 ] | |
Affects Version/s | 1.6.00-RC2 [ 10032 ] |