Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
MAXlength limit
CvR
#1 Posted : Thursday, June 10, 2010 2:07:07 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 10
Location: Nederland
The following erros are listed in the errorlog.txt several times:

6/10/2010 1:55:43 PM: Cannot set column 'softwareVersion'. The value violates the MaxLength limit of this column.
at System.Data.DataColumn.CheckMaxLength(DataRow dr)
at System.Data.DataColumn.CheckColumnConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at LansweeperService.mdlTracker.AddTracker(Int32 action, String section, DataRow datarow, String table, SqlConnection& sqlcon)

Can i change the MaxLength Limit easily or is there another fix available?

MarcoM
Lansweeper
#2 Posted : Thursday, June 10, 2010 5:54:46 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 9,982
Which version of Lansweeper are you using?
CvR
#3 Posted : Friday, June 11, 2010 7:46:16 AM

Rank: Premium user

Groups: Premium Users, Member
Posts: 10
Location: Nederland
Currently we're using 4.0.0.27 premium.

Started with 3.5.2.0 and upgraded to 4.x
Upgrade path: 4.0.0.18 > 4.0.0.21 > 4.0.0.24 > 4.0.0.27
Server is running Windows 2003 R2 Ent.Ed. with - a lansweeper dedicated - SQL Server 2008 Std.Ed.(10.0.2531)

MarcoM
Lansweeper
#4 Posted : Friday, June 11, 2010 10:11:22 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 9,982
Can you find the software/computer with this problem.
The field is currently 100 characters (which is long for a version number)
CvR
#5 Posted : Monday, June 21, 2010 1:34:09 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 10
Location: Nederland
Tried to find the computer / software but it isn't listed in the database, due to the maxlenght i quess. I checked the table and the longest value is appr. 50 chars.

...So i have to find it another way...any suggestions?
Lansweeper
#6 Posted : Monday, June 21, 2010 4:55:05 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 9,982
Do you have a computer scanned ok but without the software?
CvR
#7 Posted : Wednesday, June 23, 2010 9:18:46 AM

Rank: Premium user

Groups: Premium Users, Member
Posts: 10
Location: Nederland
Found a (corporate) deployed ms update (KB951608) that uses 115 characters in the version field!
Don't know if it's our own customized deployment or MS set the version info.

It's nearly impossible to edit all workstations that have this update installed. And lansweeper is working as it should so i'm ok with it for now....

Thanks for the support.

Marco

Found it in the windows registry
HKLM > Software > Microsoft > Windows > Currentversion > Uninstall > %software% > DisplayVersion
Lansweeper
#8 Posted : Monday, July 05, 2010 4:04:47 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 9,982
Please e-mail us so we can try a beta version to fix this.
CvR
#9 Posted : Tuesday, September 07, 2010 12:23:00 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 10
Location: Nederland
Fixed in version 4.0.0.36

Marco
Users browsing this topic
Guest (2)
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba