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.