Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

ART & Call Manager 3.2.2c Database Problem

We are running ART with Call Manager 3.2.2c however we have a major problem, the CDR records are being send from all our publishers and are being inserted into the CDR database just fine, however the ART database isn't getting populated.

We have tried nearly everything you can thing of - we have changed the scheduler server - stop and restarted the services - rebooted the server, all to no evail.

We have noticed however that lots of errors are being generated in the scheduler error log (ARTSchError.log) with the following:-

com.cisco.art.general.GenARTMajorException

at com.cisco.art.controller.CtrPreGenReports.generate(CtrPreGenReports.java, Compiled Code)

at com.cisco.art.scheduler.SchThread.run(SchThread.java:650)

If anyone has come across this before please tell me what you did to fix it and yes we have even tried re-installing ART.

Look forward to your replies.

Jamie

Senior Network Engineer

Priceline.com

2 REPLIES
New Member

Re: ART & Call Manager 3.2.2c Database Problem

I have seen this! It happened after an upgrade and was easily fixed by reinstalling the new version of ART that came with that version of CCM. Was yours ever working???

*** http://www.iptnetworkers.com ***

New Member

Re: ART & Call Manager 3.2.2c Database Problem

I have seen this happen before and this is how I got things working again.

Steps to reload all the CDRs again into ART:

1) go to Programs -> SQL Server -> Enterprise Manager SQL Server -> SQL Server Group -- Choose the CM server. Choose ART database.

2) Delete all the records in the following table. To delete the records, select the table, open it, and choose Delete on the SQL menu and then run the command.

delete from Tbl_Load_History

delete from Tbl_Dump_PkID

delete from Tbl_Error_Id_Map

delete from Tbl_Billing_Data

delete from Tbl_Billing_Error

delete from Tbl_Dump_CallDetailRecord

delete from Tbl_Dump_CallDetailRecordDiagnostic

3) This will force ART to get all the CDR data in the database when it next loads data.

Doing this will delete all the previously loaded records and will load all the CDR records available from the CDR database into the ART database afresh. Note that the already existing autogenerated reports will not be having the newly loaded records.

Also be sure you have the latest patch for ART installed.

Hope this help,

Matthew

84
Views
0
Helpful
2
Replies