
Server error after upgrading from 19.0.22849.7006 to 19.0.23102.7020
Since the forum is closed I write this here. I upgraded from 19.0.22849.7006 to 19.0.23102.7020 and if I try to access the admin page I receive the following error:
System.AggregateException: at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
Exception rethrown at [1]:
---> System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
--> (Inner exception 0) System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).
Answer

This looks related to another registered issue, which should be fixed in the next pre-release.
Just to be sure, though, do you see errors only on the admin page? Are you unable to access it at all?

I can't access the admin page, this message pops up and nothing works. I had to restore the backup from the previous version

Could you post the extensions you have installed? There shouldn't be any more compatibility issues with the new prerelease.

This is a known issue that I didn't recognize at first (sorry). Resolutions are documented here:

I tried a different editor, this one worked but I receive the same error
Access
Install an agent and connect to unattended devices.
×
Error
System.AggregateException: at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
Exception rethrown at [1]:
---> System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
--> (Inner exception 0) System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).

I tried to modify the db but for some reason I received a syntax error running the query so I changed the values manually:

This should have worked but when I started the service I received this error:
Access
Install an agent and connect to unattended devices.
×
Error
System.AggregateException: at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
Exception rethrown at [1]:
---> System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
--> (Inner exception 0) System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).
now I'm back to 19.0.22849.7006 again

We have same exact issue as well .. have to keep reverting back to 22849.7006 else we get the following regardless of which screen you try to access (the following is just from the base URL). Tried out the latest 23550.7047 but still getting same issues.
×Error
System.AggregateException: at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
Exception rethrown at [1]:
---> System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task`1[System.Object].get_Result () [0x00000] in :0
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
--> (Inner exception 0) System.ServiceModel.FaultException`1[ScreenConnect.SessionManagerFault]: SQL logic error or missing database
near "COLUMN": syntax error (Fault Detail is equal to ScreenConnect.SessionManagerFault).

Looks like the problem is connected to Ubuntu 18.04 only supporting Sqlite 3.22 while the RENAME COLUMN command was added in Sqlite 3.25 .. need to rewrite your sql logic to use the "rename the table, create a new table, and copy the data into the new table" method.
After trying out the method noted above in https://docs.connectwise.com/ConnectWise_Control_Documentation/Technical_support_bulletins/Internal_server_error_after_upgrading_Windows_32-bit_or_Linux_on-premises_server_to_19.0.23030 .. did get the new version to launch
Customer support service by UserEcho
This is a known issue that I didn't recognize at first (sorry). Resolutions are documented here:
https://docs.connectwise.com/ConnectWise_Control_Documentation/Technical_support_bulletins/Internal_server_error_after_upgrading_Windows_32-bit_or_Linux_on-premises_server_to_19.0.23030