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:-
at com.cisco.art.controller.CtrPreGenReports.generate(CtrPreGenReports.java, Compiled Code)
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.
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.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...