Question
AmeriGroup
US
Last activity: 16 Oct 2018 12:03 EDT
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.
Pegasystems Inc.
US
If you change the column type to just timestamp(6) do you see the same issue? The timestamp with timezone format is not supported.
AmeriGroup
US
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.
Pegasystems Inc.
IN
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,
capgemini
IN
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) |
Pegasystems Inc.
US
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.
Pegasystems Inc.
US
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.