Support Article

Data type difference with OOTB CPMFS-Work & App Work table

SA-39610

Summary



Data type difference with Out-of-the-box (OOTB) CPMFS-Work & Application work table causes issue with filter with Pega Collections 7.22.

Error Messages

Union not applied because property:pxCreateDateTime in class[PegaCPMFS-Work,MGL-CAF-ESP-Work] tables are of different types[DATE,TIMESTAMP]


Steps to Reproduce



Run a report definition on the custom interaction class XXXX-Work-Interaction.


Root Cause



Table column "pxCreateDateTime" data type of OOTB CPMFS-Work table and Application work table is different.

Resolution



Refer to the below PDN article and alter the field data type:

https://pdn.pega.com/release-note/support-oracle-timestamp-data-types

Published June 19, 2017 - Updated August 1, 2017


0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.