Error installing Expense Entry

Nov 21, 2008 at 2:20 AM

Hi,

I am trying to install the expense entry on the AX 2009 image that is available through partner source.  I have gone through all the steps of importing the XPOs, building the VS project and publishing the Snap in.  When I am testing and save the Excel file then open.  I get the following error information shown below.  Also, I assumed it had something to do with VSTO 2008 and have re-ran vstor30.exe and tried to repair.  This did not resolve the issue.  What can do to get this up and running?

The customization assembly could not be found or could not be loaded.  You can still edit and save the document.  Contact your administrator or the author of this document for further assistance. 

 

Details: 

File or assembly name Microsoft.VisualStudio.Tools.Office.Runtime.v9.0, or one of its dependencies, was not found.

************** Exception Text **************
System.IO.FileNotFoundException: File or assembly name Microsoft.VisualStudio.Tools.Office.Runtime.v9.0, or one of its dependencies, was not found.
File name: "Microsoft.VisualStudio.Tools.Office.Runtime.v9.0"
   at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark)
   at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark)
   at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark)
   at System.AppDomain.Load(String assemblyString)

=== Pre-bind state information ===
LOG: DisplayName = Microsoft.VisualStudio.Tools.Office.Runtime.v9.0, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
 (Fully-specified)
LOG: Appbase = C:\Program Files\Microsoft Office\Office12\
LOG: Initial PrivatePath = NULL
Calling assembly : (Unknown).
===

LOG: Found application configuration file (C:\Program Files\Microsoft Office\Office12\EXCEL.EXE.Config).
LOG: Publisher policy file is not found.
LOG: Host configuration file not found.
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: Microsoft.VisualStudio.Tools.Office.Runtime.v9.0, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft Office/Office12/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft Office/Office12/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft Office/Office12/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0.EXE.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft Office/Office12/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0.EXE.

 

Coordinator
Nov 24, 2008 at 8:05 PM
Hi Jesika,

Are you installing the expense entry snap on the Demonstration Toolkit VPC? If so, the Demand Planner application add-in that is also installed in that environment is probably interfering with the add-in. To address it, rename or delete the file: 

\Program Files\Microsoft Office\Office12\Excel.exe.config 

And then re-start excel. Also, on that VPC, there may be some changes made to EmplTable that can cause a different error. In that case, you would see an error when refreshing the master data on a sheet. The error will refer you to the Inner Exception:

    "Invalid table relation 'SubPHRReportEmplProfilesAc' defined on table 'EmplTable', relation is empty."

If you see this error, you can build default relationships in the AOT for all of the "SubPHRReportEmpleProfilesXX" relationions. We are preparing an XPO to add to the distribution, but manually changing the relationships in AOT is pretty easy and fast.

Please let us know if this get's your snap-in running!

Coordinator
Nov 26, 2008 at 5:48 PM
We have posted an XPO that makes the proper changes to the EmplTable. Please apply this only if you are using the Demonstration Toolkit VPC from partnersource.