topic Re: Task taking long time to Load the data in QlikView

Task taking long time to Load the data

Gautam — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

We have a Scheduled Jobs, generally, it was used to taking less than 10 min to finish, since May first week our loads are taking more than 5 hrs which is not acceptable for the users, I tried by updating the ODBC drivers and recreating system DSN, No improvement found. Can you share your thoughts on this, Can you plz let me know If I want to raise the incident to Qlikview support on the same issue how to do it.

Thanks In Advance.

Regards,

Gautam.

Re: Task taking long time to Load the data

Albert_Candelario — Tue, 28 May 2019 12:27:30 GMT

Hi,
Did you checked the document logs from when it took 10min and when it took 5h. Is loading the same amount of data? Any change in the environment?
Cheers!

Re: Task taking long time to Load the data

Gautam — Tue, 28 May 2019 12:32:40 GMT

Hi,

I did not see any changes in the environment, from 7th May onwards I see the issue.

Re: Task taking long time to Load the data

Josh_Berg_Support — Tue, 28 May 2019 12:34:47 GMT

I agree with Albert, I would compare the document logs from a time when the reload took 10 minutes to now and see where the additional time is coming from. Have there been any changes in your Qlikview environment before this reload started taking longer than expected? Have other reload tasks been affected as well? Have there been any changes in the source data?

Thanks,
Josh
Qlik Support

Re: Task taking long time to Load the data

Gautam — Tue, 28 May 2019 12:49:43 GMT

Hi,

Load time takes for all Data Sources. I have attached the log file 05/03 & 05/15. Can you plz check and let me know.

Thanks In Advance.

Re: Task taking long time to Load the data

Albert_Candelario — Tue, 28 May 2019 14:32:36 GMT

I can see the reload time is not the same. If you try to run it at the same time as before, does it also take 5h?
To check the number of rows loaded you would need to check the document log, not the task one.
Cheers!

Re: Task taking long time to Load the data

Gautam — Wed, 29 May 2019 11:05:15 GMT

Hi Albert,

we are generating the document but unfortunately not with the time stamp, log overwrites every time.

Re: Task taking long time to Load the data

martinpohl — Wed, 29 May 2019 11:09:57 GMT

On QlikView Server you can find the Script logs for each reload tasks for the last 30 days

Look at

C:\ProgramData\QlikTech\DistributionService\1\Log

there is a folder for each day, a folder for each task and the script log and the task log.

Regards