Notification

Icon
Error

Azure does not scan the whole subscription

Posted: Saturday, April 13, 2019 9:48:51 AM(UTC)
Okan

Okan

Member Original PosterPosts: 26
2
Like
After scanning one subscription, LS does not return all of the assets and resources groups in that subscription. I also get the following error in the Scanning Targets page:

Entity of type "AssetMacAddress" in state "Added" has caused a DbUpdateException. SqlException Errors: -> Number 515: Cannot insert the value NULL into column 'Mac', table 'lansweeperdb.dbo.tblAssetMacAddress'; column does not allow nulls. INSERT fails.
Esben.D
#1Esben.D Member Administration Posts: 1,834  
posted: 4/15/2019 1:30:44 PM(UTC)
Are you on version 7.1.100.12 or higher? That version contained a fix for an issue with that error.
Okan
#2Okan Member Original PosterPosts: 26  
posted: 4/15/2019 1:36:15 PM(UTC)
Thank you for your reply. I am using 7.1.100.16.
Diego Pontes
#3Diego Pontes Member Posts: 1  
posted: 4/16/2019 10:51:03 AM(UTC)
Originally Posted by: Okan Go to Quoted Post
After scanning one subscription, LS does not return all of the assets and resources groups in that subscription. I also get the following error in the Scanning Targets page:

Entity of type "AssetMacAddress" in state "Added" has caused a DbUpdateException. SqlException Errors: -> Number 515: Cannot insert the value NULL into column 'Mac', table 'lansweeperdb.dbo.tblAssetMacAddress'; column does not allow nulls. INSERT fails.




I have the same problem.
Susan.A
#4Susan.A Member Administration Posts: 1,535  
posted: 4/22/2019 10:08:06 AM(UTC)
I think Esben might have been referring to a different fix/issue. The error below in relation to Azure scanning had already been reported to our development team and is scheduled for a fix in Lansweeper 7.1.110, our next build.

We don't have a release date for 7.1.110 yet, but we recommend keeping an eye on our changelog for this release: https://www.lansweeper.com/changelog/
The issue has internal reference "LAN-2869" in our system and will be referred to as such in our changelog once fixed.

Quote:
Entity of type "AssetMacAddress" in state "Added" has caused a DbUpdateException. SqlException Errors: -> Number 515: Cannot insert the value NULL into column 'Mac', table 'lansweeperdb.dbo.tblAssetMacAddress'; column does not allow nulls. INSERT fails.
Okan
#5Okan Member Original PosterPosts: 26  
posted: 8/4/2019 9:49:06 PM(UTC)
I installed 7.1.118.10 and I still have the same issue. Do you know when this will be fixed?
Esben.D
#6Esben.D Member Administration Posts: 1,834  
posted: 8/8/2019 1:20:07 PM(UTC)
It lists that this should have been fixed in version 7.1.110.5. So it is best you contact support so they can help you further and maybe re-open the issue if needed.

Active Discussions

Lansweeper Remove all users from old domain
by  cmuter   Go to last post Go to first unread
Last post: 9/20/2019 8:03:58 PM(UTC)
Lansweeper Static IP Address
by  cycleheat  
Go to last post Go to first unread
Last post: 9/20/2019 4:07:16 PM(UTC)
Lansweeper Bitlocker Encryption Recovery Key no information found
by  Stephane   Go to last post Go to first unread
Last post: 9/20/2019 2:26:19 PM(UTC)
Lansweeper InTune Scanning Issues
by  Esben.D  
Go to last post Go to first unread
Last post: 9/20/2019 12:34:59 PM(UTC)
Lansweeper Office 365 scanning issues
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:23:30 PM(UTC)
Lansweeper Hard Drive Tracking - Start to Finish
by  Lone Jedi  
Go to last post Go to first unread
Last post: 9/19/2019 8:11:56 PM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Jpatterson   Go to last post Go to first unread
Last post: 9/19/2019 12:52:14 PM(UTC)
Lansweeper Cannot edit a ticket anymore
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 12:32:42 PM(UTC)