User unable to login Dynamics 365 due to Insufficient Permissions

Recently updated CRM from 2016 Online to Dynamics 365, Users were unable to login Dynamics 365.

Tested the same User login with the same security roles in CRM 2013 and 2016 environments, not facing any login issue.

Finally found that in Dynamics 365, it is mandatory to have Organization Read Level permission on Organization Entity for a security role, and which is not mandatory in other CRM versions.

Issue resolved.

Hope this helps 🙂

Principal User is missing prvReadIncident privilege

Got the below issue when i am trying to assign a record to a Team via Action from Incident entity field update from CRM Webform,

I have searched in google for this error and found so many blogs and forums, majority of them saying, to change the Access Mode to Read-Write in System User entity for the user who is facing this issue. User is having Read-Write in my case, but still i faced this issue.

Finally i found that, somehow the Team got converted to Access Team, which i am assigning from Action.

I converted the team from Access Team to Owner Team.

Still, i faced the issue and found that there is no security role assigned to the Owner Team.

At last assigned required Security role to the Team and issue resolved.

Hope this helps and resolves your issue 🙂

 

Dynamics 365 Pricing

Click here and have a look at Dynamics 365 Pricing.

How to Enable/ Disable languages in Dynamic 365 Online?

Follow the below steps to Enable/ Disable languages in CRM Online,

Step 1: Goto Dynamics 365 -> Settings -> Administration. Click on Languages.

Step 2: Select the required Language to Enable/ Disable and Apply.

In this Example, I am going to Enable Language Hindi (India).

Step 3: Click on Ok to Confirm Language Change.

Step 4: It will take some time to Enable/ Disable Languages.

Step 5: Click on Personal Settings to see the Enable/ Disable Language changes.

Step 6: Go to Languages Tab and see the newly added language. Select Hindi (India) to see the changes in CRM and click on OK.

Step 7: You can see the new language in CRM.

Hope you learned a new thing today :):):)

 

QuickFindQueryRecordLimit exceeded. Cannot perform this operation in CRM

I am facing the below issue, when the user is searching for a Text in Contact’s Home Page grid view.

Root cause: User is searching for a Text in Contact’s Home Page grid view and there are having more than 10,000 records.

Due to this limitation in CRM for Quick Find Search, CRM Platform is throwing this issue.

Solution: Goto Settings -> Administration -> System Settings

Change the Enable Quick Find record limits under Set up Quick Find to No and click on OK.

Now you can search the required Text without any issues.

Hope this resolves your issue.

FetchXML Formatter Online

With regards to my Post FetchXML Formatter Tool, Ashish created an online version of this Tool.

Click here and have a look at the FetchXML Formatter Online Version and it really helps as it can be accessed online by everyone from anywhere.

Really appreciate Ashish Vishwakarma’s effort in creating this Tool in Online Version.

 

How to get the System User last accessed CRM Application info using SQL?

Run the below query in SQL against the required CRM Organization to get the System User last accessed CRM Application details,

With CRMSystemUser
As
(
select Row_Number() Over(Partition by U.fullname Order By MAX(DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn)) desc, U.fullname desc) As Row_Num,
 U.fullname AS [FullName], U.DomainName AS [UserName], U.BusinessUnitIdName AS [BusinessUnitIdName]
,DATEPART(YYYY,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))AS [Year]
,MAX(DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn)) [LastAccessAt]
FROM AUDIT A
INNER JOIN SystemUser U ON A.objectid = U.Systemuserid
WHERE Action= 64
GROUP BY
U.fullname, U.DomainName, U.BusinessUnitIdName, U.Systemuserid
,DATEPART(YYYY,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))
,DATEPART(MM,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))
,DATEPART(DD,DATEADD(HH,(DATEDIFF(HH,GetUTCDate(),GetDate())), A.CreatedOn))
)

Select 
CRMSystemUser.FullName,
CRMSystemUser.UserName,
CRMSystemUser.LastAccessAt
From CRMSystemUser
Where ROW_NUM = 1 
order by 
LastAccessAt desc

Output:

Credits to My Friend Krishna Gowtham