Problem

When using Interchange with the bundled embedded Derby database and upgrading to the latest 5.12sp4-sp8 version your system will not run. Worse, if you do not have a backup you risk losing your data.

Resolution

This process is quite simple in theory and should also be in practice. The newer 5.12sp4-latest has altered the basic layout of the Interchange binaries. In particulare the /interchange/corelib/ directory.

As long as you backup this directory prior to starting any upgrade beyond that of the base 5.12sp3 installation then you will be able to rectify the changes made by the new Interchange layout.

After you have copied the /corelib/ directory in whole, you will need to go ahead and complete any and all steps, prerequisites, or other processes as noted in the Read Me/Release Notes for desired service pack.

Next, after you have completed the service pack installation you will want to start your Interchange. It will fail, but it will get all the items in line for you to update as follows.

1. Take the contents of the backed up copy of /corelib/db/derby/ (this will include a /Cyclone/ directory and a few other derby files. The list is as follows:

derby.jar

derby.log

derby.properties

derbytools.jar

2. Now navigate to the new location where you will place these contents. The new location is /interchange/derby/. Notice that we are still using the /derby/ directory.

3. With the contents in place we need to validate a the jvmarguments.xml file has had the appropriate changes to classpaths. You can find this file in the /interchange/conf/ directory.

(*note - the following file will look different from base 5.12sp3 compared to the latest sp8)

4. Search within the file for '/derby'. It should only list the something similar to '../derby'. If you find '../corelib/db/derby' you would want to alter that so the /corelib/db/ is removed and just leaves the '../derby' as any field entries.

5. Start your Interchange.

**Please contact Axway Product Support if you have the slightest question, comment, or concern about your Interchange and a license for bundled embedded database.

***This article does not pertain to any customer with an external database such as Oracle, MS-SQL, or MySQL.