AppD Archive

Appagent/Machine agent unable to connect to controller

CommunityUser
Splunk Employee
Splunk Employee

Hi,

Have configured Appagent (For tibco BW application) and machine agent (Linux)

but it is unable to connec to controller.

Attached are appagent/controller.xml file

machineagent/controller.xml file

Log files for both

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

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.

0 Karma

Arun_Dasetty
Super Champion

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

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...