After deleting and then adding and updating mail notifications in vCloud Usage Merer 4.7, the journal service of the appliance is in an incosistent state

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:
After performing multiple operations in the Mail Notifications tab in the Usage Meter 4.7 web like create and delete, then create and update a mail notification, the journal service of the virtual appliance is in an inconsistent state.

The following error is observed as a result from the journal service issue:
 

2023-11-21T06:49:34.471Z ERROR 1595 — [https-jsse-nio-127.0.0.1-8051-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: java.lang.IllegalStateException: Duplicate key sendDataFileManagementNotifications (attempted merging values 16 and 44)] with root cause

Environment

VMware vCloud Usage Meter 4.x

Cause

The database of the vCloud Usage Meter journal service has contradicting records, which cannot be merged.

Resolution

This is a known issue and will be resolved in a future vCloud Usage Meter release.

Workaround:
To solve this issue, do the following:

1. Log in to the vCloud Usage Meter appliance as root.
2. Stop the journal service.

systemctl stop vmware-um-journal.service

3. Go to the directory where the journal service database is located.

cd /opt/vmware/cloudusagemetering/platform/data/

4. Connect to the database.

sqlite3 journal-service.db

5. (Optional) Check the table names of the database.

.tables

6. Delete the following data from the 'settings' table of the journal service database:

delete from settings where 1=1;

7. Delete the following data from the 'custom_properties' table of the journal service database:

delete from custom_properties where 1=1;

8. Quit the sqlite3 shell program.

.quit 

9. Start the Usage Meter journal service.

systemctl start vmware-um-journal.service

Additional Information

Impact/Risks:
The mail notifications may not be properly configured as a result of this issue.