After updating a database field the values are not reflected in the application layer

Issue: After updating a database field directly on the primary data source the values are not reflected on the IMSI and/or FHIR interfaces.

Applies To:

• OpenIZ Immunization Management Service (IMS)

Symptoms:

• When updating a database field using SQL the value is changed in the database but not reflected in applications.

• When querying a FHIR based resource the updated values do not present themselves.

Cause: The OpenIZ IMS uses an in-memory cache to speed up the retrieval of data from the primary data source. The two options for this are a built-in memory cache or REDIS. When you update the value directly on the database, it does not invalidate the cache data.

Solution:

When using the built-in memory cache:

1. Open a command prompt as Administrator

2. Restart the OpenIZ host process using the command:

   • net stop openiz

   • net start openiz

3. Note: Your instance of OpenIZ IMS will be unavailable during this time

When using the REDIS cache service

1. Open a command prompt as Administrator on your REDIS host server

2. Restart the REDIS process using the command

   • net stop redis

   • net start redis

3. Note: Your instance of OpenIZ IMS will continue to be available during this time.