IBM Support

JR47749: TASKS VIEW FOR PDW MISSING USERNAME DATA ON ORACLE

Subscribe

You can track all active APARs for this component.

 

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