Genesys CTI User Forum

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

Title: ODS and Datamart DB Reset CCA 7.1
Post by: mdewhurstuk@gmail.com on March 03, 2009, 11:43:24 AM

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, 12: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, 02: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, 07:46:52 AM

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