Author Topic: ODS and Datamart DB Reset CCA 7.1  (Read 2706 times)

Offline mdewhurstuk@gmail.com

  • Newbie
  • *
  • Posts: 26
  • Karma: 1
ODS and Datamart DB Reset CCA 7.1
« on: March 03, 2009, 08:43:24 PM »
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.


Offline mdewhurstuk@gmail.com

  • Newbie
  • *
  • Posts: 26
  • Karma: 1
Re: ODS and Datamart DB Reset CCA 7.1
« Reply #1 on: March 03, 2009, 09:19:50 PM »
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?

Offline Adam G.

  • Hero Member
  • *****
  • Posts: 552
  • Karma: 12
  • Still Gorgeous.......
Re: ODS and Datamart DB Reset CCA 7.1
« Reply #2 on: March 03, 2009, 11:25:59 PM »
Just drop the Datamart and rerun the DB creation scripts and reconnect in ETL Assistant. An hour tops.



I continue to be tortured by Genesys

Offline mdewhurstuk@gmail.com

  • Newbie
  • *
  • Posts: 26
  • Karma: 1
Re: ODS and Datamart DB Reset CCA 7.1
« Reply #3 on: March 04, 2009, 04:46:52 PM »
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