Qdabra qRules

Re: SubmitToSharePointList: "Access Denied" (I broke it AGAIN!!)

ErnestoM — Thu, 03 May 2012 11:38:49 GMT

Hi Roger,

I'm sorry that we haven't been able to solve this via the forum. If you'd like to continue investigating this, please send us email to support at qdabra dot com and we can discuss next steps and support options.

Thank you.

Re: SubmitToSharePointList: "Access Denied" (I broke it AGAIN!!)

Roger.W — Wed, 02 May 2012 11:30:27 GMT

AFAIK nothing has changed on the SP server (I'll be talking with the admin this morning about just that). The test form was first "looking" at the same list and, when that failed, I connected it to a different, very simple one-record, one-field list with the same result.

Re: SubmitToSharePointList: "Access Denied" (I broke it AGAIN!!)

Hilary Stoupa — Tue, 01 May 2012 21:15:40 GMT

Did anything else change on your SharePoint server? Updates?

With your test form that you created, were you using the same list? Or a different list?

Re: SubmitToSharePointList: "Access Denied" (I broke it AGAIN!!)

Roger.W — Tue, 01 May 2012 16:40:11 GMT

I did a bit of poking around in the log files on the SP server and found the following entries (seemingly related to the issue I'm having);

0x1EA8 SharePoint Foundation         Logging Correlation Data      xmnv Medium Name=Request (POST:http://teams.tshore.com:80/custcare/_vti_bin/lists.asmx) 13bae01b-d730-4ec4-b6e8-c0c20aff32
0x1EA8 SharePoint Foundation         General                       fbv5 Medium SoapAction: "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems" 13bae01b-d730-4ec4-b6e8-c0c20aff32f
0x1EA8 SharePoint Foundation         General                       fbv6 Medium <?xml version="1.0" encoding="UTF-8" standalone="no"?><SOAP-ENV:Envelope xmlns:SOAPSDK1="http://www.w3.org/2001/XMLSchema" xmlns:SOAPSDK2="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAPSDK3="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><tns:UpdateListItems xmlns:tns="{C8641E38-1E11-4196-AD0F-9ADA6B51272B}http://schemas.microsoft.com/sharepoint/soap/"><tns:listName>{C8641E38-1E11-4196-AD0F-9ADA6B51272B}</tns:listName><tns:updates><Batch OnError="Continue"><Method ID="1" Cmd="New"><Field Name="Title">1</Field></Method></Batch></tns:updates></tns:UpdateListItems></SOAP-ENV:Body></SOAP-ENV:Envelope> 13bae01b-d730-4ec4-b6e8-c0c20aff32f
0x1EA8 SharePoint Foundation         Logging Correlation Data      xmnv Medium Site=/ 13bae01b-d730-4ec4-b6e8-c0
0x1EA8 SharePoint Foundation         General                       c3pa High    Batchmgr Method error. Errorcode: 0x0f74acc0. Error message: Access denied. You do not have permission to perform this action or access this resource. 13bae01b-d730-4ec4-b6e8-c0c20aff32
0x1EA8 SharePoint Foundation         Monitoring                    b4ly Medium Leaving Monitored Scope (Request (POST:http://teams.tshore.com:80/custcare/_vti_bin/lists.asmx)). Execution Time=19.4697929485451 13bae01b-d730-4ec4-b6e8-c0c20aff32f4

I don't know if any of this is useful, but here it is...

Re: SubmitToSharePointList: "Access Denied" (I broke it AGAIN!!)

Roger.W — Tue, 01 May 2012 15:24:18 GMT

OK...I did as you asked Ernesto;

I created a simple form with a single field. I mapped that field (using the new qRules) to the SAME list that my complicated form was mapped to...with the same results. Then I created a new custom list with a single-line text field in the same subsite, generated a new mapping file (with the same name as the old) between the form and the list and re-created the data connection to the new mapping file (just in case). I got the same error.

As far as I know, nothing has changed in the site, or subsite that would cause me NOT to have permissions to the list. So...what am I missing? Where should I look to next?

Roger

PS - just for grins, I went to both lists and manually entered and modified items - which I could do with ease.

Re: SubmitToSharePointList: "Access Denied" (I broke it AGAIN!!)

ErnestoM — Tue, 01 May 2012 14:04:40 GMT

I wonder whether a new, simple SharePoint list mapping would work. Would you be willing to step thru a very simple form mapping to a very simple list, and verify whether that works correctly? This would at least tell us whether it is an issue with the environment or the form.

A. If your simple (new) form and new mapping work, then it's an issue within the current form itself.

B. If your simple new form and mapping fail, then we can guess it's an issue in the environment.

Would you mind doing this as a troubleshooting step? Create a blank new form, inject it with qRules, create a ShP list, and then create a mapping between the form and the list. Publish the form and test it out. Let us know what you find. Thanks!

SubmitToSharePointList: "Access Denied" (I broke it AGAIN!!)

Roger.W — Tue, 01 May 2012 13:53:21 GMT

A case of "curiouser and curiouser"...I had a form that used the SubmitToSharePointList rule which had an error that you (Ernesto and Hillary) helped to resolve in this thread;

http://www.infopathdev.com/forums/t/22067.aspx

That issue was resolved by re-injecting the form with the "latest and greatest" of the qRules. Since the end of that episode I've made several changes which have precipitated a NEW error; "Errors occurred submitting to list: Access denied. You do not have permission to perform this action or access this resource." The changes I've made to the orginal form are (in order of change);

Several "layout" changes to make the form easier to navigate.
Two new fields on the form that are used to control visibility of sections in the form based on input to other fields.
Inclusion of a new data connection to retrieve info from another list (display of multiple customer addresses that change with the entry of a customer ID).
Insertion of a new view to select from one of those addresses in #3 above, and a new button to "record" that selection into another new field in the form.
Some "tweaks" to rules to make all of the above work (more or less, I'm still debugging this).

I got through all of this (which I thought was non-impactful to the submit function - silly me), and went to test my shiny new form - from "Preview" mode in InfoPath 2010 - where I found the error mentioned above ("...access denied...") blazing from a "qRules error" box that I (thankfully) kept around for debugging purposes. Here are the steps I've taken so far - to no avail;

I thought I had somehow "broken" the mapping XML, so I manually edited that...with disasterous effects (I'm no XML-dude, by any stretch of the imagination).
I downloaded qRules (which we had recently purchased - I was previously using the Trial), thinking that our Trial had expired, and re-generated the mapping file AND re-injected the form...nada.
I checked and double-checked my permissions to the list I was trying to submit to (yep, I'm still a site collection admin, yep, I still have "full Control" access to the list).

And that is the extent of my troubleshooting. So now what? I'm sure that the answer will be embarassingly simple, but I am stumped for now.

Roger