Question
Last activity: 28 Sep 2016 20:23 EDT
pega v 7.1.6 is not supporting oracle timestamp datatype
pega v 7.1.6 is not supporting oracle timestamp datatype, getting below error in Report definition execution, how to resolve this issue ?


Pegasystems Inc.
US
Is this your own report? Timestamp is not supported until 7.1.8. Check this link for details: https://pdn.pega.com/support-articles/report-definition-and-list-view-do-not-display-timestamp-values
You can request for HFix-10049. This should fix the report definition error for TIMESTAMP(6) on Pega 7.1.6.
Please let us know the SR if you open one to obtain HFix-10049!
This issue resolved in pega 7.1.6
Here you have solution
Task 1
Add the oracle.jdbc.J2EE13Compliant with a value of true here under custom properties in JVM
-Doracle.jdbc.J2EE13Compliant=true
Task 2.
Install hot fixs in below order
1.DL-59489
2.DL-59835
3.DL-60458
After hot fix installtion, when I include timestamp column in report defintion. getting error.
<message>caught exception java.lang.NullPointerException</message>
PegaRULES 7.10 ML6 (coreAssemblyCached_716_259_filtered)
Hi John
The Oracle's TIMESTAMP datatype is not supported in Pega 7(as stated in previous posts). This has been mentioned in the help as well.
So you will have to change the Datatype in Oracle so that you do not see this error.
Accepted Solution
This issue resolved in pega 7.1.6
Here you have solution
Task 1
Add the oracle.jdbc.J2EE13Compliant with a value of true here under custom properties in JVM
-Doracle.jdbc.J2EE13Compliant=true
Task 2.
Install hot fixs in below order
1.DL-59489
2.DL-59835
3.DL-60458
I think there was some bug reported for timestamp previously, and probably the fix was to alter the column datatype to date type.