Reference ZenDesk Ticket: 1865456

Description:  IRP Agent was receiving "Server Error" while accessing the Advanced Request Module in IRP iZone.

Troubleshooting:

1. In order to get the true error message rather than "Server Error" you will need to login to the internal IRP iZone webserver TORIRPIWEBPV001.biz.btswyn.com .  Launch the iZone site using IIS or localhost http://localhost/Irp/default.aspx

Login to iZone using jlai and summer as the credentials. 

2. Pull up the member file using the Quick Search field and click on Advance Request

Reviewing the output of the trace error the system is complain about bad or missing data " System.NullReferenceException: Object reference not set to an instance of an object"

3. Login to the IRP database 10.139.88.101 and confirm if any data is missing from the tables.

-- Checks the Advanced Request table for claims under the members file number.  This query returned no results

select top 100 * from AdvanceRequest where projectid='CSC 202100438'

-- Checks Claims table for claims submitted under the member file number

select * from claim where projectid='CBSA202200006'

-- Checks Claims_Detail table for expense line entries under the claim ID from the previous query.  The query returned no results

select * from claim_detail where claim_id='1466116'

Solution:

It appears during the Advanced Request submission process there was a glitch where the Advance Request and Claims_Detail tables were not populated.  In order to resolve the issue we need to delete the data in the Claims table.

use irp
begin tran
delete from claim
--select * from claim
where claim_id = '1466065' and projectid='CSC 202100438'
IF @@ERROR <> 0 or @@rowcount <>1
BEGIN
ROLLBACK TRAN
RETURN
END
commit tran

Once the script has been applied confirm you are now able to access the Advanced Request module and ask the agent to reach out to the member to resubmit Advance.