An unexpected error occurred: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.4

Please share any images or screenshots, if relevant.

image
image830×794 19.9 KB

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!

2

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.

3 
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
4

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