KB Article #190380

[INTERCHANGE] usageReport tools is not working with DB2 database

Problem

When trying to use the Interchange/tools/usageReport, it failed with error in <hostname>_cn_metering.log :

2025-04-09 06:56:53,890 - ERROR [pool-4519-thread-1] (TableBuilder) - Database connection error, SQL syntax error or Database version incompatible with the query to be executed.
com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][2013][11249][4.33.31] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
at com.ibm.db2.jcc.am.b4.a(b4.java:808) ~[db2jcc4.jar:?]


Resolution

There error is generated beacause the tables are not created and the user has not the correct permissions, please refers to the article https://support.axway.com/fr/admin/kbadmin/article... to solve the issue related to the missing database tables.