Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Policy based AVVI backup jobs are shown twice under Backup Calendar after upgrading from BE 2010 R3 to BE 2012 which results in email alert notification for the pre upgrade job.

Created: 20 Apr 2012 | 1 comment
DevG's picture
3
Votes
Login to vote
Me Too!I have the same issue
Product(s): Backup Exec - 2012, Backup Exec
Severity: Minor functionality
Status: Investigating/gathering information
Tech Note: More Information

Policy based AVVI backup jobs are shown twice under Backup Calendar after upgrading from BE 2010 R3 to BE 2012 which results in email alert notification for the pre upgrade job.

Pre upgrade job will also attempt to run and fail with the following error:

0xe00081d2 - The script associated with this job contained no valid selections
V-79-57344-33234 - The script associated with this job contained no valid selections

For more information please check the following article

http://www.symantec.com/docs/TECH186876

Comments 1 CommentJump to latest comment

GrandmasterPhil's picture

I made a script to fix this issue since it is not a Symantec priority.  Backup your database; and I offer to no guarantees and am not responsible - use at your own risk.

STEP 1:  Rename your existing jobs so that you can tell the old ones from the new ones in the database (use the GUI).  Stop your backup exec services.

 

STEP 2:  Run the following script to find the invalid policy in the Policy table.  Replace the Your_Job_Name text below with the name of the server that is throwing the invalid email alert and execute the query.

DECLARE @targetjob nvarchar(1000)

SET @targetjob = '%Your_Server_Name%

SELECT * FROM Policy WHERE PolicyName LIKE @targetjob

STEP 3:  Narrow down the above results until it returns a single row.  You should be able to identify the invalid row by looking at it; replace the query with more specifc text.  Once you get it down to 1 row, go to Step 4.

STEP 4:  Execute the following block with your specific job text at the top (the one you verified returns a single result.  It will delete the invalid rows. Restart the services and see if the issue is gone.

 

DECLARE @targetjob nvarchar(1000)

SET @targetjob = '%SERVERNAME Backup Policy-1-2%'

DECLARE @BEJobID uniqueidentifier

DECLARE @PolicyID uniqueidentifier

SELECT @PolicyID = PolicyID FROM Policy WHERE PolicyName LIKE @targetjob

DELETE a FROM Schedule a JOIN TaskDefinition b ON a.ScheduleID = b.ScheduleID JOIN Policy c on b.PolicyID = c.PolicyID WHERE c.PolicyID = @PolicyID

DELETE b FROM TaskDefinition b JOIN Policy c on b.PolicyID = c.PolicyID WHERE c.PolicyID = @PolicyID

DELETE FROM Policy WHERE PolicyID = @PolicyID

SELECT @BEJobID = BEJobID FROM BEJobs WHERE PolicyID = @PolicyID

DELETE FROM BeJobs WHERE BEJobID = @BEJobID

DELETE FROM Jobs WHERE BEJobID = @BeJobID

 

 

0
Login to vote