Reference ZenDesk Ticket: 1865456
Description: IRP Agent was receiving "Server Error" while accessing the Advanced Request Module in IRP iZone.
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'
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.
delete from claim
--select * from claim
where claim_id = '1466065' and projectid='CSC 202100438'
IF @@ERROR <> 0 or @@rowcount <>1
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.