CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name xxxx

(0) Share

Report

Posted on by YOG

414

Hi All,

please can you advise.

I am having issue.

here is what happened

I had custom data entity called 'CAPSALESINVOICELINEMARGIN'
I have extended this data entity to make more change. extended data entity is named as 'CAPSALESINVOICELINEMARGIN.CAPEXTENSION'
I have then included staging table 'CAPSALESINVOICELINEMARGINSTAGING' of original data entity to new extended project.
I have deleted 'CAPSALESINVOICELINEMARGINSTAGING' table from project (clicked delete table permanently to yes)
Performed build
I am now trying to recreate data entity from scratch but getting error as below

7701.Err.JPG

I have the same question (0)

All responses (8)

Answers (3)

Verified answer

WillWU 22,361 on at

Like (0)

Report

Hi YOG,

Make sure the table CAPSALESINVOICELINEMARGINSTAGING does not exist in AOT.

Please synchronize the DB and try it again.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Your steps seem very strange.

If you want to add fields to an entity using extension, you have to extend the entity and the staging table. But if you developed the original entity, you don't need to extend it, just add your fields directly in the original entity and staging table!

Why did you delete the staging table? Anyway, after deleting the table, please perform DB sync before attempting to create it again.

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

hi Will,

I can see staging table in AOT.

how can i delete it?

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can delete any object by adding it to Visual Studio project and deleting it.

I thought you said you already deleted it. But you also said that you recreated it :) So please delete it, sync db and then try to recreate it.

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

hi Nikolaos,

thank you . i'll try this.

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

Hi Nikolaos/Willi,

I have deleted table and done build too.

I have created new entity from scratch but I am now unable to export data and instead getting error as below.

I can see services are disable but i cannot find option to unable it. is there any way?

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

This is a completely new problem, I suggest you post it as new question.

When posting, please provide a bit more information about your environment (is it MS managed, Cloud hosted, or local VM). This way others can start providing help right away.

Also could you please close this discussion by marking the relevant answer(s) as verified. Thanks!

Was this reply helpful? Yes No
YOG 414 on at

Like (0)

Report

Sure Nikoloas,

Thanks for your help.

Was this reply helpful? Yes No