"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.

Oracle Analytics Wizard-Oracle

Hello,

Here is a link to knowledge material on Reset Data Warehouse is Running for Long Time (Doc ID 2989382.1)