Tools

Database error when deleting a Tech Group

This article describes an issue where you cannot delete a tech group from a report.

First published date

10/17/2018 8:16 PM

Last published date

9/25/2020 8:14 PM

Overview

When you try to delete a tech group from a report, the following error message displays

"Problem deleting the Tech Group: com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:23000 -- error code: 547 -- msg: The DELETE statement conflicted with the REFERENCE constraint "REPORT_GROUP_TECH_GROUP_techGroup_FK". The conflict occurred in database "whd", table "dbo.REPORT_GROUP_TECH_GROUP", column 'TECH_GROUP_ID'."

Product section

Web Help Desk

Cause

A tech group is assigned to one or more report groups. 

Resolution

  1. Log in to Web Help Desk as an administrator.
  2. Click Reports > Report Groups. 
    Each group name (such as Sample Reports) display. The Access column displays the assigned groups that can access the report.
  3. Edit the groups that have the tech group you want to delete, especially those groups assigned to Tech Groups: All. 
  4. Choose Specific Groups only to remove the Tech Group that you want to delete.
  5. After you remove the tech group from the report groups, log out.
  6. Log back in and try deleting the tech group.