Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Teradata Connection Error

  1. #1
    Join Date
    Sep 2012
    Posts
    25

    Default Teradata Connection Error

    Hi,

    i am trying to load data into Teradata. i am able to successfully connect using spoon. when i run the job using kitchen, i get the below connection Error.
    i verified all the parameters, everything seems correct. i have the teradata jdbc driver copied to the JDBC folder. can you please tell me the reason for this error?

    INFO 01-07 15:59:30,494 - TIMELAB_TERADATA_DEV - New database connection defined
    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

    ERROR 01-07 15:59:31,365 - Transformation - Unable to prepare for execution of the transformation
    ERROR 01-07 15:59:31,366 - Transformation - org.pentaho.di.core.exception.KettleException:
    We failed to initialize at least one step. Execution can not begin!


    at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:932)
    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)

    INFO 01-07 15:59:31,387 - JOB_LOAD_RET_RATES_TD - Finished job entry [Transformation] (result=[false])
    INFO 01-07 15:59:31,388 - JOB_LOAD_RET_RATES_TD - Job execution finished
    INFO 01-07 15:59:31,389 - Kitchen - Finished!
    ERROR 01-07 15:59:31,390 - Kitchen - Finished with errors
    INFO 01-07 15:59:31,392 - Kitchen - Start=2013/07/01 15:59:29.417, Stop=2013/07/01 15:59:31.391

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Teradata JDBC Driver User Guide
    Appendix B Troubleshooting
    Section "Checking the environment parameters"

    If you receive a “UserFile parameter null” error, then the problem might be due to the
    classpath not being set, or the classpath being set incorrectly such that tdgssconfig.jarcannot
    be found. The tdgssconfig.jar file must be listed on the classpath.
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.