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

[Joe Keller]

2000-4-4a-sr9  	 17-JUL-2007
SR10 came out this week:
2000-4-4a-sr10  	21-AUG-2007
Opening a TAC...

On 8/24/07, Bichler, Jeri <jbichler at co.boulder.co.us> wrote:
>
>
>
> That is BS. TAC, and tell them to test this stuff...  When did SR9 come out
> on the site???   I get all the emails about updates....
>
>
> -----Original Message-----
> From: cisco-voip-bounces at puck.nether.net
> [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of
> Joe Keller
> Sent: Friday, August 24, 2007 9:54 AM
> To: Cisco-VoIP mailing list
> Subject: [cisco-voip] BARS fails due to SQL Server, after OS 4.4aSR9 update
>
> 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?
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip