Cannot start up Admin console with Database error

Products

• CA Strong Authentication

Issue/Introduction

Communications with the DB are correct. The DB has been checked and no errors have been detected.

When starting JBOSS 7.3, it returns the following error,

2025-01-30 01:00:47,920 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 104) MSC000001: Failed to start service jboss.deployment.unit."arcotuds.war".undertow-deployment: org.jboss.msc.service.StartException in service jboss.deployment.unit."arcotuds.war".undertow-deployment: javax.servlet.ServletException: Database error

...

Cause

Troubleshooting:

The arcotuds.log doesn't show any database related error.

Check arcotadmin.log, it shows,

2025-01-30 01:00:47,613 CET : [ServerService Thread Pool -- 88] : ERROR : framework.init.PrintUtil : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : Could not load configuration from ARADMINCONFIG table
2025-01-30 01:00:47,613 CET : [ServerService Thread Pool -- 88] : FATAL : framework.init.AdminInitManager : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : Error while initializing application, com.arcot.common.api.ArcotCommonException: Database error
com.arcot.admin.framework.common.DataStoreException: com.arcot.common.api.ArcotCommonException: Database error

...

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-04088: error during execution of trigger 'SYS.PROG_PROHIB'
ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SYS"."LOGIN_INFO_TME"."HOST_NAME" (actual: 64, maximum: 60)
ORA-06512: at line 2

...

 

So, it's a problem from Oracle DB side -- size limit on hostname

Resolution

 The service recovered by disabling the trigger which returned the error.

 

Alternate solution:

Update table  "SYS"."LOGIN_INFO_TME" and alter the size of "HOST_NAME" column to 128.