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:
Encountered a result set that has a column of an unrecognized type
***Edited by Moderator Marissa to update categories***
**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.
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.
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.
Please provide details of the property type within pega, is it date or datetime? Also please confirm the database server you are running on and table structure. And provide the complete portion of the log where you see this error.
There is not enough of the error posted here to actually determine what the issue is. Please provide some details of what you are trying to do, complete error, the property type within pega, the database column type, etc.