All Forums Connectivity
asridhar7 1 post Joined 04/13
01 Jul 2013
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>(Unknow n Source)
        at com.teradata.tdgss.jtdgss.TdgssManager.<init>(Unknown Source)
        at com.teradata.tdgss.jtdgss.TdgssManager.getInstance(Unk nown Source)
        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM(Gene ricTeraEncrypt.java:629)
        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(Ge nericTeraEncrypt.java:647)
        at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameF orOid(GenericTeraEncrypt.java:740)
        at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.j ava:50)
        at com.teradata.jdbc.jdbc.GenericLogonController.run(Gene ricLogonController.java:124)
        at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:216)
        at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6 _SQL_Connection.java:35)
        at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct SQLConnection(JDK6ConnectionFactory.java:25)
        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:179)
        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(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.connectUsingClas s(Database.java:482)
        at org.pentaho.di.core.database.Database.normalConnect(Da tabase.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.ini t(TableOutput.java:606)
        at org.pentaho.di.trans.step.StepInitThread.run(StepInitT hread.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.ini t (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.connectUsingClas s (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.createConnect ion (ConnectionFactory.java:169)
        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion (ConnectionFactory.java:179)
        at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct SQLConnection (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.getUserNameF orOid (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.dis pose (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.getDatabaseMetaD ata (Database.java:3101)

        at org.pentaho.di.core.database.Database.getDatabaseMetaD ata(Database.java:3105)
        at org.pentaho.di.core.database.Database.rollback(Databas e.java:724)
        at org.pentaho.di.core.database.Database.rollback(Databas e.java:713)
        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dis pose(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.getDatabaseMetaD ata(Database.java:3101)
        ... 10 more
 

tomnolan 594 posts Joined 01/08
01 Jul 2013

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
 

UMamahajan 1 post Joined 04/15
14 Apr 2015

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

tomnolan 594 posts Joined 01/08
15 Apr 2015

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
 

crwirz 1 post Joined 11/15
09 Nov 2015

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

tomnolan 594 posts Joined 01/08
10 Nov 2015

@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
 

You must sign in to leave a comment.