Reporting database rebuild issue in Sitecore 9.2 scaled environment

We all must have gone through issue where analytics dashboard not showing latest reports. Recently, we were facing the same issue on one of our environment which is on-prem scaled instance of Sitecore 9.2 version.

We checked all different possible issues like 1) xConnect models not deployed to xConnect role 2) Marketing Automation service getting stopped due to credentials or certificate issue 3) Processing role getting stopped after ideal timeout.

We fixed all these issues and we were able to see the latest data in analytics dashboard. But we were not able to see past data as they were collected but not processed.

So, we wanted to do a reporting database rebuild as mentioned in https://doc.sitecore.com/developers/90/sitecore-experience-platform/en/rebuild-the-reporting-database.html/ We performed all steps mentioned in this document. Now it was time to launch below URL on ContentManagement role and execute the rebuild by providing date range if required.

/sitecore/admin/RebuildReportingDB.aspx

We faced below error when launching above URL:

Reporting

As per https://community.sitecore.net/developers/f/9/t/5594, if you’re having scaled environment where you have different ContentManagement and different Reporting role, you need to have Sitecore.Xdb.Remote.Client.config enabled and configured reporting server URL & schema properly.

We double checked and everything was specified for attributes serviceUrl, requireHttps, connectionStringName, headerName etc. And all patching was getting applied properly as well. As per issue we tried to search serviceHostUrl in config files but we couldn’t found single instance.

xdb-remote-client

We then realized that somehow parameter for reporting URL is misspelled in Sitecore.Xdb.Remote.Client.config. And in scaled version, it uses the API to call reporting rebuild on Reporting role. By changing param desc from serviceUrl to serviceHostUrl on ContentManagement role fixed our issue and we were able to browse rebuildreportingDB.aspx page.

Sitecore xDB Cloud 2.0 – Using RestAPI for xDB Cloud Service to solve many purpose

In previous posts, we discussed what is xDB Cloud, Advantages/Disadvantages, Useful Terminologies, How to configure etc. In disadvantages, we seen that we could not connect xDB Cloud directly using tool like Robomongo and MongoVUE. Limiting the action we can perform on MongoDB over On-Premise setup. To overcome this, Sitecore has come up with xDB Cloud RestAPI, not strong enough but maturing steadily. Using which you can perform different operations.

Let’s understand each methods with an example. I use Postman for such purpose. It is a tool build on top of Chrome with lots of cool feature.

Continue reading “Sitecore xDB Cloud 2.0 – Using RestAPI for xDB Cloud Service to solve many purpose”

Sitecore xDB Cloud 2.0 – Configuration, Connection, and Troubleshooting

In earlier, blog posts we discussed the basics of xDB Cloud, some of the advantages and disadvantages of using xDB Cloud as well some useful terminologies. Now we will see how to configure xDB Cloud for various environments. Consider below versions of the resources for our exercise:

  • Sitecore Experience Platform 8.1 rev. 160519 (8.1 Update-3)
  • xDB Cloud 2.o
  • Sitecore xDB Cloud 8.1 rev. 160721

Continue reading “Sitecore xDB Cloud 2.0 – Configuration, Connection, and Troubleshooting”

Sitecore xDB Cloud 2.0 – Useful Terminologies

In earlier, blog post we discussed the basics of xDB Cloud, some of the advantages and disadvantages of using xDB Cloud. Now it’s time to jump on the battle field to configure the xDB Cloud on the local environment. But before moving ahead to configuration and connection, let’s walk through few terminologies which will help you understand each and every configuration very well throughout the setup.

Continue reading “Sitecore xDB Cloud 2.0 – Useful Terminologies”

Sitecore xDB Cloud 2.0 – What it is? Advantages and disadvantages over On-Premise setup

Sitecore and Cloud

Sitecore extensively looking to offer the cloud offering after joining the party with Microsoft in 2016. In an effort to that, Sitecore now available as an App Service on Azure. Have a look at it https://azuremarketplace.microsoft.com/en-us/marketplace/apps/Microsoft.AppSvc_SiteCore_xp?tab=Overview/ Along with this, Sitecore also supports xDB service completely on the cloud (xDB Cloud) if you are running Sitecore 8.0 or higher.

What is included in Sitecore xDB Cloud?

Sitecore xDB Cloud Edition is a managed service that enables you to run Sitecore xDB entirely in the Cloud. This service includes dedicated Sitecore application servers for processing, aggregation, and reporting.

Continue reading “Sitecore xDB Cloud 2.0 – What it is? Advantages and disadvantages over On-Premise setup”