3

I am getting following error in Publishing queue but publishing working fine.

(80040E31) Query timeout expired Unable to get list of publishing queue items.SQLUtilities.OpenRecordsetByStoredProcedure SystemDAL.GetListData SystemBLST.lObjListPublishTransactions SystemBLST.IBLSystemST_GetListData ManagementInfo.GetListPublishQueue

I am running publisher service in debug mode and writing all output to a text file, interestingly log file writing wrong time. Time on server is correct, timezone in Tridion CMS is correct. I have restarted the server as well but still having wrong time in publisher log. I believe this wrong time is the issue why publishing queue is not showing transactions.

It was working well before but having this issue since yesterday.

Improve this question
3
  • Can you edit your question and its title; is it regarding the timestamp or the error? Are you assuming one is correlated to the other?
    – Nickoli Roussakov
    Dec 19, 2013 at 2:37
  • I believe time is not correct in CMS and publishing queue trying to load transactions with wrong time and get stuck somewhere and gets timeout error.
    – Ali
    Dec 19, 2013 at 4:07
  • Can anybody help on this?
    – Ali
    Jan 3, 2014 at 1:32

1 Answer 1

Reset to default
4

This error is caused by your publish queue timing out.

Here's some of the steps i'd take to resolve this:

  • Purge the list of items in the queue, either using filtering in the GUI and deleting smaller groups, or using the purge tool to wipe it.
  • Increase the time outs in the SDL Tridion Configuration Manager snap-in
  • Ensure you have the latest software rollup for SDL Tridion 2011
Improve this answer
3
  • Why is the timestamp in the log showing the wrong time?
    – Nickoli Roussakov
    Dec 19, 2013 at 2:34
  • time on tridion server is 02:09 PM and I published a page and got following line in publisher log file.04:09:32.0448 <11668> Receiving deployment feedback for publish transaction [tcm:0-13406-66560] with status: Success. Other logging file like cd_core has correct time.
    – Ali
    Dec 19, 2013 at 4:11
  • I did run purge tool and it got finished without any error, If I open the "PUBLISH_TRANSACTIONS" table from the database i have only 1083 rows.
    – Ali
    Dec 19, 2013 at 4:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.