# Error in prov. transaction report **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq, reports\ **Created:** [May 8, 2024, 6:26pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896 "2024-05-08T18:26:27Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![abhishek\_chowdhury](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/abhishek_chowdhury/32/6767_2.png) [@abhishek\_chowdhury](https://developer.sailpoint.com/discuss/u/abhishek_chowdhury)\ **Post date:** [May 8, 2024, 6:26pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/1 "2024-05-08T18:26:27Z")
### Which IIQ version are you inquiring about? Version 8.3 ### Please share any images or screenshots, if relevant. ![Screenshot 2024-05-08 112338.png](https://global.discourse-cdn.com/sailpoint/original/2X/4/444ee56dff2c6d513900c7236977eb23b8ab1701.png) ### Share all details related to your problem, including any error messages you may have received. In out of the box provisioning transaction report when selecting more than one application in application channel, we are getting following error, the report works fine with one application channel sailpoint.tools.GeneralException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at sailpoint.persistence.HibernatePersistenceManager.countObjects(HibernatePersistenceManager.java:2758) at sailpoint.persistence.ClassPersistenceManager.countObjects(ClassPersistenceManager.java:358) at sailpoint.server.InternalContext.countObjects(InternalContext.java:918) at sailpoint.reporting.datasource.ProjectionDataSource.getSizeEstimate(ProjectionDataSource.java:61) at sailpoint.reporting.JasperCsvWriter.write(JasperCsvWriter.java:96) 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: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1602) at sailpoint.persistence.HibernatePersistenceManager.countObjects(HibernatePersistenceManager.java:2745) … 10 more Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) at org.hibernate.loader.Loader.getResultSet(Loader.java:2304) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) at org.hibernate.loader.Loader.doQuery(Loader.java:948) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) at org.hibernate.loader.Loader.doList(Loader.java:2850) at org.hibernate.loader.Loader.doList(Loader.java:2832) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) at org.hibernate.loader.Loader.list(Loader.java:2659) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593) … 11 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘,’. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:648) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:567) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7675) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4137) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:485) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) … 26 more ---
**Author:** ![iamksatish](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/iamksatish/32/26217_2.png) [@iamksatish](https://developer.sailpoint.com/discuss/u/iamksatish)\ **Post date:** [May 8, 2024, 6:30pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/2 "2024-05-08T18:30:42Z")
Is this error specific to any app as part of selection, When you select only Azure AD and only ServiceNow, is the report working fine? ---
**Author:** ![abhishek\_chowdhury](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/abhishek_chowdhury/32/6767_2.png) [@abhishek\_chowdhury](https://developer.sailpoint.com/discuss/u/abhishek_chowdhury)\ **Post date:** [May 8, 2024, 6:31pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/3 "2024-05-08T18:31:55Z")
nope this error is just when there are more than 1 app, it could be any app ---
**Author:** ![patrickboston](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/patrickboston/32/5876_2.png) [@patrickboston](https://developer.sailpoint.com/discuss/u/patrickboston)\ **Post date:** [May 8, 2024, 6:35pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/4 "2024-05-08T18:35:37Z")
Seems like a bug. I was able to re-produce on 8.4p1 as well. ![image](https://global.discourse-cdn.com/sailpoint/original/2X/0/0e9bf4e2920173c1ed48442776ea3e8bfe12b0ef.png) Because this is a `Filter` type report, you can easily change the TaskDefinition to fix the bug. I did a quick change on the `integration` Query Parameter script to perform a `Filter.in` instead of a `Filter.like` as it was originally. ![image](https://global.discourse-cdn.com/sailpoint/original/2X/f/f6f38eb09e65381be50c6a5933b3cc9deaa565e0.png) Other option is to report to SailPoint via an official support ticket. Not sure what their response will be though. ---
**Author:** ![abhishek\_chowdhury](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/abhishek_chowdhury/32/6767_2.png) [@abhishek\_chowdhury](https://developer.sailpoint.com/discuss/u/abhishek_chowdhury)\ **Post date:** [May 8, 2024, 6:38pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/5 "2024-05-08T18:38:50Z")
thanks I will try this and and get back. I will also open a case ---
**Author:** ![abhishek\_chowdhury](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/abhishek_chowdhury/32/6767_2.png) [@abhishek\_chowdhury](https://developer.sailpoint.com/discuss/u/abhishek_chowdhury)\ **Post date:** [May 8, 2024, 6:49pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/6 "2024-05-08T18:49:00Z")
yes updating the filter works as expected, i will also open a case. ---
**Author:** ![ipobeidi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/ipobeidi/32/16000_2.png) [@ipobeidi](https://developer.sailpoint.com/discuss/u/ipobeidi)\ **Post date:** [May 10, 2024, 4:32pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/7 "2024-05-10T16:32:03Z")
Same happened in here, and had the same solution. ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [July 9, 2024, 4:32pm UTC](https://developer.sailpoint.com/discuss/t/error-in-prov-transaction-report/55896/8 "2024-07-09T16:32:34Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.