While trying to login in Configuration Migration (DataMigrationUtility.exe), we were getting the below error in the log file.
The tool was working fine from one machine but giving an error in other. As suggested in some forum, deleting the LiveDeviceId.xml also didn’t fix the issue.
The way we got it working was to download the latest version of SDK and running the tool from there.
In one of our recent implementations, we were working with Marketing List which could be in millions.
So we had the recent request wherein we split the marketing list into groups.
For adding members to a marketing list we have the following request
AddListMembersListRequest
https://msdn.microsoft.com/en-us/library/microsoft.crm.sdk.messages.addlistmemberslistrequest.aspx
which is quite efficient as we can add multiple members in a single request.
However, when it comes to removing a member from marketing, we do not have a corresponding Remove request like RemoveListMembersListRequest.
https://msdn.microsoft.com/en-us/library/microsoft.crm.sdk.messages.removememberlistrequest.aspx
We only have RemoveMemberListRequest, which only removes 1 member at a time, which is highly inefficient when we are taking in consideration large number of records.
Kindly vote up for this idea !!
https://ideas.dynamics.com/ideas/dynamics-crm/ID0002529
More details
Hi,
We got the below error in one of our Sandboxed Plugins
“System.Security.SecurityException: That assembly does not allow partially trusted callers”.
We realised it was because of using System.Web.HttpUtility class
We replaced it with EscapeDataString method and this fixed the issue.
System.Uri.EscapeDataString()
Helpful thread
https://stackoverflow.com/questions/3840762/how-do-you-urlencode-without-using-system-web
Hope it helps..
Hi,
We were recently facing issue while trying to update status for Campaign Entity using SetStateRequest in Dynamics 365. The value for were not getting updated.
Eventually we realized that it could be because of SetStateRequest being deprecated now in Dynamics 365 (online).
Updating the code to use UpdateRequest fixed the issue.
Hope it helps..
We were getting the below error for projects inside our Dynamics 365 Developer toolkit solution template.
Trying to run the setup brought the following message
The fix was to go to Tools à Extensions and Updates and enable the extension.
Fixed à
Hope it helps..
Just sharing a sample code that could be used for group by and sum operation on EntityCollection.
Suppose below is the output that we want
We can use the below code for that.
// select categoryid, final forecast, final awards from SubCategory Entity
// category id is lookup in SubCategory Entity
EntityCollection result = orgProxy.RetrieveMultiple(new FetchExpression(fetch));
var details = from r in result.Entities.AsEnumerable()
group r by new
{
groupByCategoryID = ((EntityReference)r.Attributes["categoryId"]).Id.ToString()
}
into g
select new
{
sumFinalForecast = g.Sum(x => Convert.ToInt32(x.Attributes["finalforecast"])),
sumFinalAwards = g.Sum(x => Convert.ToInt32(x.Attributes["finalawards"])),
categoryId = g.Key.groupByCategoryID
};
// update the parent record
foreach(var detail in details)
{
Entity entityUpdate = new Entity("category");
entityUpdate.Id = new Guid(detail.categoryId);
entityUpdate.Attributes["totalfinalforecast"] = detail.sumFinalForecast;
entityUpdate.Attributes["totalfinalawards"] = detail.sumFinalAwards;
orgProxy.Update(entityUpdate);
}
Hope it helps..
