Re: CuteLiveSupport database not capturing chat session

  •  10-02-2013, 6:58 PM

    Re: CuteLiveSupport database not capturing chat session

    Discovered there were some errors in the application logs.  Curious if anyone has seen this before.

     

     

     

    Log Name:      Application

    Source:        ASP.NET 4.0.30319.0

    Date:          10/1/2013 10:47:41 AM

    Event ID:      1309

    Task Category: Web Event

    Level:         Warning

    Keywords:      Classic

    User:          N/A

    Computer:      **********

    Description:

    Event code: 3005

    Event message: An unhandled exception has occurred.

    Event time: 10/1/2013 10:47:41 AM

    Event time (UTC): 10/1/2013 3:47:41 PM

    Event ID: 65a903d8557e4a1ebd41db676444b4ad

    Event sequence: 75909

    Event occurrence: 1

    Event detail code: 0

     

    Application information:

        Application domain: /LM/W3SVC/27/ROOT/LiveSupport-1-130250917601231934

        Trust level: Full

        Application Virtual Path: /LiveSupport

        Application Path: …..\LiveSupport\

        Machine name: *********

     

    Process information:

        Process ID: 2080

        Process name: w3wp.exe

        Account name: ********

     

    Exception information:

        Exception type: SqlException

        Exception message: 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.TdsParser.ThrowExceptionAndWarning()

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteScalar()

       at CuteChat.SqlServerDataProvider.CreateSession(SupportSession session)

       at CuteChat.ChatDataManager.CreateSession(SupportSession session)

       at CuteChat.SupportSessionChannel.a()

       at CuteChat.ChatManager.AddPlaceItem(ChatPlaceItem item)

       at CuteChat.ChatManager.InternalConnect(ChatIdentity identity, ChatCookie cookie, NameValueCollection nvc)

       at CuteChat.ChatManager.Connect(ChatIdentity identity, ChatCookie cookie, NameValueCollection nvc)

       at CuteChat.ChatAjaxHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)

       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

     

     

     

    Request information:

        Request URL: ***********/LiveSupport/ChatAjax.ashx

        Request path: /LiveSupport/ChatAjax.ashx

        User host address: ***.***.***.***

        User: ***********

        Is authenticated: True

        Authentication Type: Forms

        Thread account name: **********

     

    Thread information:

        Thread ID: 38

        Thread account name: ***********

        Is impersonating: False

        Stack trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteScalar()

       at CuteChat.SqlServerDataProvider.CreateSession(SupportSession session)

       at CuteChat.ChatDataManager.CreateSession(SupportSession session)

       at CuteChat.SupportSessionChannel.a()

       at CuteChat.ChatManager.AddPlaceItem(ChatPlaceItem item)

       at CuteChat.ChatManager.InternalConnect(ChatIdentity identity, ChatCookie cookie, NameValueCollection nvc)

       at CuteChat.ChatManager.Connect(ChatIdentity identity, ChatCookie cookie, NameValueCollection nvc)

       at CuteChat.ChatAjaxHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)

       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

     

View Complete Thread