Question

1
Replies
518
Views
AnujN348 Member since 2016 73 posts
Infosys
Posted: 3 years ago
Last activity: 3 years 3 months ago
Closed
Solved

Exception thrown by connect sql

i get the following exception in tracer on using a connect sql :

com.pega.pegarules.pub.clipboard.WrongModeException: The property .COUNT was of mode String while com.pega.pegarules.data.internal.clipboard.ClipboardPropertyStrMinFeatureImpl.getPageValue() was expecting Page mode.

The query used in connect sql is :

select COUNT (pxCommitDateTime) from XX_CPE_SR_LME_OTP
where {.pxCommitDateTime} >= to_date({.CalculationStart},'yyyy-mm-dd hh:mi:ss AM')

Can any body explain this and provide a solution ?

Low-Code App Development Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn