Arlecho's ScreenConnect 6 releases

[Arlecho]

If I remember correctly there were just some tables in the sqlite files that are required, you could export them, backup the keys in the config file make a clean install and reimport everything

[Mr_sjappie]

I am not a super expert with sqllite, but worth a try to figure out what tables are needed.

[apssian]

The SessionDB problem is due to the OS. I have 2 Server 2022 VMs from Vultr and 2 from Azure.
Vultr machines have no issues with upgrade and both of the Azure are not working after the upgrade.
It has something to do with the OS.

[Arlecho]

What virtualisation host? Had some issues (a long, long time ago, with xen hosts that would just corrupt mssql databases)

[felipeit]

In vmware vsphere with Server 2022 works fine for me.

[apssian]

What virtualisation host? Had some issues (a long, long time ago, with xen hosts that would just corrupt mssql databases)

Vultr uses QEMU virtualization and Azure is Hyper-V

[Arlecho]

Do both platforms have issues?

[Mr_sjappie]

Did a test here with the upgrade to see if it is OS related..

Windows 11 baremetal, SessionDB problem
Windows 2022 server on ESXI, SessionDB problem
Windows 2019 server on ESXI, SessionDB problem

So here it is not an OS thing....

Still have to test with transfering the settings and tables from the SQLlite DB, but did not have time to dive into that yet... As I am not an expert, so need to read into everything and experiment.

If somebody has exact knowledge on what to export and import, then it would be handy for everybody with the SessionDB problem...
Otherwise I will dive into it after next week and circle back if it worked.

[apssian]

Get a VM from vultr - server 2022 and try it.

---

Server 2022 ISO link for Vultr

https://f005.backblazeb2.com/file/techsh...er2022.iso

[Mr_sjappie]

Did some testing and experimenting.

The problem comes from the "old" Session table in the database, there are all the session's and the SessionTypes with the label 0 are having the problems. I deleted those from the database, and I no more problems here.

Those are Support sessions in Connectwise, so you have to add Support session again if you need those. The normal Access session's are still working.

So if you have problem's look at the session.db with DB Browser. https://sqlitebrowser.org/