Thank you @amolsatvix, for helping to fix this error…
It was solve thru:
deleting the records with all address in the category in the mysql database:
delete from event_records where category like ‘%address%’;
delete from event_log where category like ‘%address%’;
inserting the addresshierarchy.sql command:
Insert into event_records(uuid,
title,
timestamp,
uri,
object,
category)
(select uuid(),
‘addressHierarchy’,
‘1970-01-01 00:00:01’,
concat(‘/openmrs/ws/rest/v1/addressHierarchy/’,uuid),
concat(‘/openmrs/ws/rest/v1/addressHierarchy/’,uuid),
‘addressHierarchy’
from address_hierarchy_entry);
restart the bahmni-event-log:
(check status)
service bahmni-event-log-service status
(stop)
service bahmni-event-log-service stop
(check status again - should not be running)
service bahmni-event-log-service status
(start)
service bahmni-event-log-service start
(check status again - should be running)
service bahmni-event-log-service status
Go to bahmni connect website, Clear Storage, Re-Run… There it should sync…