Healthshare Drug Error During Database Replication

During the Database Replication process you may receive an alert similar to below:

This alert is related to a bug that we have identified in Genie version 9.0.8 and above whereby the [HealthShareDrug] and [HealthShareAudit] tables are not being included in the replication process. This will also result in an error saying that 'The number of records in the local database is lower than the number of records in the server database'.

Selecting OK will allow you to continue through the replication. This should complete without issue, and should be perfectly viable for use unless you require the Healthshare Drug data while offsite; if you prescribe while offsite and wish to send Healthshare Fact Sheets when prescribing, you will need to resolve the issue before you will be able to do so.

To resolve the issue for future replications, you can follow the steps below. Please note that these steps require the Genie Server application to be closed, which will prevent users from accessing Genie during this process; you should ensure that these steps are performed outside of practice hours to allow for this downtime.

1. On the server machine, quit out of the Genie Server application. 
2. Within the Genie folder, delete ONLY the Genie.4DSyncData and Genie.4DSyncHeader files. The default location for the Genie folder is Applications: Genie (Mac) or Local Disk C:/ Genie (Windows)
3. Repeat this on the laptop being used for offsite logging.
4. Relaunch Genie Server on your server machine.
5. Open Genie Client on your offsite logging laptop. Navigate to File> Maintenance & Reports> General and select Reset IDs
6. Once the above has been completed, run a Full Replication. It is necessary to run a Full Replication and not a Local Synchronisation.   

If you are not confident making changes to the files on the Genie Server, please give our support team a call on 1300 889 362 so that we can assist you with this directly.

Related Articles

Database Replication and Offsite Logging

Using Genie Remotely

If you think somebody else would appreciate reading this article feel free to email them a link.