ODS and Datamart DB Reset CCA 7.1

[mdewhurstuk@gmail.com]

We have a problem where someone connected another version of CCA to our DEV environment and now the ETL is givining errors everywhere about unique constraints and missing tables.

I think two different ETLs were processing the DB at the same time. 

Luckily its a dev environment so we will just flush all data and create the DS Layouts from scratch. We dont mind about the lost data.

My question is without having to re-install the whole CCA process is there a quick way to get DataSourcer to run from a fresh ? I had a look a the ODS and DataMart DB to see if i could delete some reference to the old data but not sure.

[mdewhurstuk@gmail.com]

To be clear the ODS works fine and DataSourcer is collectioning stats ok.

So its just the ETL. So how do i get the ETL to ignore the checks and run as a fresh?

[Adam G.]

Just drop the Datamart and rerun the DB creation scripts and reconnect in ETL Assistant. An hour tops.

[mdewhurstuk@gmail.com]

Yeah tks i did that in the end.

Was just trying to find a lazy way todo it ;-)

e.g change on  table and it fools ETL into thinking its running for the first time.

Cheers anyway