Imported Database function in Teiid Designer gives "TEIID30068 The function <> is an unknown form"

Solution Verified - Updated -

Issue

  • Imported Database Function via JDBC Database >> Source Model in Teiid Designer, when I run the function I receive below error:
org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'functionname' is an unknown form.  Check that the function name and number of arguments is correct.

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.2, 6.3
  • Red Hat JBoss Developer Studio (JBDS) 8.1.0, 9, 10, 11
  • Teiid Designer for JBDS 9.0.7, 10, 11
  • Oracle Database function
  • Microsoft SQL Server function

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In