IBM Support

PH34738: CANNOT EXPORT THE OBJECT IN .XLSX FORMAT, WITH THE ERROR ?THE REQUESTED OPERATION COULD NOT BE COMPLETED?

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • Description:
    When the customer created export template in .xlsx file format
    and tried to export the object, they were unable to do it, with
    the error ?The requested operation could not be completed?
    In our documentation, it says ?select the object type you want
    and click the Export icon (to export in .xls or .xlsx format).?
    https://www.ibm.com/support/knowledgecenter/SSFUEU_8.2.0/op_grc_
    admin/t_adm_fastmap_an_overview_of_the__import_process.html
    This statement gives the impression to the customer that it can
    be exported in xlsx format.
    
    Workaround:
    Export the object in .xls format first, then open the file and
    save as .xlsx file type.
    
    Prerequisites:
    
    1.	Login as OpenPagessAdministrator and change to SUI
    2.	Download Default template
    Administration > Manage System Files > Files
    % to filer to show DafaultTemplate.xls > export
    
    3.	In this example, create export template for Issue object
    Open DefaultTemplate.xls file which exported in the previous
    step and save as "SOXIssue" with .xlsx format
    4.	Change Profile to OpenPages Platform3 to import newly create
    template ?SOXIssue?
    Administration > Manage System Files > Files
    Change to Folder view and Expand "Template" and "Fastmap"
    Select "FLV" > Add New > Select SOXIssue.xlsx and click "Create"
    
    Steps to Reproduce:
    
    1.	Login as OpenPagesAdministrator and change to SUI
    2.	Remediation > Issue to show all Issue sample object and click
    export icon
    3.	Select ?All Fields? under Fields to Export and ?Issue? under
    Object Types to Export > Click ?Export
    
    4.	The error ?The requested operation could not be completed?
    
    
    Note: The below entries were found from the logs.
    org.apache.poi.poifs.filesystem.All right: The supplied data
    appears to be in the Office 2007+ XML. You are calling the part
    of POI that deals with OLE2 Office Documents. You need to call a
    different part of POI to process this data (eg XSSF instead of
    HSSF)
    
    Expected Results:
    
    The object can be exported in .xls or .xlsx format
    
    Actual Results:
    
    The object can be exported in only .xls format
    
    Error Message:
    
    The requested operation could not be completed
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * CANNOT EXPORT THE OBJECT IN .XLSX FORMAT, WITH THE ERROR     *
    * ?THE REQUESTED OPERATION COULD NOT BE COMPLETED?             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages with Watson 8.2 Fix Pack *
    * 2 (8.2.0.2). See the following document for details on       *
    * obtaining OpenPages 8.2.0.2:                                 *
    * https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
    * ck-2                                                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH34738

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    820

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-02-22

  • Closed date

    2021-04-02

  • Last modified date

    2021-04-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

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":"820"}]

Document Information

Modified date:
03 April 2021