IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR51366

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-09-29

  • Closed date

    2014-12-18

  • Last modified date

    2014-12-18

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
18 December 2014