Forum Discussion

Will_Restore's avatar
Will_Restore
Level 6
10 years ago

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?  

Backup and Recovery
Not Applicable
OpsCenter
Tip-How to
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    10 years ago

    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's avatar
    Will_Restore
    Level 6
    10 years ago
    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's avatar
    RiaanBadenhorst
    Level 6
    10 years ago

    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's avatar
    Will_Restore
    Level 6
    10 years ago

    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!