→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
abolus
Engaged Sweeper
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'..........

3 REPLIES 3
Hemoco
Lansweeper Alumni
Please download http://www.lansweeper.com/files/it-license.zip to resolve this issue.
Hemoco
Lansweeper Alumni
Please mail us and provide the output of stored procedure "web40softwarelicenses" in excel.
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