Hi
Just to update I am able to start my appagent and machine agent.
Also connection issue has been resolved as it was because of windows firewall.
Now I am seeing exceptions in server log
===========================================================
Caused by: com.singularity.ee.controller.beans.agent.db.DataCacheException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'controller.requestdata_summary' doesn't exist
at com.singularity.ee.controller.beans.agent.db.RequestMemoryDataStore.adjustStartingId(RequestMemoryDataStore.java:422)
at com.singularity.ee.controller.beans.agent.db.RequestMemoryDataStore.initFilter(RequestMemoryDataStore.java:340)
at com.singularity.ee.controller.beans.agent.db.RequestMemoryDataStore.init(RequestMemoryDataStore.java:310)
... 69 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'controller.requestdata_summary' doesn't exist
============================================================
Seems some of my mysql tables are not created,
- Does it get created as a standard installation
- if not then where can I find those scripts to create these tables.
Hi Rajeev,
We apologize for delay in response, We see such issues due controller system not meeting system requirements resulting in corruption of tables and also this could happen if controller mysql process is crashed somehow. Can you please send the following details to debug further:
- latest couple of server.log and database.log under <controller_install_dir>/logs path
- we will figure out the controller version from logs and will send you the steps and sql scripts to recreate tables once we analyzed the logs that we requested
To answer your other query, we expect all the relevant tables to be created during controller installation or successfull controller installation itself , let us know if the controller installation succeeded in first place.
Keep us posted requested information to assist you further.
Regards,
Arun