cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

OpsCenter State deleted or unknown

We have a few entries in OpsCenter "All Jobs" where the State is "deleted" or "unknown".  They cannot be found in the NetBackup Master so they must stored somewhere in OpsCenter database.  They are quite old & no longer needed.  How to remove these entries?  

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

You'll need to follow the

You'll need to follow the process as described here to remove the entries https://www-secure.symantec.com/connect/forums/opscenter-deleting-master-servers-data

 

Having said that, support might have issues with you messing about in the DB.

 

Make sure you back it up before playing around.

View solution in original post

6 Replies
Highlighted

Anyone? Anyone? Bueller?  :)

Anyone? Anyone? Bueller? 

Smiley Happy

 

Highlighted

Please show an example.

Please show an example.

Highlighted

JobID Master Type State Stat

JobID	Master		Type	State	Status	Policy	Client		Start	Elapsed		End	Size	Files	Complete
172402	Hostname	Backup	Deleted	-	-	-		-	00:00:00	-	0B	0	0%
172405	Hostname	Backup	Deleted	-	-	-		-	00:00:00	-	0B	0	0%
185271	Hostname	Backup	Unknown	-	-	Hostname	Jan 15	00:00:00	-	0B	0	0%


 

Highlighted
Accepted Solution!

You'll need to follow the

You'll need to follow the process as described here to remove the entries https://www-secure.symantec.com/connect/forums/opscenter-deleting-master-servers-data

 

Having said that, support might have issues with you messing about in the DB.

 

Make sure you back it up before playing around.

View solution in original post

Highlighted

Yes, suspect it will be

Yes, suspect it will be something like that. 

Ours is running on Linux (forgot to mention that before).  And what is the schema for jobs? 

...

*edit*

found the Schema Guide - OC_Schema_Document_08May_7.6.pdf - and ran these commands. 

select * from domain_Job where id=185271
	

delete from domain_Job where id=185271	

commit

and after restart the offending entry is gone, thanks!

 

Highlighted

:)

Smiley Happy