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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.