One Star

Job Process Fails - TNS:protocol adapter error

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: TNSSmiley Tonguerotocol 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.
1 REPLY
One Star

Re: Job Process Fails - TNS:protocol adapter error

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