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

ART Report 1.1(1) in CallManager 3.1(3a)

I tried to run an ART user report (any of them) for yesterday (27-Mar-03). I'm getting error code:

30023: Data is not available for the date range selected. Data is available only from 31-Aug-2002 to 26-Mar-2003.

The reports are run daily for the previous day and this is the first occurence of this. Has anyone experienced this problem or have any suggstions on where to look? Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: ART Report 1.1(1) in CallManager 3.1(3a)

In ART, can you do a CDR report for that same date range using the "CDRSearch" drop down menu? If

you can, but you can't do an ART report for that the same date range as the CDR report then you

should follow the steps below:

Steps to reload all the CDRs again in ART is:

1) Go to Programs -> SQL Server -> Ent Mgr 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 would delete all the previously loaded records and will load all

the CDR records available from the CDR database into ART database afresh

with the new settings(charge, dialplan, etc.). Note that auto generated

reports exists already will not be having the newly loaded records.

THE ART scheduler will load the new data overnight. So, run reports the next morning after you have

followed the above procedure.

2 REPLIES
Cisco Employee

Re: ART Report 1.1(1) in CallManager 3.1(3a)

In ART, can you do a CDR report for that same date range using the "CDRSearch" drop down menu? If

you can, but you can't do an ART report for that the same date range as the CDR report then you

should follow the steps below:

Steps to reload all the CDRs again in ART is:

1) Go to Programs -> SQL Server -> Ent Mgr 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 would delete all the previously loaded records and will load all

the CDR records available from the CDR database into ART database afresh

with the new settings(charge, dialplan, etc.). Note that auto generated

reports exists already will not be having the newly loaded records.

THE ART scheduler will load the new data overnight. So, run reports the next morning after you have

followed the above procedure.

New Member

Re: ART Report 1.1(1) in CallManager 3.1(3a)

That solution worked perfectly. Thank you very much for your assistance.

81
Views
0
Helpful
2
Replies
CreatePlease to create content