Note to self:
The solution for this appalling BUG in Microsoft IIS & Excel is terrific:
- Create directory "C:\Windows\SysWOW64\config\systemprofile\Desktop " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile\Desktop " (for 32 bit Windows)
- Set Full control permissions for directory Desktop (for example in Win7 & IIS 7 & DefaultAppPool set permissions for user
eConnect WCF exception handling
For this example a WCF service reference to the server endpoint running the GP2010 eConnect integration service as a reference named “GPeConnect” is used.
If an exception were to occur from eConnect on say the CreateEnity mehods, and the exception examined as type system.exception, then the following message is found from ex.message,
System.ServiceModel.FaultException: The creator of this fault did not specify a Reason
To retrieve the error message from econnect that we are interested in, use the System.ServiceModel.FaultException class as shown below. By accessing the Detail.Message property, it is possible to get message of interest.
Microsoft Free eBooks
At my local user group NEByes yesterday evening we enjoyed a session on Mobile Business Intelligence Using Microsoft (Jen Stirrup) and Tableau and SharePoint Virtualisation (Level 100) IT Pro or Technical Beginner (John Timney)
The following free ebooks were pointed out, although I knew some were available, it was a prod to go and investigate, here are the ones I found…
eConnectProcsRunFirst is not part of eConnectProcessInfo for eConnect 2010
eConnectProcsRunFirst is not present in the schema for GP2010 eConnect. Just to confuse people, the documentation in the eConnect SDK still references it in quite a few places still.
Converting eConnectProcsRunFirst to use eConnect 2010
What to do when converting previous versions? It seems to be very simple, the order of the nodes in the XML document submitted to eConnect defines the run order. So if a custom stored procedure is required to run first, ensure it is placed first in the XML document relative to the item it must run ahead of. Yes it is that simple!