Skip to main content
ALWOSABY
ALWOSABY
Gold ⭐️
April 1, 2024
Solved

ORA-01882: timezone region not found

When try to use ExecuteSQL 1.25.0  to query  data from oracle 11g  , we received the below errors  can you guide me please , we have Apache NiFi in docker .

Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

ALWOSABY_0-1711966324048.png

 

 

    MattWho
    MattWhoAnswer
    Titanium ⭐️⭐️⭐️
    April 1, 2024

    @ALWOSABY 

    This looks related to the driver version you may be using in the processor.  Perhaps trying a different driver version may resolve you issue.  Perhaps try ojdbc6 version 11.1.0.7.0?

    Please help our community thrive. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

    Thank you,
    Matt

     
    View in thread

    1 reply

    MattWho
    Titanium ⭐️⭐️⭐️
    MattWhoAnswer
    Titanium ⭐️⭐️⭐️
    April 1, 2024

    @ALWOSABY 

    This looks related to the driver version you may be using in the processor.  Perhaps trying a different driver version may resolve you issue.  Perhaps try ojdbc6 version 11.1.0.7.0?

    Please help our community thrive. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

    Thank you,
    Matt

     
    Translate
      Terms & ConditionsAccessibility statement