Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Oracle Timestamp not supported in Pega 7.1.8

SA-33340

Summary



On Pega 7.1.8, when updating an external table on Oracle database with a Timestamp column: TIMESTAMP(6) WITH LOCAL TIME ZONE which is
mapped to a DateTime property
In Pega. On update of the property error message is displayed.


Error Messages



When writing to the table:

[23/01/17 11:15:26:245 GMT] 00000099 SystemOut O 2017-01-23 11:15:26,244 [ WebContainer : 0] [OpenPortal] [ FCM:01.01.01] ( internal.access.DatabaseImpl) ERROR - The deferred save failed with the following exception
com.pega.pegarules.pub.database.BadInputException: Trying to save an invalid page: Trying to save an invalid page: page is not valid
.LST_UPDT_TMSTAMP: ** LST_UPDT_TMSTAMP



When reading from the table:

[23/01/17 09:42:12:887 GMT] 00000099 SystemOut O 2017-01-23 09:42:12,886 [ WebContainer : 11] [OpenPortal] [ FCM:01.01.01] (.access.PageDatabaseMapperImpl) WARN |IP Address - Encountered a result set that has a column of an unrecognized type
[23/01/17 09:42:12:887 GMT] 00000099 SystemOut O 2017-01-23 09:42:12,886 [ WebContainer : 11] [OpenPortal] [ FCM:01.01.01] (.access.PageDatabaseMapperImpl) WARN |IP Address - database: ng3u
[23/01/17 09:42:12:887 GMT] 00000099 SystemOut O 2017-01-23 09:42:12,886 [ WebContainer : 11] [OpenPortal] [ FCM:01.01.01] (.access.PageDatabaseMapperImpl) WARN|IP Address- table: VC1.IMAGE
[23/01/17 09:42:12:887 GMT] 00000099 SystemOut O 2017-01-23 09:42:12,886 [ WebContainer : 11] [OpenPortal] [ FCM:01.01.01] (.access.PageDatabaseMapperImpl) WARN |IP Address- column: LST_UPDT_TMSTAMP


Steps to Reproduce



Attempt to write/read to the external Item table with TIMESTAMP with TIMEZONE format and the issue is not occurring with generic TIMESTAMP.

Root Cause



Not Applicable

Resolution



An enhancement request, FDBK-18224, has been created for consideration by Pega Product Management.
Suggest Edit

Published March 26, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

66% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us