While scanning the DHCP servers running on Windows Server 2012, IPAM fails with the error:
Command Failed: An unexpected error has occurred when processing DHCP scopes results for server 'X'
Depending on what is found in the ipambusinesslayer logs will determine which portion is failing. There are several possible reasons, but the general 2 are outlined.
First has to do if the error pertains to a value missing out of the scopes being scanned. Generally it will look like this:
ERROR SolarWinds.IPAM.ScanningEngine.JobProcessor.JobProcessorBase`1 (null) - Error occurred when processing DHCP results - serverGroupId: X, serverNodeId: X
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'X', table 'X'; column does not allow nulls. INSERT fails.
Second has to do if the error pertains to a SqlDateTime overflow:
SolarWinds.IPAM.ScanningEngine.JobProcessor.JobProcessorBase`1 (null) - Error occurred when processing DHCP results - serverGroupId: X, serverNodeId: X
System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
All versions of IPAM
Windows DHCP 2012
For First Cause:
To verify and remove the Type value Unknown from your scope:
For Second Cause:
There are 2 possible causes of this, depending on the errrors that are seen in the IPAM Businesslayer logs:
1st: The scope type has a value of Unknown on the DHCP server for the Type filed on an address lease. The DHCP scan cannot process the Unknown value and fails the DHCP scan. Other possibilities include missing scope Option in the scope details on the DHCP server
2nd: The scope has a lease time that is set before or after the ranges in the error within a reserved IP.