Rob Wunderlich wrote:
So the only difference I see is the order of QVD builds in step #1, correct? Can you post the script for Step #1?
If you can't post the script, examine the use of exists(), join, drop -- these are all items that could be affected by the order of things.
Thank you so much for your help. Each portion of #1 is actually a separate QVW file being loaded with many separate scripts creating many separate QVD's as its output. None of the QVD creators in step #1 have any dependencies on the others, to my knowledge. Table viewer in our dashboard looks a little like a plate of spaghetti with 27 tables in it and there are probably about 60-ish pages of load script altogether in the QVD creators.
As far as I am aware, nothing that's loaded from QVD into the database builder is dropped as a full table (just individual fields) and there are no joins or exists()'s in there, but I'll take a look and post back if I'm wrong.
Hi Holly M.
I know this is an old thread but it sounds very similar to intermittent Data Loss we are experiencing.
I've just replied to someone elses recent post here http://community.qlik.com/message/197579 which explains what we are seeing.
In short I have created a document that runs on the QV server, loads data from various tables in a SQL database, writes each result set to a QVD file, then checks the count of records that were loaded into the QVD's. Our source database isn't changing so we expect the record counts to be constant. Unfortunately we are seeing random data loss - sometimes of only a few records sometimes over a thousand.
We have tried a number of things but nothing has resolved it.
Did you manage to resolve your problem?