Probleme with tRestRequest: Exception in tRESTRequest_1_LoopProcess

[Anonymous]

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 :

14:48:16,502 | WARN  | qtp386639925-162 | pl.WebApplicationExceptionMapper   72 | 99 - org.apache.cxf.cxf-rt-frontend-jaxrs - 3.1.4 | javax.ws.rs.WebApplicationException: HTTP 500 Internal Server Error

            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,

[Anonymous]

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.

[Anonymous]

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,

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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)....

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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 !

[Anonymous]

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