During Ask the Experts webinar for (mainly) Lawson customers we got a lot of good questions. I’m going to try and answer some of the questions in coming posts and today I’m going to give you some tips and tricks for updating and migrating data to 10.1 and later. This post was originally posted on the Lawson Tech blog.
Many customers have questions about upgrading from 10.0.4.x or 10.0.5 to the latest version which is currently 10.1 for Lawson customers and 10.2 for M3 customers. 10.2 is not publicly available for Lawson customers but as soon as it is I’ll publish that information on the blog. It is important to know that installing 10.1 requires a migration and it is not an upgrade path.
But if you are on 10.1 it’s an easy upgrade to 10.2. No extra steps involved. Please note that Search and LBI is an extra installation (.lawsonapp) as of 10.2. If you are on M3 10.1 or M3 13.1 and higher you can use Smart Office 10.2.
I always recommend you to restart your server and check the log before upgrading. This is because we recently had a support case where the database was locked – probably due to an immediate grid shutdown when Smart Office was starting up and doing the database validation check.
There is a new stand-alone tool (Mango Admin Tool) that will help you with the export and import of data. It was built for 10.0.5.2 and this is the version you need to get to in order to export the data.
Here are some important notes to consider.
- You can only have one Smart Office installation per grid. (It does not matter if the name has changed to MangoServer)
- If you want to use the same grid you need to: upgrade to 10.0.5.2, export the data, move the zip or download it, then uninstall and install 10.1.x (at least 10.1.1).
- Separate .lawsonapplications need to be installed on 10.1.1 before importing the data But you do not have to reconfigure them beucase the configuration will be imported. Installed features will not be migrated but installed Mashups will be included in the MangoData.zip that you exported.
- For Lawson DSSO you should NOT configure Smart Office to use the DSSO Router. You should use the Default Router with the DSSO session provider.
- You can run 10.1.x on MS SQL server instead of the built in H2 database. This is recommended for production.
- You can use the Mango Admin tool to export and import data in the same version, cloning your production setup to test for example.
- Even if the Life Cycle Manager says the upgrade was a success you need to check the server log in the grid for MangoServer (LSO). If there are database changes those are applied as the server starts.
Here are some sample preparation steps:
- Write down all features you have installed (or screenshot from Installation point Manager)
- – .lawsonapplication files (LPA / IPA, LBI, Search) will need to be re-installed in 10.2.
- Upgrade to 10.0.5.0 then 10.0.5.2
- – Smart Office 10.0.5 still requires the same grid version as 10.0.4 so grid does not need to be upgraded before applying 10.0.5
- Download the 10.1 package and get the Mango Admin tool from the zip
- Run the export of all data from the database
- Copy the MangoData.zip to a new location
- Optional: Copy the h2 database to a backup location as well as the LSO files folder
Milestone Check: You have upgraded to 10.0.5.2 and have completed the export of data. You also have a backup of that data. You have two options:
1. Use the same grid – you need to uninstall everything
2. Use a new grid – you can then have 10.0.5 and 10.1 in parallel (on two different grids)
Note that for client (desktop) installs 10.1 is on .Net 4.5 (x86) so it is a new client installation. There will be no automatic update of the client.
Use a new grid
Install a new grid and then install the 10.1.1 or 10.2 version of Smart Office.
Install all extra features.
Import the migrated data (MangoData.zip).
Use the same grid
Use the same grid if you want to avoid having to configure a new the Session Provider in the new grid. The windows session provider requires no configuration and the LDAP is easy to configure if you can check the configuration in the original grid and compare.
Smart Office 10.1 is a new installation so there is no upgrade. You need to:
- Uninstall all installed .lawsonapplications, Features, and mashups
- Uninstall Smart Office 10.0.5.2
- Upgrade the Grid to 10.1.11
- Upgrade GDBC to 2.0.7 (or at least 2.0.3 – but I always go with the latest version specified for the grid version I’m on)
After completing these steps you have the previous grid upgraded and ready for a clean install of 10.1.1 or 10.2.
Regardless of the version you are going to install make sure you download and apply any released service packs for that version before installing.
1) Install Smart Office
2) Install any additional features (.lawsonapplication) for the new Smart Office server
3) Import the data in the Mango Admin tool (after installing all Mashups and extra features like LBI/Search/Mashup designer ( .lawsonapp) in step 2)
Always check the server log before upgrading. You can for example restart the server and see that there are no errors in the log before trying to upgrade.
Then after upgrading and LCM says success make sure you check the log file again.
There are some liquibase warnings or you might have a warning that GDBC is not available yet. Those are OK.
liquibase.exception.LockException: Could not acquire change log lock
We have had one customer issue where the H2 database was locked by liquibase probably due to an immediate shutdown of the server. If you see any kind of error message related to the database being locked you should contact Infor Extreme support in the first hand but if you are confident updating the database you can manually remove the lock by setting it to 0 in the LOCKED column in the table DATABASECHANGELOGLOCK. The correct column values are: 1 0 NULL NULL (Or you might have to delete the row and then add a new row with 1 0 NULL NULL.
org.h2.jdbc.JdbcSQLException: The database is read only
Here is another issue that I have only seen once and my suggestions were the following:
1) Restart the grid
2) Check that the user that grid is running as has access to the h2 db file (it normally has access but if something has changed in the setup you need to check this). It is located under the GDBC application in the grid:…\LifeCycle\grid\InstallTest3\applications\GDBC\h2db\MangoServer.h2.db
3) Check the database file with H2 recovery tool to rebuild and recover the DB files. Check the Grid Extensions admin guide.
Subscribe to the CCSS RSS channel for fixes
In Life Cycle Manager you can download and apply fixes. I have a great admin tips to keep track of when new fixes are published. I simply add the RSS channel to Outlook. Instructions for OUtlook 2013.
Here are the URLs (notice that there are different roots depending on LCM version):
All fixes on all tech channels:
All fixes on a specific channel:
Smart Office 10.0.5 on LCM 9
All fixes on all tech channels:
All fixes on a specific channel: