Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gef Buneri on April 30, 2019, 09:02:41 AM

Title: Deleting records from genesysdatamart.object@report table.
Post by: Gef Buneri on April 30, 2019, 09:02:41 AM

Hi all,
may I delete freely records from the table in the object? the table stores any current or old object parameters, even if it's no longer existing. I was guessing about reasons why I should not manually delete them.

Any clue?


Best regards.

Title: Re: Deleting records from genesysdatamart.object@report table.
Post by: cavagnaro on April 30, 2019, 01:48:17 PM

Have you configured the pruning?
The fact that an agent doesn't work or exist doesn't entirely justify the fact to delete it. That is why is historical. Imagine you want to compare last 3 years of workload for your agents, if you delete them manually then you break the data. Another thing is to say, we will only store last 5 years of data and delete automatically the oldest information bigger than 5 years. That is what you do at ETL assistant


Enviado de meu SM-G9650 usando o Tapatalk

Title: Re: Deleting records from genesysdatamart.object@report table.
Post by: Gef Buneri on April 30, 2019, 02:39:34 PM

Nope, never configured pruning. Usually everything is fine with having old records. In one case only, a few years ago, a queue with a wrong name was created, containing an apostrophe in the name, and suddenly deleted to recreate the right one. This isolated case forces me to run queries with dedicated conditions and I was evaluating whether there was a way to correct the database. Maybe renaming the field?

Title: Re: Deleting records from genesysdatamart.object@report table.
Post by: cavagnaro on April 30, 2019, 02:43:39 PM

Why correct it? There is nothing wrong. You had an exceptional issue which was a human error. So you need to fix that item only. How could ETL know that was an error at all?



Enviado de meu SM-G9650 usando o Tapatalk

Title: Re: Deleting records from genesysdatamart.object@report table.
Post by: Gef Buneri on April 30, 2019, 02:55:58 PM

Nope Cav, abolutelly no problem with ETL. I was considering correcting it just to avoid special treatment when executing external data extraction directly from db (i.e. a web interface showing all vqs available); in the statement to populate the interface field I have to introduce an exception to exclude the "wrong" character, making the statement a bit heavier.

Title: Re: Deleting records from genesysdatamart.object@report table.
Post by: cavagnaro on April 30, 2019, 03:00:11 PM

Well no that I am aware of, I also do that, show a specific list of Queues/objects needed as there can be many of them.

Title: Re: Deleting records from genesysdatamart.object@report table.
Post by: Gef Buneri on April 30, 2019, 03:07:21 PM

Yep, I'm doing so, at the moment. Guess I'll continue to do so... :D