APAR status
Closed as program error.
Error description
SIBus can not start because of missing DELIVERYDELAY_TIME column after migration from V8.5 to V9.0 with CWSIS1529E error message. sibDBUpgrade does not help to resolve the problem.
Local fix
Edit ddl generated by sibDBUpgrade.sh to change only do ADD DELIVERYDELAY_TIME column. And apply it to SIBus tables.
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server * **************************************************************** * PROBLEM DESCRIPTION: After migration from V8.5 to V9, a * * messaging engine using a datastore * * cannot start, and running the * * sibDBUpgrade tool fails. * **************************************************************** * RECOMMENDATION: * **************************************************************** V9 Introduced the deliveryDelay columns to the database schema. These would be added by the sibDBUpgrade tool, but the tool only works when upgrading from V7 or earlier as it tried to add all the updates that were added in V8 and V8.5. If those are already present, the tool will fail.
Problem conclusion
The sibDBUpgrade tool has been updated so that the version being migrated from can be specified. The fix for this APAR is targeted for inclusion in fix pack 9.0.5.12. For more information, see 'Recommended Updates for WebSphere Application Server': https://www.ibm.com/support/pages/node/715553
Temporary fix
Comments
APAR Information
APAR number
PH42891
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-12-16
Closed date
2022-06-06
Last modified date
2022-06-06
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
WEBS APP SERV N
Fixed component ID
5724H8800
Applicable component levels
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0"}]
Document Information
Modified date:
07 June 2022