Support Article
Property with value 0 from DB saved as 0E-9 on Clipboard
SA-83768
Summary
A property has a value that is equal to zero in the database table. After executing the report definition, the corresponding property displays ‘0E-9’ in the pyReportContentPage on exporting a file to Excel using MSOGenerateExcelFile.
On the UI of the same report definition, the same property displays the value correctly (as zero).
Error Messages
Not Applicable
Steps to Reproduce
Run a report definition containing a column with zero as the value.
Root Cause
A defect in Pegasystems’ code or rules. Postgres added trailing zeroes when a property of type decimal is created. It created a column with numeric (18,9) data type. To match the scale set on numeric (18,9), the value changes to 13.950000000 (for 13.95). Similarly the value 0 is stored as 0.000000000.
Resolution
An enhancement request, FDBK-29106, is created for consideration by Pega Product Management.
As a local-change, invoke a function to convert the value from 0E-9 to 0.000000000.
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.