Question

1
Replies
529
Views
Close popover
Anuj Newrekar (AnujN348)
Infosys

Infosys
AU
AnujN348 Member since 2016 75 posts
Infosys
Posted: July 5, 2017
Last activity: July 6, 2017
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