IBM Support

PH27139: GRID VIEW DECIMAL VALUES USED IN COLOR RANGE NOT RETAINED AFTER PUBLISH

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

  • Description:
    
    When a client creates a grid view which includes a decimal field
    and a color range is applied on that decimal field, if decimal
    values are used in the color range they are not retained after
    the view is published.  The decimal values in the color range
    are rounded to the nearest whole number.
    
    Prerequisites:
    
    OpenPages 8.1.0.1 or OpenPages 8.2
    For this example we will use SOXTask/Action Item, but this
    behavior would happen for any/all object types.
    
    1.	Log on to OpenPages as the Administrator
    2.	Create a decimal field
    a.	Switch to the standard UI
    b.	Navigate to Administration -> Object Types
    c.	Select SOXTask
    d.	Select a field group (for this example we selected OPSS-AI)
    e.	Click ?Add? next to ?Field Definitions?
    f.	Provide a name, date type = decimal
    g.	Enable System Admin Mode
    h.	Click ?Create?
    i.	Disable System Admin Mode
    3.	Add the new field to the profile
    a.	Navigate to Administration -> Profiles
    b.	Select the profile the administrator is part of
    c.	Select SOXTask from ?Object Types?
    d.	Next to ?Object Fields? click ?Include?
    e.	Select your new decimal field and click ?Include?
    4.	Create a Grid View
    a.	Navigate back to the Task Focused UI
    b.	Click on the ?Settings? (gear) icon and choose ?Manage Views?
    c.	Click on ?Add New?
    d.	Check ?Use as Default View for this object type for all
    profiles?
    e.	Object Type = Action Item
    f.	Provide a name
    g.	Type = Grid
    h.	Click ?Add?
    i.	Add some fields to the ?Default? section, including the
    decimal value created earlier
    j.	Click on the decimal field
    k.	Set the color ranges to include a decimal field (for example
    -infinity to 1.25 and 1.25 to infinity)
    l.	Click ?Done?
    m.	Click ?Publish?
    5.	Close any open ?tabs?
    
    Steps to Reproduce:
    
    1.	Check the color range values in the view
    a.	Click on the ?settings? (gear) icon and select ?Manage Views?
    b.	Click on your newly created view
    c.	Click on the decimal value to display the flyover window
    d.	Note the Color Range values have changed to -infinity to 1.00
    and 1.00 to infinity
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    *  GRID VIEW DECIMAL VALUES USED IN COLOR RANGE NOT RETAINED   *
    * AFTER PUBLISH                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages with Watson 8.2 Fix Pack *
    * 1 (8.2.0.1). See the following document for details on       *
    * obtaining OpenPages 8.2.0.1:                                 *
    * https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
    * ck-1                                                         *
    ****************************************************************
    

Problem conclusion

  • The platform was saving the value as a long instead of a float.
    We changed the data type from Long to Float, where possible,
    maintaining the original Long versions of the functions for
    backwards compatibility.
    
    Customers should download OpenPages with Watson 8.2 Fix Pack 1
    (8.2.0.1). See the following document for details on obtaining
    OpenPages 8.2.0.1:
    https://www.ibm.com/support/pages/openpages-watson-82-fix-pack-1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH27139

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-07-06

  • Closed date

    2020-11-24

  • Last modified date

    2020-11-24

  • 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

    OPENPAGES GRC

  • Fixed component ID

    5725D5100

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810"}]

Document Information

Modified date:
25 November 2020