Hello,
We were testing out the feature to join/leave chat. I was the customer, clicked to connect. Our rep Jamie accepted the connection in his operator client. Our rep Peter then right clicked on the Customer entry and said Join. This worked, both were able to IM me (the customer). Then Jamie dropped off clicking the X in the Conversations pane. Peter and I were able to chat a few more lines, and then the system seemed to hang. The browser chat client said the server had been reset and that the chat room was closed. The MainForm in the operator app hung and then crashed. It took a couple tries to restart it.
Exception from the server:
System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at CuteChat.SqlServerDataProvider.LogMessage(ChatPlace place, ChatIdentity sender, ChatIdentity target, Boolean whisper, String text, String html)
at CuteChat.ChatDataManager.e.Process(IChatDataProvider provider)
at CuteChat.ChatDataManager.Maintain()
Exception from the client: I don't see anyqhere it gets logged.
Are there any known bugs here? Anything we did wrong on the transfers? Our goal was to test everything end to end:
Jamie Accepts customer chat
Jamie chats, needs Peter
Jamie PM's peter using Agent panel
Peter Joins customer chat
Jamie drops off
Peter chats with customer
Peter wants to grab Jamie to wrap up
Peter messages Jamie on Agent panel
Jamie joins customer chat again
Peter drops off
Jamie wraps up and drops off
Are we hitting anything unstable or is there anything we should avoid? Thanks,
-Andrew