cancel
Showing results for 
Search instead for 
Did you mean: 

Procces Chain problem

lakshminarayanan_m
Contributor
0 Kudos

Hi all

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Lakshminarayana,

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

Subray Hegde

lakshminarayanan_m
Contributor
0 Kudos

Hi,

While process chain running whether it will use both Dialog and background process. Iam very much confused on this part.. Can any one explain this process.

Regards

MLN

Answers (1)

Answers (1)

lakshminarayanan_m
Contributor
0 Kudos

Not got a proper answer. so iam closing thread