AMC Configuration issue in TAC

[Anonymous]

Hi Team,
To configure AMC in TAC for Talend Data fabric 6.1.1., what datasource name have to provide in TAC ? is there any where we need to configure it ? 
For driver issue i have configured mysql driver in amc,tac and tomcat lib folders, it got resolved.
I am configured AMC in studio, its properly running. But from TAC getting below errors.
Exception in component connectionStatsLogs
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at routines.system.SharedDBConnectionLog4j.getConnection(SharedDBConnectionLog4j.java:86)
at routines.system.SharedDBConnectionLog4j.getDBConnection(SharedDBConnectionLog4j.java:166)
at bdpoc.testamc_0_1.TestAMC.connectionStatsLogsProcess(TestAMC.java:1600)
at bdpoc.testamc_0_1.TestAMC.preStaLogConProcess(TestAMC.java:473)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5014)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)
Exception in component talendStats_DB
java.lang.NullPointerException
at bdpoc.testamc_0_1.TestAMC.talendStats_STATSProcess(TestAMC.java:3286)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5025)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)
Exception in component talendLogs_DB
java.lang.NullPointerException
at bdpoc.testamc_0_1.TestAMC.talendLogs_LOGSProcess(TestAMC.java:2256)
at bdpoc.testamc_0_1.TestAMC.tWarn_1Process(TestAMC.java:1233)
at bdpoc.testamc_0_1.TestAMC.tFixedFlowInput_1Process(TestAMC.java:1012)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5033)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)
Exception in component talendStats_DB
java.lang.NullPointerException
at bdpoc.testamc_0_1.TestAMC.talendStats_STATSProcess(TestAMC.java:3286)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5059)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)
Please help to solve this problem asap.

[Anonymous]

The AMC is its own web application and needs the MySQL driver. The TAC only provides the database URL to the AMC application.
Put the MySQL driver in the tomcat endorsed/ directory and restart the tomcat again.

[Anonymous]

Thanks for quick reply. I have included mysql connector j in tomcat endorsed folder. Now AMC is configured properly. But by jobs are running properly in Talend studio but same jobs are failing below error when i scheduled it job conductor. Please help me with asap.


[INFO ]: bdpoc.testamc_0_1.TestAMC - talendLogs_DB - Start to work.
[FATAL]: bdpoc.testamc_0_1.TestAMC - talendLogs_DB null
[INFO ]: bdpoc.testamc_0_1.TestAMC - talendLogs_DB - Start to work.
[FATAL]: bdpoc.testamc_0_1.TestAMC - talendLogs_DB null
[INFO ]: bdpoc.testamc_0_1.TestAMC - talendStats_DB - Start to work.
[FATAL]: bdpoc.testamc_0_1.TestAMC - talendStats_DB null
[INFO ]: bdpoc.testamc_0_1.TestAMC - talendLogs_DB - Start to work.
[FATAL]: bdpoc.testamc_0_1.TestAMC - talendLogs_DB null
Exception in component connectionStatsLogs
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at routines.system.SharedDBConnectionLog4j.getConnection(SharedDBConnectionLog4j.java:86)
at routines.system.SharedDBConnectionLog4j.getDBConnection(SharedDBConnectionLog4j.java:166)
at bdpoc.testamc_0_1.TestAMC.connectionStatsLogsProcess(TestAMC.java:1600)
at bdpoc.testamc_0_1.TestAMC.preStaLogConProcess(TestAMC.java:473)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5014)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)
Exception in component talendStats_DB
java.lang.NullPointerException
at bdpoc.testamc_0_1.TestAMC.talendStats_STATSProcess(TestAMC.java:3286)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5025)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)
Exception in component talendLogs_DB
java.lang.NullPointerException
at bdpoc.testamc_0_1.TestAMC.talendLogs_LOGSProcess(TestAMC.java:2256)
at bdpoc.testamc_0_1.TestAMC.tWarn_1Process(TestAMC.java:1233)
at bdpoc.testamc_0_1.TestAMC.tFixedFlowInput_1Process(TestAMC.java:1012)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5033)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)
Exception in component talendStats_DB
java.lang.NullPointerException
at bdpoc.testamc_0_1.TestAMC.talendStats_STATSProcess(TestAMC.java:3286)
at bdpoc.testamc_0_1.TestAMC.runJobInTOS(TestAMC.java:5059)
at bdpoc.testamc_0_1.TestAMC.main(TestAMC.java:4858)

[Anonymous]

Hello rafisk 
Check your mysql version and make sure you put the right driver connector for your mysql version, and select the corresponding version in stats & logs settings. 


Regards
Shong