IBM Support

IJ49153: DB2 only. Integrity Checker fails with NullPointerException/nullerror on attributes with MAXTYPE=ALN, LENGTH=32000

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

  • Running updatedb on db2 fails, with the following message:

BMXAA0442W ? Warning - BMXAA7726W ? Unique column ID does not
have the BIGINT maxtype on the following tables:
ANYWHEREAPP
ANYWHEREPROPERTY
ANYWHEREPROPVALUE
ANYWHERERESOURCE
ANYWHERERESOURCEVALUE
BMXAA0443E ? Error - BMXAA0494E ? The definition of this
column does not match the actual column. The native column
definition does not match the servers metadata. Run the
Integrity Checker in repair mode. Thu Nov 09 18:31:13 UTC 2023
BMXAA0443E ? Error - BMXAA0494E ? The definition of this
column does not match the actual column. The native column
definition does not match the servers metadata. Run the
Integrity Checker in repair mode. Thu Nov 09 18:31:13 UTC 2023
BMXAA0443E ? Error - BMXAA0494E ? The definition of this
column does not match the actual column. The native column
definition does not match the servers metadata. Run the
Integrity Checker in repair mode. Thu Nov 09 18:31:13 UTC 2023
null
at com.ibm.tivoli.maximo.integrity.check.TableColumnData(Table
ColumnData.java:260)
at com.ibm.tivoli.maximo.integrity.check.TableColumnData(Table
ColumnData.java:115)
at com.ibm.tivoli.maximo.integrity.check.VerifyMaximoColumns(V
erifyMaximoColumns.java:86)
at com.ibm.tivoli.maximo.integrity.IntegrityCheck(IntegrityChe
ck.java:126)
at psdi.configure.Validate(Validate.java: 6302)
at psdi.configure.Validate(Validate.java: 1088)
at psdi.configure.UpgradeUI(UpgradeUI.java: 437)
at psdi.configure.UpgradeUI(UpgradeUI.java: 342)
at javax.swing.AbstractButton(AbstractButton.java: 2033)
at javax.swing.AbstractButton$Handler(AbstractButton.java:
2359)
at javax.swing.DefaultButtonModel(DefaultButtonModel.java: 413)

at javax.swing.DefaultButtonModel(DefaultButtonModel.java: 270)

at javax.swing.plaf.basic.BasicButtonListener(BasicButtonListe
ner.java:263)
at java.awt.Component(Component.java: 6544)
at javax.swing.JComponent(JComponent.java: 3335)
at java.awt.Component(Component.java: 6309)
at java.awt.Container(Container.java: 2247)
at java.awt.Component(Component.java: 4900)
at java.awt.Container(Container.java: 2305)
at java.awt.Component(Component.java: 4722)
at java.awt.LightweightDispatcher(Container.java: 4899)
at java.awt.LightweightDispatcher(Container.java: 4536)
at java.awt.LightweightDispatcher(Container.java: 4477)
at java.awt.Container(Container.java: 2291)
at java.awt.Window(Window.java: 2757)
at java.awt.Component(Component.java: 4722)
at java.awt.EventQueue(EventQueue.java: 769)
at java.awt.EventQueue(EventQueue.java: 108)
at java.awt.EventQueue$3(EventQueue.java: 720)
at java.awt.EventQueue$3(EventQueue.java: 714)
at java.security.AccessController(AccessController.java: 664)
at java.security.ProtectionDomain$JavaSecurityAccessImpl(Prote
ctionDomain.java:91)
at java.security.ProtectionDomain$JavaSecurityAccessImpl(Prote
ctionDomain.java:101)
at java.awt.EventQueue$4(EventQueue.java: 742)
at java.awt.EventQueue$4(EventQueue.java: 740)
at java.security.AccessController(AccessController.java: 664)
at java.security.ProtectionDomain$JavaSecurityAccessImpl(Prote
ctionDomain.java:91)
at java.awt.EventQueue(EventQueue.java: 739)
at java.awt.EventDispatchThread(EventDispatchThread.java: 212)
at java.awt.EventDispatchThread(EventDispatchThread.java: 127)
at java.awt.EventDispatchThread(EventDispatchThread.java: 116)
at java.awt.EventDispatchThread(EventDispatchThread.java: 112)
at java.awt.EventDispatchThread(EventDispatchThread.java: 104)
at java.awt.EventDispatchThread(EventDispatchThread.java: 93)

Local fix

  • Running updatedb on db2 fails, with the following message:

BMXAA0442W ? Warning - BMXAA7726W ? Unique column ID does not
have the BIGINT maxtype on the following tables:
ANYWHEREAPP
ANYWHEREPROPERTY
ANYWHEREPROPVALUE
ANYWHERERESOURCE
ANYWHERERESOURCEVALUE
BMXAA0443E ? Error - BMXAA0494E ? The definition of this
column does not match the actual column. The native column
definition does not match the servers metadata. Run the
Integrity Checker in repair mode. Thu Nov 09 18:31:13 UTC 2023
BMXAA0443E ? Error - BMXAA0494E ? The definition of this
column does not match the actual column. The native column
definition does not match the servers metadata. Run the
Integrity Checker in repair mode. Thu Nov 09 18:31:13 UTC 2023
BMXAA0443E ? Error - BMXAA0494E ? The definition of this
column does not match the actual column. The native column
definition does not match the servers metadata. Run the
Integrity Checker in repair mode. Thu Nov 09 18:31:13 UTC 2023
null
at com.ibm.tivoli.maximo.integrity.check.TableColumnData(Table
ColumnData.java:260)
at com.ibm.tivoli.maximo.integrity.check.TableColumnData(Table
ColumnData.java:115)
at com.ibm.tivoli.maximo.integrity.check.VerifyMaximoColumns(V
erifyMaximoColumns.java:86)
at com.ibm.tivoli.maximo.integrity.IntegrityCheck(IntegrityChe
ck.java:126)
at psdi.configure.Validate(Validate.java: 6302)
at psdi.configure.Validate(Validate.java: 1088)
at psdi.configure.UpgradeUI(UpgradeUI.java: 437)
at psdi.configure.UpgradeUI(UpgradeUI.java: 342)
at javax.swing.AbstractButton(AbstractButton.java: 2033)
at javax.swing.AbstractButton$Handler(AbstractButton.java:
2359)
at javax.swing.DefaultButtonModel(DefaultButtonModel.java: 413)

at javax.swing.DefaultButtonModel(DefaultButtonModel.java: 270)

at javax.swing.plaf.basic.BasicButtonListener(BasicButtonListe
ner.java:263)
at java.awt.Component(Component.java: 6544)
at javax.swing.JComponent(JComponent.java: 3335)
at java.awt.Component(Component.java: 6309)
at java.awt.Container(Container.java: 2247)
at java.awt.Component(Component.java: 4900)
at java.awt.Container(Container.java: 2305)
at java.awt.Component(Component.java: 4722)
at java.awt.LightweightDispatcher(Container.java: 4899)
at java.awt.LightweightDispatcher(Container.java: 4536)
at java.awt.LightweightDispatcher(Container.java: 4477)
at java.awt.Container(Container.java: 2291)
at java.awt.Window(Window.java: 2757)
at java.awt.Component(Component.java: 4722)
at java.awt.EventQueue(EventQueue.java: 769)
at java.awt.EventQueue(EventQueue.java: 108)
at java.awt.EventQueue$3(EventQueue.java: 720)
at java.awt.EventQueue$3(EventQueue.java: 714)
at java.security.AccessController(AccessController.java: 664)
at java.security.ProtectionDomain$JavaSecurityAccessImpl(Prote
ctionDomain.java:91)
at java.security.ProtectionDomain$JavaSecurityAccessImpl(Prote
ctionDomain.java:101)
at java.awt.EventQueue$4(EventQueue.java: 742)
at java.awt.EventQueue$4(EventQueue.java: 740)
at java.security.AccessController(AccessController.java: 664)
at java.security.ProtectionDomain$JavaSecurityAccessImpl(Prote
ctionDomain.java:91)
at java.awt.EventQueue(EventQueue.java: 739)
at java.awt.EventDispatchThread(EventDispatchThread.java: 212)
at java.awt.EventDispatchThread(EventDispatchThread.java: 127)
at java.awt.EventDispatchThread(EventDispatchThread.java: 116)
at java.awt.EventDispatchThread(EventDispatchThread.java: 112)
at java.awt.EventDispatchThread(EventDispatchThread.java: 104)
at java.awt.EventDispatchThread(EventDispatchThread.java: 93)

Problem summary

  • DB2 Only. Attributes added in Database Configuration as MAXTYPE
ALN, LENGTH 32000 cause null pointer when Integrity Checker is
executed.

Problem conclusion

  • A fix for this APAR will be included in a future release.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IJ49153
    • 

  • 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
    2023-11-10
    • 

  • Closed date
    2024-01-29
    • 

  • Last modified date
    2024-01-29
    • 





    

  • 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


    








      
              
                            

              

              [{"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","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            29 January 2024
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback