Small and medium business | Business Central, N...

Cannot delete an entity

(0) Share

Report

Posted on by Rusthy

So I am working with SaaS Business Central that is:
[b]Version: W1 20.2 (Platform 20.0.41086.43114 + Application 20.2.41144.41547)[/b]

The user I am logged in with, has Super, Security, Full Business, Extension Management - Admin rights for all the entities.

I have total of 3 entities and wish to keep just one.

Whenever I try to delete a company I get the following error after about 15 to 20 minutes of waiting;
[b]An unexpected error occurred after a database command was cancelled.[/b]

I tried to delete it using VSCode debugger and I can't catch the error on VScode to know why can't I delete the entity.

Thank you for any advice on this. I am stuck at it from 2 days.

I have the same question (0)

All responses (10)

Answers (0)

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi Rusthy ,

I have not found much resource, please refer below link if it helps you, other wise please a log a support ticket to MS support.

github.com/.../7067

Was this reply helpful? Yes No
Suggested answer

S.Kawamura 1,530 on at

Like (0)

Report

Hi,

First, try to make sure that Super permission set are not restricted to a specific company.

To analyze the cause of the problem, you might try the following:

a) Copy environment and same operation (delete company) on copied environment.

b) Create new blank company, then delete the company.

c) Copy the company that you want delete and failed to delete, and then delete copied company.

I hope this helps you.

S.Kawamura

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, This appears to trigger the Database limit below.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online#Database

It is recommended that you uninstall all Extensions other than Microsoft and try again. If there is still a problem, it is recommended to submit a Service Request to Microsoft.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Rusthy 20 on at

Like (0)

Report

Hi, thanks for your response. Is there a way, even if it is from AL Development Envoirnment, that I can know which table is taking so much time to complete its SQL command?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the information below can give you some help.

From Business Central Launch Event:

More details:

[View:/cfs-file/__key/communityserver-discussions-components-files/758/What_2700_s-new-in-Server-and-Database.pdf]

Was this reply helpful? Yes No
Rusthy 20 on at

Like (0)

Report

I clicked on the emit telemetry and then tried to delete the entity but it still didn't give me a more friendlier error. It was the same 1 line error; An unexpected error occurred after a database command was canceled.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

I will suggest please log a support ticket with MS.

Was this reply helpful? Yes No
Rusthy 20 on at

Like (0)

Report

We are not partners. I work as a developer client side. How do I contact Microsoft for this?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

In that case please take help of your License partner.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, try below ways.

Where to file bugs ,issues and Questions

https://yzhums.com/20581/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No