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

SQL stored procedure not inserting required data into PROJECT_ID

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.01, 1.7.02
    • 1.7.04
    • CRC Cell, Install
    • None
    • Rank:
      0|i0008f:
    • i2b2 Core
    • Oracle
    • Fixed already, except in Postgres which is unsupported in the Loader currently.

    Description

      The SQL procedure i2b2demodata. INSERT_PATIENT_FROMTEMP() throws the following Exception, “cannot insert NULL into ("I2B2DEMODATA"."PATIENT_MAPPING"."PROJECT_ID")

      In the PATIENT_MAPPING table, COLUMN PROJECT_ID is defined as NOT NULL.

      However, in the INSERT_PATIENT_FROMTEMP.sql, the SQL code tries to insert records into patient_mapping without setting the value for PROJECT_ID column. It throws the following Exception,
          Cannot insert NULL into
          ("I2B2DEMODATA"."PATIENT_MAPPING"."PROJECT_ID")

      The SQL code is as below.
      "execute immediate ' insert into patient_mapping (patient_ide,patient_ide_source,patient_num,patient_ide_status, upload_id)
            (select distinct ...... ) ';

      Attachments

        Activity

          People

            jmd86 Janice Donahoe
            hongluo1 Hong Luo
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: