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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.santesuite.org/knowledgebase/sdb-kb/kb014-after-updating-a-database-field-the-values-are-not-reflected-in-the-application-layer.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.