I have been attempting to setup the Lansweeper sync, there are a couple of issues I've noticed. The First being that the ID code doesn't seem to stick as after entering the code it is able to find the site, but once i update the entry and go back into it the site selector no longer works until i re-enter the ID code?? The Second being the sync doesn't work even immediately after updating the entry selecting the site and using the default filters, the app logs give me this (minus the values that were in the 2nd block): -
13/02/2024 18:17:04 2023.3.39.0 - 64-bit 2 System.Exception: ClickHouseStatement error: Syntax error: failed at position 228 ('assets') (line 4, col 5): assets.assets_view
WHERE
siteId = {siteId:String} AND date_diff('d', registryCreatedAt, NOW()) < 14
group by
siteId, assetKey
having
deleted =. Expected one of: token, Dot, OR, AND, IS NOT DISTINCT FROM, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, REGEXP, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, MOD, DIV, alias, AS, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, FETCH, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query.
13/02/2024 18:15:19 2023.3.39.0 - 64-bit 2 System.FormatException: The format of value 'Token {"Data":"","SourceConnectionId":"","SourceRepositoryId":"","Type":1}' is invalid.
at System.Net.Http.Headers.HttpHeaderParser.ParseValue(String value, Object storeValue, Int32& index)
at System.Net.Http.Headers.HttpHeaders.ParseAndAddValue(String name, HeaderStoreItemInfo info, String value)
at System.Net.Http.Headers.HttpHeaders.Add(String name, String value)
at Devolutions.RemoteDesktopManager.Managers.LansweeperManager.InitializeRequestMessage(String identityCode)
at Devolutions.RemoteDesktopManager.Managers.LansweeperManager.GetAssetTypes(String siteID, String identityCode)
I'm assuming that because the ID code isn't sticking after the first update it may be causing the sync issues.
Any ideas??
JK
Devolutions Force Member (and Long time Devolutions Fan)
Hello,
We've been able to reproduce these issues are currently working on fixing them.
We'll notify you as soon as we have an update.
Regards
Jonathan Del Signore
Thanks, i am glad to know my instincts were right, that it wasn't my end.
Thanks
Hello,
We've been able to reproduce these issues are currently working on fixing them.
We'll notify you as soon as we have an update.
Regards
JK
Devolutions Force Member (and Long time Devolutions Fan)
Hi again,
Fixes for both of these issues will be included in beta version 2024.1.10.0.
Regards
Jonathan Del Signore