Error: [ecc_agent_status] table record missing for MIDSERVER "Midserver name" : no thrown error in Logs.

Error Log - [ecc_agent_status] table record missing for MIDSERVER "Midserver name" : no thrown error in Logs.

Cause: (Cloning is causing this error. You did not add all related midserver tables to your exclude tables in clone configuration)

Each MIDServer should have a matching record in ecc_agent_status table. So, if you have 10 MIDServers, you will have its 10 corresponding ecc_agent_status records.

If you see an empty record(MIDServer is empty) in ecc_agent_status table, then you will get an error for a MIDServer.

The sys_id (Open the empty record, then right click on header and click  show xml – copy the value mentioned in agent display_value  and open your production instance and open MIDServers table, and check in the filter if sysid is agent display value you got. You will find the record in production. They must have overwritten this table  in DEV on a previous clone from production.

When we look into the Exclude tables from cloning we can see that the  list of MID servers have been excluded from the clone but not ecc_agent_status so this brought the wrong references to MID servers in the ecc_agent_status table, therefore these MID server entries were blanked out. So, this cloning has got the whole errors.

Resolution:

1.     Delete all the empty records from ecc_agent_status table.

2.     Create a new record in ecc_agent_status table by just adding your missing midserver name.

You will not see any errors in the logs anymore.

To prevent this error in future add below tables to the Excluded and Preserved lists in the Clone configuration in the instance:

These tables are missing:

ecc_agent_status - Leading to MID Servers missing from the MID Server Dashboard, and lots of Errors in the system log

ecc_agent_issue

 ecc_agent_config

ecc_agent_application / ecc_agent_application_m2m

 ecc_agent_ip_range / ecc_agent_ip_range_m2m

 ecc_agent_capability / ecc_agent_capability_m2m

ecc_agent_property

ecc_agent_thread

ecc_agent_metric / ecc_agent_counter_metric / ecc_agent_memory_metric / ecc_agent_rgr_metric / ecc_agent_scalar_metric

ecc_agent_privileged_command_m2m