Upgrading from older versions - simple

Installation Guide > Codebeamer Installation Guide > Codebeamer Installation > Upgrading from older versions - simple - since 21.09 (Emma)

Upgrading from older versions - simple - since 21.09 (Emma)

Please check the supported upgrade paths

To control the whole upgrade process, use this upgrade guide:Upgrading from older versions - advanced - since 21.09 (Emma).

Before Emma version please refer to Upgrading from older versions - simple - before 21.09 (Emma).

On Linux, upgrading to Codebeamer 22.04 (Felicity), the followings are required:

• Java has to be updated to version 11.x.

• The ARIALUNI.TTF font (used by mxGraph) must be downloaded and installed to the target server manually.

• There are additional fonts that could be missing, for this Intland Support team found some possible workaround. Before applying any of the workaround, check whether using them is necessary!

◦ https://knowledge.broadcom.com/external/article/239487/fontconfiguration-x11-error-in-db-load-u.html

◦ https://forum.plantuml.net/9781/invocationtargetexception-fileformat-getjavadimension

◦ https://github.com/corretto/corretto-11/issues/53#issuecomment-615210401

◦ https://stackoverflow.com/questions/55791235/pentaho-poi-throws-invocationtargetexception

If MySQL or Oracle database were used before upgrading to Codebeamer 21.09 (Emma), take into consideration that only MySQL 8.0 and Oracle 19 are supported from Codebeamer 21.09 (Emma).Upgrade your MySQL/Oracle instance

before upgrading Codebeamer. Not meeting this requirement could corrupt the database.

As from Codebeamer 21.09 (Emma) only MySQL 8.0 is supported, refer to How to migrate from MySQL 5.7 database to MySQL 8.0 when upgrading from MySQL 5.7.

When upgrading MySQL to a newer version, do not forget to do the following:

• run the following command in a terminal/CLI: mysql_upgrade -u root -p --force.

• restart mysqld.

You can find more information on this webpage: https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html

1. It is imperative that you make a backup of your Codebeamer and Codebeamer database before you upgrade.

2. Codebeamer must be stopped during the installation. Ensure all java/javaw processes are stopped, otherwise data loss is possible.

Please note: The upgrade procedure transfers your installation instance data from the old version to the new version. Migration from the new version back to the old version is NOT supported.

The old Codebeamer instance will be referred as OLD-CB, the new one as NEW-CB throughout this document.

Step 1. Install NEW-CB

Install NEW-CB into a new directory (the installation must not be executed into an existing directory) and do not start the Codebeamer server at the end of the installation.

Step 2. Database upgrade

Upgrade database engine if required. PostgreSQL 12, MySQL 8.0 and Oracle 19 are supported. Please see advanced description: Upgrading from older versions - advanced - since 21.09 (Emma).

How to export/import MySQL database: Create and Load MySQL Dumps

How to export/import PostgreSQL database: Create and Load PostgreSQL Dumps

How to export/import Oracle database: Import and Export Codebeamer Database with Oracle.

Setting character encoding on MySQL

Follow the steps described here: Migrate MySQL database to UTF8MB4 character encoding.

Step 3. Start upgrade script

Windows

NEW-CB\upgrade\upgrade.bat

Unix

NEW-CB\upgrade\upgrade.sh

Go through the upgrade steps.

In case of errors occuring, fix the problem and start the whole process again. (Reinstall new Codebeamer)

Step 4. Get a new license

Check the relevant Release Notes whether a new license is required. Read the Getting Licenses section in Codebeamer Licensing

You need to have that license at hand before you continue with the next steps.

Please also consider that you can only request licenses from Intland Software

from Monday through Friday, 8:00 - 17:00 GMT+2, and that processing a license request may take hours up to several days!

So do not shut down your live production system or schedule the upgrade overnight or during the weekend, until you already have a license for the new system.

To install the new license:

1. Login Codebeamer with System Admin and open System Admin —> License page.

2. Click on [Edit License] button and insert the new License and Save.

Step 5. Runtime Parameters

If you had customized OLD-CB runtime variables, e.g. special JVM, HEAPSIZE, etc., then you should copy these settings from the OLD-CB start script to the NEW-CB start script.

Operating System	Path	Script
Unix/Linux/Mac OS X	~/NEW-CB/bin	cb
Windows (No Service)	~/NEW-CB/bin	cb.bat
Windows (Service)	~/NEW-CB/tomcat/bin	cbservice.bat

For changes in ~/NEW-CB/tomcat/bin/cbservice.bat to take effect, you must run the following command manually afterwards:

cbservice codebeamer codebeamer

Step 6. Start

Start the NEW-CB server. The first time the Codebeamer server is started, the database schema will be upgraded to version NEW-CB.

Depending on which version you're upgrading from, and the amount of data in your database, the first startup of the NEW-CB server might take up to 10-120 min, because the database scheme will be updated in the background (the database process might use a lot of CPU).

Do not shutdown or kill the NEW-CB server as long as the database upgrade is in progress, otherwise the database might be corrupted.

Step 7. Clearing Browser Caches

Because browsers cache javascript files, the cached javascript files must be reloaded. It is strongly recommended clearing the browsers' cache and restarting the browser.

Step 8. Starting Re-indexing

After upgrading, the index database is empty thus searching will not provide any matching.

Perform a re-indexing of artifacts by going to System Admin > Indexing, click on [YES, drop file cache and re-index!]

During the re-indexing process the search results may not contain all matches, it is recommended to perform outside business hours.

Step 9. Validate logs

Check if ~/NEW-CB/tomcat/logs/errors.txt contains any error. In case of an error, create a bug ticket on https://Codebeamer.com

with the attached log files (cb.txt / errors.txt)

Step 10. Git http-backend verification ( Optional, for Windows- based installation )

In System Admin —> Application Configuration menu verify and update the http-backend key in git section:

"git" : {

"http-backend" : "C:\\NEW_CB_\\libexec\\git\\mingw64\\libexec\\git-core\\git-http-backend.exe",[supported upgrade paths|https://intland.com/technical-support/#!/supported-version-software]

Troubleshooting

MisfireHandler: Error handling misfires

When seeing the following error in the log files:

ERROR impl.jdbcjobstore.JobStoreTX - MisfireHandler: Error handling misfires: Couldn't retrieve trigger: com.intland.codebeamer.search.IndexerJobContext; local class incompatible: stream classdesc serialVersionUID = -7585049943194384322, local class serialVersionUID = -8731699021495524083

The problem is that single run index triggers (manual triggers - MT) got stuck at shutdown, and do not get to be rescheduled, but rather fail when misfire handler tries to rerun the job.

Run the following SQL script to clean up these triggers:

-- check how many trigger is manually created #1

SELECT COUNT(*) FROM QRTZ_SIMPLE_TRIGGERS WHERE TRIGGER_NAME NOT LIKE 'com.intland%' AND TRIGGER_GROUP = 'DEFAULT';

SELECT COUNT(*) FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME NOT LIKE 'com.intland%' AND TRIGGER_GROUP = 'DEFAULT';

-- check how many trigger is manually created #2

SELECT COUNT(*) FROM QRTZ_SIMPLE_TRIGGERS WHERE TRIGGER_NAME LIKE 'MT_%';

SELECT COUNT(*) FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME LIKE 'MT_%';

If both SELECT statement pairs return the same numbers, execute the following DELETE statements:

-- remove unwanted single run triggers

DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE TRIGGER_NAME LIKE 'MT_%';

DELETE FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME LIKE 'MT_%';

Was this helpful?