Finance forum

Exception occurred on the metadata service on client or server - error

(0) Share

Report

Posted on by Syed@Dynamics365

Hi experts,

Please help me in solving this error I get while selecting a Query for a SSRS report's dataset.

I have Microsoft Dynamics 365 for Operations in my VM.

In Visual Studio 2015, I have created a new project and trying to customize an existing report.
I open the report. Go to the dataset and select "Query" as the "Data Source Type" in the properties window. Go to the Query property and click "..." to open the dialog.
Select any Query and click next, I get the error "Exception occurred on the metadata service on client or server".

2063.MetadataError1.JPG

6787.MetadataError2.JPG

Thanks,

Syed

Categories:

Development / Customization / SDK

I have the same question (0)

All responses (20)

Answers (1)

Martin Dráb 238,751 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What if you log into Operations and try it again?

Was this reply helpful? Yes No
Syed@Dynamics365 15 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

I did login again into Operations. Restarted the VM . Restarted all services.

None of the above helped.

Thanks,

Syed

Was this reply helpful? Yes No
Syed@Dynamics365 15 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

I did try it. I log into Operations. Restarted the VM, restarted all the services. Still the error persists.

Thanks

Was this reply helpful? Yes No
Martin Dráb 238,751 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I see two options: either you look logs for more details, because you can anything until you know what's wrong, or you simply create a support request with Microsoft.

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!

Are you connected with domain?

i was same error before because i was not connect with domain.

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!

and also try to run Visual Studio as administrator

Was this reply helpful? Yes No
Sakthiananth 2,127 on at

Like (0)

Report
Copy link

Link copied!

I was facing this issue but I managed to get rid of this error by doing the successful completed packages build and DB sync. after this successful process do deploy the reports using power shell. all the best Syed.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

I was wondering if you had found a solution to this issue ?

Thank you

Was this reply helpful? Yes No
Verified answer

emincas on at

Like (3)

Report
Copy link

Link copied!

Hi Matt,

We have solved the problem.

When try to change Dataset on SSRSReports, VS try to call the following webservice https://usnconeboxax1aos.cloud.onebox.dynamics.com/Services/MetadataService/

with AuthUser administrator@contosoax7.onmicrosoft.com

This settings is present in file C:\AOSService\PackagesLocalDirectory\Bin\DynamicsDevConfig.xml at the key

<OfflineAuthenticationAdminEmail>administrator@contosoax7.onmicrosoft.com</OfflineAuthenticationAdminEmail>

We have changed this settings with AAD user, reopen VS and all works fine.

Was this reply helpful? Yes No
Frantisek 125 on at

Like (0)

Report
Copy link

Link copied!

Reply to @emincas.

Thank you. I can confirm that this solution works perfectly.

Was this reply helpful? Yes No