[CORE-263] PostgreSQL Error: Too many parameters specified for RAISE Created: 01/May/17  Updated: 29/Jun/17  Resolved: 14/Jun/17

Status: Closed
Project: i2b2 Core Software
Component/s: Data
Affects Version/s: 1.7.08b
Fix Version/s: 1.7.09

Type: Bug Priority: Major
Reporter: Janice Donahoe Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i003ef:
i2b2 Sponsored Project/s:
i2b2 Core
Affects Database/s:
PostgreSQL
Participant/s:

 Description   
Three of the create stored procedures scripts for PostgreSQL will return the following error when they are run:

      "Too many parameters specified for RAISE"

The three scripts that have the problem are:

      "create_temp_patient_table"
      "create_temp_pid_table"
      "create_temp_eid_table"



LINE CAUSING THE ERROR:
The following line can be found in all three scripts and is causing the errors:

        RAISE NOTICE '%%%', SQLSTATE, ' - ' , SQLERRM;


REASON:
In PostgreSQL ‘RAISE NOTICE’ can only have two parameters defined.

 Comments   
Comment by Janice Donahoe [ 01/May/17 ]
To fix this issue the offending line in all 3 scripts will be updated to the following:

        RAISE NOTICE '%%%', SQLSTATE || ' - ' || SQLERRM;

Comment by Janice Donahoe [ 14/Jun/17 ]
This issue has been fixed and will be included in release 1.7.09.
Generated at Fri Jun 05 15:25:58 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.