One of the QV Task is running longer than its average time

[anandsai4u]

Hi ,

One of the QV Task is running longer than its average time.

Usually the task will complete around 1 hour but now its taking time around 3 hours.

Thanks & Regards

Anand Sai

[#2]

hi,

generate log file, and check at which step its taking more time.

sometime due to some function like inner join/interval function its effect.

i have faced this problem then i updated my Windows server ,the problem automatically solved.

Regards

Vimlesh

[anandsai4u]

Hi Vimlesh,

I observed in Log File, the step which was taking more time is  "Reloading and as well as it displayed information  "Slow down logging. Log every <900> seconds" "

Thanks & Regards

Anand

[#4]

hello,

go to qlikview application and qlik -properties-then document properties-general- tick at generate log file.

and then observe at which place its stuck (Document Log)

[ashfaq_haseeb]

Hi,

It could happen,

If some of the indexes were removed from your table.

Can you confirm the same from your DBA?

Regards

ASHFAQ

[its_anandrjs]

Hi,

Some of the questions for check this.

1. Are you use the complex joins in the script part or the model.

2. Did your data model create the synthetic keys and the synthetic tables.

3. Many SQL ODBC or OLE DB connection you use.

Note:- Better way is you can use the QVDs in the application in different stage if there is the joins available.

Regards

Anand

[anandsai4u]

Hi Vimlesh,

Data is coming from SAP and observed in log file total around 16808 lines fetched.

If around 16808 lines means it will take long time ...?

Thanks & Regards

Anand Sai

[anandsai4u]

Data is coming from SAP and observed in log file total around 16808 lines fetched.

If around 16808 lines means it will take long time ...?

Thanks & Regards

Anand Sai

[#9]

hello,

if you are fetching data from SAP when the user uses SAP (that time your fetching of data will be slow down because uses also hit the database.)

but if you are fetching data at night when Database free means no insertion/deletion in database that time your fetching will be fast.

there is no much difference (depend upon table).

i have told you to create qlikview log file. can you generate it (in which your script will be comming).

Regards

Vimlesh

[simsondevadoss]

Its due to the connectivity between Qlikview server and database