Problem

Usage Tracking tables are not created due to the error seen in <hostname>_cn_metering.log :

2025-04-08 06:49:26,297 - INFO [pool-4976-thread-1] (TableBuilder) - Database connected! Checking tables...
2025-04-08 06:49:26,337 - ERROR [pool-4976-thread-1] (TableBuilder) - Database connection error, SQL syntax error or Database version incompatible with the query to be executed.
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=HLAGIT1.MESSAGEENTRY;TABLE, DRIVER=4.33.31
at com.ibm.db2.jcc.am.b4.a(b4.java:810) ~[db2jcc4.jar:?]

Resolution

The root cause of the error is a wrong setup (permissions) in the database for the database user.
Check with the DBA that the "user" defined in /shared/local_te/conf/metering/meteringAgent.properties has the correct permissions for the "schemaname".