Question

3
Replies
60
Views
Sree Kumar Kesavan (softsree)
Bank of America

Bank of America
US
softsree Member since 2012 1 post
Bank of America
Posted: September 1, 2020
Last activity: September 2, 2020
Posted: 1 Sep 2020 16:29 EDT
Last activity: 2 Sep 2020 12:18 EDT

JDBC connection to Terradata from Pega 8.1.5

when trying to connect to Terradata from Pega 8.1.5, we are getting below error message. 

ERROR - Section 'TestConnectionResults' execution error on page 'ClassConnectionStatus' of  class 'Code-Pega-ConnectionReport'. com.pega.pegarules.pub.database.DatabaseException: Database-General    Problem retrieving schema information for database XXXXX , table AAAAA.BBBBB 3523    42000    [Teradata Database] [TeraJDBC 15.10.00.14] [Error 3523] [SQLState 42000] The user does not have SELECT access to DBC.UDTInfo. DatabaseException caused by prior exception: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.14] [Error 3523] [SQLState 42000] The user does not have SELECT access to DBC.UDTInfo.  | SQL Code: 3523 | SQL State: 42000  

 

***Edited by Moderator Marissa to update Content Type from Discussion to Question***

Pega Platform 8.1.5 Data Integration Financial Services Lead System Architect