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

PostgreSQL: Error executing CRC stored procedure CREATE_TEMP_PROVIDER_TABLE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.00, 1.7.01
    • 1.7.02
    • Install
    • None
    • PostgreSQL Database
    • Rank:
      0|i000lj:
    • 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

            mem61 Mike Mendis
            melek Melek Somai
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: