SqlTypeException Error since update toDevolution Server 2022.2.8.0
Hello All,
since the update of the Devolutions Server to version 2022.2.8.0 we receive very often from different users the following error. This error is sent by the Devolutions Server itself via mail through the integrated Email Notification.
Unfortunately this error message does not tell me. Therefore I need your support.
Thanks a lot
Alex
Error:
SqlTypeException - EventSubscription at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) at Microsoft.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at Microsoft.Data.SqlClient.TdsParser.WriteUnterminatedValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj, Int32 paramSize, Boolean isDataFeed) at Microsoft.Data.SqlClient.TdsParser.TDSExecuteRPCAddParameter(TdsParserStateObject stateObj, SqlParameter param, MetaType mt, Byte options, SqlCommand command, Boolean isAnonymous) at Microsoft.Data.SqlClient.TdsParser.TdsExecuteRPC(SqlCommand cmd, _SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Devolutions.Server.DatabaseManager.<>c__DisplayClass19_0.<ExecuteNonQuery>b__0(DbCommand dbCommand) at Devolutions.Server.DatabaseManager.ExecuteCommand(DbConnection dbConnection, DbTransaction dbTransaction, String sql, IEnumerable`1 parameters, CommandType commandType, Action`1 action) at Devolutions.Server.DatabaseManager.ExecuteNonQuery(DbConnection dbConnection, DbTransaction dbTransaction, String sql, IEnumerable`1 parameters, CommandType commandType) at Devolutions.Server.DatabaseManager.ExecuteNonQuery(String sql, IEnumerable`1 parameters, CommandType commandType) at Devolutions.Server.Business.NotificationV2.NotificationEventManager.InsertEvent(NotificationEvent notificationEvent, PamBatchExecution batch) at Devolutions.Server.Business.NotificationV2.NotificationEventManager.SaveEvent(NotificationEvent notificationEvent, PamBatchExecution batch)
Source:
System.Data.Common
All Comments (4)
Hello Alex,
Thank you for submitting this issue.
Have you set any notifications or is there any user subscriptions in Administration - Notifications?
Are you able to determine what user action has triggered this error message? Is there any log entry that correspond to this error in Reports - Activity Logs on the DVLS web UI?
Best regards,
Érica Poirier
Hello Erica
Sorry that it took a little longer.
I have no entries available in the subscriptions.
In the Activity Logs I searched and found a match with one with an email.
SSH and RDP connections are established on our end via an SSH VPN gateway, which was established via these instructions.
https://blog.devolutions.net/2020/02/how-to-configure-a-secure-gateway-in-remote-desktop-manager/
Terminating such a VPN connection brought the Observed error message in the Activity Log.
Therefore, I assume that starting and closing such a n SSH VPN connection generates such error messages.
At the moment we are working on the migration to a datacenter where we will use the Devolutions Gateway. We already have a license for the Devolutions Gateway.
I think this error will then no longer occur.
Thanks a lot
Alex
Hello Alex,
Thank you for your collaboration and the information. We will investigate further more and we will keep you updated.
As for the Gateway, once you will use it in place of the SSH VPN Gateway, I confirm this will prevent getting the error messages as our QA already tested that possibility without getting any errors.
Best regards,
Érica Poirier
Hello Alex,
Thank you for your patience on that issue. We have found the problem and it has been fixed internally. The next DVLS version 2022.3 will contain the fix for this issue. So as these error messages doesn't affect the DVLS functionalities, you can ignore them until the new version will be available.
Best regards,
Érica Poirier