Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: mdewhurstuk@gmail.com on March 03, 2009, 08:43:24 PM

Title: ODS and Datamart DB Reset CCA 7.1
Post by: mdewhurstuk@gmail.com 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.

Title: Re: ODS and Datamart DB Reset CCA 7.1
Post by: mdewhurstuk@gmail.com 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?
Title: Re: ODS and Datamart DB Reset CCA 7.1
Post by: Adam G. 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.



Title: Re: ODS and Datamart DB Reset CCA 7.1
Post by: mdewhurstuk@gmail.com 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