[CORE-91] PostgreSQL: Error executing CRC stored procedure CREATE_TEMP_PROVIDER_TABLE Created: 02/Apr/14 Updated: 01/Jul/14 Resolved: 02/Apr/14 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Install |
| Affects Version/s: | 1.7.00, 1.7.01 |
| Fix Version/s: | 1.7.02 |
| Type: | Bug | Priority: | Major |
| Reporter: | Melek Somai | Assignee: | Mike Mendis |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: | PostgreSQL Database | ||
| Affects Database/s: |
PostgreSQL
|
| Participant/s: |
| Description |
|
PROBLEM: An error is returned when running the ant script to create the CRC Stored Procedures. Upon further investigation it appears the problem is with the create statement in the CREATE_TEMP_PROVIDER_TABLE.sql script. The following statements are excerpts from the error received when running this script. ERROR MESSAGE (EXCERPTS): Failed to execute: CREATE OR REPLACE FUNCTION create_temp_provider_table (tempProviderTableName IN text, errorMsg OUT text) RETURNS CREATE_TEMP_PROVIDER_TABLE.sql text AS $body$ . . . Org.postgresql.util.PSQLException: ERROR: syntax error at or near "text" Position: 152 RECOMMENDED SOLUTION: Remove the reference to CREATE_TEMP_PROVIDER_TABLE.sql in the script. The edited version would be as follows: CREATE OR REPLACE FUNCTION create_temp_provider_table (tempProviderTableName IN text, errorMsg OUT text) RETURNS text AS $body$ . . . the rest of the script |
| Comments |
| Comment by Janice Donahoe [ 02/Apr/14 ] |
| This has been fixed as suggested and will be included in the 1.7.02 release. |