MAP Assessment fails

Nick Smith 1 Reputation point
2022-03-16T15:14:08.63+00:00

When running the assessment following the inventory scan the assessment fails, from the log file it looks as though a SQL job timesout:

<2022-03-16 12:08:58.25 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Perf_Assessment].[CreateMetricsPerTimeInterval]] : 1471797 ms
<2022-03-16 12:18:21.68 TID-1@ProgressPage,I> FormClosingHandler: Closing reason: UserClosing
<2022-03-16 12:18:31.98 TID-1@ScenarioDetailsContentControl,E> DataContextChangedHandler(): The DataContext has been assigned a null.
<2022-03-16 12:18:32.01 TID-20@ScuiFxTraceListener,W> <NavigationModelAdaptor.GetNode> Query for node 'msscnav://root/Windows' from provider 'msscnav://providers/definition' return no result.
<2022-03-16 12:18:32.01 TID-20@ScuiFxTraceListener,W> <TasksPublisher.OnParentNavigationNodeAvailable|WARN> No node returned for query to location 'msscnav://root/Windows', no tasks will be displayed for this location.
<2022-03-16 12:20:20.59 TID-19@ScuiFxTraceListener,W> <NavigationModelAdaptor.GetNode> Query for node 'msscnav://root/Windows' from provider 'msscnav://providers/definition' return no result.
<2022-03-16 12:20:20.59 TID-19@ScuiFxTraceListener,W> <TasksPublisher.OnParentNavigationNodeAvailable|WARN> No node returned for query to location 'msscnav://root/Windows', no tasks will be displayed for this location.
<2022-03-16 12:38:58.25 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 3 more time(s). Retrying in 5000 milliseconds.
|onSqlExceptionMessage = Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries].
|Exception message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
|The statement has been terminated.
<2022-03-16 13:09:03.63 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 2 more time(s). Retrying in 10000 milliseconds.
|onSqlExceptionMessage = Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries].
|Exception message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
|The statement has been terminated.
<2022-03-16 13:39:13.60 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 1 more time(s). Retrying in 15000 milliseconds.
|onSqlExceptionMessage = Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries].
|Exception message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
|The statement has been terminated.
<2022-03-16 14:09:28.96 AssessInventoryWorker@Analyzer,E> RunAssessments() - Assessment threw an exception:
|Microsoft.AssessmentPlatform.MapException: Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries]. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
|The statement has been terminated. ---> System.ComponentModel.Win32Exception: The wait operation timed out
| --- End of inner exception stack trace ---
| at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) | at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) | at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) | at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) | at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) | at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
| at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) | at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProcHelper(String storedProcName, Object[] parameters) | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.<>c__DisplayClassa.<ExecuteStoredProc>b__9() | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | --- End of inner exception stack trace --- | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProc(Nullable1 isolationLevel, String storedProcName, Object[] parameters)
| at Microsoft.AssessmentPlatform.Analytics.Assessments.StoredProcAssessment.RunAssessment(ThreadSafeFlag continueProcessingFlag, SecureString connectionString)
| at Microsoft.AssessmentPlatform.Analytics.Analyzer.RunAssessments(IEnumerable`1 assessments)
<2022-03-16 14:09:28.96 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
<2022-03-16 14:09:28.96 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
<2022-03-16 14:09:28.96 TID-7@TaskProcessor,I> Run: Completed. Status: Failed
<2022-03-16 14:09:29.44 TID-7@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.WpfConsole.Tasks.TaskProcessor
<2022-03-16 14:50:09.88 TID-1@ProgressPage,I> FormClosingHandler: Closing reason: UserClosing
<2022-03-16 15:03:11.67 TID-1@ScuiFxTraceListener,W> <WindowJobsService.Dispose|WARN> This instance of console jobs has already been disposed, returning.
|
<2022-03-16 15:03:11.68 TID-1@SqmSessionHelper,I> GetSession(): Started SQM session Database with AppId 101457990
<2022-03-16 15:03:11.68 TID-1@SqmSessionHelper,I> Upload(): 0 files queued. Skipping upload.

Can someone advise on what to do as I've seen no other queries relating to this online.

Thanks,

Nick

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 32,986 Reputation points MVP
    2022-03-16T19:56:42.763+00:00

    Could you please share with us the complete log file in order to investigate your case further. The log file should be present at “C:\Users\<current user profile>\AppData\Local\Microsoft\MAP\ MAP Toolkit” and is called MapToolkit.log

    One thing you can try is to increase the MAP SQL database timeout value. This article can help you achieve that. You are probably hitting the SQL timeout limit.

    Make sure MAP is not finding port TCP 135 blocked. Please read more about what happens when timeouts occur on this article.


  2. Nick Smith 1 Reputation point
    2022-03-18T15:25:53.393+00:00

    I cannot upload the log file as it's nearly 1.4GBs in size, I've increased the timeout time and it still fails.

    <2022-03-17 18:07:22.95 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 3 more time(s). Retrying in 5000 milliseconds.
    |onSqlExceptionMessage = Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries].
    |Exception message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    |The statement has been terminated.
    <2022-03-18 00:07:27.58 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 2 more time(s). Retrying in 10000 milliseconds.
    |onSqlExceptionMessage = Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries].
    |Exception message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    |The statement has been terminated.
    <2022-03-18 06:07:37.61 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 1 more time(s). Retrying in 15000 milliseconds.
    |onSqlExceptionMessage = Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries].
    |Exception message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    |The statement has been terminated.
    <2022-03-18 12:07:52.63 AssessInventoryWorker@Analyzer,E> RunAssessments() - Assessment threw an exception:
    |Microsoft.AssessmentPlatform.MapException: Caught SqlException running the stored procedure [Perf_Assessment].[SmoothenTimeSeries]. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    |The statement has been terminated. ---> System.ComponentModel.Win32Exception: The wait operation timed out
    | --- End of inner exception stack trace ---
    | at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) | at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) | at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) | at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) | at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) | at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
    | at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) | at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProcHelper(String storedProcName, Object[] parameters) | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.<>c__DisplayClassa.<ExecuteStoredProc>b__9() | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | --- End of inner exception stack trace --- | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProc(Nullable1 isolationLevel, String storedProcName, Object[] parameters)
    | at Microsoft.AssessmentPlatform.Analytics.Assessments.StoredProcAssessment.RunAssessment(ThreadSafeFlag continueProcessingFlag, SecureString connectionString)
    | at Microsoft.AssessmentPlatform.Analytics.Analyzer.RunAssessments(IEnumerable`1 assessments)
    <2022-03-18 12:07:52.63 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
    <2022-03-18 12:07:52.64 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
    <2022-03-18 12:07:52.64 TID-11@TaskProcessor,I> Run: Completed. Status: Failed
    <2022-03-18 12:07:53.17 TID-11@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.WpfConsole.Tasks.TaskProcessor
    <2022-03-18 15:22:39.43 TID-1@ProgressPage,I> FormClosingHandler: Closing reason: UserClosing