Getting error for a report after upgrading to 8.4

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

Version 8.4

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

We are getting below report for a report after upgrading to 8.4

Report is to get the identity details:

sailpoint.tools.GeneralException: Error preparing ProjectionDataSource
at sailpoint.reporting.JasperCsvWriter.write(JasperCsvWriter.java:152)
at sailpoint.reporting.LiveReportExecutor.execute(LiveReportExecutor.java:275)
at sailpoint.api.TaskManager.runSync(TaskManager.java:981)
at sailpoint.api.TaskManager.runSync(TaskManager.java:764)
at sailpoint.scheduler.JobAdapter.execute(JobAdapter.java:128)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: net.sf.jasperreports.engine.JRException: Error preparing ProjectionDataSource
at sailpoint.reporting.datasource.BaseProjectionDataSource.next(BaseProjectionDataSource.java:210)
at sailpoint.reporting.JasperCsvWriter.write(JasperCsvWriter.java:116)
… 6 more
Caused by: sailpoint.tools.GeneralException: Could not find class for join property extendedAttribute in packages [sailpoint.object, sailpoint.object.accesshistory]
at sailpoint.persistence.HibernatePersistenceManager.search(HibernatePersistenceManager.java:2198)
at sailpoint.persistence.ClassPersistenceManager.search(ClassPersistenceManager.java:343)
at sailpoint.server.InternalContext.search(InternalContext.java:950)
at sailpoint.reporting.datasource.ProjectionDataSource.prepare(ProjectionDataSource.java:61)
at sailpoint.reporting.datasource.BaseProjectionDataSource.next(BaseProjectionDataSource.java:207)
… 7 more
Caused by: java.lang.RuntimeException: Could not find class for join property extendedAttribute in packages [sailpoint.object, sailpoint.object.accesshistory]
at sailpoint.persistence.HQLFilterVisitor.getClassFromProperty(HQLFilterVisitor.java:932)
at sailpoint.persistence.HQLAliasContextImpl.substituteAlias(HQLAliasContextImpl.java:104)
at sailpoint.persistence.HQLAliasContextStack.substituteAlias(HQLAliasContextStack.java:101)
at sailpoint.persistence.HQLFilterVisitor.addSelectColumns(HQLFilterVisitor.java:578)
at sailpoint.persistence.HQLFilterVisitor.getQueryString(HQLFilterVisitor.java:512)
at sailpoint.persistence.HibernatePersistenceManager.search(HibernatePersistenceManager.java:2180)

2

Hi @pguptatd

Try to get more logs

  • enable the detailed Access History logging by changing in log4j2
  • try again and see if you will get some more logs.

Also try to turn off the access History from system configuration and see if it works. something related to upgrade steps got missed.

Also, If possible then provide the report name. will try to see in my local of 8.4.

Let us know if you have some data.

3

Did you run the IIQ console extended schema after the upgrade? After generating the extended schema attributes, you should run the database scripts in your database. This report should work after restarting your servers.

Thanks,
Dheeraj

4

What is your extended Property name in the error, looks like there is an existing bug if your extended property starts with Upper Case, is it possible to share the report xml

5

All of our extended attributes are already in DB and up to date.
Already have checked the logs but it keeps on throwing error.
@satish yes the extended attributes names are in capital for which it is throwing error.

Do you know the fix for the same?

6

Access History is already disabled in our system

7

@pguptatd

Thats the issue, it is a known issue, check below link.

Either you create a new one with lower case and change all your config and drop this or Modify the name in all places, configurations as temporary fix.

Solved: Could not find class for join property “attribute name” in packages [sailpoint.object] - Compass

8

Also recommendation is always use lower case or CamelCase for any extended attribute names.

Hibernate tends to translate upper case letters to class names and lower case to property names.

Please do changes suggested in above comment and let me know if that worked.

9

I don’t think that is the case in this case.
As same works with 8.1 and 8.2 version

10

@pguptatd
Are you able to reproduce this issue in any Sandbox or Dev environment, if so I suggest you to try what I mentioned above in Dev or Sandbox because looking at the error this more or less the same what happened for me earlier as well, I understood this is not the case with your earlier version but if we give a try in sandbox or Dev , that way we can get to a conclusion