Website - Alternate Language Bleed Through Issue Resolution
From time to time, after a user publishes the SchoolDatabase folder within Sitecore, the incorrect language version can bleed through to an unintended Website language version. For example, German language may show on the English version of the Educatius website.
German language (circled in orange) showing up on the English version of the Educatius website.
This is entirely related to a connection between our Sitecore and our School Database where we manage all our school profile information.
First some background on what is happening:
- The Educatius School Database is the main repository for all school information.
- Editors update school profiles in the School Database as changes are announced by schools.
- The School Database sends one scheduled daily update to SchoolDatabase folder in Sitecore around 14:00 EST.
- In Sitecore, editors publish daily the SchoolDatabase folder to ensure the latest school information is shown live on the websites using the School Database Integration around 16:30 EST.
The issue appears to be related to the automatic push from the School Database to Sitecore and it creating a problem with the School Index in Sitecore. When users Publish the SchoolDatabase folder in Sitecore, they accidentally publish the errors in the School Index as well which then causes the incorrect language versions to show up on the wrong site. To fix this you need to take the following steps (please note, each step will take several hours for completion):
1) Reindex the educatius_school_index item found under the Indexing Manager in the Sitecore Control Panel (takes about 3-4 hours).
First access the "Control Panel" from the Sitecore Dashboard circled in green
Next access the "Indexing Manager" circled in green
In the next window check off the "educatius_school_index" and uncheck other items, then click "Rebuild" circled in green
2) Republish all Schools within the SchoolDatabase Folder, make sure you Republish with Publish Subitems and Publish Related Items check off. Do not Smart Publish (takes about 3-4 hours).
Open the "Content Editor" circled in green
Navigate the File Tree to the School Database Folder:
sitecore/Content/Global/Reusable Items/School/School Integration/School Database
Click the "Publish" tab in the Sitecore Ribbon, then click the upside triangle next to the "Publish" button, finally click "Publish Item" all circled in green.
In the next window, make sure your settings match the image above. It is especially important that you check off "Republish" and not "Smart Publish." Be sure that "Publish subitems" and "Publish related items" are also checked.
Once you complete these steps, navigate to the website in question and check the school profiles, school search and general site search to confirm everything looks as expected. Also, remember to view in a private browser or refresh your current browser instance to clear your cache.