cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ccdesktop
Champion Sweeper
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.
1 ACCEPTED SOLUTION
ccdesktop
Champion Sweeper
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

View solution in original post

5 REPLIES 5
ccdesktop
Champion Sweeper
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
Champion Sweeper
Just emailed as requested.
Hemoco
Lansweeper Alumni
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
Champion Sweeper
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
Lansweeper Alumni
Please contact us at support@lansweeper.com and provide a screenshot of your current credentials.