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 '20 at 12:45
  • Still getting the same error what I was getting earlier.
    – Nash
    May 15 '20 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 '20 at 7:11
  • could you please share your configuration changes and the aggregation/reportingStoragaProviders section for secondary? May 18 '20 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 '20 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.