Recently one of my sites that was created using umbraco has started to behave somewhat strange. There was nothing that seem to be wrong and all the errors produced were:
No Document exists with Version ‘00000000-0000-0000-0000-000000000000’
As it turned out the problem was due to extreme delay in the SQL Server. What made me look into that was that the tree in the content area of the backend was not loading for the folder with all the articles in it.
Also it seemed that the problem might have originated because I also use DateFolders extention. Adding the index below dramatically increased the speed of the sql that runs to generate the content trees (from 32sec to less that 2sec for more than 7000 records) and it seems to resolved all my other problems as well.
/****** Object: Index [IDX_cmsDocument_nodeId_versionId] Script Date: 09/20/2011 13:13:20 ******/ CREATE NONCLUSTERED INDEX [IDX_cmsDocument_nodeId_versionId] ON [cmsDocument] ( [nodeId] ASC, [versionId] ASC ) INCLUDE ( [published]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO
