Unable to remove Out of the Box request offering categories for HEAT 2014.xe even when they were deleted from the front end.

Version 1

    Details

    Unable to remove Out of the Box request offering categories for HEAT 2014.xe even when they were deleted from the front end.


    Resolution

     

    ***Verify these request offering categories are not associated to any request offering***

    This can be accomplished by delete the category from the backend.

    1. Do a select statement to verify that the category exists.

    SELECT *
      FROM [dbo].[ServiceReqCategory]
    where CategoryName = 'Test'


    2. Do a delete statement.

    delete FROM [dbo].[ServiceReqCategory]
    where CategoryName = 'Test'

    Test this in your test environment. The recommendation is to make sure that there is no request offering associates to that category and if there is child category associated to a parent category. Delete the child category first and then the parent.