locked
Inventory assessment fails RRS feed

  • Question

  •  

    I am trying to run MAP toolkit 6 but i am not able to get the inventory assessment report. Find the log below.

     

     

    |========================================

       |

       |Logging started at 09/07/2011 10:37:22

       |    Application:     Microsoft.AssessmentPlatform.UI.Console.exe Build 6.0.3939.0 retail

       |    Platform:        Win32NT 5.1.2600.196608 Service Pack 3

       |    UI Culture:      en-US

       |    Culture:         en-GB

       |    Architecture:    32-bit

       |    OS Product Name: Microsoft Windows XP Professional

       |

       |========================================

    <2011-09-07 10:37:25.03 TID-1@MAPSMain,I> ConsoleMain.Main: Checking version values.

    <2011-09-07 10:37:25.89 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

    <2011-09-07 10:37:25.89 TID-1@MAPSMain,I> CheckVersion: VersionAction reg key value: ''

    <2011-09-07 10:37:25.94 TID-1@MAPSMain,I> Open Master UI Console

    <2011-09-07 10:37:27.00 TID-1@ConsoleWindow,I> ConsoleWindow.CheckReferenceMaterialsDownload: Download updates option enabled. Spawning thread to download of reference materials.

    <2011-09-07 10:37:27.00 TID-5@ConsoleWindow,I> ConsoleWindow.DownloadReferenceMaterials: Starting reference materials download.

    <2011-09-07 10:37:27.00 TID-5@DownloadUtil,I> Starting DownloadUtil()

    <2011-09-07 10:37:27.19 TID-1@WunderBarBasePage,I> DisplayViewPage: Opening view type: InventoryAssessmentOverview

    <2011-09-07 10:37:28.44 TID-5@DownloadUtil,E> An exception occurred in method: DownloadUtil:GetDownloadFromURL()

       |Exception message: The remote server returned an error: (407) Proxy Authentication Required.

       |Stack trace:

       |   at System.Net.HttpWebRequest.GetResponse()

       |   at Microsoft.AssessmentPlatform.UI.Console.DownloadUtil.GetDownloadFromURL(String installDir, String url)

       |Location of error report:

       |   at Microsoft.AssessmentPlatform.UI.Console.DownloadUtil.GetDownloadFromURL(String installDir, String url)

       |

    <2011-09-07 10:37:28.44 TID-5@ConsoleWindow,I> ConsoleWindow.DownloadReferenceMaterials: Completed reference materials download. Status: fail

    <2011-09-07 10:37:35.33 TID-5@OpenCreateDbDialogViewModel,I> OpenAnExistingDatabase(A5007_new): Opening database. Version: 3427

    <2011-09-07 10:37:43.25 TID-1@WunderBarBasePage,I> DisplayViewPage(): View 'MachineInventory' failed a view predicate. Reason message: Inventory data needs to be assessed.

    <2011-09-07 10:37:43.25 TID-1@WunderBarBasePage,I> DisplayViewPage: Opening view type: PredicateFailedView

    <2011-09-07 10:37:49.01 TID-1@ConsoleWindow,I> OnRefreshAssessmentCommand() - The user chose to refresh the inventory assessment.

    <2011-09-07 10:37:49.36 TID-5@TaskProcessor,I> TaskProcessor.Run: Processing task: 'Assess inventory'

    <2011-09-07 10:37:49.36 TID-5@TaskProcessor,I> TaskProcessor.StartWorkers: Starting worker thread: 'AssessInventoryWorker'

    <2011-09-07 10:37:49.36 AssessInventoryWorker@TaskProcessor,I> TaskProcessor.RunWorker: Running worker: 'AssessInventoryWorker'

    <2011-09-07 10:37:49.37 AssessInventoryWorker@Analyzer,I> Getting Download Directory

    <2011-09-07 10:37:49.37 AssessInventoryWorker@Analyzer,I> Got Download Directory

    <2011-09-07 10:37:49.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

    <2011-09-07 10:37:49.73 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentStartedEventHandler: Assessment start event.

    <2011-09-07 10:37:52.70 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[dbo].[sp_remove_inactive_ip_addresses]] : 2953 ms

    <2011-09-07 10:38:01.34 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[dbo].[sp_remove_duplicate_devices]] : 8641 ms

    <2011-09-07 10:38:01.44 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[dbo].[sp_post_inventory_setting]] : 94 ms

    <2011-09-07 10:38:01.44 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'StoredProcAssessment': 11704 ms

    <2011-09-07 10:38:01.45 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SetAssessmentFlagsAssessment': 15 ms

    <2011-09-07 10:38:12.90 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_device_assessment] : 11437 ms

    <2011-09-07 10:38:20.70 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_hardware_assessment] : 7797 ms

    <2011-09-07 10:38:22.28 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_HostGuestRelationships] : 1578 ms

    <2011-09-07 10:38:29.31 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_SecurityCenter] : 7032 ms

    <2011-09-07 10:38:31.03 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_server_assessment] : 1718 ms

    <2011-09-07 10:38:32.47 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_ws2008r2_assessment] : 1438 ms

    <2011-09-07 10:38:32.50 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_AggregatePerfData] : 31 ms

    <2011-09-07 10:38:34.28 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_windows7_assessment] : 1781 ms

    <2011-09-07 10:39:41.17 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_office2010_assessment] : 66891 ms

    <2011-09-07 10:39:44.67 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_server_role_assessment] : 3500 ms

    <2011-09-07 10:39:45.04 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [sp_assessment_IEDiscovery] : 375 ms

    <2011-09-07 10:39:52.81 AssessInventoryWorker@Analyzer,E> RunAssessments() - Assessment threw an exception:

       |Microsoft.AssessmentPlatform.MapException: Caught SqlException running the stored procedure sp_office365_assessment. ---> System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

       |The statement has been terminated.

       |   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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

       |   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.ExecuteStoredProcHelper(String storedProcName, Object[] parameters)

       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.<>c__DisplayClass7.<ExecuteStoredProc>b__6()

       |   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.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)

       |Location of error report:

       |   at Microsoft.AssessmentPlatform.Analytics.Analyzer.RunAssessments(IEnumerable`1 assessments)

       |

    <2011-09-07 10:39:52.83 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.

    <2011-09-07 10:39:52.83 AssessInventoryWorker@TaskProcessor,I> TaskProcessor.WorkerCompleted: Worker: 'AssessInventoryWorker'

    <2011-09-07 10:39:52.83 TID-5@TaskProcessor,I> TaskProcessor.Run: Completed. Status: Failed

    <2011-09-07 10:39:52.83 TID-1@WunderBarBasePage,I> DisplayViewPage(): View 'MachineInventory' failed a view predicate. Reason message: Inventory data needs to be assessed.

    <2011-09-07 10:39:52.83 TID-1@WunderBarBasePage,I> DisplayViewPage: Opening view type: PredicateFailedView

    <2011-09-07 10:39:52.86 TID-5@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.Console.Tasks.TaskProcessor

    <2011-09-07 10:43:52.34 TID-1@ProgressPage,I> ProgressPage.FormClosingHandler: Closing reason: UserClosing

    <2011-09-07 10:43:53.76 TID-1@MAPSMain,I> ConsoleMain.Main: Application exiting.

    Thursday, September 8, 2011 7:33 AM

Answers

  • At this point, the bug fix is part of the MAP 6.5 release currently available at www.microsoft.com/map
    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.
    Friday, December 9, 2011 7:56 PM

All replies

  • This issue is being handled by direct email.
    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.
    Friday, September 9, 2011 7:36 PM
  • Has there been a resolution? I have the EXACT same issue.

     

    Any help is appreciated

     

    Thanks

    Thursday, September 15, 2011 6:59 PM
  • We are still investigating the problem.  If you would like, you can send an email to mapfdbk@microsoft.com and reference this forum thread.  I will then let you know when we have found a solution.


    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.
    Friday, September 16, 2011 4:20 PM
  • I was having the same issue, I had to completely uninstall everything, including removing the SQL instance of MAPS.  I know a complete uninstall and reinstall isn't the best scenario but it worked for me.

    Tuesday, December 6, 2011 6:33 PM
  • At this point, the bug fix is part of the MAP 6.5 release currently available at www.microsoft.com/map
    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.
    Friday, December 9, 2011 7:56 PM