Whitelabel Error Page (OpenKM CE 7.0.2)

[kwokhy]

Hello,

When I try to check the "logged users" records, OpenKM shows "Whitelabel Error Page". I checked the "localhost" log file and the following messages were recorded:

org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcherServlet] in context with path [/openkm] threw exception [An exception occurred processing [WEB-INF/jsp/management/auth/loggedUsers/list.jsp] at line [147]

144: <td>${se.id}</td>
145: <td>${se.ip}</td>
146: <td>${se.host}</td>
147: <td><u:formatDate calendar="${se.creation}"/></td>
148: <td><u:formatDate calendar="${se.lastAccess}"/></td>
149: <td align="center">
150: <a href="${urlLog}" type="button" class="btn btn-sm btn-light p-1 ml-1">


Stacktrace:] with root cause
java.lang.NullPointerException
at java.base/java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:617)
at java.base/java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:599)
at com.openkm.util.tags.FormatDateTag.doStartTag(FormatDateTag.java:69)
at org.apache.jsp.WEB_002dINF.jsp.management.auth.loggedUsers.list_jsp._jspx_meth_u_005fformatDate_005f0(list_jsp.java:1727)
at org.apache.jsp.WEB_002dINF.jsp.management.auth.loggedUsers.list_jsp._jspx_meth_c_005fforEach_005f0(list_jsp.java:1558)
at org.apache.jsp.WEB_002dINF.jsp.management.auth.loggedUsers.list_jsp._jspService(list_jsp.java:291)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:349)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:300)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
.........

OS: Ubuntu 24.04.4
Jave: OpenJDK 11.0.31
Browser: Firefox, Edge

Please give some suggestions to me for troubleshooting.
Thanks for your help

[jllort]

I haven't been able to reproduce the issue in my development environment; it seems to fail specifically with dates because it's unable to apply the date pattern. The application first tries to use the date pattern for the language you're logged in with, and then, as a last resort, the one for English (en-GB). Check both in the language you used to log into the UI and in English (in case they're not the same) whether you have this translation "general.date.pattern" (you can check this from Administration > Tools > Languages, and select the language edit view to locate this translation).

[kwokhy]

I checked the language setting (Administrator > Administration > Languages > "en-GB") and found that:

1. only "kcenter" module was found
2. the key "date.pattern" was found but the key "general.date.pattern" was not found

I downloaded the language setting SQL file for en-GB and found that the key "general.date.pattern" is set for the modules "extension" and "frontend", not "kcenter".

Did I set something wrong for the configuration?
I used "OKMInstaller.jar" for the installation and select Mariadb for the database.

Also, I did not find "Administration > Utilities > Database query" so I did not enable any extension.