AnsweredAssumed Answered

Datamart Extraction job taking way too long?

Question asked by Chris_Shaffer_hcsc on Aug 23, 2010
Latest reply on Aug 23, 2010 by Chris_Shaffer_hcsc

We are upgrading from 7.5.3 to 12 (finally). One thing we are noticing is that our datamart extraction job is running on average 5-6 hours on a good day.

1) Is this normal? We were told that the newer version added improvements in the jobs because they only processed new and changed data. Since this is on a dev box, we have not had many changes.

2) When looking at the NBI_RUN_LOGS table, I see a step that says "EXTR_PCF_TTL_PROJECTS=6078" This is the step that is taking forever it looks like. Does anyone know what exactly this step means? I assume the 6078 is the number of projects it is processing or something. I think it would be nice to know what it is pulling. Perhaps we have projects that aren't set up right to leave them off the job?

Any help or advice would be greatly appreciated.