WebUI installer fails with error [CAUAJM_E_116421] Failed granting database privileges to WebUI database user. Error while granting permission to user

Products

• Autosys Workload Automation

Issue/Introduction

WebUI install was attempted on one node against primary database node, that finished fine. 

But on the secondary WebUI node, installation against secondary database node fails with error: [CAUAJM_E_116421] Failed granting database privileges to WebUI database
user. Error while granting permission to user,

cawa_installer.log has below error:

2026-02-16 10:54:07,625 [main] INFO  com.ca.autosys.db.main.AutoSysDBConnection(493) - Running query : GRANT SELECT, INSERT, UPDATE, DELETE ON AO_AGENT_ISO TO "wcc"
2026-02-16 10:54:07,628 [main] ERROR com.ca.autosys.db.main.AutoSysDBConnection(500) - Error in query execution :org.postgresql.util.PSQLException: ERROR: cannot execute GRANT in a read-only transaction
2026-02-16 10:54:07,628 [main] ERROR com.ca.wla.ae.installer.mm.action.wcc.WCCGrantDBPrivilegesToDBUser(328) - Error while granting permission to user, error is {} org.postgresql.util.PSQLException: ERROR: cannot execute GRANT in a read-only transaction
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2734)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2421)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:518)

 

Environment

AutoSys WebUI install against PostgreSQL

Cause

The secondary database node was in a standby configuration (read only mode) with the primary database node that the was used for the first WebUI install.  

For the Installer to work successfully, it has to operate against a database that is in Read Write mode.

Resolution

Re-run the installer against a database that is available in Read Write mode.