[cisco-voip] BARS fails due to SQL Server, after OS 4.4aSR9 update

Joe Keller joe.j.keller at gmail.com
Fri Aug 24 11:54:19 EDT 2007


CCM 4.1(3)
BARS 4.0.12
OS was 2000.4.3aSR9 updated to 2000.4.4aSR9. Update log showed no
errors. BARS fails since update.

Bars status window shows:
 [02:00:19 AM]  Dumping Ccm0302 database on x.x.x.x
 *** [02:00:24 AM]  Could not verify db backup.
 [02:00:24 AM]  Staging database dump from x.x.x.x to staging directory.
 *** [02:00:24 AM]  Failed to stage the database Ccm0302.
 *** [02:00:24 AM]  Could not backup database Ccm0302 successfully.
 [02:00:24 AM]  Staging Locales folder C:\Program
Files\Cisco\CallManager\DBInstallCSV\Products
 [02:00:26 AM] Backing up URL Services Page.
 *** [02:00:26 AM]  Failed to copy URL Services page. Couldn't find
IIS Root Directory for CCMCIP in x.x.x.x
 [02:00:26 AM]  Skipping CDR database backup on x.x.x.x.
 [
BARS trace log shows:
[02:00:24 AM]   Could not verify database backup successfully:
-2147218303    [Mic-
                rosoft][ODBC SQL Server Driver][SQL Server]Cannot open backup d-
                evice 'stiFileDump'. Device error or device off-line. See the S-
                QL Server error log for more details.
[Microsoft][ODBC SQL Serv-
                er Driver][SQL Server]VERIFY DATABASE is terminating abnormally.
                .
[02:00:24 AM]   Could not verify db backup.
[02:00:24 AM]   Moving dump to staging dir
[02:00:24 AM]   Failed to stage the database Ccm0302.
[02:00:24 AM]   Error in modBackup DB: 450    Wrong number of
arguments or invalid-
                 property assignment
[02:00:24 AM]   Could not backup database Ccm0302 successfully.
[02:00:24 AM]   Staging Locales folder C:\Program Files\Cisco\CallManager\DBIns-
                tallCSV\Products
[02:00:24 AM]   Locales Folder Created
[02:00:24 AM]   In function modStageDir
[02:00:26 AM]   Successfully backed up locales folder.
[02:00:26 AM]   The CCM database, DBNAME from registry CCM0302 and the  Connect-
                ion String registry value for DBConnection0 is CCM0302 .
[02:00:26 AM]   Inside function modGetLocalComputerName
[02:00:26 AM]   Local Computer name is CCMPUB
[02:00:26 AM]   Exiting function modGetLocalComputerName
[02:00:26 AM]   Initializing Sockets
[02:00:26 AM]   Inside function modGetIpAddress
[02:00:26 AM]   IPAddress = x.x.x.x
[02:00:26 AM]   Closing Sockets
[02:00:26 AM]   Exiting function modGetIpAddress
[02:00:26 AM]   Succesfully wrote the Publisher details to the catalog.ini file.
[02:00:26 AM]   Inside Function modExecuteQuery
[02:00:26 AM]   modExecuteQuery=http://x.x.x.x/CCMCIP/getservicesmenu.asp
[02:00:26 AM]   Backing up URL Services Page.
[02:00:26 AM]   Given URL Server: x.x.x.x
[02:00:26 AM]   Given Backup Server: x.x.x.x
[02:00:26 AM]   Inside function modVirualDir
[02:00:26 AM]   [modVirualDir]: -2147463168 Automation error
[02:00:26 AM]   Failed to copy URL Services page. Couldn't find IIS Root Direct-
                ory for CCMCIP in x.x.x.x

DBLHelper shows no problems

SQL Server error log shows the following error at 2:00:24:29:
"BackupDiskFile::OpenMedia: Backup device 'C:\Ccm0302.dmp' failed to
open. Operating system error = 32(The process cannot access the file
because it is being used by another process.)."

Any ideas?


More information about the cisco-voip mailing list