Description: When the supplier is logging into services.bgrs.ca to processes their TPSP participation renewal they are seeing another supplier's name in the top righthand corner of the page.
BGRS Reference ZenDesk Incident: 5085038
-- Search Contact table by email
select * from contact where firstname.lastname@example.org'
-- Search Organization by email address
select * from organization where org_uid='6348'
-- Search Registration table by email address
select top 10 * from BGRS_TPSPContactDetails where PersonalEmailAddressemail@example.com'
--Search for user account using cont_uid and email from the contact table
select * from bgrs_supplierusers where cont_uid='42762' or UserEmailfirstname.lastname@example.org'
-- Seach table by suppliers id from the bgrs_supplierusers table
select * from BGRS_SupplierUsersContact where supplieruserid='943'
In the BGRS_SupplierUsersContact table we see 2 entries for the SupplierUserID 943 pointing at 2 different users as seen with the Cont_uid's. We know 42762 is for Sonat Try.
--Determine who is Cont_uid 42763
select * from contact where cont_uid='42763'
Here we see that the user is Jennifer Chiasson and is why Sonat Try is also seeing her name in his profile. We have also noted that the cont_status is "I" which indicates Jennifer is inactive. In this case we can delete the entry in BGRS_SupplierUsersContact for SupplierUserID 943 and Cont_Uid 42763.
delete from BGRS_SupplierUsersContact
-- select * from BGRS_SupplierUsersContact
where SupplierUserId='943' and Cont_uid='42763'
if @@ERROR > 0 or @@ROWCOUNT <> 1