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
Tags:
Published August 1, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.