SQL Event Log Error after Upgrade to CCM and BARS

Unanswered Question
Feb 27th, 2008

Last night I upgraded a CCM 4.1(3) to SR6. I also updated BARS to 4.0(13). There were some problems with BARS so I ended up uninstalling it from the Master and from the Target and then reinstalling it fresh on both servers.

Since then I've been getting the following error in the event logs:

Source - SQLSERVERAGENT

Category - Job Engine

Event - 208

SQL Server Scheduled Job 'Monitor Disk Space' (0xA95C14072AD59F4AA1F111DCD488A4F4) - Status: Failed - Invoked on: 2008-02-27 02:00:02 - Message: The job failed.

The Job was invoked by Schedule 21 (Schedule 1). The last step to run was step 2 (TruncateCCMLog).

I found Bugs CSCsc55053 & CSCsg32819, but they aren't for 4.0(13). Anyone have any ideas? Thanks!

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
MikeTomasko Wed, 02/27/2008 - 10:26

Those 2 fixes are the ones listed in the bugs I referenced. I already checked both fixes and my system appears to be fine. The correct database name is listed in the scripts and Administrator is the owner of the database.

Any other ideas?

MikeTomasko Wed, 02/27/2008 - 10:35

After reading the next post down in that other thread, it said to check the CDR database too. It is showing the owner as Unknown so that may be my problem.

Does running sp_changedbowner '\administrator'

also work to set the permssions for the CDR database? Thanks!

MikeTomasko Wed, 02/27/2008 - 16:13

Can anyone confirm the command to reset the owner for the CDR database? Thanks!

Actions

This Discussion