One Star

Teradata JDBC Connection

Hi team,
I am using Talend Team edition 4.2 using to to load Teradata database. I have Install Teradata Client on my machine. I have two jar file:
1. tdgssconfig.jar
2. terajdbc4.jar
and placed in C:\jdbc Folder.
url string is com.teradata://<Ip_Config>/<DB_Name>
I have Class path environement variable as c:\jdbc
there is no space in the Talend Studio Directory.

I am using tTeradataMultiload Component to load database.
While executing tthe Job I have encounter the following error. I tried alot to solve but could not. Help me to solve this. Let me know if more info is requested.

connecting to socket on port 3482
connected
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:623)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:641)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:734)
at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
at com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:218)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:127)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:219)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:152)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.tJDBCConnection_1Process(Utility_Log_TableEnd_Stage.java:529)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJobInTOS(Utility_Log_TableEnd_Stage.java:2404)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJob(Utility_Log_TableEnd_Stage.java:2201)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tRunJob_5Process(Teradata_AccountProgram.java:2383)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_5Process(Teradata_AccountProgram.java:2080)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tTeradataMultiLoad_1Process(Teradata_AccountProgram.java:1988)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tFileInputXML_1Process(Teradata_AccountProgram.java:1790)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_3Process(Teradata_AccountProgram.java:698)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.runJobInTOS(Teradata_AccountProgram.java:2834)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.main(Teradata_AccountProgram.java:2555)
Exception in component tJDBCConnection_1
java.lang.NullPointerException
at com.teradata.tdgss.jtdgss.TdgssConfigApi.GetMechanisms(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:623)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:641)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:734)
at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
at com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:218)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:127)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:219)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:152)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.tJDBCConnection_1Process(Utility_Log_TableEnd_Stage.java:529)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJobInTOS(Utility_Log_TableEnd_Stage.java:2404)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJob(Utility_Log_TableEnd_Stage.java:2201)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tRunJob_5Process(Teradata_AccountProgram.java:2383)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_5Process(Teradata_AccountProgram.java:2080)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tTeradataMultiLoad_1Process(Teradata_AccountProgram.java:1988)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tFileInputXML_1Process(Teradata_AccountProgram.java:1790)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_3Process(Teradata_AccountProgram.java:698)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.runJobInTOS(Teradata_AccountProgram.java:2834)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.main(Teradata_AccountProgram.java:2555)
Exception in component tRunJob_5
java.lang.RuntimeException: Child job running failed
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tRunJob_5Process(Teradata_AccountProgram.java:2401)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_5Process(Teradata_AccountProgram.java:2080)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tTeradataMultiLoad_1Process(Teradata_AccountProgram.java:1988)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tFileInputXML_1Process(Teradata_AccountProgram.java:1790)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_3Process(Teradata_AccountProgram.java:698)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.runJobInTOS(Teradata_AccountProgram.java:2834)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.main(Teradata_AccountProgram.java:2555)
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:623)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:641)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:734)
at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
at com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:218)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:127)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:219)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:152)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.tJDBCConnection_1Process(Utility_Log_TableEnd_Stage.java:529)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJobInTOS(Utility_Log_TableEnd_Stage.java:2404)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJob(Utility_Log_TableEnd_Stage.java:2201)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tRunJob_5Process(Teradata_AccountProgram.java:2383)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_6Process(Teradata_AccountProgram.java:2494)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.runJobInTOS(Teradata_AccountProgram.java:2847)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.main(Teradata_AccountProgram.java:2555)
Exception in component tJDBCConnection_1
java.lang.NullPointerException
at com.teradata.tdgss.jtdgss.TdgssConfigApi.GetMechanisms(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:623)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:641)
at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:734)
at com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
at com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:218)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:127)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:219)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:152)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.tJDBCConnection_1Process(Utility_Log_TableEnd_Stage.java:529)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJobInTOS(Utility_Log_TableEnd_Stage.java:2404)
at aci_roundy_32.utility_log_tableend_stage_2_0.Utility_Log_TableEnd_Stage.runJob(Utility_Log_TableEnd_Stage.java:2201)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tRunJob_5Process(Teradata_AccountProgram.java:2383)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_6Process(Teradata_AccountProgram.java:2494)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.runJobInTOS(Teradata_AccountProgram.java:2847)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.main(Teradata_AccountProgram.java:2555)
Exception in component tRunJob_5
java.lang.RuntimeException: Child job running failed
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tRunJob_5Process(Teradata_AccountProgram.java:2401)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.tJava_6Process(Teradata_AccountProgram.java:2494)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.runJobInTOS(Teradata_AccountProgram.java:2847)
at aci_roundy_32.teradata_accountprogram_2_0.Teradata_AccountProgram.main(Teradata_AccountProgram.java:2555)
disconnected
Job Teradata_AccountProgram ended at 22:32 08/07/2012.
11 REPLIES
One Star

Re: Teradata JDBC Connection

Hi
I'm just curious about this.
Why don't you use the components under teradata family in TOS which can offer better performance and Talend support?
Regards,
Pedro
One Star

Re: Teradata JDBC Connection

I am very new to Teradata and so Talend. I used tTeradatafastloadutilityprotol as well. but the same issue.
May I request you to let me know the correct component.
One Star

Re: Teradata JDBC Connection

Hi
I notice you are using tJDBCConnection and you didn't configure it correctly. That's why you got a nullpointerexcetion.
What's your essential requirement? What's the design of your job?
Regards,
Pedro
One Star

Re: Teradata JDBC Connection

I have to load teradata database. my source file is dat file and I am using JDBC Connection to insert Audit info like start time, end time and seq id. then disable any index on the table. after that load database, archive file and enable the index.
One Star

Re: Teradata JDBC Connection

Hi
According to your description, you can use two components about teradata.
tTeradataOutput is used for loading data while tTeradataRow can disable or enable index.
Regards,
Pedro
One Star

Re: Teradata JDBC Connection

Thanks Pedro. But I also need tJDBCConnection. I am attaching my Screen shot. I would be great help, if you point out the missing configuration in JDBC. Also Let me know if you need more info.
One Star

Re: Teradata JDBC Connection

did you get a chance to check? I check my job for Netezza databasee and its working fine as attached.
But for Teradata, its not.
One Star

Re: Teradata JDBC Connection

Hi Pedro,
its a bit urgent. can you please help me to sort it out? let me know if addition info is required
Cheers,
Siegfried
One Star

Re: Teradata JDBC Connection

Hi
I suggest that you should use the components under teradata famlily in TOS.
Because the JDBC jar files about teradata may cause some unexpected errors due to wrong version.
Why don't you download the document and read the instructions about teradata components? They are much more efficient than JDBC way.
Regards,
Pedro
One Star

Re: Teradata JDBC Connection

Thanks Pedro for youre reply and your suggeation.
As we are using DB type as our context and based on the DB, job will be executed and hence I am emphasize on to use JDBC Connection.
I check the version of the JDBC and its matching with the Teradata DB. I will also check your option.
Apart from this, I would like to know one more thing on Datatype. My target and source tables have Numeric datatype in Netezza Database. I need to implement one complex expression that has mathematical operation and case statement too.
but during implementation, I am facing several problem like big decimal issue and division required option like half down,half up etc.
Could you please help me to opt the better approach to implement this?
Cheers
Siegfried
One Star

Re: Teradata JDBC Connection

Hi
Because this expression is complicated, I sugget that you should create a custom routine, which would make all stuff and your thought clear.
Regards,
Pedro