I am having trouble with publishing queue, getting query timeout error. I am also trying to read publish transactions using following code but getting same error.
var filter = new PublishTransactionsFilterData();
filter.StartDate = DateTime.Today.AddSeconds(-10);
filter.EndDate = DateTime.Now;
filter.PublishTransactionState = PublishTransactionState.Success;
var publishTransactions = client.GetSystemWideListXml(filter);
If I try to get "Failed" items it works. Seems my filter is not taking start date and end date into account. Where are these publish transactions stored in the database?
update
The following is the error:
(80040E31) Query timeout expired Unable to get list of publishing queue items. SQLUtilities.OpenRecordsetByStoredProcedure SystemDAL.GetListData SystemBLST.lObjListPublishTransactions SystemBLST.IBLSystemST_GetListData ManagementInfo.GetListPublishQueue