"Reset the Data Warehouse" Running for very long time

Bharath Raghupathi-Oracle

Summary:

Hi All,

We tried the "Reset the Data Warehouse" option in FAW and this is running for very long time 12+ hours. We are getting this banner after that.

Any inputs on how long it should take to complete this ?

Thanks,

Bharath

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Nupur Joshi-Oracle

Hi Bharath ,

Please raise a service request for this issue. So that appropriate statistics can be checked and it can be resolved.

Regards,

Nupur

Bharath Raghupathi-Oracle

Thanks @Nupur Joshi-Oracle .

Bharath Raghupathi-Oracle

To update this thread, "Reset the Data Warehouse" completed after running for approx 24 hours.

Thanks,

Bharath

Krithika Raghavan-Oracle

Thanks for the update. Going forth, please raise an SR if you encounter this problem again

DAB

As basis of comparison I just reset our data warehouse and it took 5hr 33mins. I don't know what the time is dependent upon or how long it is expected to take on average but just figured I'd post it here in case other people are interested.