Error upgrading 10.0.0 to 10.0.5

[Graham Conway]

Hi Guys,

We are trying to upgrade to the latest stable production version of openOlat from our current production version, which is
(10.0.0a)

We have tried to go directly to openolat 11.0, openolat 10.5.8 and have run into problems.
So were are trying to now do incremental upgrades version by version.

I attempted to upgrade from OpenOlat 10.0.1 to 10.0.5  (the earliest 10.0.0 release i could find in http://www.openolat.com/fileadmin/downloads/releases/)

When we do the upgrade, the program is producing an exception, on groupdao.getgrants

error upgrading postsysteminitupgrade::olat_10.0.3 ^%^ >>>stack of 1.cause::java.lang.nullpointerexception: null
->  at org.olat.basesecurity.manager.groupdao.getgrants(groupdao.java:216)
at org.olat.group.right.bgrightmanagerimpl.findbgrights(bgrightmanagerimpl.java:145)
 at org.olat.upgrade.olatupgrade_10_0_3.processrightgroup(olatupgrade_10_0_3.java:130)

 my guess is we are missing some database tables detinitions or data that are related to groups. And that those changes happened between olat 10.0.0 and 10.0.5

I am wondering are there any wars / releases between 10.0 before 10.0.5 that would fix our data?
Or do you have suggetsions on fixing our data, it that's what needs to be done.

Thanks Graham Conway


 warn  upgrademanagerimpl  - olat::warn ^%^ n1-w6 ^%^ org.olat.upgrade ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a ^%^ error upgrading postsysteminitupgrade::olat_10.0.3 ^%^ >>>stack of 1.cause::java.lang.nullpointerexception: null ->  at org.olat.basesecurity.manager.groupdao.getgrants(groupdao.java:216) at org.olat.group.right.bgrightmanagerimpl.findbgrights(bgrightmanagerimpl.java:145) at org.olat.upgrade.olatupgrade_10_0_3.processrightgroup(olatupgrade_10_0_3.java:130) at org.olat.upgrade.olatupgrade_10_0_3.upgradebusinessgroups(olatupgrade_10_0_3.java:114) at org.olat.upgrade.olatupgrade_10_0_3.dopostsysteminitupgrade(olatupgrade_10_0_3.java:84) at org.olat.upgrade.upgrademanagerimpl.dopostsysteminitupgrades(upgrademanagerimpl.java:78) at org.olat.upgrade.upgrademanager.event(upgrademanager.java:205) at org.olat.core.util.event.eventagency$2.run(eventagency.java:113) at org.olat.core.logging.activity.threadlocaluseractivityloggerinstaller.runwithuseractivitylogger(threadlocaluseractivityloggerinstaller.java:108) at org.olat.core.util.event.eventagency.fireevent(eventagency.java:111) at org.olat.core.util.event.abstracteventbus.dofire(abstracteventbus.java:93)
2016-11-30 02:59:10,092 [activemq session task] debug threadlocaluseractivityloggerinstaller  - olat::debug ^%^ n1-d519 ^%^ org.olat.core.logging.activity ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a ^%^ reset original logger back with originallogger == null!
2016-11-30 02:59:10,093 [ActiveMQ Session Task] ERROR EventAgency  - OLAT::ERROR ^%^ N1-E1 ^%^ org.olat.core.util.event ^%^ n/a ^%^ n/a ^%^ n/a ^%^ n/a ^%^ Error while sending generic event! Removing listener: org.olat.upgrade.UpgradeManagerImpl@1ecb70b8 ^%^ >>>stack of 1.cause::java.lang.RuntimeException: *** CRITICAL ERROR IN UPGRADE MANAGER. Loading aborted. ->  at org.olat.upgrade.UpgradeManager.abort(UpgradeManager.java:199) at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:86) at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:205) at org.olat.core.util.event.EventAgency$2.run(EventAgency.java:113) at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) at org.olat.core.util.event.EventAgency.fireEvent(EventAgency.java:111) at org.olat.core.util.event.AbstractEventBus.doFire(AbstractEventBus.java:93) at org.olat.commons.coordinate.cluster.jms.ClusterEventBus.serveMessage(ClusterEventBus.java:352) at org.olat.commons.coordinate.cluster.jms.ClusterEventBus.onMessage(ClusterEventBus.java:273) at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1204) at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:131)>>>stack of 2.cause::java.lang.NullPointerException: null ->  at org.olat.basesecurity.manager.GroupDAO.getGrants(GroupDAO.java:216) at org.olat.group.right.BGRightManagerImpl.findBGRights(BGRightManagerImpl.java:145) at org.olat.upgrade.OLATUpgrade_10_0_3.processRightGroup(OLATUpgrade_10_0_3.java:130) at org.olat.upgrade.OLATUpgrade_10_0_3.upgradeBusinessGroups(OLATUpgrade_10_0_3.java:114) at org.olat.upgrade.OLATUpgrade_10_0_3.doPostSystemInitUpgrade(OLATUpgrade_10_0_3.java:84) at org.olat.upgrade.UpgradeManagerImpl.doPostSystemInitUpgrades(UpgradeManagerImpl.java:78) at org.olat.upgrade.UpgradeManager.event(UpgradeManager.java:205) at org.olat.core.util.event.EventAgency$2.run(EventAgency.java:113) at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) at org.olat.core.util.event.EventAgency.fireEvent(EventAgency.java:111) at org.olat.core.util.event.AbstractEventBus.doFire(AbstractEventBus.java:93)

[Stéphane Rossé]

Hi 

You cannot have an exception there. Your database is not in clean state. Your business group are missing a very important database row which whose added with 10.0.

Connect to your database and make this query

select * from o_gp_business where fk_group_id is null;

If it find a result, you have a problem. The update to 10.0 was not successful and your database is not in a clean state.

Best regards

Stéphane