Removing file from Que

crcampbel's Avatar

crcampbel

22 Dec, 2010 01:49 PM

There is a file stuck in our que. We attempted to reboot our system, but it didn't remove the file. What are our options at this point?

Thank you!

  1. Support Staff 1 Posted by Tim on 22 Dec, 2010 02:37 PM

    Tim's Avatar

    Hi,

    Approximately how long has the file been stuck? Is it just one file or is it a folder?

    Please have your DBA execute the following SQL queries and attach the results here as files:

    select * from cxml_publishrequest_dest;
    select * from cxml_publishrequest_config;
    select * from cxml_publishrequest;
    

    Once those results have been attached here, you should be able to clear the publish queue by executing the following SQL queries in order:

    delete from cxml_publishrequest_dest;
    delete from cxml_publishrequest_config;
    update cxml_publishrequest set prevId = null, nextid = null;
    delete from cxml_publishrequest;
    

    NOTE: These queries will remove everything from the queue. If you have other jobs waiting, you may wish to take a screen shot of the publish queue before running these queries so that you can put those jobs back in the queue once it has been cleared.

    Let me know how everything goes.

    Thanks

  2. 2 Posted by crcampbel on 22 Dec, 2010 03:44 PM

    crcampbel's Avatar

    Hey Tim,

    That worked. Thanks so much!

    I spoke to Justin Klingman this morning and stop the Cascade service, reboot the database server, and restart the Cascade service. Out of curiosity would this have also worked?

    Thanks again,

    Craig

  3. Support Staff 3 Posted by Tim on 22 Dec, 2010 03:51 PM

    Tim's Avatar

    Hi Craig,

    Good deal. Restarting alone will not clear the publish queue since jobs are stored in the database. Having said that, it really depends on what caused the job to get stuck in the first place. Sometimes, jobs end up taking a long time due to other factors (network activity, other problems, etc). In some cases, a restart will correct one of these other problems which then allows the publish to finish.

    Thanks!

  4. Tim closed this discussion on 22 Dec, 2010 03:51 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac