IBM Support

IV65748: EXPORT TO EXCEL ISSUES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • We have had a reported issue and have been able to document
    that a
    Tririga report is exported to Excel, data gets corrupted -
    duplicates
    are recorded where no duplicates exist and some data does not
    get
    exported.
    
    We have verified that no issue exists with the records and when
    you
    export 1 record at a time, the export works.
    
    Business impact ( BusImpact )
    Exported data cannot be used and reporting is required for daily
    operations
    

Local fix

  • The Order By is a possible workaround
    

Problem summary

  • When creating reports in Report manager, it may be necessary to
    add an Order By column so it is easier to track down any
    duplicates that may show in the export to excel report. We also
    suggest adding the sys record id to the report to validate that
    the duplicates in export to excel are true duplicates, or are
    caused by multiple associations.
    

Problem conclusion

  • Adding an Order By to the report resolved the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV65748

  • Reported component name

    TRI APP PLTFM R

  • Reported component ID

    5725F26RE

  • Reported release

    331

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-10

  • Closed date

    2014-11-13

  • Last modified date

    2014-11-13

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"331","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
30 March 2022