Error 47 on Image Clean

[Moeman]

Anyone know the sql command to clear up error 47 on the image clean process?  I've searched this forum and found multiple posts about a sql command to fix the problem but no one has been nice enough to share the command.  When I look at the detailed status of the image clean job I see a ton of servers listed that have been gone for years.  It would be nice to get that cleaned up.  I hope someone can help.

Netbackup 6.5.6 running on Windows Server 2003 SP2.

[RamNagalla]

Symantec Technical support is the one who could help you on this..

please log a case with Symantec technical support.

[Moeman]

If I had Symantec technical support I would have contact them.

[Marianne]

What about the images written by these media servers? Do you need to keep the images written by these media servers?

You can use nbdecommission to properly decommission these media servers.

See http://www.symantec.com/docs/TECH125456 
and http://www.symantec.com/docs/TECH62119

as well as http://www.symantec.com/docs/TECH66237

[Andy_Welburn]

That piece of SQL is specific to each particular issue

e.g. for us the EC47 was due to several image inconsistencies & the sql provided by support was to specifically clear up these - now I doubt very much that you have exactly the same issue we did!

There *may* be other things you could do, as per Mariannes post or highlighted in my discussion for the same problem, that *may* clear this, but support may be your only option for corrective action.