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

SQLSERVER: Missing PM APPROVAL tables in installation DDL scripts

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.00-RC2
    • 1.6.01
    • Data, Install, PM Cell
    • None
    • SQLSERVER 2008

    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

          bswilsonb Brian Wilson created issue -
          mem61 Mike Mendis made changes -
          Field Original Value New Value
          Fix Version/s 1.6.01 [ 10053 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Workflow classic default workflow [ 10143 ] i2b2 Issues [ 10367 ]
          jmd86 Janice Donahoe made changes -
          Component/s Data [ 10024 ]
          Component/s Install [ 10020 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          jmd86 Janice Donahoe made changes -
          Workflow i2b2 Issues [ 10367 ] i2b2 Issues Workflow [ 10539 ]
          jmd86 Janice Donahoe made changes -
          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 LEOPARD-61 CORE-35
          Project i2b2 [ 10000 ] i2b2 Core Project [ 10034 ]
          Affects Version/s 1.6.00-RC2 [ 10137 ]
          Affects Version/s 1.6.00-RC2 [ 10032 ]

          People

            mem61 Mike Mendis
            bswilsonb Brian Wilson
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: