KB Article #179339

Sentinel WebDashboard not reachable after first SP installation

Problem

Sentinel WebDashboard home page not accessible after first SP installation on Sentinel

* In jetty logs following can be noticed:
2017-12-12 11:06:55,923 ERROR [main] web.LifeCycle (LifeCycle.java:298) - com.prelytis.dashboard.interfaces.DashboardRuntimeException: SQL_ERROR
2017-12-12 11:06:55,924 ERROR [main] web.LifeCycle (LifeCycle.java:299) - Axway Sentinel Web Dashboard update : unknown error
com.prelytis.dashboard.interfaces.DashboardRuntimeException: SQL_ERROR
...............................
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;BBDASH.BA_USER, DRIVER=3.64.82

Resolution

* Link "https://developer.ibm.com/answers/questions/24036/failing-update-table-in-db2-with-sqlcode-668-sqlstate-57016-sqlerrmc-7/" talks about this ERROR. And asks to "Reorganize the table using the REORG TABLE command with the call ADMIN_CMD command"

* For Sentinel WebDashboard following command should be run at database level:
reorg table <schema name>.BA_USER