IBM Support

PH19869: FASTMAP IMPORT FAILS DUE TO THE TRIGGER WHEN THE AMOUNT VALUES IN THE CURRENCY FIELDS OF THE LOSS IMPACT OBJECT ARE DECIMALS.

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

  • Fastmap import of Loss Impact Objects fail due to the out of the
    box trigger when the amount values in the currency fields are
    set as 0.01 and 0.02 or few other decimal values.
    If the trigger column in the fastmap spreadsheet is set to No
    then the upload is successful with the above mentioned decimal
    values otherwise fastmap spreadsheet fails to load successfully
    due to the out of the box Loss Impact trigger.
    
    
    Workaround:
    
    Set the trigger column to No but this workaround is not always
    feasible to use.
    
    Prerequisites:
    
    8.0.0.3 modules installed.
    
    1.	Configure Profile
    
    1.	Log into OpenPages as an admin user via a supported browser.
    2.	Click on user icon on the top right and switch to Standard
    UI.
    3.	Navigte to menu ? Administration > Profiles > OpenPages
    Modules 7.4.0 Master
    4.	Click on LossImpact Object
    5.	In the Object fields section, click on Include button to
    include Trigger Run column if not included already.
    
    
    2.	Create Entity Hierarchy
    
    
    1.	Log into OpenPages as an admin user via a supported browser.
    2.	Click on user icon on the top right and switch to Standard
    UI.
    3.	Set Profile for the Admin user as OpenPages Modules 7.4.0
    Master
    4.	Click on Add New button and select Business Entity.
    5.	Enter a name for Business Entity(BE) and any other mandatory
    fields and click Save.
    6.	Open the Detail View of the above BE and click on Loss Events
    under Associations menu on left side.
    7.	Click on Actions drop down and create a new Loss Event.
    
    
    3.	Create Fastmap Spreadsheet
    
    1.	Download the attached spreadsheet and modify the parent
    columns as per the above steps.
    2.	Ensure that the Trigger column is set to Y.
    3.	Set the amount fields as per spreadsheet.
    
    
    Steps to Reproduce:
    1.	Log into OpenPages as an admin user via a supported browser.
    2.	Click on user icon on the top right and switch to Standard
    UI.
    3.	Navigate to menu ? Reporting > Fastmap Import
    4.	Select the spreadsheet created using above steps and click on
    Import.
    5.	Fasmap import fails with an error as below ?
    
    
    
    Expected Results:
    
    Fastmap upload should be successful irrespective of the currency
    values entered into the currency fields.
    
    Actual Results:
    
    Fastmap upload fails due to the out of the box trigger.
    
    
    Error Message:
    
    Invalid float value error is logged in aurora log file.
    

Local fix

  • Set the trigger column to No
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * FASTMAP IMPORT FAILS DUE TO THE TRIGGER WHEN THE AMOUNT      *
    * VALUES IN THE CURRENCY FIELDS OF THE LOSS IMPACT OBJECT ARE  *
    * DECIMALS.                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages 8.2 from Passport        *
    * Advantage. See the following document for details on         *
    * obtaining OpenPages 8.2:                                     *
    * https://www.ibm.com/support/pages/downloading-ibm-openpages- *
    * watson-version-82-passport-advantage                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH19869

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-03

  • Closed date

    2020-06-18

  • Last modified date

    2020-06-18

  • 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

[{"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":"800","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 June 2020