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

SQL stored procedure not inserting required data into PROJECT_ID

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.01, 1.7.02
    • Fix Version/s: 1.7.04
    • Component/s: CRC Cell, Install
    • Labels:
      None
    • Rank:
      0|i0008f:
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      Oracle
    • Developer Notes:
      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

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

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code