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.