Export to Excel (Data Only) from a portlet or Dashboard where a column includes negative numeric number causes Export fails in Clarity PPM

book

Article ID: 129882

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction


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],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:AAAA:[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:BBBB:[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:CCC:[email protected]
FROM
(
Select
12345 as A123,
(2) as AAAA,
to_CHAR(-2) as BBBB,
-1 as CCC
From Dual
)SQL
where
@[email protected]


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

Cause

This issue is caused by DE46400

Environment

Release: CODCVU9900-15.5.1-PPM SAAS-View Only Userpack for-Canadian Government Entities
Component:

Resolution

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).