Nitin Bhui, Bentley Technical Support Group
Not able to delete the document with copies. Getting error as You may not delete this record since it is being referenced by other records. The DELETE statement conflicted with the REFERENCE constraint “document_copies_fk”. The Conflict occurred in the database.
Workaround: This is by the design of the of AssetWise. Once the document has been on a Distribution Order and issued out to users (internal/external), it cannot be removed from said Distribution Order.
If it needs to be deleted as it is a legacy document, the best practice is for the document’s approval status to be set as Obsolete. If it has been superseded by a different document number, then that information should also be present (Superseded By ‘relationship’).