Unanswered

Internal server error on lists and forms

(0) Share

Report

Posted on by antonhh

I am building a Power Pages site and I am using Business Central Virtual Tables (Dataverse) as the data source and everything looks good when I use my developer account to login to view data but when I switch to External User I get the error Internal Server Error.

The external user has all the same relevant data, Account, Customer and customerid (custom column used for viewing related data to a customer).

This is what I get when I am logged in as external user:

This external user has both anonymous and authenticated user web roles and the table has these permission setting:

Has anybody had this problem before when using Virtual Tables, I am at a loss here.

Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Neil Phelan 6 on at

Like (0)

Report

Hi @antonhh

I am getting the same issue, did you manage to resolve it?

Thanks Neil.

Was this reply helpful? Yes No
antonhh 35 on at

Like (0)

Report

I managed to find the reason why it was happening, I am waiting on a fellow coworker to help me with BC side of things to resolve the issue.

The reason why I got the Internal server error was because the external user I was using did not have a required value in a Custom Lookup Column I had 'BC Customer'

The Realtionship in this column was many to one
When I tried to add a customer value "Trey Research" on more than one contact I got a error. By my estimation it must be the relationship that is the reason to my problem.

It did work fine when I removed the customer from 1 user and added it to the one getting the Internal server error.

If any expert sees this it would be appreciated to get any feedback on this.

Was this reply helpful? Yes No
Neil Phelan 6 on at

Like (1)

Report

Hi @antonhh
Miracellously the internal server error disappeared in the last hour.
I then started getting this error.
Failed to find synthetic relationship attribute in referenced entity: contact, attributeName:crc36_bccustomer2, record id: 2dc415bd-391c-ef11-840a-6045bd8b4f87

My issue was i hadn't added the customer into the new field bccustomer2 in the dataverse.
So just edit this record and start typing to link the relevant customer record.

After that it worked perfectly.

Was this reply helpful? Yes No
antonhh 35 on at

Like (0)

Report

Brilliant!!

What happens when you add more contacts to the same BCCustomer2 value to them?
Any issues with that?

Was this reply helpful? Yes No