DataWarehouse issues

We have problems with our DW in that when we look at DW status we get that the data warehouse is not configured.
We have gone through setup and it is all clear.
The logs show the issue as :-

"java.sql.SQLException: ORA-00942: table or view does not exist"

We wondered if the following would resolve?

Backup DB's
Drop / recreate DW
Rerun setup OR repotools-<all_apps> -createWarehouse

Finally, How do we find out what table or view it is upset over?

Regards

Mark.