Direct links to fixes
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