Spider Setup: Server Error in '/Spider' Application | Input String was in a wrong format

[#1]

Summary

After an Update to Spider LCM 6.3.4 you cannot start up the Spider application but get an unhandled exception.

Symptoms

After an Update to Spider LCM 6.3.4 you cannot start up the Spider application but get an unhandled exception:

Server Error in '/Spider' Application. Input String was not in a correct format.

Cause

The problem lies in a missing registry key during the setup leading into one configuration entry being empty (nut NULL)

Resolution

To solve this problem follow these steps:

Method 1:

1. Open the Spider Admin tool
2. Navigate to Spider Core > Config > Application > Indexing
3. You will see that the ApiPort has an empty value. Set it to 80
   
   Ignore the FormatException message
   

Method 2:

1. Open Microsoft SQL Management Studio
2. Navigate to the Spider Core database
3. Open the Config table for editing
4. Change the value of the Key ApiPort in the Area Application.Indexing to 80
   

Additional Information

If you think you ran in a similar cause (string conversion error) but this is not the config key that causes the problem, run the following SQL statement to get all integer configuration values that are not numeric:

SELECT [Area],[Key],[Value]      
FROM [SpiderCore63].[dbo].[Config]  
WHERE CLRType = 'System.Int32'
AND ISNUMERIC([Value])=0

Products

LCM6