Export to Excel (Data Only) from a portlet or Dashboard in Clarity PPM where a column includes negative numeric number causes Export fails.
Error generated is: This file cannot be opened because of errors or a Corrupt file error
The output in the log file is:
'XML ERROR in Table REASON: Bad Value'
STEPS TO REPRODUCE
1. Create an Nsql query using the following;
SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:A123:[email protected],
12345 as A123,
(2) as AAAA,
to_CHAR(-2) as BBBB,
-1 as CCC
2. Create a Grid portlet using the Query created in step 1 as the data provider and add all columns in the List Column layout section
3. Put the Portlet in a Tab on PPM => Home => Overview page and do an Export to Excel (Data Only)
EXPECTED RESULTS: Data gets exported to Excel and file opens up successfully
ACTUAL RESULTS: Excel file generated errors with message - 'This file cannot be opened because of errors' or 'Corrupt file' error
This issue is caused by DE46400
Release: CODCVU9900-15.5.1-PPM SAAS-View Only Userpack for-Canadian Government Entities
This issue is fixed in Clarity PPM 15.6
Workaround: Do an 'Export to Excel' then save the output file again as a Comma delimited (CSV).