IBM Support

IJ33123: TABLES MISSING PRIMARY KEY

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Problem:
    BudgetRuleProc, BudgetRuleProcTrans, and ReportAttachUNCPath
    objects should have Primary Key Columns defined to prevent
    duplicate records from being created
    
    Steps to reproduce:
    
    After installing TPAE 7.6.1.2 Fix Pack, the Integrity Checker
    raises the following WARNING messages:
    
    BMXAA0416I -- Verifying that an index exists for the primary key
    column sequence of each table. Wed May 12 15:19:39 MST 2021
    BMXAA0442W -- Warning - BMXAA0471W -- No primary key sequence is
    defined on the table. Review the table and decide if a primary
    key sequence is required
    
    Expected Results:
    That these tables have a Primary Key
    
    Reported version:
    7.6.1.2
    

Local fix

Problem summary

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    package: | Release 7.6.1.3 of Base Services
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ33123

  • Reported component name

    MAXIMO ASST MGM

  • Reported component ID

    5724R46AM

  • Reported release

    761

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-06-09

  • Closed date

    2021-11-03

  • Last modified date

    2021-11-03

  • 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

    MAXIMO ASST MGM

  • Fixed component ID

    5724R46AM

Applicable component levels

[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761"}]

Document Information

Modified date:
04 November 2021