Scanning Credentials - Webserver Error

[ccdesktop]

Hi - everything seems to be working with Lansweeper except when I click on the "Scanning Credentials" options under Configuration. When I do I get the following error:

Any ideas?

Webserver Error
http://SERVERNAME/lansweeper/Configuration/Credentials/default.aspx

SELECT icon, type, mapping, CredID, Credname, itemID, Credtype, Priority, firstorder FROM (SELECT TOP 100000 'network.png' AS icon, 'IP Address' AS type, tsysUniqueIPCredentials.IPAddress AS mapping, tsysCredentials.CredID, tsysCredentials.Credname, tsysUniqueIPCredentials.IPAddress AS itemID, tsysCredentials.Credtype, tsysUniqueIPCredentials.Priority, CAST(SUBSTRING(tsysUniqueIPCredentials.IPAddress, 1, CHARINDEX('.', tsysUniqueIPCredentials.IPAddress) - 1) AS INT) + CAST(SUBSTRING(tsysUniqueIPCredentials.IPAddress, CHARINDEX('.', tsysUniqueIPCredentials.IPAddress) + 1, CHARINDEX('.', SUBSTRING(tsysUniqueIPCredentials.IPAddress, CHARINDEX('.', tsysUniqueIPCredentials.IPAddress) + 1, LEN(tsysUniqueIPCredentials.IPAddress))) - 1) AS INT) AS firstorder FROM tsysUniqueIPCredentials INNER JOIN tsysCredentials ON tsysUniqueIPCredentials.CredID = tsysCredentials.CredID ORDER BY firstorder UNION ALL SELECT TOP 100000 'network.gif' AS icon, 'IP Range' AS type, tsysIPScanRanges.Ipstart + ' - ' + tsysIPScanRanges.Ipend AS mapping, CASE WHEN tsysIPRangeCredentials.CredID IS NULL THEN 0 ELSE tsysIPRangeCredentials.CredID END AS CredID, tsysCredentials_1.Credname, CONVERT(nvarchar, tsysIPScanRanges.IprangeID) AS itemID, tsysCredentials_1.Credtype, tsysIPRangeCredentials.Priority, CAST(SUBSTRING(tsysIPScanRanges.Ipstart, 1, CHARINDEX('.', tsysIPScanRanges.Ipstart) - 1) AS INT) AS firstorder FROM tsysIPScanRanges LEFT OUTER JOIN tsysIPRangeCredentials ON tsysIPRangeCredentials.IPrangeID = tsysIPScanRanges.IprangeID LEFT OUTER JOIN tsysCredentials AS tsysCredentials_1 ON tsysCredentials_1.CredID = tsysIPRangeCredentials.CredID ORDER BY firstorder UNION ALL SELECT TOP 100000 'evsuccess.png' AS icon, 'Windows Computer' AS type, tsysUniqueWindowsCredentials.AssetUnique AS mapping, tsysCredentials_3.CredID, tsysCredentials_3.Credname, tsysUniqueWindowsCredentials.AssetUnique AS itemID, tsysCredentials_3.Credtype, 0 AS Priority, '' AS firstorder FROM tsysUniqueWindowsCredentials INNER JOIN tsysCredentials AS tsysCredentials_3 ON tsysUniqueWindowsCredentials.CredID = tsysCredentials_3.CredID ORDER BY mapping UNION ALL SELECT TOP 100000 'domain.gif' AS icon, 'Workgroup or Domain' AS type, tsysDomainCredentials.DomainName AS mapping, tsysDomainCredentials.CredID, tsysCredentials_2.Credname, tsysDomainCredentials.DomainName AS itemID, tsysCredentials_2.Credtype, tsysDomainCredentials.Priority, '' AS firstorder FROM tsysDomainCredentials INNER JOIN tsysCredentials AS tsysCredentials_2 ON tsysDomainCredentials.CredID = tsysCredentials_2.CredID ORDER BY mapping) AS X Invalid length parameter passed to the LEFT or SUBSTRING function.
Details

Stack trace: at LS.DB.ExecuteDataset(String commandText, Object[] parameterValues) at LS.CF.Credentials.Load(DataTable& credentials, DataTable& globalcredentials, DataTable& domaincredentials, DataTable& uniqueipcredentials, DataTable& uniquewindowscredentials, List`1& Domains, List`1& UniqueIps, DataTable& tsysIPRangeCredentials, DataTable& credentialMappings) at configuration_Credentials_Default.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Target: System.Data.DataTable ExecuteDataset(System.String, System.Object[])

Webversion: 5131

Please contact support@lansweeper.com for technical assistance about this problem.

[ccdesktop · Accepted solution]

In case others have this particular problem...turned out it was an invalid IP range shown under scanning methods.

Deleted and all ok now.

Cheers

[ccdesktop]

Just emailed as requested.

[Hemoco]

Please send the following information to support@lansweeper.com

(create queries from sql management studio)

select * from tsysUniqueIPCredentials
select * from tsysCredentials
select * from tsysDomainCredentials
select * from tsysUniqueWindowsCredentials
select * from tsysIPRangeCredentials

[ccdesktop]

How do I provide a screenshot of current credentials...?

When I click on credentials I get the error!

What should I provide a screenshot of?

Cheers

[Hemoco]

Please contact us at support@lansweeper.com and provide a screenshot of your current credentials.