How to clear queued assets in Fatwire 7.0.3 staging publishing queue?

Hi,

 

We have done a publish from Fatwire 7.0.3 p5 staging server to a newly built machine.

 

Publishing went fine couple of times and now we had publishing failure last night during the mirroring stage. We now have nearly 25,000 assets in the publishing queue.

 

Is there any way to clear these assets from the publishing queue ?( Modifying the backend Oracle database tables )         -  we don't want to publish so many assets at one go .

 

 

It failed as below :

 

Content-Type: text/html; charset=UTF-8

Transfer-Encoding: chunked

Cache-Control: no-cache="set-cookie"

#errorPublish failed for approved assets (error number: -105). sendRows: Mirror failed, errno=-105