Jaspersoft error Profile Level (PROFILE_LEVEL_ADMIN_USER) do not contain non-empty and valid mandatory attributes for DS

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After upgrade from Jaspersoft 8.1.1 to Jaspersoft 9.0 started seeing the error on running any OOTB or custom reports in Clarity:

2025-01-10T11:39:25,493 ERROR GenericExceptionMapper,https-openssl-nio-8443-exec-2:89 [] - Unexpected error occured. null. Profile Level (PROFILE_LEVEL_ADMIN_USER) do not contain non-empty and valid mandatory attributes for DS. Pool will be destroyed.
java.lang.reflect.InvocationTargetException: null
           at jdk.internal.reflect.GeneratedMethodAccessor985.invoke(Unknown Source) ~[?:?]
           at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
           at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
           at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BeanReportDataSourceServiceFactory.createService(BeanReportDataSourceServiceFactory.java:94) ~[jasperserver-api-engine-impl-9.0.0.jar:?]
           at jdk.internal.reflect.GeneratedMethodAccessor987.invoke(Unknown Source) ~[?:?]
[…….]
Caused by: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Profile Level (PROFILE_LEVEL_ADMIN_USER) do not contain non-empty and valid mandatory attributes for DS. Pool will be destroyed.
           at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:457) ~[ca-jasper-extensions.jar:?]
           at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:162) ~[ca-jasper-extensions.jar:?]
           ... 278 more
           Suppressed: org.apache.jasper.JasperException: Profile Level (PROFILE_LEVEL_ADMIN_USER) do not contain non-empty and valid mandatory attributes for DS. Pool will be destroyed.
                       at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:290) ~[ca-jasper-extensions.jar:?]
                       at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:162) ~[ca-jasper-extensions.jar:?]

After running the Clarity commands to reset user attributes syncPPMcontext and jasperparameters it starts working for some time and then the next day it stops working again

Environment

Jaspersoft 9.0

Cause

• The service user jasperadmin was for some reason created and active in Clarity with Report permissions (not expected)
• Create and Update JS user job was resetting the profile attributes on jasperadmin on each run

Resolution

1. Update jasperadmin user in Jaspersoft - Users to match exactly the OOTB jasperadmin user
2. Also delete all Clarity profile attributes on jasperadmin user in Jaspersoft 
3. Restart Jaspersoft
4. Run the commands:
   
   • admin update jasperParameters
   • admin jaspersoft syncPPMContext -userName superuser -password superuser
5. Update jasperadmin user in Clarity to remove the Report permissions, set to Inactive and change the ID to something else, i.e. jasperadmin1
6. Test that Reports are working from Advanced Reporting and Clarity Reports and Jobs
7. Run Create and Update JS Users job with inactive users option and retest again to make sure it's resolved