Hi Hilary
I am having the same issue. I am working on a sample InfoPath form found here: http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-excel-services.htm
The form works fine in InfoPath Filler but not in the browser. My form, which is a Leave form, does have a few more fields which are textboxes and 2 people picker controls. I also have 2 buttons on the form, one to get the days between two dates and one to submit the form to the form library. I get the error when I hit the button that contact Excel services to get the days between 2 dates.
My log files on WFE say this:
07/23/2013 14:10:39.54 w3wp.exe (0x0C10) 0x02F8 InfoPath Forms Services Runtime - Business Logic 82g1 Critical There was a form postback error. (User: domain\user01, Form Name: LeaveForm, IP: , Request: http://portal/_layouts/FormServer.aspx?XsnLocation=http://portal/FormServerTemplates/LeaveForm.xsn&SaveLocation=http://portal/Leave Form&ClientInstalled=true&Source=http://portal/Leave%2520Form/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:LeaveForm:-myXSD-2013-07-18T23-06-48, Type: KeyNotFoundException, Exception Message: The given key was not present in the dictionary.) 4f391534-b1d1-49fb-a001-c08e2a8252a4
07/23/2013 14:10:39.54 w3wp.exe (0x0C10) 0x02F8 InfoPath Forms Services Runtime 8geb Exception Unhandled exception when rendering form on postback System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.ThrowHelper.ThrowKeyNotFoundException() at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DatabaseHelper.GetSchemaXml(String namespaceUri, Solution solution, String dataObjectName, SchemaNavigator& schema, XPathNavigator& originalSchema, XmlNamespaceManager& namespaceManager) at Microsoft.Office.InfoPath.Server.SolutionLifetime.PartFragmentHelper.IsDataSetNode(Solution solution, XPathNavigator node) at Microsoft.Office.InfoPath.Server.SolutionLifetime.PartFragmentHelper.ApplyPartFragmentGather(DataAdapter adapter, XPathNavigator sourceDOM, DataObjec... 4f391534-b1d1-49fb-a001-c08e2a8252a4
07/23/2013 14:10:39.54* w3wp.exe (0x0C10) 0x02F8 InfoPath Forms Services Runtime 8geb Exception ...ts dataObjects, XPathNavigator targetDOM, PartFragment[] partFragments, Boolean[]& areDataSets) at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterWebServiceSubmit.Execute(Document document, Uri soapAction, Uri serviceUrl, XPathNavigator querySubDOM, XPathNavigator resultsSubDOM, XPathNavigator errorsSubDOM, Int64 timeout, DataAdapterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf) at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataAdapterWebServiceSubmit.ExecuteInternal(XPathNavigator queryFields, XPathNavigator resultFields, XPathNavigator errors) at Microsoft.Office.InfoPath.Server.SolutionLifetime.RuleAction.EvaluateExpression(Document document, XPathNavigator currentTarget) at Microsoft.Office.InfoPath.Server.SolutionLifeti... 4f391534-b1d1-49fb-a001-c08e2a8252a4
07/23/2013 14:10:39.54* w3wp.exe (0x0C10) 0x02F8 InfoPath Forms Services Runtime 8geb Exception ...me.RulesRuleSet.EvaluateExpression(Document document, XPathNavigator targetNavigator) at Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.Click(Document document, XPathNavigator container) at Microsoft.Office.InfoPath.Server.DocumentLifetime.EventClick.Play(Document document, BindingServices bindingServices, EventLogProcessor eventLogProcessor) at Microsoft.Office.InfoPath.Server.DocumentLifetime.EventLogProcessor.ExecuteLog(Int32 expectedEventLogID) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.<>c__DisplayClass13.<PlayEventLog>b__11() at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) 4f391534-b1d1-49fb-a001-c08e2a8252a4
07/23/2013 14:10:39.54 w3wp.exe (0x0C10) 0x02F8 SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 41b7c39f "infopath forms services", 0e00178d "14.0.6029.0", c180aef3 "mscorlib", 0200c627 "2.0.50727.0", 5174de33 "mon apr 22 16:52:35 2013", 000000dd "000000dd", 00000005 "00000005", 0560164b "keynotfoundexception", 38676562 "8geb" 4f391534-b1d1-49fb-a001-c08e2a8252a4
07/23/2013 14:10:39.74 OWSTIMER.EXE (0x0A44) 0x0AA4 Web Content Management Site Management c07h High SpawnVariationSitesJob has started 14a9a01e-116a-44a0-874b-6fdc0d53f800
Event Viewer on WFE reports this:
There was a form postback error. (User: domain\user01, Form Name: LeaveForm, IP: , Request: http://portal/_layouts/FormServer.aspx?XsnLocation=http://portal/FormServerTemplates/LeaveForm.xsn&SaveLocation=http://portal/Leave Form&ClientInstalled=true&Source=http://portal/Leave%2520Form/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:LeaveForm:-myXSD-2013-07-18T23-06-48, Type: KeyNotFoundException, Exception Message: The given key was not present in the dictionary.)
Thanks
Yoshi