*********************Internal KB For Cloud Customer’s *********************
Environment:
iVend Version 6.6 7989 with SAPB1.
Problem Statement:
Customer may report that:
While attempting to clear failed integration records below error message comes (API link will be customer specific):
Issue Details:
When API address is accessed from the browser of same machine, below exception is recevied
{"Message":"The type initializer for 'CXS.Retail.API.IntegrationService' threw an exception.","ExceptionType":"System.TypeInitializationException","Source":"CXS.Retail.API", "Description":"System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.
Resolution/Work Around:
Generally the issue should get fixed automatically after some time. But in case there is any urgency or it does not get fixed, the iVend API service is to be restarted once.
Recommendations /Suggestions:
Below setting/configurations of the iVend API to be checked and need to update same if these are not.
These are as a possible attempt to avoid this reported error for the customer again.
IIS--> Application Pool-- > iVendAPiPool--> Advance setting | (General) - Start Mode= AlwaysRunning
IIS--> Application Pool-- > iVendAPiPool--> Advance setting | Process Model - Idle Time out(minutes) =0
IIS--> Application Pool-- > iVendAPiPool--> Advance setting | Recycling -Regular Time Interval(minutes) = 60 ( default was 1740)
IIS -> CXS-SHALABHS--> Sites -->Default Web site -->iVend API --> Advanced Setting -->PreLoad Enabled= True