topic Re: Incremental refresh oracle database in Developer

Incremental refresh oracle database

Anonymous — Fri, 25 Sep 2020 22:38:05 GMT

After configuring the incremental refresh parameters, I have the following error when filtering the date field

DataSource.Error: Oracle: ORA-01882: Time zone region not found

Re: Incremental refresh oracle database

Greg_Deckler — Sat, 26 Sep 2020 00:18:43 GMT

@Anonymous Tough to say, you may have better luck on a SQL or Oracle forum:

https://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found

https://support.oracle.com/knowledge/Middleware/1478578_1.html

Re: Incremental refresh oracle database

Anonymous — Thu, 01 Oct 2020 09:42:40 GMT

Hi @Anonymous,

I think this issue should more relate to the parameters that you used in the query steps.
You need to double-check these parameter values and format to confirm they have been transformed as the general date format that oracle query recognized.

Regards,

Xiaoxin Sheng

Re: Incremental refresh oracle database

Anonymous — Thu, 01 Oct 2020 12:36:09 GMT

@Greg_Deckler Thanks your repost, i'm verify in the Oracle forum

Re: Incremental refresh oracle database

Anonymous — Thu, 01 Oct 2020 12:37:45 GMT

@Anonymous Thanks your repost, you say about the native queries?