Question
Accenture
AU
Last activity: 14 Dec 2022 1:23 EST
Union not applied because property:pxCreateDateTime in class tables are of different types[DATE,TIMESTAMP]
We've been getting this error in the log file and trying to resolve it. Does anyone know which RD that causes this log error message? and how would we resolve it? The complete message is here: "Union not applied because property:pxCreateDateTime in class[PegaCA-Work,PegaCA-Work-Service-StatementCopy] tables are of different types[DATE,TIMESTAMP]"
We've been trying to find the RD from looking at the "view reference" of "pxCreateDateTime" property but since it's an OOTB property it's almost impossible to go through all the RDs that use that property
We suspect that it may be an OOTB RD that causes the error, and we'd need to modify the RD to ensure that whatever the table is using is the correct type of property.
Any suggestions are welcome thanks!