I am trying to rebuild the reporting database using the URL, https://abc.com/sitecore/admin/RebuildReportingDB.aspx but every time getting the below error. enter image description here

The version of Sitecore we are using is 9.0.2, also connection string of reporting and reporting.secondary databases are correctly configured in the CMS server config file.

Thanks Nash

  • Try to update the reporting, reporting.secondary and xdb.processing.tasks connection strings by adding: ;Connection Timeout=90; May 14, 2020 at 12:45
  • Still getting the same error what I was getting earlier.
    – Nash
    May 15, 2020 at 12:44
  • @Nash can you try to use DTC Tester to see if there are any issues with the configuration. microsoft.com/en-us/download/details.aspx?id=30746 May 18, 2020 at 7:11
  • could you please share your configuration changes and the aggregation/reportingStoragaProviders section for secondary? May 18, 2020 at 8:53
  • @MahendraShekhawat : Which all configs you need and from which server, like we have separate CM, Processing, and Xconnect server. Also "aggregation/reportingStoragaProviders section for secondary" this part from which file?
    – Nash
    May 18, 2020 at 10:57


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.