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

PostgreSQL: Error executing CRC stored procedure CREATE_TEMP_PROVIDER_TABLE

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.00, 1.7.01
    • Fix Version/s: 1.7.02
    • Component/s: Install
    • Labels:
      None
    • Environment:
      PostgreSQL Database
    • Rank:
      0|i000lj:
    • Affects Database/s:
      PostgreSQL

      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

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code