connecting with wrong user to mssql

Four Stars

connecting with wrong user to mssql

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 ?

Moderator

Re: connecting with wrong user to mssql

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: connecting with wrong user to mssql

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) ~[246Smiley Surprisedrg.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>
 

Moderator

Re: connecting with wrong user to mssql

Hello,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read