none
Excel 2007 crashes upon connecting to a database in Microsoft Assessment and Planning Toolkit and running generate reports/proposals task. RRS feed

  • Question

  • Hi,

    I have installed the Microsoft Assessment and Planning toolkit along with all of the prerequisite software listed in the "Getting Started guide". I am running the toolkit on Windows XP (x86) with SP3 and Office 2007 SP2.  Upon opening the MAP toolkit and choosing a database to connect to, Excel 2007 will run and then crash with this error message:

    Event Type:        Error

    Event Source:    Microsoft Office 12

    Event Category:                None

    Event ID:              1000

    Date:                     7/17/2009

    Time:                    2:18:37 AM

    User:                     N/A

    Computer:          N/A

    Description:

    Faulting application excel.exe, version 12.0.6504.5001, stamp 49fea693, faulting module mso.dll, version 12.0.6425.1000, stamp 49d65443, debug? 0, fault address 0x000c40f8.

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 41 00 70 00 70 00 6c 00   A.p.p.l.

    0008: 69 00 63 00 61 00 74 00   i.c.a.t.

    0010: 69 00 6f 00 6e 00 20 00   i.o.n. .

    0018: 46 00 61 00 69 00 6c 00   F.a.i.l.

    0020: 75 00 72 00 65 00 20 00   u.r.e. .

    0028: 20 00 65 00 78 00 63 00    .e.x.c.

    0030: 65 00 6c 00 2e 00 65 00   e.l...e.

    0038: 78 00 65 00 20 00 31 00   x.e. .1.

    0040: 32 00 2e 00 30 00 2e 00   2...0...

    0048: 36 00 35 00 30 00 34 00   6.5.0.4.

    0050: 2e 00 35 00 30 00 30 00   ..5.0.0.

    0058: 31 00 20 00 34 00 39 00   1. .4.9.

    0060: 66 00 65 00 61 00 36 00   f.e.a.6.

    0068: 39 00 33 00 20 00 69 00   9.3. .i.

    0070: 6e 00 20 00 6d 00 73 00   n. .m.s.

    0078: 6f 00 2e 00 64 00 6c 00   o...d.l.

    0080: 6c 00 20 00 31 00 32 00   l. .1.2.

    0088: 2e 00 30 00 2e 00 36 00   ..0...6.

    0090: 34 00 32 00 35 00 2e 00   4.2.5...

    0098: 31 00 30 00 30 00 30 00   1.0.0.0.

    00a0: 20 00 34 00 39 00 64 00    .4.9.d.

    00a8: 36 00 35 00 34 00 34 00   6.5.4.4.

    00b0: 33 00 20 00 66 00 44 00   3. .f.D.

    00b8: 65 00 62 00 75 00 67 00   e.b.u.g.

    00c0: 20 00 30 00 20 00 61 00    .0. .a.

    00c8: 74 00 20 00 6f 00 66 00   t. .o.f.

    00d0: 66 00 73 00 65 00 74 00   f.s.e.t.

    00d8: 20 00 30 00 30 00 30 00    .0.0.0.

    00e0: 63 00 34 00 30 00 66 00   c.4.0.f.

    00e8: 38 00 0d 00 0a 00         8..... 

     

    Unfortunately, this error also occurs when running the "Generate Reports/Proposals" task.  I am not sure if this is a bug or an application incompatibility issue. All other features work correctly.  If anyone has experienced this issue before or can produce a resolution for it, I would appreciate the assistance.


    Thank you


    G. L. Fortenberry
    Friday, July 17, 2009 7:34 AM

All replies

  • First debugging step for these kinds of issues is to uninstall and then re-install Office.  Also, make sure you have Office Service Pack 2 applied.

    If the issue recurrs, let me know and we'll do deeper investigation with the Office team.

    Thanks,
    Jay
    Wednesday, July 22, 2009 3:31 PM
  • Thank you for your reply.

    Currently, I have Office 2007 SP2 installed.  I really doubt the issue is with my office installation due to the fact that this issue is occurring in two separate locations.  First, I installed the MAP Toolkit on my home computer running Windows XP Pro x64 with SP2 and Office 2007 SP2.  This computer has all current Windows Updates installed.  Second, I installed the MAP Toolkit on my work computer (different office and network) which has Windows XP x86 SP3 with Office 2007 SP2.  The same issue occurs at both locations and both computers have different configurations with the only major difference that my home computer is running a 64-bit platform. Excel does not crash when opening spreadsheets or other excel files and I have not seen a crash in office or excel before the installation of MAP.  This crash only occurs in excel when running the "generate reports" task and connecting to the Database from the "File" menu in the MAP toolkit. However, I will re-install Office 2007 with SP2 to see if that may resolve the issue, but I am betting it will not. I have already taken the step to uninstall and re-install the MAP toolkit, but this did not solve the problem. I will get back to you shortly.


    G. L. Fortenberry

    Wednesday, July 22, 2009 8:23 PM
  • Okay,

    I have re-installed Office 2007 with SP2 with all office security and critical updates released since SP2.  Unfortunately, I have to report that this did not fix the problem, as I suspected it would not.  I am receiving the exact crash error I was receiving before in Excel when generating reports.  I also get the excel needs to be restarted dialog box when opening the MAP Toolkit. I really do not understand why excel would need to run when opening the MAP Toolkit.  Otherwise, there is not a problem with Excel.  I can open/work with spreadsheets and open other files and display charts/graphs without a problem.  Other Office apps, such as Word and PowerPoint work fine as well.  I am willing to bet there is an issue with a bit of code in one of Microsoft Office's dynamic link libraries conflicting with MAP or its process threads. In the event entry for this crash the mso.dll file is referenced in the fault, which is suppose to belong to Microsoft Office; it is not a system dll. I am not a developer, so I have no clue what steps to take next in debugging this issue further.  I do know that the MAP Toolkit version I downloaded is the latest version, released on the 17th of July this year.


    G. L. Fortenberry
    Thursday, July 23, 2009 6:19 AM
  • Hi Garrett,

    I'm getting a related issue but I don't actually get an event log entry or an app crash but there is definitely something wrong with the way MAP integrates with Office. When I generate the reports I see the following:

    - for every proposal generated I get the following dialog box:
       Title: Microsoft Office Word
       Warning: The program used to create this object is Excel. That program is not installed on your computer. To edit this object, you must install a program that can open the object.

    I get this twice for every proposal it wants to generate and,

    - a slew of the following dialog boxes:
       Title: Microsoft Office Excel
       Warning: Microsoft Office Excel is waiting for another application to complete an OLE action

    The Excel warning boxes will keep reappearing until I kill the Excel.exe process that is left running. Meanwhile, all of the reports generate fine, I can launch Excel and open them...no problems.

    I'm running Vista Ultimate x64 with Office 2007 SP2 - could there be either an incompatibility with SP2 or issues with pathing around the x64 binaries?


    Brad Turner, ILM MVP - Ensynch, Inc - www.identitychaos.com
    Friday, July 31, 2009 9:15 PM
  • Brad,

    I guess my first question would be what database engine are you running with MAP? (SQL 2005 or SQL 2008). If you are running SQL 2005, what service pack is installed?  I am running SQL 2008 Express, and usually OLE errors are related to object linking issues between applications. The Excel warning you listed may be caused during an object linking between Excel and MAP. Most of the time OLE will "map" objects from one application to another and display the data without needing to actually open that application. Try repairing Office, or I would unistall then reinstall Office without SP2 and see if you get those errors. Also, what Service Pack are you running on Vista?

    I do not believe this problem or other problems experienced with MAP have to do with the platform you have installed MAP on.  My issue occurred with both the x86 and x64 versions of Windows XP.  I have not tried to install Office without SP2 to see if the Service Pack for Office may be the issue, but if it is then the development team for MAP should look into this. I have not tried MAP with Office 2003, which is supposed to be supported with this version of MAP as well. 

    This release of MAP is very new, July 17th 2009.  I am betting there are bugs in this release that need to be ironed out, so my suggestion is to hold off on using it right now.  I still have not heard anything from the development team on this issue.


    Garrett Fortenberry


    G. L. Fortenberry
    Sunday, August 2, 2009 8:38 AM
  • Hi there,

    I am getting a similar error, but i havent pinpointed it to connecting to a database from excel.
    I am using 2007 SP2 etc.. but i also had it in 2003 (upgraded the pc's from 2003 to 2007).

    Faulting application excel.exe, version 12.0.6341.5001, stamp 49a5e049, faulting module mso.dll, version 12.0.6320.5000, stamp 485ae817, debug? 0, fault address 0x0003d0b3.

    It happens in different excel sheets on different times. sometimes it takes 1 hour, sometimes 4 ...

    Are there any tests i can do to start pinpointing the problem area?... for at this moment i have no clue what is causing it to crash randomly.
    Wednesday, August 5, 2009 2:23 PM
  • Guarrand,

    This forum is specifically about the Microsoft Assessment and Planning toolkit.  The issue you're experiencing with Excel crashing (not as a part of the MAP tool) needs to be brought to the product support team for Excel.

    You can find out how to contact product support in your region here:  http://support.microsoft.com/

    Thanks,
    Jay
    Wednesday, August 5, 2009 9:09 PM
  • Garrett,

    This problem may be caused by add-ins for Excel.  Can you try to setup Excel to do a clean boot with no addins?  Instructions follow.

    CLEAN BOOT EXCEL:
    1. Search for XLStart directories (Can be more than one)

    2. Check for alternate startup location - remove all contents and save to another
    location
    Office 2007: Office Button > Excel Options > Advanced tab > General section > At
    startup, open all files in:

    3. Uncheck ALL (ie. .xla, .xll, .xlam, COM) add-ins through Excel's User
    Interface
    Excel 2007 > Office Button > Excel Options > Add-ins tab > Manage: Excel Add-ins >
    Click Go

    4. Search for custom toolbar files:
    Search for *.xlb, Excel12.qat, Excel12.ribbonx Append ".old" to ALL found

    5.Check for COM Add-ins at the following locations in the registry:
    HKCU | Software | Microsoft | Office | Excel | Addins | Export starting at "...
    Office | Excel then delete from the registry
    HKLM | Software | Microsoft | Office | Excel | Addins | Export starting at "...
    Office | Excel then delete from the registry
    *NOTE: Some COM Add-ins will "add" themselves back into the registry - after
    exporting and deleting the keys, launch Excel, save a file, close Excel, then check
    the registry again to see if they are still gone or not

    6. Delete Excel keys at:
    HKCU | Software | Microsoft | Office | <version> | Excel (key will recreate itself
    the next time Excel is launched so no need to export)
    HKLM | Software | Microsoft | Office | <version> | Excel (key will recreate itself
    the next time Excel is launched so no need to export)
    Wednesday, August 5, 2009 9:16 PM
  • Thank you for your reply,

    I will try the steps you have outlined here in the next few days, and will get back to you with the results next week.

    Also, please clarify step 1. Search for XLStart directories (Can be more than one). - What do I do with these directories if they are returned in the search results.
    The rest should be a no brainer.


    Thanks,

    Garrett Fortenberry
    G. L. Fortenberry
    Thursday, August 6, 2009 6:32 AM
  • for number 1, I would move any contents of XLStart directories to some other directory temporarily while you're testing, then move those contents back later afterwards.  Sorry that wasn't stated, my oversight.

    Thanks,
    Jay
    Thursday, August 6, 2009 4:07 PM
  • Jay,

     

    I have completed steps 1 through 6 as you outlined in your last post.  When I start the Microsoft Planning and Assessment toolkit I recieve this error below:

     

     "The following prerequisite software is not installed. Please install the prerequisite software before continuing."

     

    "Excel: The wizard requires Microsoft Excel 2003 or Microsoft Excel 2007 for generating reports. Microsoft Excel is not installed. You will need to install either version of Microsoft Excel, and then rerun the wizard."

     


    G. L. Fortenberry
    Thursday, August 6, 2009 9:23 PM
  • Garret,

    Per the last step, you'll need to launch Excel once outside of MAP to re-create some of the registry keys:

    6. Delete Excel keys at:
    HKCU | Software | Microsoft | Office | <version> | Excel (key will recreate itself
    the next time Excel is launched so no need to export
    )
    HKLM | Software | Microsoft | Office | <version> | Excel (key will recreate itself
    the next time Excel is launched so no need to export
    )


    After launching Excel & exiting, try MAPS again.

    Thanks,
    Jay
    Friday, August 7, 2009 7:43 PM
  • Right,

      I did open Excel after step 6 by itself.  It opened fine.  I checked the 2 locations you listed in step 6 and only the key at HKLM recreated itself.  In step 1, I found only 2 XLStart folders, which makes sense because I have 2 user profiles on this computer.  Both XLStart folders were empty.  In step 2 no alternative startup locations were defined.  In step 3 no Excel add-ins were enabled, however I disabled all COM-Add-ins. In step 4 I was only able to locate 2 .xlb files, which I appended .old to the end of the extension; The Excel12.qat and Excel12.ribbonx files were not returned in my search results, and yes I searched in hidden folders as well. Steps 5 and 6 were completed as outlined. I did start excel before I attempted to open the MAP Toolkit console. When I opened MAP, it just would not open, so what I did after I wrote about the error I was receiving was restore the files and registry keys that were either deleted or changed from your post. MAP now opens fine. Granted, the crash problem with Excel still exists. I am running this tool under an account with Administrator Rights, so I do not think permissions would be the problem.  But what is weird is that when I open the MAP Toolkit console; excel sends a message stating it needs to be restarted. In some instances, I am able to run reports without receiving any errors.  This problem seems to be intermittent at best.

     

    Thanks,

    Garrett Fortenberry


    G. L. Fortenberry
    Friday, August 7, 2009 9:10 PM