Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: C_Genesys on June 23, 2016, 11:45:06 AM

Title: old interactions are not archived and cleaned up properly / In GENMCR and GENMCA
Post by: C_Genesys on June 23, 2016, 11:45:06 AM

The interactions older than 6 months should be archived/moved to GENMCA database and purged after 7 uyears from archived DB.


If we run the following SQL statement on GENMCR we can see the interactions from 2011
SELECT * from interaction where startdate <TO_DATE('30/APR/2015','dd/mon/yyyy') order by startdate;


! Old interactions count in GENMCR is : 5,655,621
SELECT count(*) from interaction where startdate <TO_DATE('30/APR/2015','dd/mon/yyyy');

Title: Re: old interactions are not archived and cleaned up properly / In GENMCR and GENMCA
Post by: cavagnaro on June 23, 2016, 04:23:21 PM

So?
Maybe they are still in open state. Your Strategies probably didn't ended them.

Title: Re: old interactions are not archived and cleaned up properly / In GENMCR and GENMCA
Post by: Kubig on June 24, 2016, 07:51:12 AM

All interactions within particular thread must meet following conditions:

[list]
[li]Must be stopped (attribute [UCS_DB].Interaction.Status=3)[/li]
[li]Interaction processing must be finished (attribute [UCS_DB].Interaction.EndDate must not be NULL)[/li]
[li]Interaction attribute [UCS_DB].Interaction.EndDate must be earlier (older) than the selected time limit for pruning/archiving[/li]
[/list]

Title: Re: old interactions are not archived and cleaned up properly / In GENMCR and GENMCA
Post by: cavagnaro on June 24, 2016, 01:00:58 PM

[quote author=chetanentc link=topic=9684.msg43819#msg43819 date=1466751454]
Hi,

They are already ended . What could be the the another issue ??
[/quote]
When you say they are finished you say because you business rules or because DB property. I talk, as Kubig says, about a flag on the DB. If your callflow has no control points then they won't be considered as closed.


Enviado de meu E6633 usando Tapatalk

Title: Re: old interactions are not archived and cleaned up properly / In GENMCR and GENMCA
Post by: cavagnaro on June 27, 2016, 06:43:01 PM

Need to check you strategies and see any loop around. On those interactions check which queue they are right now.

Enviado de meu E6633 usando Tapatalk

Title: Re: old interactions are not archived and cleaned up properly / In GENMCR and GENMCA
Post by: cavagnaro on June 30, 2016, 04:43:22 PM

Then check that strategy on that queue, there must be something not controlled. Check URS logs, IXN logs. You need to do your detective work there.

Enviado de meu E6633 usando Tapatalk