Qlik Replicate - V$TIMEZONE_NAMES

[lqthinguyen]

Good evening

Qlik Replicate task stopped and the following message was logged "Timezone Region id 4162 is not found in Oracle V$TIMEZONE_NAMES view"; meanwhile 20minutes the task would resume back to normal but then it has happened numerous time over the course of the last 2 days

Thank you

Theresa

[john_wang]

Hello Theresa Nguyen, @lqthinguyen 

Please allow me some time, I will do some researching and get back to you shortly.

BTW, seems you opened a similar article, Qlik Replicate -. Let's focus on this article.

Regards,

John.

[john_wang]

Hello Theresa Nguyen, @lqthinguyen 

The V$TIMEZONE_NAMES view in Oracle provides a list of all the time zone names that are supported by the Oracle database. This view is particularly useful when we need to work with time zones in your database operations. However, the inaccessibility of this view should not prevent a task from running. You can verify access by connecting to the Oracle server via SQL*Plus using the same account as the one configured for the Oracle endpoint, and executing the following query:

SELECT DISTINCT TZNAME FROM V$TIMEZONE_NAMES;

If you require assistance, please open a support ticket and attach the diagnostic packages. Our support team will be more than happy to assist you.

Regards,

John.

[lqthinguyen]

Good morning Mr. Wang,

I did precisely that "SELECT DISTINCT TZNAME FROM V$TIMEZONE_NAMES;" and quite aware what the purpose of V$TIMEZONE_NAMES

Meanwhile if you notice that the error message was looking for a "numeric" value not a "character" furthermore the Replicate task stopped and resumed about 20mns later in which this frequency is more than once or twice.

Thank you

[john_wang]

Hello Theresa Nguyen, @lqthinguyen ,

Thanks for the update. You are right, the error messages contains a "numeric" value however it seems we never see it before, and I cannot find any related information about it from our knowledge database, this is a pretty rare error message, that's why I'd like to suggest opening a support ticket. We need to check the task settings and task log files to understand the root cause.

thanks,

John.

[lqthinguyen]

Good morning Mr. Wang,

Thank you, sir

I appreciate if you please provide the link to compose a Qlik Replicate support ticket.

Regards

Theresa

[john_wang]

Hello Theresa Nguyen, @lqthinguyen ,

In below link you may get help from LiveChat, and you may open support ticket by yourself, or by LiveChat Agent help to new a ticket.

https://community.qlik.com/t5/Support/ct-p/qlikSupport

More detailed information can be found at How to contact Qlik Support.

Hope this helps.

John.

[Dana_Baldwin]

Hi @lqthinguyen 

What is the full version number of the Oracle database and Oracle client on the Replicate server being used?

I've seen issues where using the version 12 client with version 19 server can cause issues as the time zone files may not match.

Thanks,

Dana