"There is already an object named 'XXXX_id' in the database"

(0) Share

Report

Posted on by Community Member

Hi all,

My first post is about a problem I have the last week.

When I try to install an extension in a CRONUS Sandbox in BC365 its everything ok. When I try to install in Production, I get this error.

1-I didnt modify any table or tableextension.

2- If I delete the cronus Sandbox and make another one with the same data of production environment I get the same error.

3- At this moment, in production I have the last Extension that was installed until I installed this.

4- I tried to install previous extension (with another version) but I get the same error.

5- I have tried too, to change the version APP.

Thanks.

8662.ErrorBusinessCentral.PNG

Categories:

Financial Management

All responses (15)

Answers (1)

Community Member on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

Today I was try to import a report in word (.al + .doc) using txt2al. The object was the Confirm Order. When I just copy the files into my project I change the names of the files and the paths, compile an then crash all the sandbox environment. Now I cant download symbols and I cant compile the project.
Community Member on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

The crash was in app version 62. So I check between 61 and 62 there are no new tables or tableextensions changes. I confirm this with my repo.

I will be very careful with this...

Thank you so much for your attention Stefano.
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

It's difficult to understand without seeing previous deplouyment but it seems that you have previously deployed a table extension and now you're deploying another tabe extension with same name. You cannot have objects with same names in extensions (this is why prefix/suffix are born).
Verified answer

Community Member on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

I only could solved this changing my app ID and its name. After that I have a new app extension without any problem.

But I need to know why happened this. This has no explanation for me.
Community Member on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

Today I was just trying to rename all the tables (50xxx) of my extension and then I got the same error with... "Sales Line".

My first table extension is SalesLine but the error is in "Sales Lines" which I supose is the Table ID 37 not my table extension...
Community Member on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

Yes I have checked that before in my repo. The id is still the same....

I can't understand this error...
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

RE: "There is already an object named 'XXXX_id' in the database"

Ok so the object exists.

Have you changed the app ID from the first deployment? Can you check this?
Community Member on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

This is the error message with option F6
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

Ok more clear, so no Powershell. Try to deploy from VS Code with schemaupdatemode = recreate but using F6 instead of F5. Please then report the error message.
Community Member on at

Like (0)

Report

RE: "There is already an object named 'XXXX_id' in the database"

This is not in an on-premise BC sandbox. This is the Sandbox from the cloud.