Pages

Wednesday, July 18, 2012

K2 4.6 Upgrade - Things to know

I recently upgraded a K2 Blackpearl environment from version 4.5 to version 4.6. Here I want to outline me findings in case someone runs into similar issues.

Background

One of the major changes in this release is the database consolidation which stores everything in one single database. I personally like this, as it makes the life of DB admins easier and it should also bring some performance enhancements as well.

Gotchas

If you are about to upgrade to 4.6 from an existing version, keep in mind that your databases will stay as they are. They will not be consolidated into 1 database. This only happens if you are doing a clean installation.

Another thing that I found out after the upgrade is the required task of rebuild the index on some of the K2 databases. The following 3 databases need to be reindexed after the upgrade
  • K2Server
  • K2ServerLog
  • K2SmartBroker
By following the instructions the index rebuild can be triggered from the "K2 Configuration Analysis wizard" at the end of the upgrade by pressing the "Repair" button. For some reason it didn't work for me. The tool keeps on saying that either the indexing jobs could not be created or the indexes have not started rebuilding.

I checked the database security settings to make sure everything was correct. Still the same problem.

In the end I had to manually trigger the following stored procedures on the SQL server to force the index rebuild.
  • [K2Server].[DatabaseCheckIndexes]
  • [K2ServerLog].[DatabaseCheckIndexes]
  • [K2SmartBroker].[DatabaseCheckIndexes] 
After that I re-run the Analysis wizard and everything was fine.

Apart from that the Upgrade to version 4.6 went without any issues.

No comments:

Post a Comment