Teradata connection Error

Connectivity

Teradata connection Error

Hi,

i am trying to connect to Teradata using JDBC from my Linux server using Pentaho and i get the following error.

can you please help

GSSException: Failure unspecified at GSS-API level (Mechanism level: UserFile parameter null)

        at com.teradata.tdgss.jtdgss.TdgssParseXml.<init>(Unknown Source)

        at com.teradata.tdgss.jtdgss.TdgssConfigApi.<init>(Unknown Source)

        at com.teradata.tdgss.jtdgss.TdgssManager.<init>(Unknown Source)

        at com.teradata.tdgss.jtdgss.TdgssManager.getInstance(Unknown Source)

        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM(GenericTeraEncrypt.java:629)

        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:647)

        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:740)

        at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)

        at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:124)

        at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:216)

        at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)

        at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)

        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)

        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)

        at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)

        at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql.DriverManager.getConnection(Unknown Source)

        at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:482)

        at org.pentaho.di.core.database.Database.normalConnect(Database.java:350)

        at org.pentaho.di.core.database.Database.connect(Database.java:315)

        at org.pentaho.di.core.database.Database.connect(Database.java:277)

        at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:606)

        at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62)

        at java.lang.Thread.run(Unknown Source)

ERROR 01-07 15:59:31,356 - Table output - An error occurred intialising this step:

Error occured while trying to connect to the database

Error connecting to database: (using class com.teradata.jdbc.TeraDriver)

        at java.lang.Thread.run (null:-1)

        at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:62)

        at org.pentaho.di.trans.steps.tableoutput.TableOutput.init (TableOutput.java:606)

        at org.pentaho.di.core.database.Database.connect (Database.java:277)

        at org.pentaho.di.core.database.Database.connect (Database.java:315)

        at org.pentaho.di.core.database.Database.normalConnect (Database.java:350)

        at org.pentaho.di.core.database.Database.connectUsingClass (Database.java:482)

        at java.sql.DriverManager.getConnection (null:-1)

        at java.sql.DriverManager.getConnection (null:-1)

        at com.teradata.jdbc.TeraDriver.connect (TeraDriver.java:158)

        at com.teradata.jdbc.TeraDriver.doConnect (TeraDriver.java:232)

        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection (ConnectionFactory.java:169)

        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection (ConnectionFactory.java:179)

        at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection (JDK6ConnectionFactory.java:25)

        at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init> (JDK6_SQL_Connection.java:35)

        at com.teradata.jdbc.jdbc_4.TDSession.<init> (TDSession.java:216)

        at com.teradata.jdbc.jdbc.GenericLogonController.run (GenericLogonController.java:124)

        at com.teradata.jdbc.AuthMechanism.<init> (AuthMechanism.java:50)

        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid (GenericTeraEncrypt.java:740)

        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig (GenericTeraEncrypt.java:647)

        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM (GenericTeraEncrypt.java:629)

        at com.teradata.tdgss.jtdgss.TdgssManager.getInstance (null:-1)

        at com.teradata.tdgss.jtdgss.TdgssManager.<init> (null:-1)

        at com.teradata.tdgss.jtdgss.TdgssConfigApi.GetMechanisms (null:-1)

ERROR 01-07 15:59:31,357 - Table output - Error initializing step [Table output]

INFO  01-07 15:59:31,358 - TX_LOAD_RET_RATES_TD - Step [Text file input.0] initialized flawlessly.

INFO  01-07 15:59:31,359 - TX_LOAD_RET_RATES_TD - Step [Select values.0] initialized flawlessly.

ERROR 01-07 15:59:31,360 - TX_LOAD_RET_RATES_TD - Step [Table output.0] failed to initialize!

INFO  01-07 15:59:31,360 - TX_LOAD_RET_RATES_TD - Step [Text file output.0] initialized flawlessly.

ERROR 01-07 15:59:31,361 - Table output - Unexpected error rolling back the database connection.

ERROR 01-07 15:59:31,362 - Table output - org.pentaho.di.core.exception.KettleDatabaseException:

Unable to get database metadata from this database connection

        at org.pentaho.di.job.Job.run (Job.java:363)

        at org.pentaho.di.job.Job.execute (Job.java:443)

        at org.pentaho.di.job.Job.execute (Job.java:728)

        at org.pentaho.di.job.Job.execute (Job.java:589)

        at org.pentaho.di.job.entries.trans.JobEntryTrans.execute (JobEntryTrans.java:1034)

        at org.pentaho.di.trans.Trans.execute (Trans.java:504)

        at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:906)

        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:708)

        at org.pentaho.di.core.database.Database.rollback (Database.java:713)

        at org.pentaho.di.core.database.Database.rollback (Database.java:724)

        at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:3101)

        at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3105)

        at org.pentaho.di.core.database.Database.rollback(Database.java:724)

        at org.pentaho.di.core.database.Database.rollback(Database.java:713)

        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:708)

        at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:906)

        at org.pentaho.di.trans.Trans.execute(Trans.java:504)

        at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1034)

        at org.pentaho.di.job.Job.execute(Job.java:589)

        at org.pentaho.di.job.Job.execute(Job.java:728)

        at org.pentaho.di.job.Job.execute(Job.java:443)

        at org.pentaho.di.job.Job.run(Job.java:363)

Caused by: java.lang.NullPointerException

        at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3101)

        ... 10 more

Tags (2)
5 REPLIES
Teradata Employee

Re: Teradata connection Error

The Troubleshooting section of the Teradata JDBC Driver Reference discusses that exception, and the possible causes.

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5.html#CHDIJJJH

Re: Teradata connection Error

com.data.jtdgss.tdgssManager:cannot initialize class because prior initialization attempts failed

Teradata Employee

Re: Teradata connection Error

Please provide some additional information:

- the complete stack trace

- the operating system and platform

- the JDK or JRE version

- the Teradata JDBC Driver version

- the classpath

- which application, or application server, is being run

N/A

Re: Teradata connection Error

Here is my version of Java that gave the same error as UMamahajan

Teradata Employee

Re: Teradata connection Error

@crwirz, it looks like you are running on some version of Windows.

Please provide additional information:

- the complete stack trace

- the Microsoft Windows version

- the Teradata JDBC Driver version

- the Java classpath

- which application, or application server, is being run