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, TaskCompletionSource
1 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](Nullable
1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | --- End of inner exception stack trace --- | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable
1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback1 callback) | at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProc(Nullable
1 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