ACTIVITY MONITORING CONSOLE - failed to connect database -MSSQL

Highlighted
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
Highlighted
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

View solution in original post


All Replies
Highlighted
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.
Highlighted
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>

 

 

 

 

Highlighted
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

View solution in original post

Highlighted
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.
Highlighted
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.

2019 GARTNER 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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog