> For the complete documentation index, see [llms.txt](https://help.santesuite.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.santesuite.org/knowledgebase/sdb-kb/kb014-after-updating-a-database-field-the-values-are-not-reflected-in-the-application-layer.md).

# 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.