Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Rajeshhyd
Contributor III
Contributor III
‎2021-11-18 03:02 AM

Qliktask running for long time and getting failed

Hi All,

From Last one week one task in our Qlik environment is running for longtime and getting failed. Normally it takes 30mins to complete the task suddenly its taking more than 6 hours and then getting failed.

Restarted the services.

CPU and memory utilization is normal

DB connection working fine

checked everything but still not able to figure it out what is the issue. Please help in resolving the issue.

Log:

(18/11/2021 5:46:21 PM) Information: Reloading.

(18/11/2021 5:46:22 PM) Information: Reloading..

(18/11/2021 5:46:23 PM) Information: Reloading...

(18/11/2021 5:46:24 PM) Information: Reloading....

(18/11/2021 5:46:25 PM) Information: Reloading.....

(18/11/2021 5:46:26 PM) Information: Reloading......

(18/11/2021 5:46:27 PM) Information: Reloading.......

(18/11/2021 5:46:28 PM) Information: Reloading........

(18/11/2021 5:46:29 PM) Information: Reloading.........

(18/11/2021 5:46:30 PM) Information: Reloading..........

(18/11/2021 5:46:31 PM) Information: Slow down logging. Log every <2> seconds.

(18/11/2021 5:46:31 PM) Information: Reloading

(18/11/2021 5:46:33 PM) Information: Reloading.

(18/11/2021 5:46:35 PM) Information: Reloading..

(18/11/2021 5:46:37 PM) Information: Reloading...

(18/11/2021 5:46:39 PM) Information: Reloading....

(18/11/2021 5:46:41 PM) Information: Reloading.....

(18/11/2021 5:46:43 PM) Information: Reloading......

(18/11/2021 5:46:45 PM) Information: Reloading.......

(18/11/2021 5:46:47 PM) Information: Reloading........

(18/11/2021 5:46:49 PM) Information: Reloading.........

(18/11/2021 5:46:51 PM) Information: Reloading..........

(18/11/2021 5:46:53 PM) Information: Slow down logging. Log every <10> seconds.

(18/11/2021 5:46:53 PM) Information: Reloading

(18/11/2021 5:47:03 PM) Information: Reloading.

(18/11/2021 5:47:13 PM) Information: Reloading..

(18/11/2021 5:47:23 PM) Information: Reloading...

(18/11/2021 5:47:33 PM) Information: Reloading....

(18/11/2021 5:47:43 PM) Information: Reloading.....

(18/11/2021 5:47:53 PM) Information: Reloading......

(18/11/2021 5:48:03 PM) Information: Reloading.......

(18/11/2021 5:48:13 PM) Information: Reloading........

(18/11/2021 5:48:23 PM) Information: Reloading.........

(18/11/2021 5:48:33 PM) Information: Reloading..........

(18/11/2021 5:48:43 PM) Information: Slow down logging. Log every <60> seconds.

(18/11/2021 5:48:43 PM) Information: Reloading

(18/11/2021 5:49:43 PM) Information: Reloading.

(18/11/2021 5:50:43 PM) Information: Reloading..

(18/11/2021 5:51:43 PM) Information: Reloading...

(18/11/2021 5:52:43 PM) Information: Reloading....

(18/11/2021 5:53:43 PM) Information: Reloading.....

(18/11/2021 5:54:43 PM) Information: Reloading......

(18/11/2021 5:55:43 PM) Information: Reloading.......

(18/11/2021 5:56:43 PM) Information: Reloading........

(18/11/2021 5:57:43 PM) Information: Reloading.........

(18/11/2021 5:58:43 PM) Information: Reloading..........

(18/11/2021 5:59:43 PM) Information: Slow down logging. Log every <300> seconds.

(18/11/2021 5:59:43 PM) Information: Reloading

(18/11/2021 6:04:50 PM) Information: Reloading.

(18/11/2021 6:09:59 PM) Information: Reloading..

(18/11/2021 6:15:09 PM) Information: Reloading...

(18/11/2021 6:20:23 PM) Information: Reloading....

(18/11/2021 6:25:36 PM) Information: Reloading.....

(18/11/2021 6:30:51 PM) Information: Reloading......

(18/11/2021 6:36:05 PM) Information: Reloading.......

(18/11/2021 6:41:15 PM) Information: Reloading........

(18/11/2021 6:46:25 PM) Information: Reloading.........

(18/11/2021 6:51:36 PM) Information: Reloading..........

(18/11/2021 6:56:50 PM) Information: Slow down logging. Log every <600> seconds.

(18/11/2021 6:56:50 PM) Information: Reloading

 

 

 

 

 

643 Views
0 Likes
1 Solution

Accepted Solutions
Rajeshhyd
Contributor III
Contributor III
‎2021-11-23 11:21 PM
Author

Issue is with SQL Query which was used in the Qlik Task. I did performance tuning and after that task is getting completed as expected.

When you have similar kind of problem. Do check your SQL code written in the Task.

View solution in original post

559 Views
0 Likes
2 Replies
Maria_Halley
Support
Support
‎2021-11-18 03:40 AM

@Rajeshhyd

 

What version of QlikView are you using?

 

If you look in the document log, you can see where the reload is stalling. That can give some clues on why it is happening.

 

If you don't have any document log, you can turn it on, see below

https://community.qlik.com/t5/Knowledge/How-To-Enable-QlikView-Document-Reload-Log/ta-p/1710459

 

 

 

624 Views
0 Likes
Rajeshhyd
Contributor III
Contributor III
‎2021-11-23 11:21 PM
Author

Issue is with SQL Query which was used in the Qlik Task. I did performance tuning and after that task is getting completed as expected.

When you have similar kind of problem. Do check your SQL code written in the Task.

560 Views
0 Likes