none
Assessment is failing

    질문

  • 0

    I have had a collection running for a number of weeks and it has stopped on the scheduled day.

    I have noticed that the collect performance data field is incomplete.

    The error: Your performance data haas not completed assessment.

    When I try to manually run an assessment it fail

    Please could some one shed any insight as to how to complete the asseesment.

    I can not destroy this data and restart.

    Also my log file is 3gb, is this normal?

    2012년 3월 15일 목요일 오후 7:28

답변

모든 응답

  • I would say 3 GB is abnormal unless you’ve had MAP installed for a while and run a lot of inventories that had a lot of errors.

    Try this:

    1. Make sure MAP isn’t running
    2. Rename the log file to something like ‘MAPbackupLog’ or ‘OldMAPLog’ or whatever makes sense to you
    3. Start MAP, this will create a new log file
    4. Open the database with the performance data you want
    5. Go to the ‘Tools’ menu and choose ‘Refresh Inventory Assessment
    6. Once it fails exit MAP
    7. Open the log and post the results

    Also, what is the file size of the database at this point?


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    2012년 3월 15일 목요일 오후 10:53
  • Here is the logs of the new file (is there no attachment option?)

    Also the database is 8.5 GB it IS express. is express 8 of 16 gb support

    2012-03-16 12:36:08.10 TID-1@DefaultLogRecordSink,I>
       |========================================
       |
       |Logging started at 03/16/2012 12:36:08
       |    Application:     Microsoft.AssessmentPlatform.UI.Console.exe Build 6.5.4226.0 retail
       |    Platform:        Win32NT 5.2.3790.131072 Service Pack 2
       |    UI Culture:      en-US
       |    Culture:         en-GB
       |    Architecture:    32-bit
       |    OS Product Name: Microsoft(R) Windows(R) Server 2003, Standard Edition
       |
       |========================================
    <2012-03-16 12:36:08.46 TID-1@SqmSessionHelper,I> GetSession(): Started SQM session Main with AppId 101457979
    <2012-03-16 12:36:08.46 TID-1@MAPSMain,I> ConsoleMain.Main: Checking version values.
    <2012-03-16 12:36:08.53 TID-1@AnalyticsConfigXml,I> Got Download URLs, URL for Inventory -> http://go.microsoft.com/fwlink/?LinkId=115180, URL for Report -> http://go.microsoft.com/fwlink/?LinkId=115181, URL for Inventory and Report -> http://go.microsoft.com/fwlink/?LinkId=115182, URL for Download Only -> http://go.microsoft.com/fwlink/?LinkId=115183, URL for Device Version -> http://go.microsoft.com/fwlink/?LinkId=152572
    <2012-03-16 12:36:08.53 TID-1@MAPSMain,I> CheckVersion: VersionAction reg key value: ''
    <2012-03-16 12:36:08.55 TID-1@MAPSMain,I> Open Master UI Console
    <2012-03-16 12:36:08.92 TID-1@ConsoleWindow,I> ConsoleWindow.CheckReferenceMaterialsDownload: Download updates option enabled. Spawning thread to download of reference materials.
    <2012-03-16 12:36:08.92 TID-5@ConsoleWindow,I> ConsoleWindow.DownloadReferenceMaterials: Starting reference materials download.
    <2012-03-16 12:36:08.92 TID-5@DownloadUtil,I> Starting DownloadUtil()
    <2012-03-16 12:36:08.99 TID-1@WunderBarBasePage,I> DisplayViewPage: Opening view type: RootPageWpfHost`2
    <2012-03-16 12:36:09.91 TID-5@DownloadUtil,I> The hosted content in the directory is the latest. Download is not required.
    <2012-03-16 12:36:09.91 TID-5@ConsoleWindow,I> ConsoleWindow.DownloadReferenceMaterials: Completed reference materials download. Status: success
    <2012-03-16 12:36:14.75 TID-9@OpenCreateDbDialogViewModel,I> OpenAnExistingDatabase(LBL_Servers_Jan12_v1): Opening database. Version: 3720
    <2012-03-16 12:36:23.11 TID-1@ConsoleWindow,I> OnRefreshAssessmentCommand() - The user chose to refresh the inventory assessment.
    <2012-03-16 12:36:23.37 TID-10@TaskProcessor,I> Run: Processing task: 'Assess inventory'
    <2012-03-16 12:36:23.37 TID-10@TaskProcessor,I> StartWorkers: Starting worker thread: 'AssessInventoryWorker'
    <2012-03-16 12:36:23.37 AssessInventoryWorker@TaskProcessor,I> RunWorker: Running worker: 'AssessInventoryWorker'
    <2012-03-16 12:36:23.37 AssessInventoryWorker@Analyzer,I> Getting Download Directory
    <2012-03-16 12:36:23.37 AssessInventoryWorker@Analyzer,I> Got Download Directory
    <2012-03-16 12:36:23.37 AssessInventoryWorker@AnalyticsConfigXml,I> Got Download URLs, URL for Inventory -> http://go.microsoft.com/fwlink/?LinkId=115180, URL for Report -> http://go.microsoft.com/fwlink/?LinkId=115181, URL for Inventory and Report -> http://go.microsoft.com/fwlink/?LinkId=115182, URL for Download Only -> http://go.microsoft.com/fwlink/?LinkId=115183, URL for Device Version -> http://go.microsoft.com/fwlink/?LinkId=152572
    <2012-03-16 12:36:23.76 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentStartedEventHandler: Assessment start event.
    <2012-03-16 12:36:26.97 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[dbo].[sp_remove_inactive_ip_addresses]] : 3203 ms
    <2012-03-16 12:36:29.39 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[dbo].[sp_remove_duplicate_devices]] : 2422 ms
    <2012-03-16 12:36:29.47 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[dbo].[sp_post_inventory_setting]] : 78 ms
    <2012-03-16 12:36:29.47 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'StoredProcAssessment': 5703 ms
    <2012-03-16 12:36:29.48 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SetAssessmentFlagsAssessment': 16 ms
    <2012-03-16 12:36:32.36 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_WindowsInstalledSoftwareAssessment] : 2875 ms
    <2012-03-16 12:36:34.59 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_device_assessment] : 2234 ms
    <2012-03-16 12:36:34.64 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_UsageTrackerForefrontEndpointProtection] : 47 ms
    <2012-03-16 12:36:36.56 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_hardware_assessment] : 1922 ms
    <2012-03-16 12:36:39.06 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_HostGuestRelationships] : 2500 ms
    <2012-03-16 12:36:39.63 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_windows7_assessment] : 578 ms
    <2012-03-16 12:36:40.34 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_office2010_assessment] : 703 ms
    <2012-03-16 12:36:41.31 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_server_assessment] : 969 ms
    <2012-03-16 12:36:55.16 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_AggregatePerfData] : 13860 ms
    <2012-03-16 12:36:56.29 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_ws2008r2_assessment] : 1125 ms
    <2012-03-16 12:36:57.60 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_SecurityCenter] : 1312 ms
    <2012-03-16 12:36:59.43 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_server_role_assessment] : 1828 ms
    <2012-03-16 12:36:59.49 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_IEDiscovery] : 63 ms
    <2012-03-16 12:37:01.16 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_office365_assessment] : 1672 ms
    <2012-03-16 12:37:03.13 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_UsageTrackerExchange] : 1968 ms
    <2012-03-16 12:37:03.13 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'StoredProcAssessment': 33656 ms
    <2012-03-16 12:37:06.77 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SpecIntApproxAssessment': 3641 ms
    <2012-03-16 12:37:06.77 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SetAssessmentFlagsAssessment': 0 ms
    <2012-03-16 12:37:07.77 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SqmDataAssessment': 1000 ms
    <2012-03-16 12:37:07.78 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SetAssessmentFlagsAssessment': 16 ms
    <2012-03-16 13:09:04.60 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 3 more time(s). Retrying in 5000 milliseconds.
       |onSqlExceptionMessage = Caught SqlException trying to run the SQL statement "
       |      begin
       |
       |      if object_id('[performance_metric_memory_GB]') is not null
       |      drop table [performance_metric_memory_GB]
       |
       |      select Q.device_number, Q.time_interval, Q.metric
       |      into [performance_metric_memory_GB]
       |      from (select
       |        mem.device_number,
       |        ti.time_interval,
       |        (ha.[total_physical_memory] - min(mem.available_bytes))/1024/1024/1024 as metric
       |        from performance_memory mem
       |        inner join [dbo].[hardware_assessment] ha
       |        on mem.[device_number] = ha.[device_number]
       |        inner join performance_time_intervals ti
       |        on mem.collection_datetime >= ti.start_datetime
       |        and mem.collection_datetime < ti.end_datetime
       |        and mem.committed_bytes is not null
       |        group by
       |        mem.device_number,
       |        ti.time_interval,
       |        ha.[total_physical_memory]) Q
       |      inner join performance_devices_view D
       |      on Q.device_number = D.device_number
       |
       |      /* interpolate missing data */
       |
       |      insert into [performance_metric_memory_GB] (device_number, time_interval, metric)
       |      select
       |      dev.device_number,
       |      ti.time_interval,
       |      coalesce(H.metric, D.metric, A.metric)
       |      from performance_devices_view dev
       |      cross join performance_time_intervals ti
       |      left join [performance_metric_memory_GB] M1
       |      on ti.time_interval = M1.time_interval
       |      and dev.device_number = M1.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      T.hour_index,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      inner join performance_time_intervals T
       |      on T.time_interval = M.time_interval
       |      group by
       |      M.device_number,
       |      T.hour_index ) H
       |      on ti.hour_index = H.hour_index
       |      and dev.device_number = H.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      T.date_index,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      inner join performance_time_intervals T
       |      on T.time_interval = M.time_interval
       |      group by
       |      M.device_number,
       |      T.date_index ) D
       |      on ti.date_index = D.date_index
       |      and dev.device_number = D.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      group by
       |      M.device_number ) A
       |      on dev.device_number = A.device_number
       |      where M1.device_number is null
       |      and A.metric is not null
       |
       |      create clustered index ci_primarykey on [performance_metric_memory_GB] (device_number, time_interval)
       |
       |      end
       |    ".
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       |The statement has been terminated.
    <2012-03-16 13:39:09.15 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 2 more time(s). Retrying in 10000 milliseconds.
       |onSqlExceptionMessage = Caught SqlException trying to run the SQL statement "
       |      begin
       |
       |      if object_id('[performance_metric_memory_GB]') is not null
       |      drop table [performance_metric_memory_GB]
       |
       |      select Q.device_number, Q.time_interval, Q.metric
       |      into [performance_metric_memory_GB]
       |      from (select
       |        mem.device_number,
       |        ti.time_interval,
       |        (ha.[total_physical_memory] - min(mem.available_bytes))/1024/1024/1024 as metric
       |        from performance_memory mem
       |        inner join [dbo].[hardware_assessment] ha
       |        on mem.[device_number] = ha.[device_number]
       |        inner join performance_time_intervals ti
       |        on mem.collection_datetime >= ti.start_datetime
       |        and mem.collection_datetime < ti.end_datetime
       |        and mem.committed_bytes is not null
       |        group by
       |        mem.device_number,
       |        ti.time_interval,
       |        ha.[total_physical_memory]) Q
       |      inner join performance_devices_view D
       |      on Q.device_number = D.device_number
       |
       |      /* interpolate missing data */
       |
       |      insert into [performance_metric_memory_GB] (device_number, time_interval, metric)
       |      select
       |      dev.device_number,
       |      ti.time_interval,
       |      coalesce(H.metric, D.metric, A.metric)
       |      from performance_devices_view dev
       |      cross join performance_time_intervals ti
       |      left join [performance_metric_memory_GB] M1
       |      on ti.time_interval = M1.time_interval
       |      and dev.device_number = M1.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      T.hour_index,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      inner join performance_time_intervals T
       |      on T.time_interval = M.time_interval
       |      group by
       |      M.device_number,
       |      T.hour_index ) H
       |      on ti.hour_index = H.hour_index
       |      and dev.device_number = H.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      T.date_index,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      inner join performance_time_intervals T
       |      on T.time_interval = M.time_interval
       |      group by
       |      M.device_number,
       |      T.date_index ) D
       |      on ti.date_index = D.date_index
       |      and dev.device_number = D.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      group by
       |      M.device_number ) A
       |      on dev.device_number = A.device_number
       |      where M1.device_number is null
       |      and A.metric is not null
       |
       |      create clustered index ci_primarykey on [performance_metric_memory_GB] (device_number, time_interval)
       |
       |      end
       |    ".
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       |The statement has been terminated.
    <2012-03-16 14:09:18.70 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 1 more time(s). Retrying in 15000 milliseconds.
       |onSqlExceptionMessage = Caught SqlException trying to run the SQL statement "
       |      begin
       |
       |      if object_id('[performance_metric_memory_GB]') is not null
       |      drop table [performance_metric_memory_GB]
       |
       |      select Q.device_number, Q.time_interval, Q.metric
       |      into [performance_metric_memory_GB]
       |      from (select
       |        mem.device_number,
       |        ti.time_interval,
       |        (ha.[total_physical_memory] - min(mem.available_bytes))/1024/1024/1024 as metric
       |        from performance_memory mem
       |        inner join [dbo].[hardware_assessment] ha
       |        on mem.[device_number] = ha.[device_number]
       |        inner join performance_time_intervals ti
       |        on mem.collection_datetime >= ti.start_datetime
       |        and mem.collection_datetime < ti.end_datetime
       |        and mem.committed_bytes is not null
       |        group by
       |        mem.device_number,
       |        ti.time_interval,
       |        ha.[total_physical_memory]) Q
       |      inner join performance_devices_view D
       |      on Q.device_number = D.device_number
       |
       |      /* interpolate missing data */
       |
       |      insert into [performance_metric_memory_GB] (device_number, time_interval, metric)
       |      select
       |      dev.device_number,
       |      ti.time_interval,
       |      coalesce(H.metric, D.metric, A.metric)
       |      from performance_devices_view dev
       |      cross join performance_time_intervals ti
       |      left join [performance_metric_memory_GB] M1
       |      on ti.time_interval = M1.time_interval
       |      and dev.device_number = M1.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      T.hour_index,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      inner join performance_time_intervals T
       |      on T.time_interval = M.time_interval
       |      group by
       |      M.device_number,
       |      T.hour_index ) H
       |      on ti.hour_index = H.hour_index
       |      and dev.device_number = H.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      T.date_index,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      inner join performance_time_intervals T
       |      on T.time_interval = M.time_interval
       |      group by
       |      M.device_number,
       |      T.date_index ) D
       |      on ti.date_index = D.date_index
       |      and dev.device_number = D.device_number
       |      left join (
       |      select
       |      M.device_number,
       |      avg(M.metric) as metric
       |      from [performance_metric_memory_GB] M
       |      group by
       |      M.device_number ) A
       |      on dev.device_number = A.device_number
       |      where M1.device_number is null
       |      and A.metric is not null
       |
       |      create clustered index ci_primarykey on [performance_metric_memory_GB] (device_number, time_interval)
       |
       |      end
       |    ".
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       |The statement has been terminated.
    <2012-03-16 14:21:19.86 TID-1@ProgressPage,I> ProgressPage.FormClosingHandler: Closing reason: UserClosing
    <2012-03-16 14:39:33.36 AssessInventoryWorker@Analyzer,E> RunAssessments() - Assessment threw an exception:
       |System.NullReferenceException: Object reference not set to an instance of an object.
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable`1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback`1 callback)
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteNonQuery(Nullable`1 isolationLevel, String sql)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceEngine.ExecuteSqlStatement(String sql)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceAnalysisEngine.CreateMetric(String metricName)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceAnalysisEngine.CreateMetrics(Int32 intervalSizeMinutes)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceAnalysisEngine.RunPerformanceAnalysis(ThreadSafeFlag continueProcessingFlag, SecureString connectionString, Boolean computeSpecIntApproximations, Boolean computeNormalizedPerfMetrics)
       |   at Microsoft.AssessmentPlatform.Analytics.Assessments.PerfDataAssessment.RunAssessment(ThreadSafeFlag continueProcessingFlag, SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.Analytics.Analyzer.RunAssessments(IEnumerable`1 assessments)
    <2012-03-16 14:39:33.36 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
    <2012-03-16 14:39:33.36 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
    <2012-03-16 14:39:33.36 TID-10@TaskProcessor,I> Run: Completed. Status: Failed
    <2012-03-16 14:39:33.84 TID-10@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.Console.Tasks.TaskProcessor

    Here is the logs of the new filw

    2012년 3월 16일 금요일 오후 4:23
  • You must have a lot of data. So much data that SQL needs more time than the 30 minutes we give it to process one of the stored procedures. You can increase the timeout MAP uses by following these steps:

    1. Exit MAP.
    2. Open the AppConifgInfo.xml file
      1. Located C:\Program Files\Microsoft Assessment and Planning Toolkit\bin
    3. Modify the SqlCommandTimeout value from 1800 to 21600 (this will change the timeout from 30 minutes to 6 hours)
    4. Restart MAP and try running Tools > Refresh Inventory Assessment again.

    Since the transactions weren’t completing in 30 minutes (the original timeout) the process of refreshing the inventory assessment will take at least 30 min and possibly a good bit longer.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    2012년 3월 20일 화요일 오후 11:23
  • Extending the timeout failed. I have added the remainder of the log. Please advise

       |    ". ---> System.Data.SqlClient.SqlException: Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
       |   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()
       |   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       |   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       |   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       |   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.<>c__DisplayClass4.<ExecuteNonQuery>b__3()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable`1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback`1 callback)
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.DoWorkInTransaction[T](Nullable`1 isolationLevel, String onSqlExceptionMessage, TransactionWorkCallback`1 callback)
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteNonQuery(Nullable`1 isolationLevel, String sql)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceEngine.ExecuteSqlStatement(String sql)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceAnalysisEngine.CreateMetric(String metricName)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceAnalysisEngine.CreateMetrics(Int32 intervalSizeMinutes)
       |   at Microsoft.AssessmentPlatform.Analytics.PerformanceAnalysisEngine.RunPerformanceAnalysis(ThreadSafeFlag continueProcessingFlag, SecureString connectionString, Boolean computeSpecIntApproximations, Boolean computeNormalizedPerfMetrics)
       |   at Microsoft.AssessmentPlatform.Analytics.Assessments.PerfDataAssessment.RunAssessment(ThreadSafeFlag continueProcessingFlag, SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.Analytics.Analyzer.RunAssessments(IEnumerable`1 assessments)
    <2012-03-21 11:35:55.94 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
    <2012-03-21 11:35:55.94 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
    <2012-03-21 11:35:55.94 TID-10@TaskProcessor,I> Run: Completed. Status: Failed
    <2012-03-21 11:35:56.52 TID-10@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.Console.Tasks.TaskProcessor
    <2012-03-21 11:56:15.79 TID-1@SqmSessionHelper,I> Upload(): 1 SQM file(s) queued for upload, with total timeout set to 60000 milliseconds.
    <2012-03-21 11:56:19.39 TID-1@SqmSessionHelper,I> Upload(): Total SQM upload time was 3636 milliseconds.
    <2012-03-21 11:56:19.39 TID-1@MAPSMain,I> ConsoleMain.Main: Application exiting.
    <2012-03-21 13:18:14.85 TID-1@DefaultLogRecordSink,I>
       |========================================
       |
       |Logging started at 03/21/2012 13:18:14
       |    Application:     Microsoft.AssessmentPlatform.UI.Console.exe Build 6.5.4226.0 retail
       |    Platform:        Win32NT 5.2.3790.131072 Service Pack 2
       |    UI Culture:      en-US
       |    Culture:         en-GB
       |    Architecture:    32-bit
       |    OS Product Name: Microsoft(R) Windows(R) Server 2003, Standard Edition
       |
       |========================================
    <2012-03-21 13:18:19.15 TID-1@SqmSessionHelper,I> GetSession(): Started SQM session Main with AppId 101457979
    <2012-03-21 13:18:19.15 TID-1@MAPSMain,I> ConsoleMain.Main: Checking version values.
    <2012-03-21 13:18:21.29 TID-1@AnalyticsConfigXml,I> Got Download URLs, URL for Inventory -> http://go.microsoft.com/fwlink/?LinkId=115180, URL for Report -> http://go.microsoft.com/fwlink/?LinkId=115181, URL for Inventory and Report -> http://go.microsoft.com/fwlink/?LinkId=115182, URL for Download Only -> http://go.microsoft.com/fwlink/?LinkId=115183, URL for Device Version -> http://go.microsoft.com/fwlink/?LinkId=152572
    <2012-03-21 13:18:21.29 TID-1@MAPSMain,I> CheckVersion: VersionAction reg key value: ''
    <2012-03-21 13:18:21.36 TID-1@MAPSMain,I> Open Master UI Console
    <2012-03-21 13:18:23.82 TID-1@ConsoleWindow,I> ConsoleWindow.CheckReferenceMaterialsDownload: Download updates option enabled. Spawning thread to download of reference materials.
    <2012-03-21 13:18:23.83 TID-5@ConsoleWindow,I> ConsoleWindow.DownloadReferenceMaterials: Starting reference materials download.
    <2012-03-21 13:18:23.83 TID-5@DownloadUtil,I> Starting DownloadUtil()
    <2012-03-21 13:18:24.14 TID-1@WunderBarBasePage,I> DisplayViewPage: Opening view type: RootPageWpfHost`2

    2012년 3월 21일 수요일 오후 1:21
  • System.Data.SqlClient.SqlException: Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    How much free disk space do you have on your machine? If you have plenty of free disk space, than the problem could be with your TempDB. Try restarting the SQL Service, this will create a new TempDB and hopefully solve the problem.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    2012년 3월 22일 목요일 오후 10:15
  • Thanks Michael.

    I am currently running a second analysis using MAP6.5.

    Are there further free tools that can assist with the analysis. I need to report on the existing VMware estate but with the option for potential Hyper V implemntation or hybrid VMW/HY-Vf.

    I need further tools to assist with my report/proposals

    Also trouble shooting machines where inventorys have failed. What do you do?

    Thanks Again for the original answer

    2012년 5월 3일 목요일 오전 8:56
  • Thanks Michael,

    I am running a new assessment and was wondering what tools you use for an assessment to assist with the reporting/proposal.

    I am running the MAP6.5 simultaniously with VMWare capacity planeer for the potential hybrid solution.

    I have veeam One Free reunning reports for the VMW but for the Hy-V I have no tools for further  analysis can you advise.

    Thanks

    2012년 5월 3일 목요일 오전 8:59
  • You can use the server consolidation feature in MAP for Hyper-V virtual machine capacity planning. MAP can also discover and inventory the existing VMware machines in your environment. And starting in MAP 7.0, you will be able to collect Linux performance data for your virtualization planning.

    The MAP 7.0 beta will begin soon. If you are interested in participating in the beta, see the announcement at the top of the MAP Forums for instructions on how to join.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    2012년 5월 3일 목요일 오후 10:41
  • For the inventory errors, look at these articles:

    For additional resources, see:


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • 답변으로 표시됨 Riley122 2012년 12월 3일 월요일 오후 12:25
    2012년 5월 3일 목요일 오후 10:44
  • This did not work for me however I did find and resolve the issue below.

    When I reviewed the logs I found the following SQL Exception being thrown:

    |Microsoft.AssessmentPlatform.MapException: Caught SqlException running the stored procedure [WinClient_Assessment].[LicensingAssessmentProc]. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'LicensingAssessment_pk'. Cannot insert duplicate key in object 'WinClient_Assessment.LicensingAssessment'. The duplicate key value is (71cf0e1f-bcb3-4522-8e35-0ed11df9a78c).

    |The statement has been terminated.

    Steps I took to resolve this:

    1) Exit all running instances of the MAP Toolkit

    2) Install SQL Management Studio

    2) Connect to: (LocalDB)\MAPToolkit

    3) Expand Databases and Find the Database name that you created when running your MAP Scan

    4) Expand Tables and find the table named: WinClient_Assessment.LicensingAssessment

    5) Expand Keys and Find: "LicensingAssessment_pk", delete this key

    You should now be able to re-launch the MAP Toolkit and successfully re-run the assessment. 




    • 편집됨 gdgx 2013년 10월 1일 화요일 오후 4:32
    2013년 10월 1일 화요일 오후 4:28