connecting with wrong user to mssql

[Anonymous]

Hello,

We have a trouble after restart Windows, Talend connecting with wrong user (user test) to db mssql. That one user doesn't exist. Everything working fine after refresh SAM bundles. We need to automized after restart is it some solution ?

[Anonymous]

Hello,

Is there any error message in tesb.log? If so, we will appreciate it a lot if you could post the information here.

Best regards

Sabrina

[Anonymous]

Here is info from tesb.log (there is problem after restart server) - after refresh SAM bundles is working fine again

 at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) ~[246rg.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
... 57 more
2019-09-25T19:25:42,989 | INFO | qtp1268440513-108 | ache.cxf.common.logging.LogUtils 478 | 32 - org.apache.cxf.cxf-core - 3.1.11 | Application {http://service.soap.sam.esb.talend.org/}MonitoringWebServiceService#{http://www.talend.org/esb/sam/M... has thrown exception, unwinding now: org.talend.esb.sam.monitoringservice.v1.PutEventsFault: Unknown error Could not get JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user test. ClientConnectionId:3263006e-7e4c-4f89-ae2e-0d9137e091a3
2019-09-25T19:25:44,661 | INFO | qtp1268440513-98 | eptor.AbstractLoggingInterceptor 274 | 32 - org.apache.cxf.cxf-core - 3.1.11 | Inbound Message
----------------------------
ID: 20
Address: http://10.199.1.137:8040/services/w1_service
Encoding: UTF-8
Http-Method: POST
Content-Type: application/soap+xml;charset=UTF-8;action="http://www.talend.org/service/product"
Headers: {accept-encoding=[gzip,deflate], connection=[keep-alive], Content-Length=[328], content-type=[application/soap+xml;charset=UTF-8;action="http://www.talend.org/service/product"], Host=[10.199.1.137:8040], User-Agent=[Apache-HttpClient/4.1.1 (java 1.5)]}
Payload: <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://www.talend.org/service/">
<soap:Header/>
<soap:Body>
<ser:AGR0_GETPRODLIST_REQ>
<LINE_ID>L01</LINE_ID>
<LINE_HASH>ORIWIN_TEST</LINE_HASH>
</ser:AGR0_GETPRODLIST_REQ>
</soap:Body>
</soap:Envelope>
 

[Anonymous]

Hello,

Could you please create a jira issue of ESB project on talend bug tracker?

Best regards

Sabrina