Dynamics 365 : Unrecognized Guid format

Recently, my client hit an error while opening a record, the form doesn't rendered anything, it totally a blank page.

After turn on the tracing, the log file show us a very weird error message "Unrecognized Guid format".

we search through everything, but unfortunately those solution didn't help us.

After that, we found out the similarity between the records, it is under a deactivated Business process flow. We tried to reactivated it, but it thrown us an error message.

It seems that there is something wrong with the BPF. So we decided to investigate deeply.

One of the step is missing, it became "Record" instead of the field we selected before. So after we choose back the correct field and save. The User is able to Open the record again.

Solution

- Remove the "Record field" or Choose a correct field.


I hope this will save you some time and Happy 365-ing.

Dynamics 365 : Get Entity Relationship using SQL Query

Recently, i got informed by my client, they need to do some clean up for the relationship between entities.

Thus, I have to generate the excel file and show to my client but as we all know there is no out of box feature to generate the relationship excel file. So, there are few ways to generate it.

1. Third party tool
   - XRM Tool Box
   - I don't want to rely on Third party tool.
2. Manually copy the relationship
   - Time consuming and sounds ridiculous.

Thus I decided to generate the relationship using SQL Query .

DEMO

1. Open up The SQL management studio.
2. Download the script from HERE.
3. Copy and paste the script.
4. Change the Entity Logical Name to suit your need.

RESULT

Save the result as CSV file.

I hope this will save your some time when it is your turn. Happy 365-ing.