none
Exception generating report RRS feed

  • Question

  • I am getting an error generating reports (proposals are generated without any problems):

    "The Microsoft Assessment and Planning Toolkit summary report could not be generated due to an error in the report generating process"

    The LOG:

    <2011-05-04 10:42:30.09 TID-1@ReportProposalHelper,I> OnGenerateReportProposal: Owner: Microsoft.AssessmentPlatform.UI.Console.Views.ServerRolesView
    <2011-05-04 10:42:30.24 TID-6@TaskProcessor,I> TaskProcessor.Run: Processing task: 'Generate Reports'
    <2011-05-04 10:42:30.24 TID-6@TaskProcessor,I> TaskProcessor.StartWorkers: Starting worker thread: 'Generate reports'
    <2011-05-04 10:42:30.24 Generate reports@TaskProcessor,I> TaskProcessor.RunWorker: Running worker: 'Generate reports'
    <2011-05-04 10:42:30.24 Generate reports@ReportGenerationWorker,I> ReportGenerationWorker.ReportGenerationStartEventHandler: Start event.
    <2011-05-04 10:42:30.25 Generate reports@ReportManager,I> Generate workbook WS2008RoleAssessment
    <2011-05-04 10:42:30.25 Generate reports@DocumentSigning,I> DocumentSigning:Load Config File DocumentSigningConfig.xml
    <2011-05-04 10:42:30.77 Generate reports@ApplicationExceptionManager,E> Exception Handling for exception: Type:Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ExcelReportEngineException, Message:Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) ,Source:, Stack:, Target:
       |Location of error report:
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdResolution, ExceptionSeverity exceptionSeverity, String resIdSubTask, String[] resSubTaskParameter)
       |
    <2011-05-04 10:42:30.77 Generate reports@ApplicationExceptionManager,E> Excel engine failed while Creating new Excel worksheet.
       |Error: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
       |Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
       |
       |StackTrace:    at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdResolution, ExceptionSeverity exceptionSeverity, String resIdSubTask, String[] resSubTaskParameter)
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdSubTask, String[] resSubTaskParameter)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ExcelReportEngine.GetNewExcelWorkbook(Int32 exWorksheetCount)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ExcelReportEngine.Init(Int32 workSheetCount)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ReportEngine.GenerateReport(String[] reportList, String outDir, String workbookname)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ReportManager.InvokeWorkbookGeneration(String outputDir)
       |   at Microsoft.AssessmentPlatform.UI.Console.Tasks.ReportGenerationWorker.Run()
       |   at Microsoft.AssessmentPlatform.UI.Console.Tasks.TaskProcessor.RunWorker(WorkItemWorker worker)
       |   at Microsoft.AssessmentPlatform.UI.Console.Tasks.TaskProcessor.<>c__DisplayClass8.<StartWorkers>b__7()
       |   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       |   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       |   at System.Threading.ThreadHelper.ThreadStart()
       |
       |Location of error report:
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.LogExceptionDetails(ApplicationExceptionDetails appExcDetails)
       |
    <2011-05-04 10:42:30.77 Generate reports@ApplicationExceptionManager,E> Exception Handling for exception: Type:Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ReportingEngineException, Message:Excel engine failed while Creating new Excel worksheet.
       |Error: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
       |Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
       | ,Source:Microsoft.AssessmentPlatform.CommonObjectLibrary, Stack:   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleApplicationExceptionManagerExceptions(Exception exception)
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdResolution, ExceptionSeverity exceptionSeverity, String resIdSubTask, String[] resSubTaskParameter)
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdSubTask, String[] resSubTaskParameter)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ExcelReportEngine.GetNewExcelWorkbook(Int32 exWorksheetCount)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ExcelReportEngine.Init(Int32 workSheetCount), Target:Void HandleApplicationExceptionManagerExceptions(System.Exception)
       |Location of error report:
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdResolution, ExceptionSeverity exceptionSeverity, String resIdSubTask, String[] resSubTaskParameter)
       |
    <2011-05-04 10:42:30.77 Generate reports@ApplicationExceptionManager,E> Exception Handling for exception: Type:Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ReportingEngineException, Message:Excel engine failed while Creating new Excel worksheet.
       |Error: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
       |Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
       | ,Source:Microsoft.AssessmentPlatform.CommonObjectLibrary, Stack:   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleApplicationExceptionManagerExceptions(Exception exception)
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdResolution, ExceptionSeverity exceptionSeverity, String resIdSubTask, String[] resSubTaskParameter)
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdSubTask, String[] resSubTaskParameter)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ExcelReportEngine.Init(Int32 workSheetCount)
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ReportEngine.GenerateReport(String[] reportList, String outDir, String workbookname), Target:Void HandleApplicationExceptionManagerExceptions(System.Exception)
       |Location of error report:
       |   at Microsoft.AssessmentPlatform.CommonObjectLibrary.ExceptionClasses.ApplicationExceptionManager.HandleException(Exception exception, String resIdResolution, ExceptionSeverity exceptionSeverity, String resIdSubTask, String[] resSubTaskParameter)
       |
    <2011-05-04 10:42:30.77 Generate reports@ReportManager,E> Exception while generating WS2008RoleAssessment
       |Location of error report:
       |   at Microsoft.AssessmentPlatform.ReportingEngine.ReportManager.InvokeWorkbookGeneration(String outputDir)
       |
    <2011-05-04 10:42:30.80 Generate reports@ReportManager,I> Report Manager completed with Failure
    <2011-05-04 10:42:30.80 Generate reports@ReportGenerationWorker,I> ReportGenerationWorker.ReportGenerationCompleteEventHandler: Complete event.
    <2011-05-04 10:42:30.80 Generate reports@TaskProcessor,I> TaskProcessor.WorkerCompleted: Worker: 'Generate reports'
    <2011-05-04 10:42:30.80 TID-6@TaskProcessor,I> TaskProcessor.Run: Completed. Status: Failed
    <2011-05-04 10:42:30.80 TID-6@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.Console.Tasks.TaskProcessor
    <2011-05-04 10:42:37.65 TID-1@ProgressPage,I> ProgressPage.FormClosingHandler: Closing reason: UserClosing

    Any help will be greately appreciated.

    Thanks in advance!

    Thursday, May 5, 2011 3:24 PM

All replies

  • Do you get the error regardless of the report you try to run or just when you try the server role report?
    Thursday, May 5, 2011 4:21 PM
    Moderator
  • Regardless of the report... I tried "Inventory Summary Results", "Software Usage Tracker", etc....

    Proposals are generated in "MS Word" with no problems...

    I have MS Office 2007.... Tried uninstalling and re-installing Excel - no luck...

    Thursday, May 5, 2011 4:47 PM
  • I figure the problem is one of two possibilities. Either the database is corrupt or something is wrong in the Office installation.  The check this, create a new database, use the manual computer discovery and scan 1 machine.  Then try the reports.

    If you still get the error, then something is wrong with the computer’s Office installation.  Since reinstalling Excel didn’t fix it, the amount of time it will take to track down the exact issue is probably not worth the time.  I would suggest that you try installing MAP on a different machine or a VM and try it again.

    Thanks,

    Michael Switzer

    Thursday, May 5, 2011 6:44 PM
    Moderator
  • Thank you, Michael... I am running out of time to test it today - will do tomorrow and let you know.
    Thursday, May 5, 2011 8:28 PM
  • OK. I created a new database and run manual computer discovery for 1 machine - same problem...

    Standing up a VM to test a new installation for Office.

    Friday, May 6, 2011 3:37 PM