Hi,
We are had custom SSRS reports with our premise CRM instance that are quite complex and when we moved to CRM online we kept the SQL based reports and rather than change toFetchXml, we moved them to an Azure SQL server and we use the Data Export Service to run the reports off. We have a custom workflow activity that creates a PDF version of the reports and sends them to a file location on another Azure VM. This all works fine for out current UAT and Production CRM organisations but we have just had to upgrade our DEV organisation to Version 9 and now we are getting a security permissions error when trying to create the PDF report. We can preview the reports fine in Version 9 but get the following error from the custom workflow activity:
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.ComponentModel.Win32Exception.GetObjectData(SerializationInfo info, StreamingContext context)
at System.Runtime.Serialization.ObjectCloneHelper.GetObjectData(Object serObj, String& typeName, String& assemName, String[]& fieldNames, Object[]& fieldValues)
This error is occuring at the following line of code:
rs.Url = reportServiceUrl;
where rs is the ReportExecutionService instance
and reportServiceUrl is http://*************.northeurope.cloudapp.azure.com//ReportServer_*************/reportexecution2005.asmx?wsdl
Any one faced the same or similar issue?
Thanks
Phil
