Question
Capgemini
IN
Last activity: 28 Aug 2017 5:41 EDT
Report Definition not fetching results as it is not able to understand a column of DB type TIMESTAMP
There are 3 date time properties which i am trying to fetch using report definition, these 3 properties have DB data type as TIMESTAMP(6) , as in attached screenshot. When i am running RD i am getting error as in screenshot. Can anyone tell me what issue might be?
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Capgemini
IN
Hi Madhuri,
Thanks for your reply.
We are using PEGA 7.1.7 version and in DB properties are of data type TIMESTAMP(7) which is causing the issue.
We got the issue resolved after we changed the data type to DATE and RD started to fetch the data.
This article from PDN was also helpful
Thanks
Abilash
Virtusa
AU
Hi Abhilash,
Currently PRPC product doesn't have support for TIMESTAMP(6) WITH LOCAL TIME ZONE or TIMESTAMP(6), etc. Only the column type "TIMESTAMP " is supported from PRPC 7.1.8 version. Can you please check if the issue is seen when the column type is "TIMESTAMP".
PFB the support article for your reference:
https://community.pega.com/support/support-articles/oracle-timestamp-not-supported-pega-718
Thank you,
Madhuri Koravadi
Accepted Solution
Capgemini
IN
Hi Madhuri,
Thanks for your reply.
We are using PEGA 7.1.7 version and in DB properties are of data type TIMESTAMP(7) which is causing the issue.
We got the issue resolved after we changed the data type to DATE and RD started to fetch the data.
This article from PDN was also helpful
Thanks
Abilash