I receive a “Maximum Length Exceeded” error when populating numerous tables in UNICOM Intelligence Reporter - Survey Tabulation
This error can be resolved by increasing the jsonSerialization maxJsonLength setting in the web.config file for the UNICOM Intelligence Reporter - Survey Tabulation Frontend and WebService:
▪The UNICOM Intelligence Reporter - Survey Tabulation Frontend web.config file is in:
C:\InetPub\wwwroot\SPSSMR\mrTables\Frontend\web.config
▪The UNICOM Intelligence Reporter - Survey Tabulation WebService web.config file is in:
C:\InetPub\wwwroot\SPSSMR\mrTables\WebService\
1 Open each web.config file and locate jsonSerialization maxJsonLength.
2 Change the value to the following: <jsonSerialization maxJsonLength="5000000" />
5000000 is the recommended value. This value prevents the error in most situations, and does not decrease the website’s concurrency and performance.
3 Restart the Internet Information Services (IIS) service after modifying the value.
See