Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: mdewhurstuk@gmail.com on July 11, 2012, 01:51:09 PM

Title: Reset ODS CCA
Post by: mdewhurstuk@gmail.com on July 11, 2012, 01:51:09 PM

Hi i am have arrived at a customer site and there production CCA installation is messed up to say the least. I want (without having to re install-reinitialize the DB) to reset the ODS to think its running first time and then create the reports from scratch.

I did it a few years ago by logging into the etl assistant and deleting the ods connecting and adding in a new one but i am not completely sure as it was so long ago. I also cant test it as they have no dev setup.

Does anyone know a easy quick win was to reset ods as to think its running first time ?

Thanks in advance

Title: Re: Reset ODS CCA
Post by: Adam G. on July 12, 2012, 07:19:52 AM

Just drop the DB and recreate it.

Pavel

Title: Re: Reset ODS CCA
Post by: JeffreyT on July 12, 2012, 11:06:51 AM

Is the current environment is still working you can also proceed as follow :
- In DMA deactive ALL layouts (but do not delete them yet)
- In ETL Assistant for each layout set the purge parameters to 0 DAY / 0 DAY (for each one of the 7 levels)
- Stop ETL_Service
- Manually run 1 or 2 ETL_Purge & ETL_Transform
  .. you may have to wait one day to perform this part
- at some point you should be able to drop the Layouts frmo DMA
Hope this helps

A quicker approach is to drop & recreate your ODS & DataMart dabases alltogether (providing the fact that you have carrefully exported your layout templates in XML format)