Reference Ticket: 1041438

Description: Agent unable to retrieve / modify an expense claim in the expense module for file NRC 202000059. When the agents go into the Expense Claim Module the are unable to select the claims to modify or approve.

Troubleshooting:

Login to the XA DB (10.139.88.101)

-- search the users ID by file number AKA DBAccessKey

select * from xa.dbo.XAUser where DBAccessKey ='NRC 202000059'

--search by user by PreferredUserID

select * from xa.dbo.WebUserRequests where AssignedUserID = 'Queen''s515'

The issue here is the transferee created their account with a special character.

In order to resolve the this issue we need to delete the UserID from xaUser and WebUserRequests

use xa
begin tran
delete from xa.dbo.WebUserRequests
--select * from xa.dbo.WebUserRequests
where RecordID = '351452'
IF @@ERROR <> 0 or @@rowCount <>1
BEGIN
ROLLBACK TRAN
RETURN
END
delete from xa.dbo.XAUser
--select * from xa.dbo.XAUser
where Record_ID = '368871'
IF @@ERROR <> 0 or @@rowCount <>1
BEGIN
ROLLBACK TRAN
RETURN
END
commit tran

Once the database change request (DBCR) has been applied, contact the agent to recreate the transferee account in the front end of iZone without the special character.  In this incident the ID would be created as Queens515. 

After the account has been recreated we need to go to the IRP DB (10.139.88.101) and update the create_by column for all claims associated to this file.

--list all claims for the file#

select * from claim where projectid='NRC 202000059'

use irp
begin tran
update claim set create_by='Queens515'
--select * from claim
where claim_id in ('1452671', '1452672')
IF @@ERROR <> 0 or @@rowcount <>2
BEGIN
ROLLBACK TRAN
RETURN
END
commit tran