D365 CRM Portal Error on Loading Entity Form Server Error

(0) Share

Report

Posted on by pmrsim

Hello,

first time posting, sorry it's with a problem/question!

I've created a Portal linked to CRM D365.

I've got a page with an Entity List, which displays fine.

Selecting a record from the Entity List opens the Entity Form on its own page. Yay.

That last step works fine, but only when the Entity List view only contains 1 record.

As soon as the List contains 2 or more records, I get an error when trying to open a record.

The error says "sequence contains more than one element" and a load of other stuff that I don't fully understand.

Through research I have found that the important part of the error message is this:

System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +470

...and it seems I need to find a way to change "SingleOrDefault" to "FirstOrDefault", however I do not know where or how to do that.

Has anyone experienced this and found a solution? I'd be immensely grateful to hear your suggestions.

The full error message:

Server Error in '/' Application.

Sequence contains more than one element

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Sequence contains more than one element

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Sequence contains more than one element]
 System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +470
 Adxstudio.Xrm.Web.UI.WebControls.EntityForm.GetEntitySourceDefinition(OrganizationServiceContext context, Entity entityform) in S:\Framework\Adxstudio.Xrm\Web\UI\WebControls\EntityForm.cs:1201
 Adxstudio.Xrm.Web.UI.WebControls.EntityForm.CreateChildControls() in S:\Framework\Adxstudio.Xrm\Web\UI\WebControls\EntityForm.cs:578
 System.Web.UI.Control.EnsureChildControls() +107
 System.Web.UI.Control.PreRenderRecursiveInternal() +58
 System.Web.UI.Control.PreRenderRecursiveInternal() +227
 System.Web.UI.Control.PreRenderRecursiveInternal() +227
 System.Web.UI.Control.PreRenderRecursiveInternal() +227
 System.Web.UI.Control.PreRenderRecursiveInternal() +227
 System.Web.UI.Control.PreRenderRecursiveInternal() +227
 System.Web.UI.Control.PreRenderRecursiveInternal() +227
 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3671

Any help would be much appreciated. Thank you!!

Pete.

(ps. cross-post https://community.dynamics.com/365/f/dynamics-365-general-forum/424351/d365-crm-portal-error-on-loading-entity-form-server-error)

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (1)

MarkBiggerstaf Microsoft Employee on at

Like (0)

Report

Hello,

After reviewing the previous thread and the description of your issue, you will likely need to open a formal support ticket for troubleshooting.

You could try creating a new entity list and form on a test page with no customizations. If that works, you might be able to compared the two to find the differences.
https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/entity-lists

If you are still unsuccessful, my recommendation is opening a new support ticket and the next available engineer will be assigned.

Thanks,

Mark Biggerstaff
Dynamics Support

Was this reply helpful? Yes No
pmrsim 27 on at

Like (0)

Report

Thanks for the suggestion Mark.
~~How do I log a ticket though... I seem to be hitting brick walls whichever way I try.., as I'm not a 'partner'.~~

Edit: Nevermind, I have logged a ticket with MS.

Thanks,
Pete.

Was this reply helpful? Yes No
Verified answer

pmrsim 27 on at

Like (1)

Report

If anyone's following this thread or comes across it in future... I logged a ticket with MS and got it resolved. I suppose, in the end it was user-misunderstanding.

The solution:
Both my Entity List and Entity Form had the Record Source Type set to 'Record Associated to Current Portal User'.
"In the Entity Form If the current Record Source Type is ‘Record Associated to Current Portal User’, which means it would retrieve whole records related to current Portal user. So it would cause error ‘Sequence contains more than one element’.

For more details, please refer to the document on it: https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/entity-forms#basic-form-attributes-and-relationships
In order to fixing this issue, please change the Record Source Type from ‘Record Associated to Current Portal User’ to “Query String”."

Thank you to Sonal at MS for solving this.

So in the end, it was all due to the Record Source Type on the Entity Form.

All the best,
Pete.

Was this reply helpful? Yes No