topic Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess in Talend Studio

Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Sat, 16 Nov 2024 07:30:04 GMT

Hello,

I have a Talend Job that works as a WS REST. So it is deployed in a container of Talend Runtime. The WS is working fine until yesterday where it was KO.

When i look on the container log i have this erros :

at project_ctpcrm_project_pcrm_0_1.SEC_CTPCRM_PROJECT_PCRM$RestServiceProviderImpl4TalendJob.processRequest(SEC_CTPCRM_PROJECT_PCRM.java:2175)

at project_pcrm.sec_ctpcrm_project_pcrm_0_1.SEC_CTPCRM_PROJECT_PCRM$RestServiceProviderImpl4TalendJob.parametres(SEC_CTPCRM_PROJECT_PCRM.java:2243)

Caused by: project_pcrm.sec_ctpcrm_project_pcrm_0_1.SEC_CTPCRM_PROJECT_PCRM$TalendException

at project_pcrm.sec_ctpcrm_project_pcrm_0_1.SEC_CTPCRM_PROJECT_PCRM.tRESTRequest_1_LoopProcess(SEC_CTPCRM_PROJECT_PCRM.java:17185)

at project_pcrm.sec_ctpcrm_project_pcrm_0_1.SEC_CTPCRM_PROJECT_PCRM$RestServiceProviderImpl4TalendJob.processRequest(SEC_CTPCRM_PROJECT_PCRM.java:2135)

... 43 more

Once I restarted the Windows service Talend-Container, the problem was solved, but the instability of WS or talend Runtime worries me because the same problem can happen again in production. I try to understand what happened to avoid the problem again.

Please can you help me.

Best regards,

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Wed, 10 Oct 2018 12:28:44 GMT

Hallo, Have you verified all the log files?

Verify log files present in container/log/tesb.log & container/data/logs, you may able to identify the root cause.

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Wed, 10 Oct 2018 16:49:12 GMT

Hi Ram,

Thank you for your answer.

I looked on the first log file tesb.log witch present in container/logs but i don't find the folder logs in container/data/.

Otherwise, the logs in tesb.log don't display the catch of LoopProcess method.

My WebService (WS) is deployed in Talend Runtime that installed in the VM Azure. So when I m deconnected from the session of this VM and try to call my WS i have this error like "The operation has timed out / url :http://server01.net/services/MyWS"

But once I restart the Talend Runtime Container , the WS works again.

Normally, I don't must be connected to the VM to call my WS?

Best regards,

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Fri, 12 Oct 2018 16:01:17 GMT

When you connected to the VM session, how you tested the service ? from outside the VM or within ? Just to understand if you need to enable Security Groups.

How you start the Runtime using trun.sh/bat ? If you are closing the trun.sh/bat window then Runtime will stop.

You need to install the Runtime as a container Service.

https://help.talend.com/reader/_zCTtDbUbgf9AGOJY8pz1Q/OOynyYh2LAh2um_8ZKOXrA

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Mon, 15 Oct 2018 11:25:37 GMT

Hi Ram

When you connected to the VM session, how you tested the service ? from outside the VM or within ? Just to understand if you need to enable Security Groups.

I test the service from outside the VM.

How you start the Runtime using trun.sh/bat ? If you are closing the trun.sh/bat window then Runtime will stop.

You need to install the Runtime as a container Service.

I installed the Runtime as a container Service Windows

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Tue, 16 Oct 2018 10:40:25 GMT

Hi Ram,

i found this log in Wrapper.log:

I/O Error: Connection reset by peer: socket write error
INFO | jvm 1 | 2018/10/16 08:15:08 | Exception in component talendLogs_DB
INFO | jvm 1 | 2018/10/16 08:15:08 | java.sql.SQLException: Invalid state, the Connection object is closed.
INFO | jvm 1 | 2018/10/16 08:15:08 | at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
INFO | jvm 1 | 2018/10/16 08:15:08 | at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
INFO | jvm 1 | 2018/10/16 08:15:08 | at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
INFO | jvm 1 | 2018/10/16 08:15:08 | at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1030)
INFO | jvm 1 | 2018/10/16 08:15:08 | at project_cible.sec_ctcible_iodas_cible_0_1.SEC_CTCIBLE_PROJECT_CIBLE.talendLogs_LOGSProcess(SEC_CTCIBLE_PROJECT_CIBLE.java:21982)
INFO | jvm 1 | 2018/10/16 08:15:08 | at project_cible.sec_ctcible_iodas_cible_0_1.SEC_CTCIBLE_PROJECT_CIBLE.tWarn_1Process(SEC_CTCIBLE_PROJECT_CIBLE.java:5101)
INFO | jvm 1 | 2018/10/16 08:15:08 | at project_cible.sec_ctcible_project_cible_0_1.SEC_CTCIBLE_PROJECT_CIBLE.tRESTRequest_1_LoopProcess(SEC_CTCIBLE_PROJECT_CIBLE.java:17201)
INFO | jvm 1 | 2018/10/16 08:15:08 | at project_pcible.sec_ctcible_project_cible_0_1.SEC_CCIBLE_PROJECT_CIBLE$RestServiceProviderImpl4TalendJob.processRequest(SEC_CCIBLE_PROJECT_CIBLE.java:2135)
INFO | jvm 1 | 2018/10/16 08:15:08 | at project_cible.sec_ctcible_project_cible_0_1.SEC_CTCIBLE_PROJECT_CIBLE$RestServiceProviderImpl4TalendJob.parametres(SEC_CTCIBLE_PROJECT_CIBLE.java:2243)
INFO | jvm 1 | 2018/10/16 08:15:08 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2018/10/16 08:15:08 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO | jvm 1 | 2018/10/16 08:15:08 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)....

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Tue, 16 Oct 2018 11:09:43 GMT

Okay looks the connection is already closed either in the Job or sql server end.
If you are deploying to Talend Runtime then we suggest to install the Datasource in Talend Runtime & use the option in Studio to get a connection from a shared pool
Using Datasource will allow you to get a fresh connection in free pool.
https://help.talend.com/reader/RSK3bOuToRo~hY3T_fdAFQ/s9CD_YiKCffOzUVudm0trw

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Tue, 16 Oct 2018 11:44:04 GMT

Thank you , i try to made your solution. the problem concerns the database talend AMC logs.

But could you indicates to me where i find "the option in Studio to get a connection from a shared pool"?

Because, I declare the connection of stats and logs in the project settings and I share this connection in all jobs.

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Wed, 17 Oct 2018 10:56:26 GMT

Hi Ram,

I try to install the last driver of sql server mssql-jdbc-7.0.0.jre8.jar from the file system C:\ using bundle:install but I don't know where i have to execute the commande line folow:
bundle:install
wrap:file:E:/talend/TESB/db/mssql/sqljdbc4-3.0.jar\\$Bundle-SymbolicName=
com.microsoft.sqlserver.jdbc&Bundle-Version=3.0&Bundle-Name=
'JDBC Driver for SQL Server'

I try to execute this command by connecting with trun.bat as Admin but i have some error.

Please could you help me !

Re: Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

Anonymous — Wed, 17 Oct 2018 12:28:43 GMT

You can also simply copy to the deploy folder the sqljdbc4*.jar
Based on your sqlserver version you need to the use Driver jar => sqljdbc4*.jar