Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Creation of Teradata stored procedure fails in Spotfire with error “[Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.UDTInfo.TypeName"
Solution:
Creation of stored procedure based on Teradata datasource in TIBCO Spotfire Analyst client > Tools > Information Designer fails with below error in the server.log:
Error retrieving metadata: [Teradata Database] [TeraJDBC 15.10.00.35] [Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.UDTInfo.TypeName
Cause:This issue occurs when the account used to create the Teradata datasource in Spotfire does not have ‘select’ privileges on the following Teradata system tables:
- DBC.Tables,
- DBC.Columns,
- DBC.UDTInfo, and
- DBC.Databases.
Comments
0 comments
Article is closed for comments.