Unable to get list of publishing queue items. Timeout expired

Question

I am on Tridion 2009 SP1. At one point the ability to view the publishing queue for all users (i.e. not filters) just stopped working. In the CM GUI a timeout error is received: ``` (80040E31) Timeout expired Unable to get list of publishing queue items. SQLUtilities.OpenRecordsetByStoredProcedure SystemDAL.GetListData SystemBLST.lObjListPublishTransactions SystemBLST.IBLSystemST_GetListData ManagementInfo.GetListPublishQueue Request.GetList ``` So I tried using the Publication Queue Manager Powertool to clean up the queue, but that just throws a 500 error, which is consistent with having too many items in the queue. Then I tried purging the queue using the Tridion Purge Tool, but it crunches for a few seconds and returns the same error: ``` 14-May-2012 21:10:12 Log cleared. 14-May-2012 21:10:12 Purge action started at 14-May-2012 21:10:12 14-May-2012 21:10:12 Keeping the last 5 versions. 14-May-2012 21:10:12 Recursive mode: False 14-May-2012 21:11:12 FAILED: <?xml version="1.0"?> <tc…

Accepted Answer

There are a number of things you can try;

In code:

- Reduce the data set to maybe specific time periods (per week, per month)

- select specific stats types (failed, success etc) one by one

On the infrastructure:

- I am not sure what you are trying to do, but if you are just removing transactions, maybe just use the purge tool (but then as you are coding I am assuming it is not clever enough for your use case)

- Use the purge tool to remove older transactions that are irrelevant to your usecase

- Ensure the database is fully optimized

- (as mentioned) increase the time outs in the Tridion Configuration snap-in

- Ensure you have the latest patches for your version of Tridion (there were a number of changes in performance of the queues for both 2009 GA and SP1

- In general ensure the hardware is performing

Unable to get list of publishing queue items. Timeout expired

Solution

Problem