I am experiencing an issue where my Experience Analytics data is current but my Experience Profile data is out of sync. I believe to fix this issue, I need to rebuild the Reporting db and Analytics index using hostname/sitecore/admin/rebuildreportingdb.aspx from the CM server. However, when I do this I get the following error:
"Connection string used by aggregation/historyTaskManager/ReportingStorage is missing."
Based on my research, I need to add a secondary reporting DB and then rebuild. What is the process for this on Sitecore Managed Cloud? On all of our servers, we do not have any connection strings to the reporting db. Instead, we have the reporting.apikey connection string which I believe is correct for Managed Cloud. But, if we don't have a connection string to a reporting db then how can I add a secondary reporting db for the rebuild?