Error When Configuring the ActiveMatrix Administrator Server

While installing ActiveMatrix BPM, an exception is thrown when configuring the ActiveMatrix Administrator server.

The error is similar to the one below: 

org.hibernate.exception.SQLGrammarException: could not execute query
SystemNode 19 Aug 2011 01:13:40,788 [amxAdminDefaultHttpConnector_41] [WARN ] org.mortbay.log.Logger - AUTH FAILURE: user root

This error can be caused if the username provided during the configuration does not have the required privileges and hence, the required views and tables cannot be created.

Procedure

  • When configuring the ActiveMatrix Administrator server, ensure that you provide the database administrator (DBA) username and password.
Next topic: Refreshing a Node when Passing an Array to a Stored Procedure
Previous topic: Sanitizing After a Failed Installation