Question
Issue with TIMESTAMP(6) WITH LOCAL TIME ZONE
On Pega 7.2.2, when browsing 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 querying the data error message is displayed.
Error: Database column CREATED_DATE in database XYZOracle, table null has an unknown type:
Type: WARN
Details:
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Changing the Date type to timestamp(6) will work. In this case, the external DB team defined it with an extension (With Local Time Zone) and we are getting this error when we access any data in these table.
I would like to know if it is feasible in Pega to accommodate/rectify this Warn.
Hi Santosh,
Do let us know if you wish to file a Pega product enhancement request. We, moderators, could file one for you on our internal portal. However, you would need to follow-up on next actions by talking to your Pega Account Executive.
Regards,
Hi Lochan_DV,
As suggested in above replies , even though the database column uses TIMESTAMP(6) still at pega end we are getting an exception while interacting with the table to get data. can you please raise an request to get it resolved or any suggestions pega team provides.
Hi Lochan_DV,
As suggested in above replies , even though the database column uses TIMESTAMP(6) still at pega end we are getting an exception while interacting with the table to get data. can you please raise an request to get it resolved or any suggestions pega team provides.
| Type | com.pega.pegarules.pub.database.BadTableMappingException | |
| Message | Database column <unknown> in database orp_ratings, table <unknown> has an unknown type: JDBC Type: DateFrom: (HC24FB11D40DABC5F37FB5C91CEA7AD19:ftc-vdi07d00902.ad.moodys.net) |