In vnms-spring-boot.log, we could see following error: -

[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] Invalid character data was found.  This is most likely caused by stored data containing characters that are invalid for the character set the database was created in.  The most common example of this is storing 8bit data in a SQL_ASCII database.

Reason:

This error is usually seen when there is a non-UTF8 character present in the backend even if the encoding of the DB is correctly set to UTF-8. This can likely happen due to incorrect/incomplete process of conversion of DB that was originally in non-UTF8 encoding to UTF-8 encoding.

Verification:

To prove this, kindly execute below steps: -

1) Take dump of the postgres:

++ pg_dump -U vnms -h localhost -d vnms -C -c -E UTF-8 -f vnms-dump.sql

2) Run below command to check if any encoding issues are present or not:

++ iconv -f utf-8 -t utf-8 vnms-dump.sql > /dev/null

++ echo $?

Note: - Any output except '0' in echo $? indicates presence of non-UTF8 characters and the reason for commit template failure.

Resolution:

If verification proves presence of non-UTF8 characters, please execute following steps to correct it.

1) stop all services in standby.

2) stop all services in active.

3) start postgres service alone on Active node.

++ sudo service postgresql start(trusty)

++ sudo systemctl start versa-postgresql.service (bionic)

4) Assuming the dump taken in verification process above is vnms-dump.sql, run the command below to fix the data and create a new dump named vnms-utf8.sql

++ iconv -f latin1 -t utf-8 -o vnms-utf8.sql  vnms-dump.sql

5) Validate the output file to see that no error is seen (non-UTF8 characters):-

++ iconv -f utf-8 -t utf-8 vnms-utf8.sql > /dev/null

5) Import the data back to postgres: 

++ sudo -u postgres psql -h localhost -f vnms-utf8.sql

6) stop postgres service on Active Node.

++ sudo service postgresql stop (trusty)

++ sudo systemctl stop versa-postgresql.service (bionic)

7) Start services in active and once all are up, start services in standby (vsh start).