Hi Scott, and thanks for reaching out.

Yes, the intermediate upgrades definitely make a difference. The previous 17.3->18.1->19.1 upgrade sequence should be fine (you may want to check the logs to be sure), but from there, you can't leap straight to 23.11.

• Table of Supported LabKey Version Upgrades

You'll also need to interleave some upgrades of Java and Postgres - you can edit the URL to step through the documentation archives to find out which versions are supported for which LabKey versions. I've linked one general plan below, but you can adjust as you like within the options supported.

You'll first need to roll back to the 19.1 database, and the Java and Postgres versions you were using previously.

• Supported Components for 19.1

From there you can go to 21.7 - using Supported Components for 21.7
then 22.11 - using Supported Components for 22.11
and then 23.11 using the Supported Components for 23.11

• Links to binaries for previous LabKey releases are here

An important note is that after 23.11, LabKey is distributed with Tomcat embedded in it. This will greatly simplify the installation and upgrade process going forward, but that process is different and requires some migration steps. For all the above upgrades to get you to 23.11, you want to be following the older upgrade process you've been using. If needed, you can find it in the documentation archives:

• Upgrades to 23.11

Once you get to that version, you'll be able to follow the migration and upgrade process to 24.7 in the current documentation.

• Upgrades to 24.x and beyond

I'm glad to hear you're picking up with LabKey again. A lot has changed in the last few years! If you're interested in learning more about our products and premium editions, contact us here to set up a demo .

--Molly

Hi Molly, - thanks for the quick and detailed reply. So our previous 19.1 install was previously using postgres 9.6, tomcat 7.x and I am not 100% sure what JVM we were using..

So it seems to me, given the system requirements, that we may not have to roll anything back (maybe just JVM?).. and then step through each of the labkey upgrade files / scripts for each version to capture the progressive updates? Does that make sense? That would be much easier too than rolling everything back..

Any chance someone has / can prepare a consolidated script from each of the versions you listed above? Would make live much easier..

Thanks

Alas, there isn't a more consolidated strategy for this kind of multi-year upgrade, and you definitely don't want to manually run any of the schema upgrade scripts. The server upgrade process will take care of that and other necessary parts of keeping things in sync. Any sort of custom scripting or detailed upgrade assistance for your specific scenario would only be available with a premium subscription.

One other alternative, depending on what you have been using LabKey for/what kinds of data you want to move forward, is to install a brand new/empty instance of 24.7 (with embedded Tomcat). This new-installation is a simpler and even scripted install process, covered here. Then migrate work using folder archives or individual spreadsheet export from the old instance and import into the new one. Watching the logs at every step is always important to catch any issues, whether you go the database upgrade or old->new data migration route.

Hope this helps,

--Molly