Retrieving SP list data works in preview but after publishing does not retrieve data from SP list - InfoPath Dev
in

InfoPath Dev

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

Last post 11-07-2011 09:50 AM by Hilary Stoupa. 35 replies.
Page 3 of 3 (36 items) < Previous 1 2 3
Sort Posts: Previous Next
  • 11-02-2011 04:05 PM In reply to

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

    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?

    Hilary Stoupa

  • 11-02-2011 04:17 PM In reply to

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

    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

  • 11-02-2011 04:36 PM In reply to

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

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

    Hilary Stoupa

  • 11-02-2011 04:47 PM In reply to

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

    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

  • 11-07-2011 09:42 AM In reply to

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

    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

  • 11-07-2011 09:50 AM In reply to

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

    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....
    Hilary Stoupa

Page 3 of 3 (36 items) < Previous 1 2 3
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.