topic Re: Qlik Replicate - V$TIMEZONE_NAMES in Qlik Replicate

Qlik Replicate - V$TIMEZONE_NAMES

lqthinguyen — Sun, 11 Aug 2024 06:01:48 GMT

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

Re: Qlik Replicate - V$TIMEZONE_NAMES

john_wang — Sun, 11 Aug 2024 09:09:00 GMT

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.

Re: Qlik Replicate - V$TIMEZONE_NAMES

john_wang — Sun, 11 Aug 2024 12:23:21 GMT

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.

Re: Qlik Replicate - V$TIMEZONE_NAMES

lqthinguyen — Sun, 11 Aug 2024 13:48:16 GMT

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

Re: Qlik Replicate - V$TIMEZONE_NAMES

john_wang — Sun, 11 Aug 2024 13:55:36 GMT

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.

Re: Qlik Replicate - V$TIMEZONE_NAMES

lqthinguyen — Sun, 11 Aug 2024 15:05:48 GMT

Good morning Mr. Wang,

Thank you, sir

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

Regards

Theresa

Re: Qlik Replicate - V$TIMEZONE_NAMES

john_wang — Sun, 11 Aug 2024 15:47:18 GMT

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.

Re: Qlik Replicate - V$TIMEZONE_NAMES

Dana_Baldwin — Wed, 14 Aug 2024 21:56:41 GMT

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