ODS and Datamart DB Reset CCA 7.1

Administration
1

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.

2

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?

1 Like
3

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

1 Like
4

Yeah tks i did that in the end.

Was just trying to find a lazy way todo it :wink:

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

Cheers anyway