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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s