IBM Support

IJ33496: UPDATEDB FAILS ON A SCRIPT WITH A NULL POINTER EXCEPTION FROM DB2 CODE

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:
UpdateDB fails on a script with a null pointer exception from
DB2 code

PERFORMANCE ISSUE:
No

STEPS TO REPRODUCE:
Upgrade ICD from 7.6.1.2 to 7.6.1.3

CURRENT ERRONEOUS RESULT:
Updatedb Error :
"ERROR: BMXAA7025E -- Script failed while running.; null"
Updatedb fails with following tail end:
-- BEGINUPDATEDBERROR
-- Product: Tivoli's process automation engine
-- Error running script: V7612_02
-- UPDATEDBFILE: V7612_02.dbc
-- Script: Error
rollback
;
// Success.
ERROR: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK ERRORS
IN UPDATE LOG FILE -Updatedb20210601163736.log
dbchange#ScriptFailure
ERROR: BMXAA7025E -- Script failed while running.;
null
    at psdi.dbmanage.ScriptRun(ScriptRun.java: 255)
    at psdi.dbmanage.Utility(Utility.java: 288)
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
343)
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
332)
    at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
289)
    at psdi.tools.RunScripts(RunScripts.java: 156)
    at psdi.tools.UpdateDB(UpdateDB.java: 2888)
    at psdi.tools.UpdateDB(UpdateDB.java: 2817)
    at psdi.tools.UpdateDB(UpdateDB.java: 2233)
    at psdi.tools.UpdateDB(UpdateDB.java: 5277)
    at psdi.tools.UpdateDB(UpdateDB.java: 279)
    at psdi.tools.UpdateDB(UpdateDB.java: 3245)
Caused by: null
    at com.ibm.db2.jcc.am.b7(b7.java: 815)
    at com.ibm.db2.jcc.am.b7(b7.java: 66)
    at com.ibm.db2.jcc.am.b7(b7.java: 140)
    at com.ibm.db2.jcc.am.Agent(Agent.java: 593)
    at com.ibm.db2.jcc.am.Agent(Agent.java: 548)
    at com.ibm.db2.jcc.am.Sqlca(Sqlca.java: 336)
    at
com.ibm.db2.jcc.am.SqlExceptionContainer(SqlExceptionContainer.j
ava: 80)
    at
com.ibm.db2.jcc.am.SqlSyntaxErrorException(SqlSyntaxErrorExcepti
on.java: 54)
    at java.lang.Throwable(Throwable.java: 203)
    at java.lang.Throwable(Throwable.java: 335)
    at java.lang.Throwable(Throwable.java: 123)
    at java.lang.Exception(Exception.java: 113)
    at java.sql.SQLException(SQLException.java: 176)
    at
com.ibm.tivoli.maximo.dbmanage.connection.WrappedSQLException(Wr
appedSQLException.java: 46)
    at
com.ibm.tivoli.maximo.dbmanage.connection.WrappedSQLException(Wr
appedSQLException.java: 41)
    ... 26 more
-- Report Version: Last report version: V7608, last release
version: V7611. No need to update reports.
ERROR: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK ERRORS
IN UPDATE LOG FILE -Updatedb20210601163736.log
dbchange#ScriptFailure
    at psdi.tools.UpdateDB(UpdateDB.java: 2833)
    at psdi.tools.UpdateDB(UpdateDB.java: 2233)
    at psdi.tools.UpdateDB(UpdateDB.java: 5277)
    at psdi.tools.UpdateDB(UpdateDB.java: 279)
    at psdi.tools.UpdateDB(UpdateDB.java: 3245)
ERROR: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK ERRORS
IN UPDATE LOG FILE -Updatedb20210601163736.log
dbchange#ScriptFailure
    at psdi.tools.UpdateDB(UpdateDB.java: 2833)
    at psdi.tools.UpdateDB(UpdateDB.java: 2233)
    at psdi.tools.UpdateDB(UpdateDB.java: 5277)
    at psdi.tools.UpdateDB(UpdateDB.java: 279)
    at psdi.tools.UpdateDB(UpdateDB.java: 3245)


ADDITIONAL INFO:
This seems to be caused by the
retrieveMessagesFromServerOnGetMessage  option being turned on
and some other, unknown factor.

ENVIRONMENT:
Tivoli's process automation engine 7.6.1.2-IFIX20210223-1245
Build 20200715-0100 DB Build V7612-284 HFDB Build HF7612-17,
Asset Management for IBM Control Desk 7.6.1.3349 Build
202012140116 DB Build V7611-01,
IBM Endpoint Manager Integration Configuration 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-01,
SLA Hold for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7530-01,
Advanced Workflow Components for IBM Control Desk 7.6.1.3349
Build ICD-PROD-498-202012140109 DB Build V7611-01,
Live Chat for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7604-01,
Instant Messaging for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7530-00,
Rational Team Concert and Rational ClearQuest Integration for
IBM Control Desk 7.6.1.3349 Build BUILD DB Build V7511-00,
IBM Maximo Asset Management Work Centers 7.6.0.4 Build
20200715-0100 DB Build V7604-119 HFDB Build HF7680-10,
Service Desk Classification Content for IBM Control Desk
7.6.1.3349 Build ICD-PROD-498-202012140109 DB Build V7511-00,
Incident Management for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-02,
IBM Endpoint Manager Integration Enablement 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-01,
Quick Configuration for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7610-02,
IBM Maximo for Service Providers 7.6.3.4 Build 20200803-2349 DB
Build V7634-10,
ChatOps Integration for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-13,
Survey Management for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7611-02,
IoT Connection Utility 7.6.0.3 Build 20200701-1409 DB Build
V7603-32,
Solution for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-02,
Instant Messaging Integration for IBM Control Desk 7.6.1.3349
Build ICD-PROD-498-202012140109 DB Build V7200-02,
Release management for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7604-01,
Search for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7610-03,
VNC for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-01,
Configuration management for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7610-02,
OSLC Support for IBM Control Desk 7.6.1.3349 Build 202012140116M
DB Build V750-06,
IBM Tpae Integration Framework 7.6.1.2 Build 20200615-2330 DB
Build V7612-11,
Service Portal for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-02,
Screen Capturer for IBM Control Desk 7.6.1.0319 Build
ICD-PROD-149-201811151250 DB Build V7530-00,
SmartCloud Provisioning and SmartCloud Orchestration Integration
7.6.1.3349 Build ICD-PROD-498-202012140109 DB Build V7511-04,
Service Request Management for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-01,
Mobile App for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-01,
Service Desk Integration MEA for IBM Control Desk 7.6.1.3349
Build ICD-PROD-498-202012140109 DB Build V7530-00,
Service Catalog for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-01,
Data Integration and Context Menu Service Configuration 7.5.0.0
Build 20090911D2 DB Build V7117-07,
Configuration items for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-01,
Change management for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-03,
IBM Tivoli Integration Composer for IBM Control Desk 7.6.1.3349
Build 202012140116 DB Build V7612-01,
Tivoli Remote Diagnostics for IBM Control Desk 7.6.1.0319 Build
ICD-PROD-149-201811151250 DB Build V7511-00,
IBM License Metric Tool logger 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-01,
Service Desk for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-01,
Common process components for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7613-03,
Self Service Center for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7611-01,
User interface widgets for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-02,
Problem Management for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7612-01,
Service Desk Everyplace for IBM Control Desk 7.6.1.3349 Build
ICD-PROD-498-202012140109 DB Build V7510-03

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* When UpdateDB is running upgrade scripts and encountering a  *
* SQL Syntax error, a null pointer exception is thrown from    *
* the DB2 code. (The syntax error is a valid part of the       *
* upgrade process.) This exception hides the actual exception  *
* UpdateDB needs to recover. This happens when the             *
* retrieveMessagesFromServerOnGetMessage flag is set when the  *
* SQL Connection is created.                                   *
****************************************************************

    



Problem conclusion


    

  • _The fix for this APAR is contained in the following maintenance
package: release\fix pack for Release 7.6.1.3 Product_

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IJ33496
    • 

  • 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-29
    • 

  • Closed date
    2021-07-16
    • 

  • Last modified date
    2021-07-16
    • 





    

  • 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:
            

            16 July 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback