B2026-031 PROMS Crash in Admin Tools Maintenance - Purge Change History #733

Merged
jjenko merged 1 commits from B2026-031 into Development 2026-03-12 11:22:07 -04:00
Owner

B2026-031 PROMS Crash in Admin Tools Maintenance - Purge Change History

There is some disconnected data in the Manual db that resulted in an error / conflict when the Purge Change History Tool was run. Error was: The DELETE statement conflicted with the REFERENCE constraint "FK_Parts_Items". The conflict occurred in database "VEPROMS_ACME_MANUAL", table "dbo.tblParts", column 'ItemID'.

B2026-031 PROMS Crash in Admin Tools Maintenance - Purge Change History There is some disconnected data in the Manual db that resulted in an error / conflict when the Purge Change History Tool was run. Error was: The DELETE statement conflicted with the REFERENCE constraint "FK_Parts_Items". The conflict occurred in database "VEPROMS_ACME_MANUAL", table "dbo.tblParts", column 'ItemID'.
djankowski was assigned by mschill 2026-03-12 11:08:51 -04:00
jjenko was assigned by mschill 2026-03-12 11:08:51 -04:00
mvickers was assigned by mschill 2026-03-12 11:08:51 -04:00
mschill added 1 commit 2026-03-12 11:08:52 -04:00
mschill requested review from jjenko 2026-03-12 11:08:52 -04:00
jjenko approved these changes 2026-03-12 11:21:52 -04:00
jjenko left a comment
Owner

change looks good

change looks good
jjenko merged commit ec823cab97 into Development 2026-03-12 11:22:07 -04:00
Member

Tested with PROMS version 2.3.2603.1211 and sql fixes 2603.1211. Ran as expected.

Tested with PROMS version 2.3.2603.1211 and sql fixes 2603.1211. Ran as expected.
Sign in to join this conversation.
No Reviewers
No Label
3 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Volian/SourceCode#733