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.

 

1 ACCEPTED SOLUTION

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

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