Hi,
I'm creating a mega project, and i'm using 3 tiers architecture, meaning, the data will be loaded into QVD by different QVW.
For the loading of the QVW, i don't want to use publisher to schedule them because it's just too many of them, and hard to maintain.
So i use the idea of BW process chain logic, and created something similar for QV.
There's a main dashboard, to monitor the load of each QVW, it will tell if it's sussccesfful or fail or when was it last run, etc.
and each QVW, we use batch file to trigger the qv process to execute the qvw in background,
and it has the ability to do daily load, weekly, monthly, or monthly on a specific date, works like wonder.
BUT sometimes it run and sometimes it doesn't, and i'm not really sure what is the error, although i can get it from the system log, but it didn't tell much.
and if i kill all the processes and did a manual trigger, it works, this solution by batch is really hard to troubleshoot.
has anyone of you done anything like this? maybe not the batch approach?
Please share .... Thx.
but that's great news!