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

UDFs aren't found when using old function definitions model

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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.

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: