Fix (APAR):                IV13380

Status:                    Fix

Product:                   WBI

Release:                   7.0.0.4

Operating System:          All operating systems

Supersedes Fixes:          

Pre-requisite Fixes:       IV07463

Exclusive-requisite Fixes: 

CMVC Defect:               IV13380

Byte size of APAR:         318516

Date:                      2012-01-31

Abstract:                  Prevent duplicate key entries in the queryable variable template table for in-flight migrated processes

Description/symptom of problem:

There can be duplicate key entries in the queryable variable template table which can cause query table functionality to fail.
The problem can occur when the following steps are done:
1) A running business process instance was migrated by using the in-flight process instance migration feature.
2) The migrated instance uses query properties.
3) At least on these query properties was updated before and after the instance has been migrated to a new template version.

NOTE: IBM Installation Manager is required to install this interim.fix (1.4.1 or later recommended). For further details see:
      http://publib.boulder.ibm.com/infocenter/dmndhelp/v7r0mx/index.jsp?topic=/com.ibm.websphere.wps.doc/doc/tins_installingfix_manually.html


NOTE: This interim fix is applicable to both a full WPS installation as well as a WPS client installation.


Directions to apply fix:


1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Extract the .zip file to a directory. For example, extract to C:\temp.

3) Add the fix pack repository location in IBM Installation Manager:
   a. Start IBM Installation Manager.
   b. In Installation Manager, click File > Preferences > Repositories.
   c. Click Add Repository.
   d. Browse to or enter the file path to the repository.config file. The repository.config file is located in the directory where
      you extracted the compressed files. For example, enter C:\temp\repository.config, and then click OK.

4) On the main page of the Installation Manager, click Update.

5) Restart WebSphere

6) Redeploy the application which is intended to be the target for the instance migration.


Directions to remove fix:
NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.  DO NOT REMOVE A FIX UNLESS
       ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.  YOU MAY REAPPLY ANY REMOVED FIX.

Example:  If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be
          removed, fix3 must be removed first, then fix2 may be removed

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Start IBM Installation Manager.

3) On the main page of the Installation Manager, click Unistall.

4) Select the package to uninstall and follow the prompts on screen.

5) Restart WebSphere

Directions to re-apply fix:

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Extract the .zip file to a directory. For example, extract to C:\temp.

3) Add the fix pack repository location in IBM Installation Manager:
   a. Start IBM Installation Manager.
   b. In Installation Manager, click File > Preferences > Repositories.
   c. Click Add Repository.
   d. Browse to or enter the file path to the repository.config file. The repository.config file is located in the directory where
      you extracted the compressed files. For example, enter C:\temp\repository.config, and then click OK.

4) On the main page of the Installation Manager, click Update.

5) Restart WebSphere.


Additional Information: