error in software license page after upgrading to 4.0.0.27 update

[abolus]

hi please advise on the server error after we upgrade to 4.0.0.27 update. if you try to click the "license compliance" in the reporting pane you will see a server error. please see attached screen shot.

Server Error in '/lansweeper' Application.
--------------------------------------------------------------------------------

Operator '<=' is not defined for type 'DBNull' and type 'Integer'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Operator '<=' is not defined for type 'DBNull' and type 'Integer'..........

[Hemoco]

Please download http://www.lansweeper.com/files/it-license.zip to resolve this issue.

[Hemoco]

Please mail us and provide the output of stored procedure "web40softwarelicenses" in excel.

[ranpakbv]

Lansweeper wrote:
Please mail us and provide the output of stored procedure "web40softwarelicenses" in excel.

We had the same issue after upgrade to 4.0.0.27.
I checked the SP "web40licensecompliance" and noticed NULL values in the column "number in use" on 2 licenses
After adding multiple versions of the license the problem is resolved