Article ID: 118821, created on Nov 22, 2013, last review on May 6, 2014

  • Applies to:
  • Operations Automation 5.4

Symptoms

When a customer is trying to remove a user/staff member, an error is thrown in CP:

ODBC error #23000: [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "ADomain_TechUsersID". The conflict occurred in database "pba", table "dbo.ADomain", column 'TechUsersID'.ODBC error #01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.ODBC error #01000: 

Cause

This user is being used as domain contact for customer's domain, or there were some AR documents attached to this user.

Resolution

Change domain contact to different user.

Additional details

The indescriptive error message was reported as PBA-40566

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF