cancel
Showing results for 
Search instead for 
Did you mean: 

OpsCenter State deleted or unknown

Will_Restore
Level 6

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 ACCEPTED SOLUTION

Accepted Solutions

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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 6

Will_Restore
Level 6

Anyone? Anyone? Bueller? 

:)

 

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Please show an example.

Will_Restore
Level 6
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%


 

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

Will_Restore
Level 6

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!

 

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

:)