none
Water Mark delay and followed by ASA Job Failed Alert RRS feed

  • Question

  • Hi,

    I am quite new to Azure platform.

    I am getting frequent alerts like below:

    1. Water mark delay(1 min to 15 min delay) 

    and then followed by

    2.Stream analytics job failed Activity Alert (SQL Exception, pls see below for exception detail)

    Pls suggest what to do to get these  back to normal.

    the exception msg alert I got for Failed alert is below:

    Properties

    {"message Time":"2020-02-13 15:15:56Z","error":"System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nThe statement has been terminated. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\r\n at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)\r\n at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Streaming.Processors.OutputAdapters.SqlOutputAdapter.<SubmitTableAsync>d__51.MoveNext() in M:\\FXAGENT-012\\_work\\12\\s\\Product\\Source\\Framework\\OutputAdapters\\Adapters\\SQL\\SqlOutputAdapter.cs:line 698\r\nClientConnectionId:f2c6711f-fade-4af8-a319-2d61be494de8\r\nError Number:-2,State:0,Class:11\r\nClientConnectionId before routing:0a6a6d3f-6c76-42f1-95ea-7648c739c5ca\r\nRouting Destination:e4f25742e418.tr282.eastus2-a.worker.database.windows.net,11018","message":"SQL Server Azure instance 'clickstreaminprod.database.windows.net', table [monitoring-prod-sqldb].[corange_monitor] - Write 1 events timed out after 300 seconds. Retrying... This message has occurred 2 times in past 33 minutes","type":"SqlOutputAdapterWriteTimeout","correlation ID":"fe526aa6-3602-4701-b0e9-d637b5f69e7c"}



    SIva


    • Edited by Siva0018 Friday, February 14, 2020 2:08 PM
    Friday, February 14, 2020 2:07 PM

Answers

All replies