How to Change the TSB Coordinator in NORMS

Owned by matthew.staynor
Jul 14, 2021
1 min read

NORMS requires there to be a TSB Coordinator to function. If the userbase is getting the following error message “Exception of type 'Norms.Application.Services.UserNotExistException' was thrown.” when attempting to do any actions, check with the product owner to see if they have changed TSB Coordinators. If the answer is yes, then the error is occurring because the TSB Coordinator does not exist.

This change does not necessarily only need to be done when the above error occurs either, as any TSB Coordinator that keeps their Transport account may request you that they stop receiving emails from NORMS. This will resolve the issue as well.

After finding out from the NORMS users who the new TSB Coordinator is, do the following:

  1. Open the NORMS production database

  2. Navigate to table AC041_INTERNAL_STAKEHOLDER

  3. Find the new TSB Coordinator by their TC_USER_ID, copying the STAKEHOLDER_ID

  4. Navigate to table AY025_STAKEHOLDER_ROLE

  5. Find the row with ROLE_TYPE_CD as L1

    1. If the old TSB Coordinator has left, change the STAKEHOLDER_ID to the one you copied in step 3

    2. If the new coordinator is in addition to the current one, create a new row identical to this one, but with the STAKEHOLDER_ID from step 3 and no ACTING_STAKEHOLDER_ID if one exists