JR51366: YOUR CUSTOMIZATIONS TO DATABASES OVERRIDE CONFLICTING IBM BPM DBUPGRADE SCRIPT CUSTOMIZATIONS

8.5.0.1-WS-BPM-IFJR51366
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• During  migrating  from BPM7512 to BPM8501, running dbUpgrade
  command will meet below errors:
  
  Error executing SQL statement: DB2 SQL Error: SQLCODE=-454,
  SQLSTATE=42723, SQLE
  RRMC=DB2ADMIN.LSW_ERASE_TEMP_GROUPS, DRIVER=4.11.69
  SQL statement that failed: CREATE PROCEDURE
  db2admin.LSW_ERASE_TEMP_GROUPS()
  LANGUAGE SQL
  BEGIN
  DECLARE groupId DECIMAL(12,0);
  DECLARE sqlCmd VARCHAR(500);
  DECLARE at_end DECIMAL(1,0);
  DECLARE not_found CONDITION for SQLSTATE '02000';
  DECLARE CONTINUE HANDLER for not_found SET at_end = 1;
  BEGIN
  DECLARE groupsToDelete CURSOR FOR stmt1;
  SET sqlCmd = 'SELECT DISTINCT g.GROUP_ID FROM
  db2admin.LSW_USR_GRP_XREF g WHERE
  NOT EXISTS (SELECT 1 FROM db2admin.LSW_TASK t WHERE g.GROUP_ID =
  ABS(t.GROUP_ID)
  ) AND g.GROUP_TYPE = 2';
  PREPARE stmt1 FROM sqlCmd;
  OPEN groupsToDelete;
  DELETE_GROUP_LOOP:
  LOOP
  SET at_end = 0;
  FETCH groupsToDelete INTO groupId;
  IF (at_end = 1) THEN
  LEAVE DELETE_GROUP_LOOP;
  END IF;
  DELETE FROM db2admin.LSW_USR_GRP_MEM_XREF WHERE GROUP_ID =
  groupId;
  DELETE FROM db2admin.LSW_USR_GRP_XREF WHERE GROUP_ID = groupId;
  END LOOP;
  CLOSE groupsToDelete;
  END;
  END
  

Local fix

• This is an internal apar for the migration issue found by us for
  BPM 850
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  IBM BPM Advanced                            *
  *                  IBM BPM Standard                            *
  *                  IBM BPM Express                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When you run DBUpgrade command to       *
  *                      upgrade IBM Business Process            *
  *                      Management (BPM) Process Server and     *
  *                      Performance Data Warehouse databases,   *
  *                      and you customized these databases,     *
  *                      such as by dropping and creating an     *
  *                      index or constraint,  these             *
  *                      customizations might conflict  with     *
  *                      the IBM BPM schema upgrade scripts.     *
  *                      As a result, the DBUpgrade command      *
  *                      fails and the conflicting               *
  *                      customizations from the IBM BPM         *
  *                      schema upgrade scripts are ignored.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  No additional information is available.
  

Problem conclusion

• A fix is available for IBM BPM V8.5.0.1 that tolerates the
  conflicts if they are safe to ignore, keeping your
  customizations
  
  On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR51366:
  
  1. Select IBM Business Process Manager with your edition from
  the product selector, the installed version to the fix pack
  level, and your platform, and then click Continue
  2. Select APAR or SPR, enter JR51366, and click Continue.
  
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  BPM ADVANCED

• Fixed component ID

  5725C9400

Applicable component levels

• R800 PSY

     UP