IV17269: BMXAA4211E - DATABASE ERROR NUMBER -803 HAS OCCURRED WHEN OPERATING ON PMZHBSMTM PROCESSNAME=SPPCMODSRV PROCESSREV=1

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • We are trying to use the migration manager app to import
    data from a source environment to a new TSAM environment
    During the pre-check of a deploy action we see the
    following error in SystemOut.log of MXServer.
    .
    BMXAA4211E - Database error number -803 has occurred when
    operating on PMZHBSMTM Processname=SPPCMODSRV Processrev=1
    Nodeid=3.
    .
    One or more values in the INSERT statement, UPDATE statement,
    or foreign key update caused by a DELETE statement are not
    valid because the primary key, unique constraint or unique
    index identified by "1" constrains table "MAXIMO.PMZHBSMTM"
    from having duplicate values for the index key.. SQLCODE=-803,
    SQLSTATE=23505, DRIVER=3.53.70 psdi.util.MXSystemException:
    BMXAA4211E - Database error number -803 has occurred when
    operating on PMZHBSMTM Processname=SPPCMODSRV Processrev=1
    Nodeid=3.
    .
    One or more values in the INSERT statement, UPDATE statement,
    or foreign key update caused by a DELETE statement are not
    valid because the primary key, unique constraint or unique
    index identified by "1" constrains table "MAXIMO.PMZHBSMTM"
    from having duplicate values for the index key.. SQLCODE=-803,
    SQLSTATE=23505, DRIVER=3.53.70
    .
    Environment is TSAM 7.2.2.1 FP 1
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of Tivoli Service Automation Manager
    7.2.2.0 and 7.2.2.1 migrating out-of-the-box or custom workflows
    by means of the Migration Manager
    ****************************************************************
    * PROBLEM DESCRIPTION: Object structure PMZHBWF is not correctly
    defined which leads to database errors when importing workflows
    ****************************************************************
    * RECOMMENDATION:
    To temporary fix this issue please follow these steps:
    
    1) In the TPAe UI, go to Integration - Object Structures and
    filter/select PMZHBWF
    2) From the Action menu select Inbound Setting Restrictions
    3) Select object PMZHBCEHR and find attribute PMZHBCEHRID
    4) Check boxes Override and Restricted
    5) Select object PMZHBSMTM and find attribute PMZHBSMTMID
    6) Check boxes Override and Restricted
    7) Click OK button
    8) Save object structure by clicking on Save Object Structure
    button from toolbar
    9) Repeat the last failed Migration Manager import step
    
    For permanent resolution apply Tivoli Service Automation Manager
    7.2.2 Fixpack 2 when available.
    

Problem conclusion

  • Primary ID fields from objects PMZHBCEHR and PMZHBSMTM are not
    correctly configured for the object structure PMZHBWF which
    leads to database errors when importing workflows containing
    these objects by means of the Migration Manager.
    
    The fix for this APAR is contained in the following maintenance
    packages:
    | fix pack | 7.2.2-TIV-TSAM-FP0002
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV17269

  • Reported component name

    TSAM (& INSTALL

  • Reported component ID

    5724W7800

  • Reported release

    722

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-03-14

  • Closed date

    2012-03-23

  • Last modified date

    2012-03-23

  • 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

    TSAM (& INSTALL

  • Fixed component ID

    5724W7800

Applicable component levels

  • R722 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Service Automation Manager

Software version:

722

Reference #:

IV17269

Modified date:

2012-03-23

Translate my page

Machine Translation

Content navigation