# An unexpected error occurred: org.hibernate.exception.SQLGrammarException: could not extract ResultSet **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq\ **Created:** [December 4, 2025, 6:29am UTC](https://developer.sailpoint.com/discuss/t/an-unexpected-error-occurred-org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/190007 "2025-12-04T06:29:23Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Bernardc](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/bernardc/32/26204_2.png) [@Bernardc](https://developer.sailpoint.com/discuss/u/Bernardc)\ **Post date:** [December 4, 2025, 6:29am UTC](https://developer.sailpoint.com/discuss/t/an-unexpected-error-occurred-org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/190007/1 "2025-12-04T06:29:23Z")
## Which IIQ version are you inquiring about? _8.4_ ## Please share any images or screenshots, if relevant. ![image](https://global.discourse-cdn.com/sailpoint/original/3X/6/3/634944be983cd583725250b39217ff13bafbd5ce.png) _Hi Sailors,_ I am trying to create a new role but hitting this error: - **An unexpected error occurred: org.hibernate.exception.SQLGrammarException: could not extract ResultSet** Anyone has any idea? Thanks in advance! ---
**Author:** ![naveenkumar3](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/naveenkumar3/32/39339_2.png) [@naveenkumar3](https://developer.sailpoint.com/discuss/u/naveenkumar3)\ **Post date:** [December 4, 2025, 7:14am UTC](https://developer.sailpoint.com/discuss/t/an-unexpected-error-occurred-org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/190007/2 "2025-12-04T07:14:58Z")
can you please grep the loggers and share the loggers?? and also, can you please try bouncing tomcat and trying to create the role again, if still you are seeing the error. ---
**Author:** ![Bernardc](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/bernardc/32/26204_2.png) [@Bernardc](https://developer.sailpoint.com/discuss/u/Bernardc)\ **Post date:** [December 4, 2025, 7:20am UTC](https://developer.sailpoint.com/discuss/t/an-unexpected-error-occurred-org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/190007/3 "2025-12-04T07:20:24Z")
```auto 2025-12-04T15:14:15,349 WARN ServerThread engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 207, SQLState: S0001 2025-12-04T15:14:15,349 ERROR ServerThread engine.jdbc.spi.SqlExceptionHelper:142 - Invalid column name 'extended5'. 2025-12-04T15:14:15,364 ERROR ServerThread sailpoint.server.Servicer:1165 - Unable to execute service: Cache sailpoint.tools.GeneralException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at sailpoint.persistence.HibernatePersistenceManager.getObjects(HibernatePersistenceManager.java:2110) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.persistence.ClassPersistenceManager.getObjects(ClassPersistenceManager.java:325) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.server.InternalContext.getObjects(InternalContext.java:935) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.server.InternalContext.getObjects(InternalContext.java:928) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.CorrelationModel.prepare(CorrelationModel.java:330) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.CorrelationModel.refresh(CorrelationModel.java:297) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.server.CacheService.execute(CacheService.java:270) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.server.Servicer.execute(Servicer.java:1162) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.server.Servicer.processServices(Servicer.java:1113) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.server.Servicer.run(Servicer.java:831) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1602) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at sailpoint.persistence.HibernatePersistenceManager.getObjects(HibernatePersistenceManager.java:2106) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] ... 9 more Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.getResultSet(Loader.java:2304) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:948) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2850) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2832) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.list(Loader.java:2659) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at sailpoint.persistence.HibernatePersistenceManager.getObjects(HibernatePersistenceManager.java:2106) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] ... 9 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'extended5'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:686) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:605) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263) ~[mssql-jdbc-12.6.3.jre11.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:520) ~[mssql-jdbc-12.6.3.jre11.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.getResultSet(Loader.java:2304) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:948) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2850) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2832) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.list(Loader.java:2659) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at sailpoint.persistence.HibernatePersistenceManager.getObjects(HibernatePersistenceManager.java:2106) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] ... 9 more ``` ---
**Author:** ![naveenkumar3](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/naveenkumar3/32/39339_2.png) [@naveenkumar3](https://developer.sailpoint.com/discuss/u/naveenkumar3)\ **Post date:** [December 4, 2025, 9:03am UTC](https://developer.sailpoint.com/discuss/t/an-unexpected-error-occurred-org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/190007/4 "2025-12-04T09:03:43Z")
The error is clear: Your database schema is out of sync with your IIQ configuration. The `ObjectConfig` for an object (likely Bundle/Role or ManagedAttribute) has been modified to include `extended5` attribute, but the corresponding database column was never created the missing column is likely on one of these tables. Run the appropriate ALTER statement: 1. Run Schema Extend Attribute to generate the sql command. iiq extendedSchema " This will show you the missing columns including `extended5` ." 2. Open the database/sql server and run the sql command using alter command and add the missing column. 3. Restart the server post that ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [February 2, 2026, 9:04am UTC](https://developer.sailpoint.com/discuss/t/an-unexpected-error-occurred-org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/190007/5 "2026-02-02T09:04:37Z")
Closed on February 2, 2026, 9:04am UTC This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.