|
Home > Archive > Voice over IP Cisco > November 2006 > Wiping ART
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Andre Beck 2006-11-14, 7:12 am |
| Hi,
I changed the dial plan rules in a certain ART installation and would
like to reapply the new classification rules to history data. Is there
a way to do so without wiping ART to force a reimport? If not, how is
this wiping supposed to be performed? Not beeing a database guy, I'm
pretty nervous about deleting anything that might essentially trash the
entire CCM installation.
TIA,
Andre.
--
The _S_anta _C_laus _O_peration
or "how to turn a complete illusion into a neverending money source"
-> Andre Beck +++ ABP-RIPE +++ IBH Prof. Dr. Horn GmbH, Dresden <-
| |
| Jason Aarons \(US\) 2006-11-14, 1:11 pm |
| A customer had the wrong cost per minute for calls, TAC said historical
data could not be changed. I know you can re-process records with
InforTel.
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Andre Beck
Sent: Tuesday, November 14, 2006 5:58 AM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] Wiping ART
Hi,
I changed the dial plan rules in a certain ART installation and would
like to reapply the new classification rules to history data. Is there
a way to do so without wiping ART to force a reimport? If not, how is
this wiping supposed to be performed? Not beeing a database guy, I'm
pretty nervous about deleting anything that might essentially trash the
entire CCM installation.
TIA,
Andre.
--
The _S_anta _C_laus _O_peration
or "how to turn a complete illusion into a neverending money source"
-> Andre Beck +++ ABP-RIPE +++ IBH Prof. Dr. Horn GmbH, Dresden <-
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
-----------------------------------------
Disclaimer:
This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the
designated addressee(s) named above only. If you are not the
intended addressee, you are hereby notified that you have received
this communication in error and that any use or reproduction of
this email or its contents is strictly prohibited and may be
unlawful. If you have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.
| |
| Wes Sisk 2006-11-14, 1:11 pm |
| In CM 5.x CAR there is a reload data option.
In CM 3.x and 4.x you have to perform manual steps. access the ART
database in SQL and run these commands:
truncate table Tbl_Load_History
truncate table Tbl_Dump_Pkid
truncate table Tbl_Error_Id_Map
truncate table Tbl_Billing_Data
truncate table Tbl_Billing_Error
truncate table Tbl_Dump_CallDetailRecord
truncate table Tbl_Dump_CallDetailRecordDiagnostic
Then restart the ART Scheduler Service from Windows Control Center
/Wes
On Nov 14, 2006, at 5:57 AM, Andre Beck wrote:
Hi,
I changed the dial plan rules in a certain ART installation and would
like to reapply the new classification rules to history data. Is there
a way to do so without wiping ART to force a reimport? If not, how is
this wiping supposed to be performed? Not beeing a database guy, I'm
pretty nervous about deleting anything that might essentially trash the
entire CCM installation.
TIA,
Andre.
--
The _S_anta _C_laus _O_peration
or "how to turn a complete illusion into a neverending money source"
-> Andre Beck +++ ABP-RIPE +++ IBH Prof. Dr. Horn GmbH, Dresden <-
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
|
|
|
|
|