Fixes are available
APAR status
Closed as program error.
Error description
Username data in the TASKS view for PDW on Oracle is null due to incorrect choice of casting syntax for comparing two columns.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of BPM Express, Standard, and * * Advanced * **************************************************************** * PROBLEM DESCRIPTION: Username data in the TASKS view for PDW * * on Oracle is null due to improper * * choice of casting syntax for comparing * * two * * columns. * **************************************************************** * RECOMMENDATION: * **************************************************************** SQL syntax used in creation of the TASKS view (available in the PDW database) leads to null username values for all rows due to improper cast on Oracle.
Problem conclusion
Modified the SQL syntax to use the correct cast for the two data columns being compared. Install/Dependency information is available in the readme.txt on FixCentral. When the user goes to the download files page in FixCentral, the readme will be available with the fix package as a separate download.
Temporary fix
Comments
APAR Information
APAR number
JR47749
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-09-10
Closed date
2013-11-12
Last modified date
2013-11-12
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
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R750 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
07 January 2022