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

[Community Alums]

Error: [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 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

[Sharon Hobart]

Very good article.  I ran into a similar situation and was able to resolve.  I like your list of other tables to consider to exclude during a clone though

[Vijay Talupula]

@Anusha Elagandula,

Thanks for your article.. Its informative & Helpful and I am also in the same situation and followed your steps... now it is not showing the error but still my credentials are not successful even tough all my input parameters are correct. Also no errors are showing up in the logs.

Any suggestions are appreciated if you aware.

Regards,

Vijay