12-Amethyst

Solved

Referencial integrity error while deleteing CAD

Forum|Forum|2 years ago
December 4, 2023
1 reply
2405 views

Hello,

I am facing Referencial integrity error while deleteing CAD "Referential integrity violations occurred for this operation:
Cannot delete wxxxxxxx.prt, because it is used by Assembly - wxxxxxxx.asm, D.14
Cannot delete CAD Part - wxxxxxxx.prt, because it is referenced by Assembly - wxxxxxxxx.asm, D.17, Drawing - wxxxxxxx.drw, D.12

please help.

Br,

Sandeep C.

CAD Data Mgmt

Best answer by HelesicPetr

Hi @Sandy7

Delete the assembly iteration where the part is used in.

But it is not so easy if the assembly is used by other objects as a drawing or another assembly.

In some cases purge can help or delete previous iterations can help if it is available. But it can be really complex issue.

PetrH

22-Sapphire II

Hi @Sandy7

First you need to delete the assembly where the part is used. Also the drawings.

wxxxxxxx.asm, D.14

If there is reference you can not delete it without deleting the usage.

simple explanation you can not remove walls if there is a roof on it

PetrH

Author

12-Amethyst

How to break the reference link? any chance?

Br,

Sandeep C.

23-Emerald I

you have to delete the referencing objects first , or cut links using SQL (Not recommended ) .

generally we run the attached SQL script with the object ida2a2 (OR) and its ida3masterreference (UsageLinks...) to see where it is referenced :

(view in My Videos)

Buiꓘa