Troubleshooting
Problem
When a user attempts to import the definition of a user-defined function in Amazon Redshift into Framework Manager no column information is retrieved.
Symptom
Cognos Analytics retrieves metadata via the DatabaseMetadata interface implemented by a JDBC driver. No Column metadata is retrieved for user-defined functions when importing the metadata into Framework Manager.
Cause
Cognos tries to retrieve column Metadata from the user-defined functions using databaseMetadata.getFunctionColumns(), when importing the metadata in Framework manager. The databaseMetadata.getFunctionColumns() function does not return any column information when using Version 1.2.32 of the Redshift JDBC driver.
Resolving The Problem
Importing metadata for a scalar user-defined function is an optional step. Expressions in a model or report can refer to a user-defined function even if nothing is imported into a model.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
19 September 2019
UID
ibm11074006