ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

Four Stars

ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

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.

 


Accepted Solutions
Employee

Re: ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

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


All Replies
Moderator

Re: ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

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

--
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: ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

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>

 

 

 

 

Employee

Re: ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

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

Moderator

Re: ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

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

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

Re: ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch