Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3950

UDFs aren't found when using old function definitions model

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.0, 8.12.5, 8.13.1, 8.7.3.6_2
    • 8.7.2.6_2
    • Server
    • None
    • Workaround Exists
    • Hide

      Remove the old functiondefinitions model and create a new one via Relational View Model > then New Child > Procedure > User Defined Function.

      Show
      Remove the old functiondefinitions model and create a new one via Relational View Model > then New Child > Procedure > User Defined Function.

      When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them.

      [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION

      [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-dsteigner Deborah Steigner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: