Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: lekie on March 05, 2009, 05:43:41 PM

Title: icon purging
Post by: lekie on March 05, 2009, 05:43:41 PM

Dear All,

Have someone use to do puring?
I have problem about purging on icon 7.5.000.22
I try to purge data but when I do purging the store procedure as below
[b]declare @COUNT_DAYS int
set @COUNT_DAYS = 15
exec gsysPurgeIR @COUNT_DAYS[/b]
the data is not gone...but it didn't show an error anything.

In document, There are 4 procedure I have to do.
• gsysPurgeIR—Purges Interaction Records (IRs).
• gsysPurgeUDH—Purges User Data History (UDH) data
• gsysPurgeLS—Purges Agent Login Session (ALS) data
• gsysPurgeOS—Purges Outbound data

I can do just only this "gsysPurgeLS" procedure.
How can I check it? and I have to do Merge before right?
There is an icon a site.

Thank you in advance,
Lekie

Title: Re: icon puring
Post by: eugene on March 06, 2009, 12:52:49 AM

Lekie, it's pretty easy actually not sure how you'll implement yours but I scheduled mine via DBMS_JOB package to run daily as such:

gsysPurgeIR(14);
gsysPurgeUDH(14);
gsysPurgeLS(14);
gsysPurgeOS(14);

In your case, just change to 15 for 15 days.

Try running the below sql from your IDB instance and see if the purging went okay:

select * from G_LOG_MESSAGES
where appname like '%Purge%'
order by 3 desc

Yes you need to have the merging procedure ran so the old data can become valid for purging.

eugene