Details
Major 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 ...... ) ';
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
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 1.7.03 [ 10156 ] | |
| Assignee | Mike Mendis [ mem61 ] | |
| i2b2 Sponsored Project/s | i2b2 Core [ 10196 ] | |
| Status | New [ 10000 ] | Open [ 1 ] |
| Fix Version/s | 1.7.04 [ 10160 ] | |
| Fix Version/s | 1.7.03 [ 10156 ] |
| Summary | The SQL procedure i2b2demodata. INSERT_PATIENT_FROMTEMP() throws the following Exception, “cannot insert NULL into ("I2B2DEMODATA"."PATIENT_MAPPING"."PROJECT_ID") | SQL stored procedure not inserting required data into PROJECT_ID |
| Description |
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 ...... ) '; |
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 ...... ) '; |
| Assignee | Mike Mendis [ mem61 ] | Jeffrey Klann [ jklann ] |
This is fixed in MSSQL & Oracle. Postgres is untested. However, multiple projects are not supported by the loader - project_id is assigned '@'.
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Developer Notes | Fixed already, except in Postgres which is unsupported in the Loader currently. | |
| Assignee | Jeffrey Klann [ jklann ] | Janice Donahoe [ jmd86 ] |
| Status | In Progress [ 3 ] | Ready to Test [ 10001 ] |
| Status | Ready to Test [ 10001 ] | Testing [ 10002 ] |
| Build Number (Fixed) | 1.7.04.0004 | |
| Resolution | Fixed [ 1 ] | |
| Status | Testing [ 10002 ] | Resolved [ 5 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |