ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

[Anonymous]

We are getting "failed to connect database" error (DB check -passed) on opening of AMC

1. Tables are created in DB

2. jtds-1.3.1.jar file has been to WEB-INF\lib folder.

on checking logs we found

ERROR RemoteDataRetreiver  - This locker is already stopped or is shutting down !

Details of env

Environment: TAC

Talend Version: 6.2.1

AMC db: MSSQL -2015 (Version 12.0.5546.0)

Thanks.

[Anonymous]

Hello,

Did you deploy amc and tac on different host? Where is your MSSQL DB? Is all well with the DB connection? More information will be preferred.

Best regards

Sabrina

[Anonymous]

Hi,

Comments inline.

Did you deploy amc and tac on different host?

<AMC , TAC are in one server>

Where is your MSSQL DB?

<MSSQL DB is hosted on different server>

Is all well with the DB connection?

<Yes-Check succeeded>

[Anonymous · Accepted solution]

I have got this error & here is the solution:

1) try to put msql jdbc driver into below folder

<tomcat home>/apache-tomcat\endorsed

restart tomcat

2) If that doesn't work, try to place mssql jdbc file at below path:

apache-tomcat\webapps\amc\WEB-INF\plugins\org.talend.amc.libraries_6.X.X.YYYYMMDD_XXXX\lib\ext

Try again

[Anonymous]

Hello,

Please take a look at this jira issue:https://jira.talendforge.org/browse/TUP-16408

Let us know if it is Ok with you.

Best regards

Sabrina

[Anonymous]

For Apache Tomcat 8.0, put the JDBC drivers in the <apache-tomcat>/endorsed path. For Apache Tomcat 8.5, you need to put the JDBC drivers in the <apache-tomcat>/lib path. For more information, see Installing database drivers in your Web application server, on the Talend Help Center.