Accessing Confluence License Details page error out with "Unable to render Velocity Template, '/admin/viewlicense.vm'"
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Confluence throws "Unable to render Velocity Template, '/admin/viewlicense.vm'" error when accessing the License Details page
Environment
This problem was identified in Confluence server and datacenter version 7.4.3. It could also affect later versions of Confluence.
Diagnosis
The following appears in atlassian-confluence.log:
2020-12-30 15:43:23,290 WARN [read-only-transaction:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.confluence.util.UserChecker': Failed due to UNCLASSIFIED_FAILURE
...
2020-12-30 15:43:23,298 ERROR [http-nio-8080-exec-144] [opensymphony.webwork.dispatcher.VelocityResult] doExecute Unable to render Velocity Template, '/admin/viewlicense.vm'
-- referer: https://localhost/admin/viewgeneralconfig.action | url: /admin/license.action | traceId: 36f2e93850998ebd | userName: admin | action: license
org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getNumberOfRegisteredUsers' in class com.atlassian.confluence.util.DefaultUserChecker threw exception java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.util.concurrent.CompletionException: java.lang.reflect.UndeclaredThrowableException at /admin/viewlicense.vm[line 58, column 78]
...
Caused by: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.util.concurrent.CompletionException: java.lang.reflect.UndeclaredThrowableException
at com.atlassian.confluence.util.ReadOnlyLicenseCalculator.handleExecutionFailure(ReadOnlyLicenseCalculator.java:83)
...
Caused by: javax.persistence.EntityNotFoundException: No row with the given identifier exists: [com.atlassian.confluence.security.SpacePermission#425988]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:111)Cause
There is a cache issue with the UserChecker utility.
Solution
Clear the plugins cache by following How to clear Confluence plugins cache