Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, Qlikers!
I have to generate 8 different reports with a loop in a field of my connection (qvw app).
My problem is that this process takes more than 3 hours and fails. My report type is HTML and the size of my qvw is 3.5 GB.
At this moment I am using a field based cycle and my logs doesn't explain the reason of failing.
Does exist a better way of doing this?
My NP version is May 2021 SR1 (Version: 21.14.4.0).
Thanks.
There are many possible reasons for this.
In reality this should not take that long...so let's begin.
1. Your QVW at 3.5 gb file size can grow in memory quite a lot from there. for example depending on complexity and number of charts and other objects in the QVW it can get even as high around 35 GB in memory.
2. Do you have any triggers or other unsupported items in your QVW? ie: always one selected values, on open triggers etc.
3. Do you have a dedicated NP server/engine service account?
Resolutions:
Kind regards...
I would start with optimisation and reduction of the qvw size. There is usually room for improvement to allow for faster report generation.
i cannot comment more on that - i am assuming you are already using qvp server connection and you have sufficient resources to run this task
There are many possible reasons for this.
In reality this should not take that long...so let's begin.
1. Your QVW at 3.5 gb file size can grow in memory quite a lot from there. for example depending on complexity and number of charts and other objects in the QVW it can get even as high around 35 GB in memory.
2. Do you have any triggers or other unsupported items in your QVW? ie: always one selected values, on open triggers etc.
3. Do you have a dedicated NP server/engine service account?
Resolutions:
Kind regards...