Setting up the Default Value for the country on account is picking up wrong Id

(0) Share

Report

Posted on by Akshay AEMO

We got a business rule that sets the default value for the country on the account form on create.

Basically the country value is set to 'Australia' as a default value. Country is a look up field.

Now when I try to create a new account, the value for country on the form is showing as Australia but when I try to save the record I'm getting an error saying -

Record Is Unavailable

The requested record was not found or you do not have sufficient permissions to view it.

The actual error when I download the log file is

I'm getting the similar error when I try to navigate to country from account (by clicking on Australia). but the strange thing is Australia does exist when I query the country .

so why is the business rule picking up the wrong Id value?

All responses (4)

Answers (1)

Akshay AEMO 22 on at

Like (0)

Report

RE: Setting up the Default Value for the country on account is picking up wrong Id

Yes! deactivating the business rule and resetting the country kinda solves the problem. I tried clearing cache but that did not work.

so hopefully deploying the updated business rule(s) to Prod will resolve the issue because can't really do this in prod.
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Setting up the Default Value for the country on account is picking up wrong Id

Hi Akshay,

You mentioned that you got a business rule to set default value, right?

You can try to deactive it and then set country lookup field manually, Check if the error still occurs.

Or you can try clear browser cache or change other browser to test again.
Akshay AEMO 22 on at

Like (0)

Report

RE: Setting up the Default Value for the country on account is picking up wrong Id

Thanks for the reply. So guid for the country in the url is different than the one in the error message. In the url I can see it's 9198cb07-b02c-ed11-9db1-002248114b1f

"&pagetype=entityrecord&etn=aemo_country&id=9198cb07-b02c-ed11-9db1-002248114b1f" but the Id in the error message is different. Which is "2cd9b145-cc61-eb11-a812-000d3a6a49c3".

It is same for any other country I select, the error message got the same id. In terms of permission I'm trying to create an account using sys admin access still the same error.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Setting up the Default Value for the country on account is picking up wrong Id

Hi Akshay,

Have you check the guid of the Australia record through clicking it in the country view(your second screenshot)?

You can view the guid in the url after openning the record form:

The guid from the URL is the same as the ID of the error message?

Will you get the same error message if you select other country records?

Perhaps you can check that the country table privilege for the security role assigned to the current user are sufficient.

--Microsoft has added a new button on the records called ‘Check Access’ using which user can easily check out their access to the records.

https://www.inogic.com/blog/2021/02/check-access-to-a-dynamics-365-crm-record-using-check-access-button/