Corrupt Components?

One Star

Corrupt Components?

Hi,
We are having problems with Talend components (tsql and jdbc driver) in our Talend Server Production Environment.
We have been restarting the job server, and commandline service to remedy the situation, but the occurence of the problem has been happening frequently.
See instances below:
1) We did not change any configuration on the server, but we suddenly got the exception error below on jobs that connect to any SQL Server Database. A service (job server and commandline) temporarily fixed the problem, but we would like to know how we can permanently solve this problem.
2) Suddenly, Talend cannot find oracle jdbc driver on the server. How can we permanently eliminate the occurrence of this problem.
Please explain why we are having this issue, and how we can solve this problem.
Thank you,
Matthew Tan
mtan@fordham.edu
Exception in thread "main" java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.NoClassDefFoundError: org/talend/designer/components/util/mssql/MSSqlUtilFactory
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tSystem_4Process(pfaidsExtractWithDeltas.java:2423)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.runJobInTOS(pfaidsExtractWithDeltas.java:12546)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.main(pfaidsExtractWithDeltas.java:12322)
Caused by: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.NoClassDefFoundError: org/talend/designer/components/util/mssql/MSSqlUtilFactory
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tMSSqlConnection_1Process(pfaidsExtractWithDeltas.java:2559)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tSystem_4Process(pfaidsExtractWithDeltas.java:2411)
... 2 more
Caused by: java.lang.Error: java.lang.Error: java.lang.NoClassDefFoundError: org/talend/designer/components/util/mssql/MSSqlUtilFactory
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tOracleConnection_1Process(pfaidsExtractWithDeltas.java:2688)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tMSSqlConnection_1Process(pfaidsExtractWithDeltas.java:2537)
... 3 more
Caused by: java.lang.Error: java.lang.NoClassDefFoundError: org/talend/designer/components/util/mssql/MSSqlUtilFactory
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tMSSqlInput_3Process(pfaidsExtractWithDeltas.java:5561)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tOracleConnection_1Process(pfaidsExtractWithDeltas.java:2666)
... 4 more
Caused by: java.lang.NoClassDefFoundError: org/talend/designer/components/util/mssql/MSSqlUtilFactory
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tMSSqlInput_3Process(pfaidsExtractWithDeltas.java:4075)
... 5 more
Caused by: java.lang.ClassNotFoundException: org.talend.designer.components.util.mssql.MSSqlUtilFactory
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Exception in component tOracleConnection_1
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tOracleConnection_1Process(pfaidsExtractWithDeltas.java:2612)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tMSSqlConnection_1Process(pfaidsExtractWithDeltas.java:2537)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.tSystem_4Process(pfaidsExtractWithDeltas.java:2411)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.runJobInTOS(pfaidsExtractWithDeltas.java:12546)
at onbase.pfaidsextractwithdeltas_8_0.pfaidsExtractWithDeltas.main(pfaidsExtractWithDeltas.java:12322).-------------------------------------------------------------------------------.
| #1. tLogRow_1 |
+------------+------------------------------------------------------------------+
| key | value |
+------------+------------------------------------------------------------------+
| moment | 2011-12-14 06:00:01 |
| pid | 20111214060000_QMiWe |
| root_pid | 20111214060000_QMiWe |
| father_pid | 20111214060000_QMiWe |
| project | ONBASE |
| job | pfaidsExtractWithDeltas |
| context | Default |
| priority | 6 |
| type | Java Exception |
| origin | tOracleConnection_1 |
| message | java.lang.ClassNotFoundExceptionSmiley Surprisedracle.jdbc.driver.OracleDriver |
| code | 1 |
+------------+------------------------------------------------------------------+

disconnected
One Star

Re: Corrupt Components?

Hi
Please show me more details about your OS, TIS version, Installation path.
And recheck whether there is space in your TIS installation path.
For example, 'C:/Program Files/TIS/'. Do not install TIS here.
Best regards!
Pedro
One Star

Re: Corrupt Components?

Hi Pedro,
Talend RTX on OS : Windows 2008 R2 (Service Pack 1)
TIS commandline Path : D:\Talend\Commandline\Commandline (132 GB Free Space)
Java Version: jdk1.6.0_24
Talend Version: 4.1.2
One Star

Re: Corrupt Components?

This was the resolution given by Talend Support Team:
Dear Matthew,
Please shut down your tomcat/jobservers and then open your TAC's configuration.properties file located at tomcat/webapps/org.talend.administrator/WEB-INF/classes/
Open this file and make sure you set the following setting:
jobServer.usercache=false
Restart your jobserver and Tomcat to see if you encounter the problem further.
Also, it appears that you are not running the latest service pack of Talend which is 4.1.3. We HIGHLY recommend that you make plans to move to 4.1.3 as soon as possible since 4.1.3 resolved many of 4.1.2 issues.
Please let us know your thoughts.
At any time, you can check out the information related to this ticket by visiting: http://support.talend.com/otrs/customer.pl?Action=CustomerZoom&TicketID=8071
Best regards,
The Talend Support Team