Qdabra qRules

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

Hilary Stoupa — Mon, 07 Nov 2011 17:50:29 GMT

Thanks for the update, Bob - if you find out what the issue is on the other site, will you post that information to this thread? It would be great to know what was up....

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Mon, 07 Nov 2011 17:42:51 GMT

Wanted to post a quick update.... I created a new web application and setup the form again with qRules. Everything worked fine. There must be something just not right with rights in the other site. I will investigate later.

Thank you for the help.

-Bob

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Wed, 02 Nov 2011 23:47:51 GMT

okay,... ran when the clock turned 6:43

I see something about high access denied and medium not persisting. not sure what that points to....

11/02/2011 18:43:00.57 OWSTIMER.EXE (0x2218) 0x2660 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Timer Job User Profile Service_ProfileSynchronizationJob) 146b8d15-dc19-4480-8b29-a282534d95f9
11/02/2011 18:43:00.57 OWSTIMER.EXE (0x2218) 0x1AC4 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Timer Job User Profile Service_LanguageSynchronizationJob) b28988b7-a9e0-46a0-b4c5-fcce4c7ec80e
11/02/2011 18:43:00.57 OWSTIMER.EXE (0x2218) 0x1AC4 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Timer Job User Profile Service_LanguageSynchronizationJob). Execution Time=3.39121312904294 b28988b7-a9e0-46a0-b4c5-fcce4c7ec80e
11/02/2011 18:43:00.95 OWSTIMER.EXE (0x2218) 0x2660 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Timer Job User Profile Service_ProfileSynchronizationJob). Execution Time=370.862777252416 146b8d15-dc19-4480-8b29-a282534d95f9
11/02/2011 18:43:01.49 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (GET:https://fc.gogoair.com:443/wf/_layouts/FormServer.aspx?XsnLocation=https://fc.gogoair.com/FormServerTemplates/qrulestest.xsn&SaveLocation=https%3A%2F%2Ffc%2Egogoair%2Ecom%2Fwf%2Fqrules&ClientInstalled=true&Source=https%3A%2F%2Ffc%2Egogoair%2Ecom%2Fwf%2Fqrules%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1))
11/02/2011 18:43:01.49 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_layouts/FormServer.aspx?XsnLocation=https://fc.gogoair.com/FormServerTemplates/qrulestest.xsn&SaveLocation=https%3A%2F%2Ffc%2Egogoair%2Ecom%2Fwf%2Fqrules&ClientInstalled=true&Source=https%3A%2F%2Ffc%2Egogoair%2Ecom%2Fwf%2Fqrules%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1) 031f3dfb-9825-4e13-b0c5-621e6bcce6b8
11/02/2011 18:43:01.49 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 031f3dfb-9825-4e13-b0c5-621e6bcce6b8
11/02/2011 18:43:01.54 w3wp.exe (0x13D0) 0x1ACC SharePoint Server State Service 8kfs Medium The StateManager is disposing and calling ReleaseLockedStates() (Count=0) 031f3dfb-9825-4e13-b0c5-621e6bcce6b8
11/02/2011 18:43:01.56 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_layouts/FormServer.aspx?XsnLocation=https://fc.gogoair.com/FormServerTemplates/qrulestest.xsn&SaveLocation=https%3A%2F%2Ffc%2Egogoair%2Ecom%2Fwf%2Fqrules&ClientInstalled=true&Source=https%3A%2F%2Ffc%2Egogoair%2Ecom%2Fwf%2Fqrules%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1)). Execution Time=53.7154861860935 031f3dfb-9825-4e13-b0c5-621e6bcce6b8
11/02/2011 18:43:01.96 w3wp.exe (0x010C) 0x1FE0 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Disk Manager: CurrentSize=789243. 11c5f189-0bf6-6753-0000-000050f7b00c
11/02/2011 18:43:02.93 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (POST:https://fc.gogoair.com:443/wf/_layouts/Postback.FormServer.aspx))
11/02/2011 18:43:02.93 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (POST:https://fc.gogoair.com:443/wf/_layouts/Postback.FormServer.aspx) 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:02.98 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation General 8kh7 High Access denied. 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:02.98 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:02.98 w3wp.exe (0x13D0) 0x1ACC InfoPath Forms Services Runtime f9n5 Medium Thread was being aborted. 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:02.98 w3wp.exe (0x13D0) 0x1ACC InfoPath Forms Services Runtime 961x Medium Not persisting state for request due to previous errors. Form Template: urn:schemas-microsoft-com:office:infopath:qrulestest:-myXSD-2011-10-31T16-04-21 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC InfoPath Forms Services Runtime 82fh Exception Unhandled exception processing request for PostbackPage Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException: Exception of type 'Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException' was thrown. at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentFormId() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentContext() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.IsDefined(GlobalItems key) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.TryGetCachedTimeZoneId(UInt16& timeZoneId) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.GetSPTimeZoneObject() at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.CalculateSPLocalTimeOffset() at Microsoft.Office.InfoPath.Server.Util.GenericUtils.GetServerTimeZone() at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderResult(TextWriter writer, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderForException(HttpContext context, Exception exception, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.Controls.PostbackPage.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 41b7c39f "infopath forms services", 0e00178d "14.0.6029.0", fd34ba92 "microsoft.office.infopath.server", 0e00178c "14.0.6028.0", 4dafefab "thu apr 21 03:49:47 2011", 0000255e "0000255e", 00000014 "00000014", 33bcb602 "infopathfatalexception", 38326668 "82fh" 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Performance nask High An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {783C0EC9-4FB8-415A-B12C-263C12B40CE0} To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Performance nask High An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {EA0487A8-C16D-4ABA-B633-DAAA359D30CF} To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Performance nask High An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {41CD5AF5-AA5C-49D6-BE00-586543F4C2BE} To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (POST:https://fc.gogoair.com:443/wf/_layouts/Postback.FormServer.aspx)). Execution Time=81.8408484877268 3e0ed8eb-cf1f-4001-a8f2-bd03883852d0
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (GET:https://fc.gogoair.com:443/wf/_layouts/AccessDenied.aspx))
11/02/2011 18:43:03.01 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_layouts/AccessDenied.aspx) 1b8ec8df-446b-448a-8576-d12e5aec8e0e
11/02/2011 18:43:03.03 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 1b8ec8df-446b-448a-8576-d12e5aec8e0e
11/02/2011 18:43:03.03 w3wp.exe (0x13D0) 0x1ACC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_layouts/AccessDenied.aspx)). Execution Time=14.090058932071 1b8ec8df-446b-448a-8576-d12e5aec8e0e
11/02/2011 18:43:03.42 w3wp.exe (0x3308) 0x1F00 Office Web Apps Office Viewing Architecture d5c5 Medium LocalStore: Checking for cached documents to be deleted.
11/02/2011 18:43:03.57 OWSTIMER.EXE (0x2218) 0x30BC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Timer Job SchedulingUnpublish) fdbe0b52-c529-465a-b943-0fed52ecfca2
11/02/2011 18:43:03.57 OWSTIMER.EXE (0x2218) 0x30BC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Timer Job SchedulingUnpublish). Execution Time=2.6313400166781 fdbe0b52-c529-465a-b943-0fed52ecfca2
11/02/2011 18:43:03.59 w3wp.exe (0x010C) 0x085C Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Memory Manager: CurrentSize=458928128. 53fed7f1-0bf6-6753-0000-000050f7b00c
11/02/2011 18:43:03.64 w3wp.exe (0x13D0) 0x1098 SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://cil-vm-sps-01:32843/a526bbefcfc246028dd9a7916f55f837/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:a091c93e-2b41-4823-9d96-11b992d591d1'
11/02/2011 18:43:03.64 w3wp.exe (0x010C) 0x30FC SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://cil-vm-sps-01:32843/a526bbefcfc246028dd9a7916f55f837/MetadataWebService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:a091c93e-2b41-4823-9d96-11b992d591d1' 1f646d97-e7ba-42da-9e67-80a64382e34c
11/02/2011 18:43:03.64 w3wp.exe (0x010C) 0x30FC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) 1f646d97-e7ba-42da-9e67-80a64382e34c
11/02/2011 18:43:03.64 w3wp.exe (0x010C) 0x30FC SharePoint Server Taxonomy fuc5 Medium MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service' starting. 1f646d97-e7ba-42da-9e67-80a64382e34c
11/02/2011 18:43:03.64 w3wp.exe (0x010C) 0x30FC SharePoint Server Taxonomy fuc6 Medium MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service' completed. 1f646d97-e7ba-42da-9e67-80a64382e34c
11/02/2011 18:43:03.64 w3wp.exe (0x010C) 0x30FC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=1.37643192081675 1f646d97-e7ba-42da-9e67-80a64382e34c
11/02/2011 18:43:05.57 OWSTIMER.EXE (0x2218) 0x2230 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Timer Job job-timer-locks) 967a4970-a3e4-43cc-93d2-a5afdde8651a
11/02/2011 18:43:05.57 OWSTIMER.EXE (0x2218) 0x2230 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Timer Job job-timer-locks). Execution Time=3.91418462402344 967a4970-a3e4-43cc-93d2-a5afdde8651a
11/02/2011 18:43:08.59 w3wp.exe (0x010C) 0x085C Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Memory Manager: CurrentSize=458997760. 53fed7f1-0bf6-6753-0000-000050f7b00c
11/02/2011 18:43:09.59 w3wp.exe (0x229C) 0x1B00 SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://cil-vm-sps-01:32843/a526bbefcfc246028dd9a7916f55f837/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:0903f01d-645b-4b08-b4a4-0c91bd1960c2'
11/02/2011 18:43:09.59 w3wp.exe (0x010C) 0x30FC SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'http://cil-vm-sps-01:32843/a526bbefcfc246028dd9a7916f55f837/MetadataWebService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:0903f01d-645b-4b08-b4a4-0c91bd1960c2' d130ecba-27d9-4aac-b115-50b82d9b80bf
11/02/2011 18:43:09.59 w3wp.exe (0x010C) 0x30FC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (ExecuteWcfServerOperation) d130ecba-27d9-4aac-b115-50b82d9b80bf
11/02/2011 18:43:09.59 w3wp.exe (0x010C) 0x30FC SharePoint Server Taxonomy fuc5 Medium MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service' starting. d130ecba-27d9-4aac-b115-50b82d9b80bf
11/02/2011 18:43:09.59 w3wp.exe (0x010C) 0x30FC SharePoint Server Taxonomy fuc6 Medium MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service' completed. d130ecba-27d9-4aac-b115-50b82d9b80bf
11/02/2011 18:43:09.59 w3wp.exe (0x010C) 0x30FC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=2.55283841940805 d130ecba-27d9-4aac-b115-50b82d9b80bf
11/02/2011 18:43:11.96 w3wp.exe (0x010C) 0x1FE0 Excel Services Application Excel Calculation Services 8jg2 Medium ResourceManager.PerformCleanup: Disk Manager: CurrentSize=789243. 11c5f189-0bf6-6753-0000-000050f7b00c

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

Hilary Stoupa — Wed, 02 Nov 2011 23:36:36 GMT

Okay - so that tells us the issue is with the environment - anything in the log at that time?

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Wed, 02 Nov 2011 23:17:41 GMT

Hi Hilary,

Ok, got it. created a new button that calls FilterOwssvr data source. Unfortuneatly it was the same result. repeating field returns data for me, but logging in with a standard user account yields nothing after clicking the button.

-Bob

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

Hilary Stoupa — Wed, 02 Nov 2011 23:05:19 GMT

So, let me try again to explain what I'd like you to do, because I feel like I am failing to describe it.

What is the name of your data connection that uses the owssvr.dll data connection?

Is it FilterOwssvr?

Drag the repeating data fields from that data source from the data source task pane onto the form (sounds like you've already done this)

Add a button to the form.

Put a single rule on the button - the action should be to query using a data source - the FilterOwssvr data source.

Open the form in the browser as the "standard" user.

Do not fill in the employee number and tab - instead, just click the button.

I am trying to find out if the issue is with IPFS in your environment and this type of data connection, or if the issue is with qRules - does that make sense?

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Wed, 02 Nov 2011 22:52:26 GMT

Hi Hilary,

Actually I still type in data on the SSN field and hit tab. Automatically retrieve data when form is opened is not checked.

Data with INfopath Form Services

11/02/2011 17:25:26.08 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime b16s Medium EnsureObjectInCache - created object to cache: ProcessId:[29] CacheId: SiteFeatures_1286f75b-b1fd-4e0b-a16c-e58324fcdc26. Finished in 00:00:00.0116078 d9d7a86b-5b94-498c-a435-18bb2ef28e5f
11/02/2011 17:25:26.09 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime 30ct High SolutionInformation got bumped from the cache.: SolutionCacheId: IpfsSolution::meta:ABPR5Y2LJN5KWSMCWQ5YVGNSPQEQCCBRFYYC4MBOGMYQ Reason: Expired d9d7a86b-5b94-498c-a435-18bb2ef28e5f
11/02/2011 17:25:26.09 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime b16s Medium EnsureObjectInCache - created object to cache: ProcessId:[29] CacheId: IpfsSolution::meta:ABPR5Y2LJN5KWSMCWQ5YVGNSPQEQCCBRFYYC4MBOGMYQ. Finished in 00:00:00.0000097 d9d7a86b-5b94-498c-a435-18bb2ef28e5f
11/02/2011 17:25:26.09 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime 39a9 Medium Solution got bumped from the cache.: SolutionCacheId: ABPR5Y2LJN5KWSMCWQ5YVGNSPQEQCCBRFYYC4MBOGMYQ Reason: Expired d9d7a86b-5b94-498c-a435-18bb2ef28e5f
11/02/2011 17:25:26.12 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime b16s Medium EnsureObjectInCache - created object to cache: ProcessId:[29] CacheId: IpfsSolution::soln:ABPR5Y2LJN5KWSMCWQ5YVGNSPQEQCCBRFYYC4MBOGMYQ. Finished in 00:00:00.0288008 d9d7a86b-5b94-498c-a435-18bb2ef28e5f
11/02/2011 17:25:26.14 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime tktw Medium On-demand loading of single file. solution Admin:4be31e5f-7a4b-49ab-82b4-3b8a99b27c09, version:1.0.0.31, file: sampledata.xml, size: 4427 d9d7a86b-5b94-498c-a435-18bb2ef28e5f
11/02/2011 17:26:06.72 w3wp.exe (0x2E08) 0x28E8 InfoPath Forms Services Runtime 961x Medium Not persisting state for request due to previous errors. Form Template: urn:schemas-microsoft-com:office:infopath:qrulestest:-myXSD-2011-10-31T16-04-21 73e9c12c-9a04-49ab-9895-db3e722bbb84
11/02/2011 17:26:26.00 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime f9n5 Medium Thread was being aborted. 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:26:26.00 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime - Business Logic 7tge Medium Exception thrown from business logic event listener: System.Threading.ThreadAbortException: Thread was being aborted. at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand() at Microsoft.Office.InfoPath.Server.SolutionLifetime.XmlEventExternal.<>c__DisplayClass10.<>c__DisplayClass12.<add_Changed>b__b() at Microsoft.Office.InfoPath.Server.Util.DocumentReliability.InvokeBusinessLogic(Thunk thunk) at Microsoft.Office.InfoPath.Server.SolutionLifetime.XmlEventExternal.<>c__DisplayClass10.<add_Changed>b__a(Object sender, XmlEventArgs e) at Microsoft.Office.InfoPath.Server.SolutionLifetime.XmlEventExternal.<>c__DisplayClass20.<FireChangedEvent>b__1c() at Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.CallFormCodeWithExceptionHandling(UserMessages userMessages, OMCall d) 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:26:26.00 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime f9n5 Medium Thread was being aborted. 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:26:26.00 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime 961x Medium Not persisting state for request due to previous errors. Form Template: urn:schemas-microsoft-com:office:infopath:qrulestest:-myXSD-2011-10-31T16-04-21 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:26:26.00 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime f9n5 Medium Thread was being aborted. 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:26:26.00 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime 961x Medium Not persisting state for request due to previous errors. Form Template: urn:schemas-microsoft-com:office:infopath:qrulestest:-myXSD-2011-10-31T16-04-21 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:26:26.04 w3wp.exe (0x2E08) 0x1100 InfoPath Forms Services Runtime 82fh Exception Unhandled exception processing request for PostbackPage Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException: Exception of type 'Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException' was thrown. at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentFormId() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentContext() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.IsDefined(GlobalItems key) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.TryGetCachedTimeZoneId(UInt16& timeZoneId) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.GetSPTimeZoneObject() at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.CalculateSPLocalTimeOffset() at Microsoft.Office.InfoPath.Server.Util.GenericUtils.GetServerTimeZone() at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderResult(TextWriter writer, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderForException(HttpContext context, Exception exception, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.Controls.PostbackPage.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:26:26.04 w3wp.exe (0x2E08) 0x1100 SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 41b7c39f "infopath forms services", 0e00178d "14.0.6029.0", fd34ba92 "microsoft.office.infopath.server", 0e00178c "14.0.6028.0", 4dafefab "thu apr 21 03:49:47 2011", 0000255e "0000255e", 00000014 "00000014", 33bcb602 "infopathfatalexception", 38326668 "82fh" 220f1743-b384-4420-ab8e-ec3cdec8cd9b
11/02/2011 17:27:26.15 w3wp.exe (0x2E08) 0x28E8 InfoPath Forms Services Runtime - State Service b5st Medium MOSS StateService threw an exception: A Microsoft SharePoint Server State Service error occurred while processing your request. For more information, contact your server farm administrator. f2a40f7c-981e-4f19-8e9c-e27fc7ee9cb1
-Bob

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

Hilary Stoupa — Wed, 02 Nov 2011 22:46:16 GMT

So, this is helpful - looks like that data connection is failing when you are using certain user IDs (standard user).

Anything in the log from InfoPath Forms Services when you open the form as a standard user (I'm assuming that you still have the data connection set to run on load, and that is why you are getting data when you open the form signed in as yourself)?

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Wed, 02 Nov 2011 22:33:31 GMT

Hi Hilary,

this is what I typed into the data source : FilterOwssvr:

https://sharepoint.company.com/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRU

I then dragged that out onto the form (the xml link)

xml (dragged to my form)

s:Schema
rs:data

With my ID i see:

as a standard user, there is nothing

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

Hilary Stoupa — Wed, 02 Nov 2011 22:13:23 GMT

What is the rule on the button? What I'd like you do is drag your data connection that you are using in your qRules command - the one that uses owssvr.dll? onto the form, so you can see the data returned to that data source. Then on the button, just have a single rule that queries that data source - doesn't use qRules at all. What I'm trying to ascertain is whether it is simply querying an owssvr.dll data source in the browser that is failing.

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Wed, 02 Nov 2011 21:44:33 GMT

Hi Hilary,

I have created a quick form to test with. Not sure if this is exactly what you were asking for.

Here is what I see when I click the button

Here is what I see when a standard user clicks the button: I type in 123-45-6789 as above but the data is wiped away and the results are null.

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

Hilary Stoupa — Wed, 02 Nov 2011 21:11:47 GMT

I'd actually be looking for messages about InfoPath Forms Services -

Can you add a button to your form that simply queries your owssvr.dll data connection (not using qRules), and drag that data source onto the form, so that you can test as a user where the command is failing and see if you also get a failure just querying the data connection?

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Wed, 02 Nov 2011 20:10:27 GMT

this looks like it gets more to the heart of the issue: something about _layouts and no access?

11/02/2011 12:33:59.77 w3wp.exe (0x1684) 0x2A80 InfoPath Forms Services Runtime - Business Logic 7tge Medium Exception thrown from business logic event listener: System.Threading.ThreadAbortException: Thread was being aborted. at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand() at Microsoft.Office.InfoPath.Server.SolutionLifetime.XmlEventExternal.<>c__DisplayClass10.<>c__DisplayClass12.<add_Changed>b__b() at Microsoft.Office.InfoPath.Server.Util.DocumentReliability.InvokeBusinessLogic(Thunk thunk) at Microsoft.Office.InfoPath.Server.SolutionLifetime.XmlEventExternal.<>c__DisplayClass10.<add_Changed>b__a(Object sender, XmlEventArgs e) at Microsoft.Office.InfoPath.Server.SolutionLifetime.XmlEventExternal.<>c__DisplayClass20.<FireChangedEvent>b__1c() at Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.CallFormCodeWithExceptionHandling(UserMessages userMessages, OMCall d) 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.77 w3wp.exe (0x1684) 0x2A80 InfoPath Forms Services Runtime f9n5 Medium Thread was being aborted. 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.77 w3wp.exe (0x1684) 0x2A80 InfoPath Forms Services Runtime 961x Medium Not persisting state for request due to previous errors. Form Template: urn:schemas-microsoft-com:office:infopath:benefits2012:-myXSD-2011-05-04T15-30-38 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.77 w3wp.exe (0x1684) 0x2A80 InfoPath Forms Services Runtime f9n5 Medium Thread was being aborted. 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.77 w3wp.exe (0x1684) 0x2A80 InfoPath Forms Services Runtime 961x Medium Not persisting state for request due to previous errors. Form Template: urn:schemas-microsoft-com:office:infopath:benefits2012:-myXSD-2011-05-04T15-30-38 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.82 w3wp.exe (0x1684) 0x2A80 InfoPath Forms Services Runtime 82fh Exception Unhandled exception processing request for PostbackPage Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException: Exception of type 'Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException' was thrown. at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentFormId() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentContext() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.IsDefined(GlobalItems key) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.TryGetCachedTimeZoneId(UInt16& timeZoneId) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.GetSPTimeZoneObject() at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.CalculateSPLocalTimeOffset() at Microsoft.Office.InfoPath.Server.Util.GenericUtils.GetServerTimeZone() at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderResult(TextWriter writer, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderForException(HttpContext context, Exception exception, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.Controls.PostbackPage.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.82 w3wp.exe (0x1684) 0x2A80 SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 41b7c39f "infopath forms services", 0e00178d "14.0.6029.0", fd34ba92 "microsoft.office.infopath.server", 0e00178c "14.0.6028.0", 4dafefab "thu apr 21 03:49:47 2011", 0000255e "0000255e", 00000014 "00000014", 33bcb602 "infopathfatalexception", 38326668 "82fh" 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.82 w3wp.exe (0x1684) 0x2A80 SharePoint Foundation Performance nask High An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {291CD7B7-FE8F-4BDB-91BF-F27AD8317CE7} To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.82 w3wp.exe (0x1684) 0x2A80 SharePoint Foundation Performance nask High An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {D6DCC8DC-CA5A-41BB-B406-1BAC76AB83AD} To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.82 w3wp.exe (0x1684) 0x2A80 SharePoint Foundation Performance nask High An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {214B478A-52D8-455B-A264-8E67E166026C} To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.82 w3wp.exe (0x1684) 0x2A80 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (POST:https://fc.gogoair.com:443/wf/_layouts/Postback.FormServer.aspx)). Execution Time=987.291960291043 23ce8745-4d48-463b-a4a5-20a611bb32e2
11/02/2011 12:33:59.84 w3wp.exe (0x1684) 0x0C5C SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (GET:https://fc.gogoair.com:443/wf/_layouts/AccessDenied.aspx))
11/02/2011 12:33:59.84 w3wp.exe (0x1684) 0x0C5C SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_layouts/AccessDenied.aspx) 1ea63834-ee2a-4b5c-9315-565a6c34a49c
11/02/2011 12:33:59.84 w3wp.exe (0x1684) 0x0C5C SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 1ea63834-ee2a-4b5c-9315-565a6c34a49c
11/02/2011 12:33:59.87 w3wp.exe (0x1684) 0x0C5C SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_layouts/AccessDenied.aspx)). Execution Time=41.6871418015418 1ea63834-ee2a-4b5c-9315-565a6c34a49c
11/02/2011 12:34:00.77 OWSTIMER.EXE (0x2218) 0x1DDC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Timer Job Bamboo Alert Plus Custom Timer Job) 6b81d611-a275-4694-b64e-3e5a512410a6

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

Hilary Stoupa — Wed, 02 Nov 2011 20:06:12 GMT

I don't see a difference between these either - I diffed them in WinMerge and only see differences in the time, etc. I've emailed Jim (another Qdabra team member) and asked him to take a look at this thread when he has a minute. You've admin approved (or sandboxed) the form, right? You must have, or qRules wouldn't be working for anyone, regardless of permissions....

Re: Retrieving SP list data works in preview but after publishing does not retrieve data from SP list

bsieloff — Wed, 02 Nov 2011 17:53:18 GMT

I have checked the logs, and don't see any errors. I went ahead and filtered the log on owssvr. I did one test at 12:33 with the test user (fail) and one at 12:40 my account (success). I'll drop that part of the log in this thread, but they look the same to me.

-B

11/02/2011 12:33:59.06 w3wp.exe (0x1684) 0x2598 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789) 2b0bc350-9dd9-48a9-a07d-3591bbe28e89
11/02/2011 12:33:59.07 w3wp.exe (0x1684) 0x2598 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789)). Execution Time=1.4730922505514 2b0bc350-9dd9-48a9-a07d-3591bbe28e89
11/02/2011 12:33:59.12 w3wp.exe (0x1684) 0x0C5C SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789) 77a855eb-bf35-4cdd-baa3-a68390495f66
11/02/2011 12:33:59.12 w3wp.exe (0x1684) 0x0C5C SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789)). Execution Time=1.54237479903172 77a855eb-bf35-4cdd-baa3-a68390495f66
11/02/2011 12:33:59.13 w3wp.exe (0x1684) 0x2598 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789) 160d262a-8b93-42f7-bc92-334987a88233
11/02/2011 12:33:59.13 w3wp.exe (0x1684) 0x02F8 SharePoint Foundation General af71 Medium HTTP Request method: GET 160d262a-8b93-42f7-bc92-334987a88233
11/02/2011 12:33:59.13 w3wp.exe (0x1684) 0x02F8 SharePoint Foundation General af75 Medium Overridden HTTP request method: GET 160d262a-8b93-42f7-bc92-334987a88233
11/02/2011 12:33:59.13 w3wp.exe (0x1684) 0x02F8 SharePoint Foundation General af74 Medium HTTP request URL: /wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789 160d262a-8b93-42f7-bc92-334987a88233
11/02/2011 12:33:59.23 w3wp.exe (0x1684) 0x2598 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789)). Execution Time=102.552419371736 160d262a-8b93-42f7-bc92-334987a88233

11/02/2011 12:40:24.43 w3wp.exe (0x1684) 0x18C0 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789) 852696b4-e84a-464b-92b4-4365c33efc0e
11/02/2011 12:40:24.43 w3wp.exe (0x1684) 0x18C0 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789)). Execution Time=1.26552397022527 852696b4-e84a-464b-92b4-4365c33efc0e
11/02/2011 12:40:24.46 w3wp.exe (0x1684) 0x18C0 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789) 835bb180-b273-4c6b-b15a-63c5f8293715
11/02/2011 12:40:24.46 w3wp.exe (0x1684) 0x18C0 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789)). Execution Time=1.68233672156657 835bb180-b273-4c6b-b15a-63c5f8293715
11/02/2011 12:40:24.46 w3wp.exe (0x1684) 0x18C0 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789) 211769cf-21bb-4093-af83-b7456e8b1298
11/02/2011 12:40:24.48 w3wp.exe (0x1684) 0x02F8 SharePoint Foundation General af71 Medium HTTP Request method: GET 211769cf-21bb-4093-af83-b7456e8b1298
11/02/2011 12:40:24.48 w3wp.exe (0x1684) 0x02F8 SharePoint Foundation General af75 Medium Overridden HTTP request method: GET 211769cf-21bb-4093-af83-b7456e8b1298
11/02/2011 12:40:24.48 w3wp.exe (0x1684) 0x02F8 SharePoint Foundation General af74 Medium HTTP request URL: /wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789 211769cf-21bb-4093-af83-b7456e8b1298
11/02/2011 12:40:24.53 w3wp.exe (0x1684) 0x18C0 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://fc.gogoair.com:443/wf/_vti_bin/owssvr.dll?Cmd=Display&List=%7b344CC859-CF44-4A06-93B7-AFA6BCB1A6F6%7d&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=EmployeeSSN&FilterValue1=123-45-6789)). Execution Time=59.1178487768697 211769cf-21bb-4093-af83-b7456e8b1298