How to Reset the Management Reporter Data Mart
Summary
• Open PowerShell and run as Administrator (Click on Start and then right-click on PowerShell and select Run as Administrator) • When prompted with the User Account Control prompt, click the Yes button. • In PowerShell type the below command (or copy and paste from below); then press the Enter key. • Import the Management Reporter PowerShell module by typing the following command: • Run the reset command Reset-DatamartIntegration and enter the below parameters for each prompt: • Reason: Valid entries are: SERVICING, BADDATA or OTHER • DatamartDatabaseUserName: SQL Login Name (can be SQL or Windows account) that has sysadmin role membership) • MRDatabaseServer: SQL Server name (same answer above, rare case to be running on separate server from data mart database) As an alternative to the above step, you can use the following example to enter the entire PowerShell command without prompting for each variable (change items where necessary): When the above information is entered you will be prompted to confirm the action. • When the process starts, the Configuration Console will display a message that the initial integration is in progress. If you need to rebuild it, stay tuned for the third blog in this series, coming July 26.
Classifications
AskAI Classifications
LabelsLinked Companies
