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. 1.
    Open a command prompt as Administrator
  2. 2.
    Restart the OpenIZ host process using the command:
    • net stop openiz
    • net start openiz
  3. 3.
    Note: Your instance of OpenIZ IMS will be unavailable during this time
When using the REDIS cache service
  1. 1.
    Open a command prompt as Administrator on your REDIS host server
  2. 2.
    Restart the REDIS process using the command
    • net stop redis
    • net start redis
  3. 3.
    Note: Your instance of OpenIZ IMS will continue to be available during this time.