Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashok0519
Contributor
Contributor

reloading through QV Server(QMC) way slower then manual run

Hi Guys,

When im manually running a qvw on server its taking only 15 mins to complete, but im reloading the task on the same qvw on QMC its taking 5 hours to run.

Here this QVW is pointing to SQL SERVER to fetch the tables.

I appreciate your help on this issue.

Thanks

Ashok

2 Replies
maggie50
Contributor III
Contributor III

Which version of QlikView are you running?

Chip_Matejowsky
Support
Support

Hi Ashok,

1. Ensure Document Logging is enabled on the QVW file.

2. Login to the QlikView Server or Publisher box with the service account which runs the QDS service and run the reload of the QVW in QlikView Desktop

3. Compare the document log from step 2 to an existing document log from when reload run via QV Server/Pub (these should be the same measure of time)

4. Run the reload of the QVW in QlikView Desktop, but this time use the user account you typically do.

5. Compare the document log from step 4 to document log from step 2.

If the reload run using typical user account is shorter than reload using the server account, then issue is likely account prioritization on the SQL db. Would work with your DBA about getting the service account configured like the typical user account.

Hope this helps,

Chip

Sr. Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!