Open a new query in SQL Server Management Studio and enter
This will display a nicely formatted error log table.
I’ve recently attempted to setup a Sitecore Habitat solution by following instructions from the GitHub site.
This was not as straight forward as I’d hoped. The following are some issues I had to resolve along the way.
Web Forms For Marketers
Ensure this is installed correctly and working. Although I had installed the module and it appear to be successful, when I checked System/Modules/Web Forms for Marketers items were missing. The problem didn’t become apparent until Unicorn tried to sync items relating to WFFM.
I also discovered although it’s not mentioned in the Habitat documentation MongoDB is required for WFFM to work correctly with Habitat.
After installing NodeJS I ran npm install from the root of the Habitat repository as instructed. However this kept failing while trying to install node-sass with a 404 error. Running npm install node-sass to manually install the package before running npm install resolved the issue for me.
Editing repository files
Make sure any files you’ve been editing are not open by another application
Although the sync process should work fine through Visual Studio Task Runner. I found it more successful to run it through a command prompt using gulp.\
Even after a success npm install I received a gulp command not found error when running gulp from a command prompt. Running npm install –global gulp-cli in the repository root resolved the problem.
Sometimes you may find an item appears in both the master and web database’s. But when you navigate to that item on the live website site either a 404 returned, or in the case of a component it’s not visible.
This could be because the item has publishing restrictions in place. There’s a few places to check:
If workflow is in place it might be worth checking the Workflow selection for this item. The state field will highlight where in the workflow this item is. However if the item is’t approved it shouldn’t show in the web database.
If the above doesn’t help its worth republishing the item or its parent..
Shut down your Mac, then turn it on and immediately hold down these four keys together:
Option, Command, P, and R.
Keep holding the keys for about 20 seconds, during which your Mac might appear to restart. (If you have a Mac that plays a startup sound when you turn it on, you can release the keys after the second startup sound.)
If you receive a warning that that CSS and/or JS files are being ignored due to incorrect mime type. It could be IIS is not serving static content. Another indication is a blank content type field for static content in the IE developer tools network tab.
To resolve the issue:
Another cause is CSS and JS mime types being incorrect registered on the IIS server. To check open regedit, expand HKEY_CLASSES_ROOT, find .css and check/change the Content Type value to text/css. Repeat for .js where the Content Type value should be text/plain.
IIS 7.5+ runs application pools using an Application Pool Identity rather than NETWORK SERVICE. To allow files to be created/modified you may need to change file permissions.
1. Open Windows Explorer
2. Select a file or directory.
3. Right click the file and select “Properties”
4. Select the “Security” tab
5. Click the “Edit” and then “Add” button
6. Click the “Locations” button and make sure you select the local machine. (Not the Windows domain if the server belongs to one.)
7. Enter “IIS AppPool\DefaultAppPool” in the “Enter the object names to select:” text box. (Don’t forget to change “DefaultAppPool” here to whatever you named your application pool.)
8. Click the “Check Names” button and click “OK”.
Note: Depending on IIS configuration you may need to add permissions for the application pool itself. Repeat the above steps but change AppPool\DefaultAppPool to AppPool\MyApplicationPool where the application pool is called MyApplicationPool
I’ve recently had an issue where every 10 minuets or so a entry would appear in the Solr logs. This was only an issue for the analytics core. After reading various articles and try different Solr configurations I failed to resolve the problem.
However after a chat with Sitecore Support the issue was resolved by a quick change to our Sitecore environment. Our production environment consists of four separate Sitecore instances, two delivery, one authoring and one processing server. By default Sitecore uses a Timed Index Refresh Strategy to update Solr’s analytics core. By having four environments pointing to the same Solr instance, the analytics core was being updated four times simultaneously.
When a processing server is being used only that should update the analytics core. In an environment without a processing server it would the possibility of authoring server.
To resolve the issue the processing server was left with the default Timed Index Refresh Strategy. Automatic updating of the analytics was disabled on the remaining three environments by changing the strategy to manual.
The strategies are set in the Sitecore.ContentSearch.Solr.Index.Analytics.config file. The default is:
<strategies hint="list:AddStrategy"> <timed type="Sitecore.ContentSearch.Maintenance.Strategies.TimedIndexRefreshStrategy, Sitecore.ContentSearch"> <param desc="interval">00:01:00</param> </timed> </strategies>
To use a manual strategy remove the above from the config file and add:
<strategies hint="list:AddStrategy"> <strategy ref="contentSearch/indexConfigurations/indexUpdateStrategies/manual" /> </strategies>
Rather than updating the config file a better solution would be creating a patch file. This way if the config file is replaced during an upgrade the config change will still be applied.
The utility to delete cached credentials is hard to find. It stores both certificate data and also user passwords.
Open a command prompt, or enter the following in the run command:
Windows 7 makes this easier by creating an icon in the control panel called “Credential manager”
Even if you disable One Drive it will still show in Explorer. The following registry change will remove One Drive from Explorer