connecting with wrong user to mssql

Anonymous — Sat, 16 Nov 2024 04:34:15 GMT

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 ?

Re: connecting with wrong user to mssql

Anonymous — Thu, 26 Sep 2019 09:57:37 GMT

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

Re: connecting with wrong user to mssql

Anonymous — Mon, 30 Sep 2019 08:58:30 GMT

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/MonitoringService/v1}putEvents 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>

Re: connecting with wrong user to mssql

Anonymous — Tue, 01 Oct 2019 02:33:14 GMT

Hello,

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

Best regards

Sabrina

topic Re: connecting with wrong user to mssql in Installing and Upgrading

connecting with wrong user to mssql

Re: connecting with wrong user to mssql

Re: connecting with wrong user to mssql

Re: connecting with wrong user to mssql