Job Process Fails - TNS:protocol adapter error

Anonymous — Fri, 23 Mar 2012 21:11:55 GMT

Using Talend Open Studio 4.0
Repository Local
Windows XP Service Pack 3
Latest Version of Java installed
The talend job was developed by a former employee and there really isn't any documentation on the job process. We run this job about once a month and it worked in Feb. When the job was run this week we received the following errors.
In the Talend Open Studio application:
Exception in component tOracleInput_1
java.sql.SQLException: ORA-12560: TNS rotocol adapter error
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
at vtigercrm_integration_process.prod_crm_all_users_0_1.PROD_CRM_ALL_USERS.tOracleInput_1Process (PROD_CRM_ALL_USERS.java:4544)
at vtigercrm_integration_process.prod_crm_all_users_0_1.PROD_CRM_ALL_USERS.runJobInTOS (PROD_CRM_ALL_USERS.java:13025)
at vtigercrm_integration_process.prod_crm_all_users_0_1.PROD_CRM_ALL_USERS.main
(PROD_CRM_ALL_USERS.java:12899)
disconnected
We have also looked at the log that was created:

LOG FILE
!ENTRY org.talend.libraries 1 0 2012-03-22 13:04:59.769
!MESSAGE 2012-03-22 13:04:59,769 INFO org.talend.designer.runprocess.Processor - Command line: C:/Program Files/Java/jdk1.6.0_22/jre/bin/java.exe -Xms256M -Xmx1024M -cp C:/talend/lib/java/advancedPersistentLookupLib.jar;C:/talend/lib/java/commons-collections-3.2.jar;
C:/talend/lib/java/javacsv.jar;C:/talend/lib/java/jboss-serialization.jar;
C:/talend/lib/java/log4j-1.2.15.jar;
C:/talend/lib/java/mysql-connector-java-5.1.0-bin.jar;
C:/talend/lib/java/ojdbc14-10g.jar;
C:/talend/lib/java/talend_file_enhanced_20070724.jar;
C:/talend/lib/java/trove.jar;
C:/talend/lib/java/xdb.jar;
C:/talend/lib/java/xmlparserv2.jar;
C:/talendwks/.Java/classes;
C:/talend/lib/java;
vtigercrm_integration_process.prod_crm_all_users_0_1.PROD_CRM_ALL_USERS --context=Default --stat_port=3345 %*
!SESSION 2012-03-22 13:15:27.237 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_22
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86
!ENTRY org.talend.libraries 1 0 2012-03-22 13:31:35.313
!MESSAGE 2012-03-22 13:31:35,297 INFO org.talend.repository.model.ProxyRepositoryFactory - itsupport@birchstreet.net logged on VTIGERCRM_INTEGRATION_PROCESS

!ENTRY org.talend.libraries 1 0 2012-03-22 13:34:14.508
!MESSAGE 2012-03-22 13:34:14,508 INFO org.talend.designer.runprocess.Processor - Command line: C:/Program Files/Java/jdk1.6.0_22/jre/bin/java.exe -Xms256M -Xmx1024M -cp C:/talend/lib/java/advancedPersistentLookupLib.jar;
C:/talend/lib/java/commons-collections-3.2.jar;
C:/talend/lib/java/javacsv.jar;
C:/talend/lib/java/jboss-serialization.jar;
C:/talend/lib/java/log4j-1.2.15.jar;
C:/talend/lib/java/mysql-connector-java-5.1.0-bin.jar;
C:/talend/lib/java/ojdbc14-10g.jar;
C:/talend/lib/java/talend_file_enhanced_20070724.jar;
C:/talend/lib/java/trove.jar;
C:/talend/lib/java/xdb.jar;
C:/talend/lib/java/xmlparserv2.jar;
C:/talendwks/.Java/classes;
C:/talend/lib/java; vtigercrm_integration_process.prod_crm_all_users_0_1.PROD_CRM_ALL_USERS --context=Default --stat_port=3439 %*
!SESSION 2012-03-22 13:36:23.470 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_22
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86
!ENTRY org.talend.libraries 1 0 2012-03-22 13:36:56.359
!MESSAGE 2012-03-22 13:36:56,343 INFO org.talend.repository.model.ProxyRepositoryFactory - itsupport@birchstreet.net logged on VTIGERCRM_INTEGRATION_PROCESS

!ENTRY org.talend.libraries 1 0 2012-03-22 13:38:59.977
!MESSAGE 2012-03-22 13:38:59,977 INFO org.talend.designer.runprocess.Processor - Command line: C:/Program Files/Java/jdk1.6.0_22/jre/bin/java.exe -Xms256M -Xmx1024M -cp C:/talend/lib/java/advancedPersistentLookupLib.jar;
C:/talend/lib/java/commons-collections-3.2.jar;
C:/talend/lib/java/javacsv.jar;
C:/talend/lib/java/jboss-serialization.jar;
C:/talend/lib/java/log4j-1.2.15.jar;
C:/talend/lib/java/mysql-connector-java-5.1.0-bin.jar;
C:/talend/lib/java/ojdbc14-10g.jar;
C:/talend/lib/java/talend_file_enhanced_20070724.jar;
C:/talend/lib/java/trove.jar;
C:/talend/lib/java/xdb.jar;
C:/talend/lib/java/xmlparserv2.jar;
C:/talendwks/.Java/classes;
C:/talend/lib/java; vtigercrm_integration_process.prod_crm_all_users_0_1.PROD_CRM_ALL_USERS --context=Default --stat_port=3820 %*
!SESSION 2012-03-23 13:35:54.478 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_22
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86
!ENTRY org.talend.libraries 1 0 2012-03-23 13:41:08.975
!MESSAGE 2012-03-23 13:41:08,959 INFO org.talend.repository.model.ProxyRepositoryFactory - itsupport@birchstreet.net logged on VTIGERCRM_INTEGRATION_PROCESS

!ENTRY org.talend.libraries 1 0 2012-03-23 13:43:16.664
!MESSAGE 2012-03-23 13:43:16,664 INFO org.talend.designer.runprocess.Processor - Command line: C:/Program Files/Java/jdk1.6.0_22/jre/bin/java.exe -Xms256M -Xmx1024M -cp C:/talend/lib/java/advancedPersistentLookupLib.jar;
C:/talend/lib/java/commons-collections-3.2.jar;
C:/talend/lib/java/javacsv.jar;
C:/talend/lib/java/jboss-serialization.jar;
C:/talend/lib/java/log4j-1.2.15.jar;
C:/talend/lib/java/mysql-connector-java-5.1.0-bin.jar;
C:/talend/lib/java/ojdbc14-10g.jar;
C:/talend/lib/java/talend_file_enhanced_20070724.jar;
C:/talend/lib/java/trove.jar;
C:/talend/lib/java/xdb.jar;
C:/talend/lib/java/xmlparserv2.jar;
C:/talendwks/.Java/classes;
C:/talend/lib/java; vtigercrm_integration_process.prod_crm_all_users_0_1.PROD_CRM_ALL_USERS --context=Default --stat_port=3832 %*
I'm new to the talend program and java so I'm not sure what information is relevant and what can be ignored. I saw posts regarding changing the random number generator in the java.security file. I checked this file and the value was already urandom. Is this a problem because the job can't connect to our database or is it connecting to the database but then losing the connection?
Thanks for any help or direction you can provide.

Re: Job Process Fails - TNS:protocol adapter error

Anonymous — Mon, 26 Mar 2012 05:59:07 GMT

Hi
Welcome to Talend Community!

ORA-12560: TNS:protocol adapter error

You'd better check whether you start up oraclehome92TNSlistener and oracleserviceXXXX(db instance) in Services.
Regards,
Pedro

topic Job Process Fails - TNS:protocol adapter error in Talend Studio

Job Process Fails - TNS:protocol adapter error

Re: Job Process Fails - TNS:protocol adapter error