Reference ZenDesk Ticket: 1175869
Description: Member was attempting to submit an "Unaccompanied Travel Claim however upon clicking on "Submit" the error below was received"
"**apperror**Invalid record Invalid record Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. InnerException --> InnerException -->
-- Search member profile via BGRS reference number and copy the cust_uid number
select * from customer where cust_ref_nbr='6351842612'
--locate username of member by searching cust_uid which is the same as moveid
select * from bgrs_transfereeusers where CurrentMoveId='19520'
--search error log using members username
select * from BGRS_ErrorLog where UserID='PTU19520'
-- Locate the Draft claim submitted by member using MovidID
select top 10 * from BGRS_FinClaimDraft where moveid='19520'
Copy the "UserJsonStageFlow" for the claim from the BGRS_FinClaimDraft table and go to https://jsonformatter.org and paste it in the window.
Here we can easily read the claim details in the righthand window pane.
Upon reviewing the "Description" field of the claim we noticed a large sized note
Validated Character Count by using https://charactercounttool.com and found that the member had exceeded the max characters (1000) for the description field. Member had submitted 1415 character.
I've shorten the description within the claim and inserted it into a our QA transferee profile. Then we logged into qa-bgrsguide.bgrs.ca as the QA Transferee account and was able to click submit.
Script to insert into QA member profile
insert into BGRS_FinClaimDraft set userflowstatejson='[Example Claim] where moveid='##'