Core Issue
Some third-party billing software (such as ISI, MDR (Avotus) Switchview, Manitoba Telecom Services Inc. (MTS), or Veramark), fails to gather the Call Detail Record (CDR) data to generate billing reports. CDR data is written to the C:\Program Files\Cisco\CallDetails\BAD directory.
After you upgrade the Cisco CallManager, the database name automatically increments (for example, from Cisco CallManager 3.0 to CallManager 3.1). Third-party CDR software may have Structured Query Language (SQL) triggers that are hard-coded to the original database name. The triggers may point to the previous database name and cause all CDR flat files to write to the bad directory on the publisher's database server.
This is a post-upgrade issue. If third-party vendor software is used and SQL triggers are imbedded in CDR, the problem of the trigger updating to the latest Cisco CallManager database is imminent. It is the responsibility of the third-party software vendor to ensure the trigger is updated.
Note: This issue applies to Cisco CallManager upgrades from 3.1 to 3.2 or 3.3. It also applies to SQL Server 7 and SQL Server 2000.
Resolution
To resolve this problem, you must edit the trigger (using a text editor) to point to the current name of the database.
Refer to the Solution section of CDRInsert Service Fails to Insert CDRs Into the SQL Server Database After a CallManager Upgrade.
For more information, refer to these Cisco bug IDs: