Avaya Support Forums  

Go Back   Avaya Support Forums > Contact Center Applications

Thread Tools Search this Thread Display Modes
Old 03-29-2010, 02:28 PM
rellerbrock rellerbrock is offline
Hot Shot
Join Date: Mar 2010
Posts: 10
rellerbrock has 10 reputation points
Default CCE Database Archiving Stored Procedure

Found this http://forum.avayacce.com/Topic1994-6-1.aspx on the AvayaCCE forum and it discusses a PrepareNextASMSDataDatabase stored procedure.

I haven't found any other documentation on this stored procedure. I had asked an Avaya engineer who was working on another case and he said he thought the it would cause the history to stop working in 4.1 (possible fixed in 4.1.1). We are running 4.0.1 and our ASMSData1 dattabase is pretty large (7 million records).

I wanted to know if anyone has ran this, if it will work on 4.0.1 and if it will be fixed in 4.1.1?
Reply With Quote
Old 04-01-2010, 07:31 AM
dmkirubhakar dmkirubhakar is offline
Join Date: Apr 2010
Posts: 3
dmkirubhakar has 10 reputation points

Prepare Next ASMS database stored procedure is available in CCE 4.0 onwards which means CCE 4.0.1 has the Next asms database stored procedure.

The data has to be archived for every one lakh records

I have attached a document to reconfigure new asms database in ftp.avaya.com

Location - ftp://ftp.avaya.com/131921454/

username - crmsupport1
password - guest
Reply With Quote
Old 05-30-2011, 09:15 AM
sntt sntt is offline
Aspiring Member
Join Date: May 2011
Posts: 1
sntt has 10 reputation points

Hi dmkirubhakar,
Pls re-attach the document for reconfiguring ASMSData database. We're running CCE 4.1 and the size of ASMSData1 database is very large. I'd to archive ASMSData1 database and create a new ASMSData2 database for storing.

Many thanks,
Reply With Quote
Old 05-31-2011, 02:24 PM
depaulai depaulai is offline
Aspiring Member
Join Date: May 2011
Posts: 2
depaulai has 10 reputation points
Default store procedure for 3.03

Do you have the same sp for 3.03, we are aware that this was developed as a custom solution since the application didn't have this as native.
Reply With Quote
Old 11-30-2011, 04:49 AM
aaltvedtob aaltvedtob is offline
Hot Shot
Join Date: Mar 2010
Posts: 14
aaltvedtob has 10 reputation points

Could you please repost?

Thanks in advance

Ole-Bjørn Aaltvedt
Reply With Quote
Old 02-04-2013, 06:25 PM
mtrosales14 mtrosales14 is offline
Aspiring Member
Join Date: Jan 2013
Posts: 1
mtrosales14 has 10 reputation points

Please reupload the document pls. Thanks
Reply With Quote


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. The time now is 05:50 PM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.