Finance | Project Operations, Human Resources, ...

How to reset financial reporting DataMart on a Sandbox Tier 2 environment?

(0) Share

Report

Posted on by rabbit1986

335

Hello,

We are experiencing some problems since our last data migration on our Sandbox Tier 2 environment.

When opening MR it says:

When closing the MR it says

I know there are several options to reset the datamart ( as we assume this might fix our issue ), but as I don't have write privileges to MR database, I can't restore the Mart in SQL.

Also we cannot reset it in management reporter.

Do we have to log a service request? Or is there another way to reset the datamart on a Tier 2 environment?

Thanks you for your help.

Kind regards

Mathieu

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi,

You can try to reset it via PowerShell.

docs.microsoft.com/.../reset-financial-reporting-datamart-after-restore

Was this reply helpful? Yes No
rabbit1986 335 on at

Like (0)

Report

I am aware of this possibility, but as I cannot logon the the environment I cannot execute the script right?

My Sandbox does not allow me to connect to the server and run Powershell scripts there:

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi,

Is it a self-service environment? If yes, in this case, you probably need to create a ticket to MS.

Was this reply helpful? Yes No
Suggested answer

Luke Sha on at

Like (0)

Report

Hi, Mathieu

For self service project, customer is able to request JIT access to SQL.

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/deploymentfaq#access-the-azure-sql-database

Step 1:Submit proper access request

Step 2: Then LCS will confirm request is received

Step3: Find SQL login and password

Step4: whitelist your client public IP

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello rabbitt1986,

Do you have a system admin colleague who could reset the data mart for you?

Best regards,

Ludwig

Was this reply helpful? Yes No