Fixes are available
IBM UrbanCode Release Fix Pack 2 (6.1.0.2) for 6.1
IBM UrbanCode Release Fix Pack 3 (6.1.0.3) for 6.1
IBM UrbanCode Release Fix Pack 4 (6.1.0.4) for 6.1
IBM UrbanCode Release Fix Pack 5 (6.1.0.5) for 6.1
IBM UrbanCode Release Fix Pack 6 (6.1.0.6) for 6.1
IBM UrbanCode Release Fix Pack 7 (6.1.0.7) for 6.1
IBM UrbanCode Release Fix Pack 8 (6.1.0.8) for 6.1
IBM UrbanCode Release Interim Fix 1 for 6.1.0.3
APAR status
Closed as program error.
Error description
When running on a DB2 database, there is an error in one of the database upgrade scripts that is applied on startup. This will cause the product to fail to start correctly.
Local fix
As a workaround, a corrected upgrade may be applied to the database manually by a user with permission to execute DDL statements. alter table tsk_task add column version2 numeric(22,0) default 0 not null; UPDATE tsk_task SET version2 = version; alter table tsk_task drop column version; alter table tsk_task rename column version2 to version; update ur_db_version set ver = 31 where release_name = '4.3';
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * Issues with DB2 on startup * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
A fix is provided in IBM UrbanCode Release 6.1.0.2
Temporary fix
Comments
APAR Information
APAR number
PI24764
Reported component name
UC RELEASE
Reported component ID
5725M5500
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-08-28
Closed date
2014-09-08
Last modified date
2014-09-08
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
UC RELEASE
Fixed component ID
5725M5500
Applicable component levels
R600 PSN
UP
R600 PSY
UP
R601 PSN
UP
R601 PSY
UP
R610 PSN
UP
R610 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS4GCC","label":"IBM UrbanCode Release"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
15 October 2021