Issue:

In some cases, KV extraction entries in the database might get corrupted, which causes the slowness of Ephesoft Transact operations, including execution of web services.

Important: Before executing this query, contact Ephesoft Technical Support.

Solution (for MSSQL database):

1. Stop the Ephesoft server.

2. Take backup of the Ephesoft database.

3. Extract the file below and save it in a temporary location.

4. Execute the procedure described in the KVExtraction_Proc.txt file in the Ephesoft database.

5. Start the Ephesoft server.