Errors when creating connections for Teradata source

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Errors occur when trying to connect Teradata source to a destination, with various database connections failing due to different SQL errors.


Question

Hello everyone.

I am getting the below errors when creating connections for Teradata source.
The test for source is successfull when i enter the details and test but when I try a connection to a destination, it fails. I tried with 4 different databases in my teradata and all failed with some error.

Internal message: java.sql.SQLException: [Teradata Database] [TeraJDBC 20.00.00.06] [Error 5315] [SQLState HY000] An owner referenced by user does not have SELECT WITH GRANT OPTION access to DBC.RoleGrants.GranteeId.
Failure origin: source
Failure type: system_error

Internal message: java.lang.RuntimeException: java.sql.SQLException: [Teradata Database] [TeraJDBC 20.00.00.06] [Error 3807] [SQLState 42S02] Object ‘KC_X.T_XXXXX_TMP’ does not exist.
Failure origin: source
Failure type: system_error

Internal message: java.lang.RuntimeException: java.sql.SQLException: [Teradata Database] [TeraJDBC 20.00.00.06] [Error 3810] [SQLState 42S22] Column/Parameter ‘http://ETL_X.XXXXXXXX.XXX|ETL_X.XXXXXXXX.XXX’ does not exist.
Failure origin: source
Failure type: system_error

Internal message: java.lang.RuntimeException: java.sql.SQLException: [Teradata Database] [TeraJDBC 20.00.00.06] [Error 6706] [SQLState HY000] The string contains an untranslatable character.
Failure origin: source
Failure type: system_error


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["teradata-source", "connection-errors", "java-sql-exception", "system-error"]