[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. |