The Administration Tools within the Sitecore 9 Control Panel (Administration Section), are an often forgotten, but powerful arsenal in managing your Sitecore environment. Some of these tools, such as rebuilding the reporting database, have prerequisites. In the case of the “Rebuild Reporting Database” tool, it requires you to create a Secondary Reporting Database and connectionString …
For those that use an XP1 build of Sitecore 9, setting the proper connectionStrings is critical for xConnect communication. One of the more confusing aspects are the connectionStrings named xconnect.collection and xconnect.collection.certificate. These may require either the xConnectCollection or xConnectCollectionSearch endpoint and matching thumbprint depending on the Sitecore Role. <add name=”xconnect.collection” connectionString=”https://Sitecore_xconnect” /> <add …
Sitecore is a .NET application that leverages relational database storage in the management of its operations. These operations could be scheduled jobs, xDB or xConnect Processing, OnPublish/OnEnd events, or manually triggered events. The Event Queue Table in the Core, Master, and Web databases store this data depending on which events the database is associated with. …
If you are using Sitecore 9 with Solr, you are most likely (should) be using Solr over SSL/HTTPS. Self-Signed Certificates are an option in non-Production environments but in the following scenarios you should use a Public Certificate Authority: Production on IaaS Azure AppServices with Solr on IaaS (AppServices cannot use Self-Signed Certificates, but require a CA …
What is the Shard Map Manager Tool The Sitecore 9 SQL Shard Map Manager sharding deployment tool is designed to create your initial sharded environment that houses raw xConnect data. It’s not intended for rebalancing or reconfiguration of an environment with data. You would need to perform manual steps to reconfigure your environment. The SQL …
If you are using Redis for your Sitecore 9 Private SessionState Provider on Content Delivery Servers and follow the Sitecore documentation for Update 1 located at: https://doc.sitecore.net/sitecore_experience_platform/setting_up_and_maintaining/session_state/session_state/walkthrough_configuring_a_private_session_state_database_using_the_redis_provider, you are likely to experience the following error: StackExchange.Redis.RedisConnectionException: No connection is available to service this operation: EVAL This is because Sitecore’s documentation for the Web.config changes are …
If you have installed Sitecore 9 and attempt to pull up a Sitecore site only to find the following error: “HTTP Error 500.21 – Internal Server Error… bad module “ManagedPipelineHandler” in its module list”, it may because you are missing ASP .NET 4.6 (Sitecore 9 requires 4.6 or 4.7. Please see SIF Prerequisites for more):
To remedy this issue, install ASP.NET 4.6 from the Server Roles manager of Server 2016 or download ASP.NET 4.7
Sitecore 9 XP1 implementations establish two key Windows Services supporting xConnect (that are created as Windows Services via the SIF, but other options exist…. more on that later). These are the Sitecore Marketing Automation Engine and Sitecore XConnect Search Indexer components. Each has distinct responsibilities in ensuring that xConnect properly functions so if xConnect is …
Sitecore 9 brings a heavy paradigm with certificates and intra-machine communication when you decide to implement a scaled XP1 environment. You could have separate servers for each Sitecore role, or an architecture that has xConnect on one Server… CMS, Processing, and Reporting on another… and your CDS(s) serving public traffic. As you need to ensure communication between …
Unweaving the Client Certificates required for an XP1 scaled implementation can be a bit of a challenge, as there are several undocumented steps that need to be undertaken. Often, many will export and import the correct certificates, update connectionStrings to use the proper ThumbPrints, but not update the SSL Settings for the IIS xConnect sites …