We are using NW2004s (BI & EP) for our company management reports.
Daily morning BI-Team will run process chain for the actual business
report as of latest status. Some time this process chain get failures
due to some wrong datas.
In failure situations of process chain ,BI-team re-scheduling the
process chain in working hours around 8am in the morning and it takes
3hrs to complete , due to running of process chain all work proces
(DIALOG & BACKGROUND) are fully occupied. So end user canu2019t able to
access and view the report they are waiting for execution.
Please guide us how to overcome from this issue.
Assuming you are using 7.0 dataflow, you can use the last update option in DTPs (Valid Records Update, reporting possible - Request Green). Set the maximum number of errors per pack to a high number (say 999999). This way, even if some data is in error, it will be written to the error stack but, the error records will be written to error PSA. Then, the only task for your BI team will be to fix the bad records in the error PSA and run ERROR DTPs. This will be selective and so, the entire process chain is not stuck because of one failed load. This feature (writing to error PSA and making the request green) is also available in 3.x. Hope this helps.
Thanks and Regards