0
Known issue

Server error after upgrading from 19.0.22849.7006 to 19.0.23102.7020

frufru 10 months ago updated by RSS Grinders 9 months ago 10

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).

ConnectWise Control Version:
11
Server Affected:
Host Client Affected:
Guest Client Affected:

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

just tried it with 19.0.23234.7026 with the same result

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

Advanced Configuration Editor and  Edit App.Config Settings

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