Upgrade Lansweeper version 8.0.130.35 Issues

[ksherazksheraz]

Hi folks,

I was using the lansweeper version 7.2.108.6 with SQL Compact. So I upgraded it to the latest version 8.0.130.35.

I follow lansweeper guide and converted the sql compact into SQL LocalDB first. During the migration process, I got the following error message


Error

I ignored the above message with the impression DB migration has been done sucessfully and went ahead to the latest version upgrade process. So update was successful though it ask me licence key and scanning credentials after the update process as it is first time set up which was strange.

So now I am testing the things and I can see my helpdesk tickets are there. But when I run any report it says

Error: Report cannot be found.

I could not see some of my custom assets under the assets tab too.


Please advise what went wrong and how to fix the issues.

Thanks!

[FrankSc]

Hello,
The cause of the error will an asset for which the Description exceeds the length if this field in the table tblAssets.
Potentially the import stopped after the error and then you might miss data.

You could run a report on your environment now that holds the SQL compact database and look for the asset that holds the description that is too long and clean that up. Afterwards you can try to run the migration from SQL Compact to LocalDB again.
If the issue would persist we recommend sending a mail to support@lansweeper.com

[ksherazksheraz]

FrankSc wrote:
Hello,
The cause of the error will an asset for which the Description exceeds the length if this field in the table tblAssets.
Potentially the import stopped after the error and then you might miss data.

You could run a report on your environment now that holds the SQL compact database and look for the asset that holds the description that is too long and clean that up. Afterwards you can try to run the migration from SQL Compact to LocalDB again.
If the issue would persist we recommend sending a mail to support@lansweeper.com

Thanks for the swift reply. I have run the report and found out some of the descriptions a bit long but my questions are :

How would I know how long I can have the description?
Is there any limitation of numbers for the words should be in the description ?

Thanks

[FrankSc]

The length of that field is 1000 characters now. It's an nvarchar datatype. So any text longer than 1000 characters will not fit in it.