Corrupt Components?

Anonymous — Sat, 16 Nov 2024 12:30:33 GMT

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.ClassNotFoundException racle.jdbc.driver.OracleDriver |
| code | 1 |
+------------+------------------------------------------------------------------+

disconnected

Re: Corrupt Components?

Anonymous — Thu, 15 Dec 2011 05:28:01 GMT

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

Re: Corrupt Components?

Anonymous — Thu, 15 Dec 2011 14:36:28 GMT

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

Re: Corrupt Components?

Anonymous — Fri, 16 Dec 2011 19:24:48 GMT

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

topic Re: Corrupt Components? in Talend Studio

Corrupt Components?

Re: Corrupt Components?

Re: Corrupt Components?

Re: Corrupt Components?