I want to know Reason for delay in activation of ODS

[Former Member]

Hi,

I am using 3.x ver. normally ODS activation took 21 - 30 mins to activate but sometimes it took 6-8 hrs to activate.

for eg.

Yesterday it took 21 mins to activate 9,24,033 records and it added records were u201C1847245u201D but to day it took 8 hrs 13 sec to activate 877,560 records and it added u201C3507974u201D.

I checked the server also at that time server had not too much load.

This job started at 07:13 and finished at 15:26.I checked job log also.

07:13 SQL-END:22:08:2009 07:13:40:00:00:27

15:26 Activation start at 07:13:40

15:26 Activation finished at 15:26

15:26 Request.......

15:26 Request.....

15:26 Data pkgs.......

could you please help me to findout the reason for delay in activation of ODS. I am not able to findout what happened in first two lines in above job log.

Thanks,

Manish

[markus_doehr2 · Accepted solution]

What database are you using?

Markus

[Former Member]

Hi Manish,

When you want the resolution, you should have answered the quetion made by Markus Doehr, He such a qualified consultant you did care to follow up your issue.

Thank you,

Prasaad