IBM Support

LI82500: Upgrade to v10.0.4.0 IFix1 failing in data populate of task table

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

  • 2022-02-05T17:06:41.886Z upgrade:util Current version is 134 for
upgrade type : upgrade_data
2022-02-05T17:06:41.886Z upgrade:upgrade current version in db
table : 134
2022-02-05T17:06:41.887Z sql
[00000000-0000-0000-0000-000000000000] [-582392941]
getConnection
2022-02-05T17:06:41.887Z sql
[00000000-0000-0000-0000-000000000000] [-582392941]
beginTransaction: level:REPEATABLE READ, characteristic: READ
WRITE
2022-02-05T17:06:41.887Z upgrade:step current step is 235 and
target step is 241 for upgrade_type upgrade_data
2022-02-05T17:06:41.894Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT *, count(*) OVER() AS fullcount  from task
WHERE task_type != $1 and originator_name IS NULL ORDER BY
updated_at DESC LIMIT 500" get connection: 0 ms, query time: 5
ms, total completed in: 5 ms, query parameters:
["consumer_onboarding"]
2022-02-05T17:06:41.924Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 25 ms,
total completed in: 25 ms, query parameters:
["ba8b8c52-ab96-472f-a40c-6ebabf5bd0ad"]
2022-02-05T17:06:41.927Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 27 ms,
total completed in: 27 ms, query parameters:
["ba8b8c52-ab96-472f-a40c-6ebabf5bd0ad"]
2022-02-05T17:06:41.928Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 28 ms,
total completed in: 28 ms, query parameters:
["8b190e13-8080-4a78-8286-b1220fe03b2f"]
2022-02-05T17:06:41.930Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 30 ms,
total completed in: 30 ms, query parameters:
["1a5d1eba-20dd-4937-9677-2c5149d80c5e"]
2022-02-05T17:06:41.931Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 31 ms,
total completed in: 31 ms, query parameters:
["1a5d1eba-20dd-4937-9677-2c5149d80c5e"]
2022-02-05T17:06:41.933Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 32 ms,
total completed in: 32 ms, query parameters:
["1a5d1eba-20dd-4937-9677-2c5149d80c5e"]
2022-02-05T17:06:41.934Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 34 ms,
total completed in: 34 ms, query parameters:
["1a5d1eba-20dd-4937-9677-2c5149d80c5e"]
2022-02-05T17:06:41.935Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 35 ms,
total completed in: 35 ms, query parameters:
["1a5d1eba-20dd-4937-9677-2c5149d80c5e"]
2022-02-05T17:06:41.937Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 37 ms,
total completed in: 37 ms, query parameters:
["1a5d1eba-20dd-4937-9677-2c5149d80c5e"]
2022-02-05T17:06:41.939Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "SELECT first_name, last_name, username, id, url FROM
"user" WHERE id = $1" get connection: 0 ms, query time: 39 ms,
total completed in: 39 ms, query parameters:
["1a5d1eba-20dd-4937-9677-2c5149d80c5e"]
2022-02-05T17:06:41.941Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 15 ms, total
completed in: 15 ms, query parameters: ["Subscription approval
task for application 553-cpc-scomp(553-CPC-SCOMP) from consumer
organization 553-cpc(553-CPC) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Arif
Shaikh","Arif Shaikh","884f366b-c4ed-46dc-9d11-8e0ded2c85a6"]
2022-02-05T17:06:41.943Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 16 ms, total
completed in: 16 ms, query parameters: ["Subscription approval
task for application 553-cpc-xolt(553-CPC-XOLT) from consumer
organization 553-cpc(553-CPC) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Arif
Shaikh","Arif Shaikh","c00eeadc-a6c7-4099-a7e0-75144d24c64b"]
2022-02-05T17:06:41.944Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 15 ms, total
completed in: 15 ms, query parameters: ["Subscription approval
task for application 319-tpc-cac(319-TPC-CAC) from consumer
organization 319-tpc(319-TPC) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Tim
Seiss","Tim Seiss","c3eb6b47-340f-4d14-8336-4104872b5c66"]
2022-02-05T17:06:41.945Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 15 ms, total
completed in: 15 ms, query parameters: ["Subscription approval
task for application 75-prest-emopa(75-PREST-EMOPA) from
consumer organization 75-prest(75-PREST) to plan Plan-250 from
product ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Rajesh
Hiremath","Rajesh
Hiremath","1c08b01e-0719-42c4-9e47-4e4c7d1f4f35"]
2022-02-05T17:06:41.946Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 14 ms, total
completed in: 14 ms, query parameters: ["Subscription approval
task for application 75-prest-ums(75-PREST-UMS) from consumer
organization 75-prest(75-PREST) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Rajesh
Hiremath","Rajesh
Hiremath","69b2a69f-69f8-4c6c-a10b-d28821cf55b3"]
2022-02-05T17:06:41.947Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 14 ms, total
completed in: 14 ms, query parameters: ["Subscription approval
task for application 75-prest-uis(75-PREST-UIS) from consumer
organization 75-prest(75-PREST) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Rajesh
Hiremath","Rajesh
Hiremath","8848b9e6-a071-4c57-9d37-2fb2b0b3fc02"]
2022-02-05T17:06:41.948Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 14 ms, total
completed in: 14 ms, query parameters: ["Subscription approval
task for application 75-prest-uifs(75-PREST-UIFS) from consumer
organization 75-prest(75-PREST) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Rajesh
Hiremath","Rajesh
Hiremath","05da1bfc-4355-4d09-beee-cd7891f5764e"]
2022-02-05T17:06:41.950Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 14 ms, total
completed in: 14 ms, query parameters: ["Subscription approval
task for application 75-prest-osa(75-PREST-OSA) from consumer
organization 75-prest(75-PREST) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Rajesh
Hiremath","Rajesh
Hiremath","00dded10-2c71-4e1f-9d11-48f382295ffb"]
2022-02-05T17:06:41.951Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 12 ms, total
completed in: 12 ms, query parameters: ["Subscription approval
task for application 75-prest-opa(75-PREST-OPA) from consumer
organization 75-prest(75-PREST) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Rajesh
Hiremath","Rajesh
Hiremath","737502d6-30b9-4af3-ab0a-98f2c902d22d"]
2022-02-05T17:06:41.951Z sql
[00000000-0000-0000-0000-000000000000] [-582392941] sql
statement "UPDATE task SET title = $1,originator_name = $2 WHERE
id = $3" get connection: 0 ms, query time: 12 ms, total
completed in: 12 ms, query parameters: ["Subscription approval
task for application 75-prest-ipwa(75-PREST-IPWA) from consumer
organization 75-prest(75-PREST) to plan Plan-250 from product
ups-enterprisesecuretokenservice:1.0.1
(UPS-EnterpriseSecureTokenService) requested by user Rajesh
Hiremath","Rajesh
Hiremath","6d34dadb-9c2f-4a5b-ad44-2ec425f0c629"]
2022-02-05T17:06:41.953Z bhendi:error unexpected error in
bhendiUtil:mapPromises: Cannot read property 'split' of
undefined
2022-02-05T17:06:41.953Z upgrade:upgrade
[00000000-0000-0000-0000-000000000000] Error while upgrading
step : 235: Cannot read property 'split' of undefined
2022-02-05T17:06:41.954Z sql
[00000000-0000-0000-0000-000000000000] [-582392941]
rollbackTransaction
2022-02-05T17:06:41.954Z sql
[00000000-0000-0000-0000-000000000000] [-582392941]
releaseConnection

Local fix

  • 



Problem summary


    

  • When there is a pending task in the task table, there is a
chance that the upgrade hit NPE and failed. Added the fix for
this so use won't hit NPE again.

    



Problem conclusion


    

  • Fixed in APIC 10.0.4.0-ifix2 (CD), APIC 10.0.5 (CD)

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    LI82500
    • 

  • Reported component name
    API CONNECT ENT
    • 

  • Reported component ID
    5725Z2201
    • 

  • Reported release
    A0X
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2022-02-10
    • 

  • Closed date
    2022-04-05
    • 

  • Last modified date
    2022-04-05
    • 





    

  • 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
    API CONNECT ENT
    • 

  • Fixed component ID
    5725Z2201
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMNED","label":"IBM API Connect"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A0X"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            06 April 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback