|Applies To||RSA Product Set: Archer|
RSA Product/Service Type: Archer
|Issue||The following error message is displayed:|
Warning: An unexpected error occurred while calculating field values for this record. Your previously stored field values, if any, have been retained for this record. Please contact your Archer administrator for assistance.
The Archer log files that have w3wp in the file name ( e. g., w3wp.20171207 - 2.xml, where the file name is a time stamp of when the error occurred) will have the following messages around the time of the warning:
|Cause||The Archer web server is unable to communicate with the SQL server or file repository. Most likely, Windows is having a system issue like low resources and the errors/warnings are the side effects. The Windows event logs may contain additional information.|
|Resolution||Reboot the Archer web server that is experiencing the issue so that Windows can recover from itself. If there are multiple web servers, the exception in the Archer log files will provide the machine name in the <Computer> XML element.|
If a reboot does not resolve the problem, resetting the Services Account password in the Archer Control Panel has also proved to resolve the issue.
It was also found the following configurations on the database can resolve the issues as well:
1. Adjust degree of parallelism to 1.
2. Setting database autogrowth appropriately.
3. Setting compatibility level according to the SQL server version