IBM Support

PI86436: EXCEPTION WITH DATE FORMAT USING ADD OR MODIFY PLANS HELPER

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:
    If an OpenPages user has Spanish locale, the Add or Modify Plans
    helper fails
    with error
    
    Exception Occured eTimeS: java.lang.IllegalArgumentException:
    Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
    
    When "Find Auditor" button is clicked.
    
    This is because the month in the date is written with a point at
    the end, for example: 17-ago.-2017.
    
    Workaround:
    Remove the point after the month manually.
    
    Prerequisites:
    OpenPages 7.3 with Solutions installed.
    
    A) Set Profile for OpenPagesAdministrator to Audit Module:
    1. Log into the OpenPages UI as OpenPagesAdministrator.
    2. Using the Navigation Bar, select Administration => Profiles.
    3. Click on the name of "OpenPages IAM 7.3.0 Master".
    4. Scroll down to "Associated Users".
    5. Click on the "Associate..." button, click the checkbox for
    OpenPagesAdministrator, and click on the Associate button.
    
    B) Create the Hierarchy:
    1. Log into the OpenPages UI as OpenPagesAdministrator.
    2. Using the Navigation Bar, select Organization => Business
    Entities.
    3. Click on the Add New button.
    4. Fill all the fields as necessary to create a Business Entity
    referenced here in this document as "Entity 1" and click on the
    Create button.
    5. In the resulting Filtered List View, enter "Entity 1" in the
    filter and hit the enter key.
    6. Click on the name of "Entity 1".
    7. Click on "Auditable Entities" in the "Related Information"
    area.
    8. Click on "Add a new Auditable Entity..." in the Actions
    drop-down.
    9. Fill all the fields as necessary to create an Auditable
    Entity referenced here in this document as "AE 1" and click on
    the Save button.
    10. In the resulting page, click on the name of "AE 1" in the
    "Auditable Entities" pane to display the details page for "AE
    1".
    11. Click on Audits in the "Related Information" area.
    12. Click on "Add a new Audit..." in the Actions drop-down.
    13. Fill all the fields as necessary to create an Audit
    referenced here in this document as "Audit 1", assign
    "OpenPagesAdministrator" as the Owner, and click on the Save
    button.
    
    C) Create an Auditor:
    1. Log into the OpenPages UI as OpenPagesAdministrator.
    2. Using the Navigation Bar, select Organization => Business
    Entities.
    3. Filter by Entity 1 and click in the link to go to its
    detail view.
    4. Click on Auditors under Associations in the left menu.
    5. Click on Add a new Auditor in the Actions drop-down.
    6. Fill all the fields as necessary to create an Auditor
    referenced here in this document as Auditor 1.
    7. Fill the field Auditor in the General section and click on
    the Save button.
    
    Steps to Reproduce:
    1. Log into the OpenPages UI as OpenPagesAdministrator.
    2. Click on OpenPagesAdministrator at the top of the form, and
    click on "My Settings".
    3. Select Spanish in the Locale drop-down.
    4. Select "Gestión de Auditorías" => "Auditorías".
    5. Filter by Audit 1 and click in the link to go to its detail
    view.
    6. In the Planes field, click on the "Add or Modify Plans" link.
    7. Click on the "Añadir nuevo" link.
    8. Check the Esperado field in Planificación section and select
    any dates. Notice the point at the end of the month in the date
    format.
    9. Click on the Encontrar auditor link. Notice the error at
    the end.
    10. Manually remove the point at the end of the month in the
    dates. Double click in the date to able the manual modification.
    11. Click on Encontrar auditor link again. Notice that there
    is no error and the auditor is listed.
    
    Expected Results:
    By default, the helper must use the proper date format.
    Also, the actual format it expects is dd-MMM-YYYY, so the error
    is misleading and suggests a format that the user cannot
    actually use.
    
    Actual Results:
    The month has a point at the end in the date format which cause
    errors.
    
    Error Message:
    Exception Occured eTimeS: java.lang.IllegalArgumentException:
    Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
    

Local fix

  • Remove the point after the month manually.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * EXCEPTION WITH DATE FORMAT USING ADD OR MODIFY PLANS       *
    * HELPER                                                       *
    ****************************************************************
    * 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

  • Dojo date formatter adds dots to abbreviated moths in some
    languages like Spanish. This was causing an issue with the Java
    date formatter. We changed format to short instead of medium and
    it worked with all the different locales.
    
    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-wats
    on-version-82-passport-advantage
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI86436

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    730

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-25

  • Closed date

    2020-06-22

  • Last modified date

    2020-06-22

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

Document Information

Modified date:
23 June 2020