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,977  
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,536  
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,977  
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

Installer Sophos Silent Install
by  Esben.D   Go to last post Go to first unread
Last post: 2/14/2020 10:41:20 AM(UTC)
Installer Update Windows with PSWindowsUpdate
by  Patrick Kuhl  
Go to last post Go to first unread
Last post: 1/17/2020 5:32:57 PM(UTC)
Installer Windows 10 Upgrade
by  Anita   Go to last post Go to first unread
Last post: 1/16/2020 5:11:46 PM(UTC)
Installer NEC_UC_Suite-6.1_Install_No_Reboot
by  mchapman1963  
Go to last post Go to first unread
Last post: 12/24/2019 4:50:17 PM(UTC)
Installer Team Viewer Host update / install
by  BastiOn  
Go to last post Go to first unread
Last post: 11/27/2019 2:09:10 PM(UTC)
Installer Office 2016 Update
by  Cem Serdar   Go to last post Go to first unread
Last post: 11/7/2019 12:05:50 PM(UTC)
Installer Mozilla FireFox 70.0 Install
by  CyberCitizen  
Go to last post Go to first unread
Last post: 11/7/2019 12:09:14 AM(UTC)