Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-35

SQLSERVER: Missing PM APPROVAL tables in installation DDL scripts

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6.00-RC2
    • Fix Version/s: 1.6.01
    • Component/s: Data, Install, PM Cell
    • Labels:
      None
    • Environment:
      SQLSERVER 2008
    • Rank:
      0|i0013z:

      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

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code