[CORE-35] SQLSERVER: Missing PM APPROVAL tables in installation DDL scripts Created: 29/Dec/10 Updated: 05/Jun/14 Resolved: 27/Oct/11 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data, Install, PM Cell |
| Affects Version/s: | 1.6.00-RC2 |
| Fix Version/s: | 1.6.01 |
| Type: | Bug | Priority: | Major |
| Reporter: | Brian Wilson | Assignee: | Mike Mendis |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: | SQLSERVER 2008 | ||
| Rank: | 0|i0013z: |
| Participant/s: |
| 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 |
| Comments |
| Comment by Mike Mendis [ 27/Oct/11 ] |
|
Will be added to 1.6.01 thanks |