none
Assessment threw an exception

    Question

  • Hi,

    I'm running Microsoft Assessment and Planning Toolkit 8, and everytime I try to do a collect inventory data or a refresh assement, it gives me an error " assessment failed".

    On the logs I can see this:

    <2013-04-17 17:51:51.53 Inventory@TaskProcessor,I> WorkerCompleted: Worker: 'Inventory'
    <2013-04-17 17:51:51.53 TID-5@TaskProcessor,I> Run: Processing task: 'Assess inventory'
    <2013-04-17 17:51:51.53 TID-5@TaskProcessor,I> StartWorkers: Starting worker thread: 'AssessInventoryWorker'
    <2013-04-17 17:51:51.53 TID-16@InventoryService,I> Stop() - The inventory engine is stopped.
    <2013-04-17 17:51:51.53 AssessInventoryWorker@TaskProcessor,I> RunWorker: Running worker: 'AssessInventoryWorker'
    <2013-04-17 17:51:51.55 AssessInventoryWorker@Analyzer,I> Getting Download Directory
    <2013-04-17 17:51:51.55 AssessInventoryWorker@Analyzer,I> Got Download Directory
    <2013-04-17 17:51:51.55 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
    <2013-04-17 17:51:51.58 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentStartedEventHandler: Assessment start event.
    <2013-04-17 17:51:51.60 AssessInventoryWorker@Analyzer,I> RunAssessments() - Elapsed time for assessment 'SetAssessmentFlagsAssessment': 0 ms
    <2013-04-17 17:51:52.22 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[WindowsInstalledSoftwareAssessment]] : 609 ms
    <2013-04-17 17:51:53.05 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[DeviceAssessmentProc]] : 827 ms
    <2013-04-17 17:51:53.85 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Win_Assessment].[HardwareAssessmentProc]] : 811 ms
    <2013-04-17 17:51:53.86 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[Unix_Assessment].[UnixDataConsistencyAssessment]] : 0 ms
    <2013-04-17 17:51:54.12 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[VMware_Assessment].[AssessmentVMwareData]] : 265 ms
    <2013-04-17 17:51:54.58 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[AllVirt_Assessment].[AssessmentHostGuestRelationships]] : 452 ms
    <2013-04-17 17:51:55.06 AssessInventoryWorker@StoredProcAssessment,I> RunAssessment() - [Perf] [[AllDevices_Assessment].[CategorizedDevicesProc]] : 484 ms
    <2013-04-17 17:51:56.19 AssessInventoryWorker@Analyzer,E> RunAssessments() - Assessment threw an exception:
       |Microsoft.AssessmentPlatform.MapException: Caught SqlException running the stored procedure [AllDevices_Assessment].[HardwareInventoryProc]. ---> 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.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.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.Analytics.Assessments.StoredProcAssessment.RunAssessment(ThreadSafeFlag continueProcessingFlag, SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.Analytics.Analyzer.RunAssessments(IEnumerable`1 assessments)
    <2013-04-17 17:51:56.19 AssessInventoryWorker@AssessInventoryWorker,I> AssessmentCompletedEventHandler: Assessment completed event.
    <2013-04-17 17:51:56.19 AssessInventoryWorker@TaskProcessor,I> WorkerCompleted: Worker: 'AssessInventoryWorker'
    <2013-04-17 17:51:56.19 TID-5@TaskProcessor,I> Run: Completed. Status: Failed

    Hope you can help,

    Thanks

    Hugo

    Tuesday, April 23, 2013 11:58 AM

All replies

  • I am experiencing this exact problem.  Any insight from Microsoft??
    Thursday, November 21, 2013 3:36 PM
  • What version of MAP are you running and are you inventorying Linux machines?


    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. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.

    Friday, November 22, 2013 7:00 PM
  • I have the same problem. I'm trying to inventory Windows and Redhat machines, but even if I don't select Linux systems in the inventory wizard I still get the same error. I'm running MAP version 8.5.
    Wednesday, December 04, 2013 5:06 PM
  • same problem here. no linux involve.. just the "Run completed. Status Failed"

    With MAP 8.5

    any solutions?

    thanks

    Wednesday, December 18, 2013 9:18 PM