IBM Support

PH36059: EXPORT OF PARENT & CHILD OBJECTS GIVES OP-00002 IF FASTMAP EXPORT TEMPLATE DEFINED FOR PARENT

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 the Admin creates a FastMap export template for an object
    type and the user tries to export that object type and a child
    of the object they will get an error message.
    
    OP-00002 The requested operation could not be completed.
    
    If the user only selects to export the object type the template
    is created for there is no error and the export completes
    successfully.
    
    Prerequisites:
    
    OP 8.2.0.2
    
    NOTE:  For this example we will use the ?Mandates? and
    ?Requirements? object although this situation would occur for
    any object types.
    
    1.	Log into OpenPages as the Administrator
    2.	Create the Fastmap Export Template for Mandates
    a.	Click on the Menu -> Compliance -> Mandates
    b.	Export the Mandates
    c.	Open the file with Excel
    d.	On the ?Mandates? tab delete all rows except the header (row
    1)
    e.	On the Definition tab clear the contents
    f.	On the Definition tab enter the following values (this
    shouldn?t matter it is just an easy way to ensure that the
    template is being used)
    i.	ignoreReadOnlyWarnings = TRUE
    ii.	useSystemNames = TRUE
    iii.	disableConflictDetection = FALSE
    iv.	headerRow = 1
    g.	Save the file as Mandate-ALL-OpenPages RCM Master.xls
    i.	Mandates = Object Type
    ii.	ALL = all locates
    iii.	OpenPages RCM Master = Profile
    3.	Add the new Export Template to OpenPages
    a.	Switch to the Standard UI
    b.	Switch to OpenPages Platform 3 Profile
    c.	Navigate to Administration -> Manage System Files -> Files
    d.	Switch to ?Folder View?
    e.	Expand Templates ->FastMap
    f.	Put a check next to ?FLV? and click ?Add New?
    g.	Browse to the file saved above and select it
    h.	Click ?Create?
    
    Steps to Reproduce:
    
    1.	Log into OpenPages as rcm/rcm (this will ensure the proper
    profile for the export template is being used)
    2.	Click on Open Primary Menu -> Compliance -> Mandates
    3.	Click the ?Export? button
    4.	Select Mandate & Requirement
    5.	Click ?Export?
    6.	Note the error: OP-00002 The requested operation could not be
    completed.
    

Local fix

  • Add a worksheet for each of the child objects that the user may
    export.
    Drawback for this is that every worksheet defined in the
    template will be in the export even if the user doesn?t select
    to export that child object.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * EXPORT OF PARENT & CHILD OBJECTS GIVES OP-00002 IF FASTMAP   *
    * EXPORT TEMPLATE DEFINED FOR PARENT                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages with Watson 8.2 Fix Pack *
    * 2 (8.2.0.3). See the following document for details on       *
    * obtaining OpenPages 8.2.0.3:                                 *
    * https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
    * ck-3                                                         *
    ****************************************************************
    

Problem conclusion

  • When the template is not the default template and the sheet for
    the child object is created from scratch, there is no
    pre-existing header row. Then we make a call to shift down a
    non-existent row in order to make room for the system fields
    row. This throws an exception.  We have corrected this issue.
    
    Customers should download OpenPages with Watson 8.2 Fix Pack 2
    (8.2.0.3). See the following document for details on obtaining
    OpenPages 8.2.0.3:
    https://www.ibm.com/support/pages/openpages-watson-82-fix-pack-3
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH36059

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-04-06

  • Closed date

    2021-08-10

  • Last modified date

    2021-08-10

  • 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":"OpenPages GRC Platform"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820"}]

Document Information

Modified date:
11 August 2021