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,822  
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,822  
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 Lansweeper Reporting Old Assets as New
by  Jpatterson   Go to last post Go to first unread
Last post: Today at 8:09:00 PM(UTC)
Lansweeper Change History or Restore of Custom Reports?
by  GoHawks5  
Go to last post Go to first unread
Last post: Today at 4:20:52 PM(UTC)
Lansweeper agents can't create new tabs
by  Esben.D   Go to last post Go to first unread
Last post: Today at 3:51:07 PM(UTC)
Lansweeper Schedule/Calendar Ticket
by  enush  
Go to last post Go to first unread
Last post: Today at 3:46:21 PM(UTC)
Lansweeper Admins view all helpdesk tickets
by  Esben.D   Go to last post Go to first unread
Last post: Today at 3:44:50 PM(UTC)
Lansweeper Features Questions
by  datev   Go to last post Go to first unread
Last post: Today at 2:03:03 PM(UTC)
Lansweeper Assets disappearing
by  Ian.Prentice  
Go to last post Go to first unread
Last post: Today at 11:39:52 AM(UTC)