We are having an issue on our production site with examine and its indexing. If we delete the Examine indexes in the /App_Data/TEMP folder, our media lookups on the front end will return empty. Rebuilding the indexes in the developer section of the back office does NOT fix this either. The only way to fix this is by going and saving each individual media item one by one. Surely there has to be a better solution than this? Does anyone have any ideas why examine would not be rebuilding these indexes on rebuild?
When you try to rebuild your indexes using the back office dashboard do you see any errors in the log file? After using the rebuild tool does it report any nodes in the index?
Are you using Azure?
Hi Jeavon, there are no errors in the log file, it does report that there are nodes in the index and we are not using Azure. Optimizing the indexes works fine as well without any errors.
Let me know if there is anything that I can provide you that would give you a clue as to what it could be.
Well that is odd and I don't think it's Examine that's the problem then. Umbraco has a fallback system so if a media items isn't in Examine then it goes to the db.
Have you checked the XML integrity dashboard?
I'm still on umbraco 7.3.3 which doesn't seem to have the XML integrity dashboard. Whenever we upgrade I will be sure to check it. Thanks for the advice!
Ok, so I added the Xml integrity checker, it did say that the media xml was bad. So I clicked fix, and it just sat there and loaded. It never gave an error message and it never fixed the issue on the front end. I checked the log file and it looks like the XmlDataIntegrityController.CheckContentXmlTable() is timing out System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
We are havig the exact same issue on 7.4.2. We tried the connection timeout and that didn't seem to fix the issue. We are trying to rebuild an index set from Umbraco developer section and when running it, its seems to bust out at some point and doesn't re-index all the nodes that it should.
There are no errors and nothing we can see that would be causing this. If I go in and save each media item individually, it adds it to the index. I created a script which loops through and saves each item, have run that which has updated the index but it's not ideal.
Examine won't reindex my media
We are having an issue on our production site with examine and its indexing. If we delete the Examine indexes in the /App_Data/TEMP folder, our media lookups on the front end will return empty. Rebuilding the indexes in the developer section of the back office does NOT fix this either. The only way to fix this is by going and saving each individual media item one by one. Surely there has to be a better solution than this? Does anyone have any ideas why examine would not be rebuilding these indexes on rebuild?
When you try to rebuild your indexes using the back office dashboard do you see any errors in the log file? After using the rebuild tool does it report any nodes in the index? Are you using Azure?
Hi Jeavon, there are no errors in the log file, it does report that there are nodes in the index and we are not using Azure. Optimizing the indexes works fine as well without any errors.
Let me know if there is anything that I can provide you that would give you a clue as to what it could be.
Thanks so much!
When you say your media returns nothing, do you mean .Url properties are empty? Are when requesting on the front end still no log entries?
No it cant even find the content at all.
That is the code that I use to get my media item and it returns null until I go back to the media item in the back office and save & publish it.
Well that is odd and I don't think it's Examine that's the problem then. Umbraco has a fallback system so if a media items isn't in Examine then it goes to the db. Have you checked the XML integrity dashboard?
I'm still on umbraco 7.3.3 which doesn't seem to have the XML integrity dashboard. Whenever we upgrade I will be sure to check it. Thanks for the advice!
You will have it, likely it's registration is missing from your dashboards.config possibly missed in a upgrade.
Ok, so I added the Xml integrity checker, it did say that the media xml was bad. So I clicked fix, and it just sat there and loaded. It never gave an error message and it never fixed the issue on the front end. I checked the log file and it looks like the XmlDataIntegrityController.CheckContentXmlTable() is timing out
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed outAny clues?
Thanks!
Hmm, ok, we've added a option in Umbraco v7.4 to be able to extend that SQL command timeout value.
It's hard to know though if you upgrade and can then execute the integrity fix if it will fix your original issue....
What do you think about upgrading to v7.4?
We will upgrade at some point soon. I will let you know when we do. Thanks for all of your help!
Cool, once you've upgraded you can add
;Connection Timeout=300to your connection string and it should let the fix completeHi,
We are havig the exact same issue on 7.4.2. We tried the connection timeout and that didn't seem to fix the issue. We are trying to rebuild an index set from Umbraco developer section and when running it, its seems to bust out at some point and doesn't re-index all the nodes that it should.
There are no errors and nothing we can see that would be causing this. If I go in and save each media item individually, it adds it to the index. I created a script which loops through and saves each item, have run that which has updated the index but it's not ideal.
Any ideas?
Thanks,
Kenny
is working on a reply...