IBM Support

IV95367: TRI3521 - BLANK DATE & TIME FIELDS BEING COUNTED BY EXCEL AFTER EXPORT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • PROBLEM:
    
    TRI3521 - Blank Date & Time fields being counted by Excel after
    export
    
    ENVIRONMENT:
    
    Platform 3.5.2.1,
    Application 10.5
    WAS Liberty (the embedded one that comes with TRIRIGA
    Application Platform 3.5.2)
    Linux / 64 bits (RHEL 7 x86_64)
    DB2 - Database Server = DB2/LINUXX8664 11.1.0
    
    STEPS TO REPRODUCE:
    
    1) Go to admin console to check build nr and version.
    
    L2 used
    http://support00.tivlab.usnv.ibm.com:24001/p352a1052/index.html
    
    Version 3521 with build nr 263324
    
    2) Go to Tab: Projects, Subtab : Capital
    
    3) Click on "Maximize" to maximize screen to all projects
    
    4) Take for example Capital id 1000930, name:test
    
    5) Click on export and open exported query ,see attached "All
    Capital Projects.xlsx"
    
    6) Open in Excel, e.g Excel 2016
    
    7) Notice once blank date fields are included they are included
    into the total count
    

Local fix

  • n/a
    

Problem summary

  • This fix not only resolved Date, Date & Time fields, but it
    also fixed Duration, Time, and System Read Only fields.
    

Problem conclusion

  • Resolved a query export to Excel issue where blank values for
    Date, Date & Time, Duration, Time, and System Read Only fields
    were not correctly resolving to blank/null on the Excel
    spreadsheet.
    This is targeted to the 1h2017 release as well as the 3.5.2.2
    release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV95367

  • Reported component name

    TRI APPLCATION

  • Reported component ID

    5725F26AB

  • Reported release

    352

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-26

  • Closed date

    2017-04-28

  • Last modified date

    2017-04-28

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

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

Modules/Macros

  • 999
    

Fix information

Applicable component levels

  • R352 PSY

       UP

[{"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":"352","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
30 March 2022