topic Re: AMC Configuration issue in TAC in Talend Studio

AMC Configuration issue in TAC

Anonymous — Sat, 16 Nov 2024 10:28:23 GMT

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.

Re: AMC Configuration issue in TAC

Anonymous — Wed, 03 Aug 2016 23:20:47 GMT

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.

Re: AMC Configuration issue in TAC

Anonymous — Thu, 04 Aug 2016 14:19:25 GMT

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)

Re: AMC Configuration issue in TAC

Anonymous — Sun, 28 Aug 2016 04:07:26 GMT

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