Problem

After changing the user password for the Metering database schema, it is necessary to update the password configuration on the Interchange metering side. Failure to do so will result in errors during TableBuilder execution. These errors can be found in the following log file:

<Install>/Interchange/logs/<hostname>_cn_metering.log

Example error message:

2025-10-07 17:06:06,983 - ERROR [pool-1289-thread-1] (TableBuilder) - Database connection error, SQL syntax error or Database version incompatible with the query to be executed.
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Resolution

1. Run the ConfigureB2Bi.sh script (or ConfigureB2Bi.bat as Administrator on Windows), located in the Axway installation directory.
2. Choose "Change server configuration" when prompted.
3. Proceed through the configuration steps.
4. When you reach "Usage tracking configuration", enter the new Metering database password.

After completion, restart the B2Bi services to verify the change was successful. The metering database password is stored in an encrypted/hashed state in the <Shared>/local_te/conf/metering/meteringAgent.properties file and is separate from the Interchange DB password located in <Install>/Interchange/conf/datastoreconfig.xml