CCE Database Archiving Stored Procedure

[rellerbrock]

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?

[dmkirubhakar]

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

[sntt]

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,

[depaulai]

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.

[aaltvedtob]

Could you please repost?

Thanks in advance

Ole-Bjørn Aaltvedt

[mtrosales14]

Please reupload the document pls. Thanks