Learning resources are corrputed after upgrade from Olat 7 to 12.5

[korm...@gmail.com]

Hi!

I'm currently working the upgrade of our Olat 7.2 installation to the latest 12.5.

Everything went OK, db updates, tomcat config, deploy, ldap config, but after logging in, although in Authoring/search I can find my existing courses but after clicking on it I get the error message:

"The learning resource is corrupted and can not be displayed"

I copied the old olatdata folder into the new installation, it seems the Olat finds it, because before I copied the files the courses were not shown.

What can I do to save my old courses?

Or I missing some extra stept maybe?

Thanks in advance!

Peter

[korm...@gmail.com]

In the meantime I finally managed to get it worked - it was a config issue.

I can see the courses but the not the groups connected to them.

As far as I can see there's a lot of changes in the database stucture since 7.2 :)

So maybe the update scripts are missing something.

I figured out the the old groups are present in the O_GP_BUSINESS table. But the FK_GROUP_ID column are empty. So the new version cannot make a connection between the course and the groups.

I think it need some rows in the O_BS_GROUP and the O_RE_TO_GROUP tables.

[Florian Gnägi]

Hi Peter

Did you update in one step or did you update with intermediate steps?

See https://www.openolat.com/fileadmin/adminwiki/_START_.html

In 8.2 some we changed the datastructures quite a bit, see also the corresponding hints in the update manual in that wiki for the 8.2 update. I’m not sure you can do the update to 12.5  in one step, I think you need to perform some intermediate updates. 

Check your database update property: 

auto.upgrade.database=true

Did you check the upgrade file in 

olatdata/system/installed_database_upgrades.xml

olatdata/system/installed_upgrades.xml

If you have some entries <installationComplete>false</installationComplete> in there, you know where to search. 

Also, make sure you read the first few meters of your olat.log after startup. 

Cheers

Florian

--
--
Sie erhalten diese Nachricht, weil Sie Mitglied sind von Google
Groups-Gruppe "OpenOLAT".
Für das Erstellen von Beiträgen in dieser Gruppe senden Sie eine E-Mail
an open...@googlegroups.com
Um sich von dieser Gruppe abzumelden, senden Sie eine E-Mail an
openolat+u...@googlegroups.com
Weitere Optionen finden Sie in dieser Gruppe unter
http://groups.google.com/group/openolat?hl=de
-------------------------------------------------------------------------------------------------------------------
OpenOLAT - infinite learning - http://www.openolat.org

---
You received this message because you are subscribed to the Google Groups "OpenOLAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openolat+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--------------------------------------------------------------------

professional services for the e-learning system OpenOLAT

hosting - operating - support - development - mobile - consulting

--------------------------------------------------------------------

www.frentix.com | www.openolat.com 

frentix  GmbH

Florian Gnägi, Geschäftsführer

Hardturmstrasse 76

CH-8005 Zürich, Switzerland

tel://+41-43-544-9000

dir://+41-43-544-9001

fax://+41-43-544-9009

Find me on wire skype twitter xing linkedin 

--------------------------------------------------------------------

[korm...@gmail.com]

Hello Florian!

Thank for the answer.

Yeah, I did it in one go. So that is clearly not working :)

All right so, I need to download all the war-s for the major releases and separately run each db upgrade scipts and deploy the wars with auto.upgrade.database=true property.

It means that not only the database upgrade scipts but the java side code is also doing some database upgrading/maintenance?

Because I cannot see any INSERTS int the sql files for these new tables for the learning groups.

Rgds,

Peter

[Florian Gnägi]

Hi Peter

Yes, we have an upgrade infrastructure that runs when you start the system and then does some cleanup or migration code. You certainly don’t need to install every single update, the upgrader code is also contained in later releases. I’ll ask Oliver if he can give you a clue which updates are the important ones. 

Cheers

Florian

[Körmöczi Péter]

Hi Florian!

Another question. Is it possible to somehow migrate from the old 7.2 Olat version, the tests and the documents uploaded under the course?

Because I'm thinking it's easier to just do a clean install of the new 12.5 and I can create the groups and users via the REST API. The only things we need is the tests and the uploaded documents.

Or should I just stick to the multi-step upgrade plan and hoping, that all my old data will be intact? :)

Thanks,

Peter

 

You received this message because you are subscribed to a topic in the Google Groups "OpenOLAT" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openolat/e-HnVPlXPLI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openolat+u...@googlegroups.com.

[Florian Gnägi]

Hi Peter

You can export your resources from your old installation and the import it into the new instance. Theoretically this should work. However, many people upgraded from OLAT 7.2 to  OpenOLAT, this can be done. I’d say it depends on how large your installation is. For a small installation it might be easier to export the resources and start from scratch, if you have a reasonable amount of data and don’t want to loose all the user data such as test results, forum entries, efficiency statements, then you must perform an upgrade. 

We can do this for you or assist you actively in this process. If you are interested in such commercial support, please contact us at con...@frentix.com. It is difficult to do this via public mailing list, we probably need access to your server. 

Best Regards

Florian