Clean op database with Solution Report, should it work?

Martijn Bokhove

Posted on 14/04/2014 14:20:02

Just installed the default empty database with DW version 8.4.0.17.

With the configuration of the settings, I also tried to clean up the existing data in the database.
If I try it in my own language (Dutch), it keeps running forever saying to wait a couple of minuts.
If I try it in English, the popup shows very short, after that nothing has happend.

Why doesn't it clean up?

Gr
Martijn

Replies

Jeppe Eriksson Agger

Posted on 23/04/2014 11:23:23

Hi Martijn,

The clean up does not affect content, only statistics data and logs. So if you're trying to "reset" the database to a completely empty state, this is not possible using the clean up feature under Solution Report.

That said, I do not know why the process doesn't conclude successfully with Dutch. Can you use the Sql Profiler to see if the database is even being touched?

- Jeppe

Imar Spaanjaars

Posted on 23/04/2014 13:37:26

Could it be a date issue where day and month are reversed? What happens when you try a date that is valid in both notations? E.g. with a day less than or equal to 12?

Imar

Jeppe Eriksson Agger

Posted on 25/04/2014 09:36:24

I don't think that's the case. We use the same date format there as the rest of the system; so unless dates are a problem in general, it shouldn't be a problem here either.

Martijn Bokhove

Posted on 29/04/2014 09:43:10

Hi Jeppe, Imar

If I don't change the date, it keeps loading forever.
If I change the date, it's ready real fast, without any visible result.

When 8.4.1 is out, I will try it again and also try to use the Sql Profiler.

I'll let you know if there are new findings.
Thanks for your replies.

Gr
Martijn

You must be logged in to post in the forum

Developer forum

Clean op database with Solution Report, should it work?

Replies