Hi all,

Having issues with upgrading the user application again and just
wondering if anyone else has come across this scenario before.
Environment is 4.0.1 to 4.0.2 (SUSE Linux/JBoss/MySQL) and getting the
below error in the User Application server logs - based on the "Unknown
column 'provisioni0_.REFRESHSTATUS' in 'field list'" text it appears
that the schema of the database has changed and this hasn't been
reflected in the database?

I've performed the install selecting using the existing database and
creation of tables at start up. As a general observation it seems that
the User Application is very troublesome to deal with particularly in
comparison to the core IDM engine that is very straight forward to
upgrade.

Cheers,

Andrew.

2014-05-13 10:53:41,551 INFO [STDOUT] (Timer-4) INFO [RBPM]
[com.novell.idm.nrf.service.CodeMapEngine:buildEnti tlementCodeMapTables]
CODE MAP refresh on entitlement: cn=group,cn=active directory
driver,cn=driverset1,o=system, processed, next refresh time:
20140513105341+1000.
2014-05-13 10:53:41,585 INFO [STDOUT] (Timer-4) ERROR [RBPM]
[com.novell.idm.nrf.service.CodeMapEngine:updateEnt itlementToCodeMapView]
Unable to complete the CODE MAP refresh for entitlement:
cn=useraccount,cn=active directory driver,cn=driverset1,o=system.
2014-05-13 10:53:41,622 INFO [STDOUT] (Timer-4) ERROR [RBPM]
[com.novell.idm.nrf.service.CodeMapEngine:updateRef reshStatus] Error
occured during the process of updating the code map tables.
com.novell.soa.persist.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute query
at
com.novell.idm.nrf.persist.ProvisioningCodeMapDAO. updateRefreshStatus(ProvisioningCodeMapDAO.java:46 5)
at
com.novell.idm.nrf.service.CodeMapEngine.updateRef reshStatus(CodeMapEngine.java:500)
at
com.novell.idm.nrf.service.CodeMapEngine.handleEnt RefreshFailure(CodeMapEngine.java:250)
at
com.novell.idm.nrf.service.CodeMapEngine.updateEnt itlementToCodeMapView(CodeMapEngine.java:372)
at
com.novell.idm.nrf.service.CodeMapEngine.buildEnti tlementCodeMapTables(CodeMapEngine.java:154)
at
com.novell.idm.nrf.service.CodeMapEngine$CodeMapBu ilder.run(CodeMapEngine.java:388)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:92)
at
org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:253 6)
at org.hibernate.loader.Loader.listIgnoreQueryCache(L oader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoa der.java:452)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(Que ryTranslatorImpl.java:363)
at
org.hibernate.engine.query.HQLQueryPlan.performLis t(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.ja va:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:1 02)
at
com.novell.idm.nrf.persist.ProvisioningCodeMapDAO. updateRefreshStatus(ProvisioningCodeMapDAO.java:44 3)
... 7 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: Unknown
column 'provisioni0_.REFRESHSTATUS' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 31)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3283)
at
com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1332)
at
com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1467)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.executeQuery(WrappedPreparedStatement.java: 342)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:80 2)
at
org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:253 3)
... 15 more


--
andrewsilcock
------------------------------------------------------------------------
andrewsilcock's Profile: https://forums.netiq.com/member.php?userid=6818
View this thread: https://forums.netiq.com/showthread.php?t=50832