Skip to Content
0
Former Member
Nov 15, 2013 at 01:46 PM

Runtimes for Rules with Failed Data Repository

17 Views

I am working on an IS 4.1 (IS 4.1 Support Pack 1 version 14.1.1.220) for a project against an ECC source system. We have noticed excessively long run times when writing to the failed data repository (on a SQLServer DB, but we've also tried a DB2 connection) for rules that take just a couple of minutes without writing to the FDR. One example is below for a simple rule that failed 100% of records (320k rows). It took 4 mins without writing to the FDR and almost 9 hours writing just 320k records to the FDR.

If I design a similar workflow in Data Services (on the same box) and write to the same DB as the FDR from the same ECC table, I see an expected run time (like 4-6 minutes) to write the full set of 320k records.

Has anyone else noticed huge increases in runtime with the FDR? I expect some increase, but not 9 hours for that volume of records, and I don't understand why IS is taking so long when I can replicate an identical process in DS (with no bulk loading) and it takes just a few minutes?

Attachments