Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a straight table (has 15,000 rows) and the size of my QVW app is 17 mb. I am using that straight table on my xls attachment in nprinting. Bringing in those 8-9 columns and then dynamically creating pivot table with those columns.
I see system out of memory error always. I tried on a server with 64 GB RAM, that did not help as well. Could someone help me in this? (using version 16.9)
ok-information you gave us is just touching the surface only - we need a lot more info
since your app is so small - would you be able to share your qvw and your nsq +template files so I could replicate issue in my environment?
thanks
Lech
couple more questions:
In short to answer your question we need full detailed picture of what you are doing.
thanks
Lech
@Lech_Miszkiewicz adding reply to your questions -
Hi @sujit_nath ,
so in short - everything works when you design report and preview it, right?
based on :" does it also fail when you try to preview report? NO, can preview"
Where do you see this error then? I am asking if you see it in NPrinting log (if you do see it in log it would be good to see at which stage you see it, or when you open excel.. so where and when do you see it? )
based on: I see system out of memory error always - where do you see it? is it in nprinting or maybe there is something wrong with Excel? No, it works fine when I only have the straight table, or the feilds not dragged into pivot rows and values
really hard to help you without seeing what is happening...
apologies i did not see your second answer...
Well - since you are not able to use your data due to company policies why don't we just build a dummy.
Open qlikview -- edit script-- ctrl+Q+Q-- reload and create app which will have 1 straight table with dimensions Dim1, Dim2 and Dim3 and Measure/Expressions: Sum(Expression1)
Then use that as a source for NPrinting report. Create excel report, add table as source data and try to create pivot table.
With this dummy sample we will be able to even film it if need be...
what do you reckon?
@Lech_Miszkiewicz Initially I had a seperate QVW for the nprinting, and same issue came at times. Like 1 in 6-7 times it would go success.
I will try again to see that helps, but the data model will be the same, it will have 6-7 tables connected.
Will check and let you know. Maybe binary load the nprinting qvw. (Will let you know)
Really appreciate the effort you're putting in to help us!!
Sure @Lech_Miszkiewicz ,
Let me try that option and get back!! Thanks again.. 🙂
hi @sujit_nath
I just noticed:
"I have a few triggers, but that table is not used in nprinting...."
QVW documents with Triggers are not supported at all - regardles if they are used in NPrinitng or not! So make sure there are no triggers in QVW document.