Unable to complete certification access review

dvdeepthi9 · May 1, 2025, 6:05pm

Which IIQ version are you inquiring about?

8.3p1

Please share any images or screenshots, if relevant.

Please share any other relevant files that may be required (for example, logs).

sailpoint.tools.GeneralException: Could not find class for join property Identity-displayName in packages [sailpoint.object]
	at sailpoint.persistence.HibernatePersistenceManager.search(HibernatePersistenceManager.java:2111)
	at sailpoint.persistence.ClassPersistenceManager.search(ClassPersistenceManager.java:334)
	at sailpoint.server.InternalContext.search(InternalContext.java:896)
	at sailpoint.service.BaseListService.getResultGroups(BaseListService.java:649)
	at sailpoint.service.certification.CertificationItemListService.getResultGroups(CertificationItemListService.java:976)
	at sailpoint.service.certification.CertificationItemListService.getCertificationItems(CertificationItemListService.java:308)
	at sailpoint.rest.ui.certifications.CertificationItemListResource.getCertificationItems(CertificationItemListResource.java:90)
	at jdk.internal.reflect.GeneratedMethodAccessor4239.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
	at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)
	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at sailpoint.rest.jaxrs.MethodOverrideFilter.doFilter(MethodOverrideFilter.java:90)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at sailpoint.rest.RestCsrfValidationFilter.doFilter(RestCsrfValidationFilter.java:61)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at sailpoint.rest.AuthenticationFilter.doFilter(AuthenticationFilter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at sailpoint.web.SailPointContextRequestFilter.doFilter(SailPointContextRequestFilter.java:61)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at sailpoint.web.SailPointPollingRequestFilter.doFilter(SailPointPollingRequestFilter.java:151)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at sailpoint.web.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:388)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:839)
Caused by: java.lang.RuntimeException: Could not find class for join property Identity-displayName in packages [sailpoint.object]
	at sailpoint.persistence.HQLFilterVisitor.getClassFromProperty(HQLFilterVisitor.java:919)
	at sailpoint.persistence.HQLAliasContextImpl.substituteAlias(HQLAliasContextImpl.java:104)
	at sailpoint.persistence.HQLAliasContextImpl.substituteAlias(HQLAliasContextImpl.java:90)
	at sailpoint.persistence.HQLAliasContextStack.substituteAlias(HQLAliasContextStack.java:93)
	at sailpoint.persistence.HQLFilterVisitor.visitIsNull(HQLFilterVisitor.java:1282)
	at sailpoint.object.Filter$LeafFilter.accept(Filter.java:1034)
	at sailpoint.persistence.HQLFilterVisitor.visitComposite(HQLFilterVisitor.java:1947)
	at sailpoint.persistence.HQLFilterVisitor.visitAnd(HQLFilterVisitor.java:2035)
	at sailpoint.object.Filter$CompositeFilter.accept(Filter.java:1141)
	at sailpoint.persistence.HibernatePersistenceManager.visitHQLFilter(HibernatePersistenceManager.java:2246)
	at sailpoint.persistence.HibernatePersistenceManager.search(HibernatePersistenceManager.java:2092)
	... 75 more

Share all details about your problem, including any error messages you may have received.

Manager is getting attached error during the certification access review. This is the same error he got earlier for the same certification access review last year. We are getting this error for specific managers but not everyone is receiving this error. Do we need to check if there is any issue with the identity which the manager is trying to review the access suggest any solution if anyone faced similar error earlier.

Thanks in advance…!

sunnyajmera · May 1, 2025, 6:24pm

check if you have an entry like identity-displayname defined in the UIConfig for certification columns. Check the UIConfig from /debug and try to remove it to see if that fixes the issue.

dvdeepthi9 · May 1, 2025, 6:37pm

I could see below in UI config.


<ColumnConfig dataIndex="Identity-displayName" groupProperty="Identity.displayName" headerKey="cert_item_tbl_header_identity" hideable="true" property="Identity.displayName" sortProperty="Identity.displayName" sortable="true" stateId="Identity-displayName"/>

Do you want me to update this or remove? I could see many entries under

<entry key="uiEntitlementOwnerCertificationItemWorksheetColumns">
<entry key="uiEntitlementOwnerCertificationItemReturnedItemsColumns">
<entry key="uiEntitlementOwnerCertificationItemDetailViewReturnedItemsColumns">
 <entry key="uiEntitlementOwnerCertificationItemDetailViewColumns">

etc.Do we need to update all of these to fix the issue?

sunnyajmera · May 1, 2025, 6:38pm

Take a backup and then remove this line from config

Save it and then try.

dvdeepthi9 · May 7, 2025, 2:46am

It seems there is product bug open IIQETN-10613 for this issue for which no fix currently exists. As of now we closed the work item from debug.

sunnyajmera · May 7, 2025, 3:10am

can you share description of this bug

dvdeepthi9 · May 7, 2025, 3:22pm

We just received the number but not the description of the bug from Vendor. Please find comments from Vendor support team.

"“The error you shared matches known issue IIQETN-10613 for which no fix currently exists.
You are on version 8.3p1 which is in Limited Support. Per https://community.sailpoint.com/t5/Working-With-Support-Knowledge/IdentityIQ-and-File-Access-Manager-End-of-Support-Policy/ta-p/77580, it is mentioned that during the Limited Support phase, no new regular patches or fixes are developed, and no new installations of the release are supported.
There is not a workaround mentioned in this ETN.
Please note that customers are encouraged to check the ETN Status, ETN Resolution, and ETN Fix Version/s fields in the Support ticket on a frequent basis. You may find this helpful for knowing when this may be fixed in a future release.”