InfoPath Dev

I setup the Check Out/Check UDC based on the tool that i purchased from Qdabra..... but i get this error and I do not know what it means: The query cannot be run for the following DataObject: CheckOutFile InfoPath cannot run the specified query. The SOAP response indicates that an error occurred on the server: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Parameter pageUrl is missing or invalid.0x82000001 Can someone help me here? Chris

Hi:

The error indicates the pageUrl parameter of the query was not set (or was not set to an existing / correct url) prior to the query being executed. What are you setting that query parameter to?

I followed the pdf.  Your pdf instructions say

 

5. (i). 

 

The first field to set is the is pageUrl:

Figure 13

It needs to be set to the URL of your form's XML file which we’ll determine via the XML’s processing instructions. Paste this in the formula box: concat(substring-before(substring-after(xdXDocument:get-DOM()/processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'href="'), 'Forms/template.xsn"'), my:FormName, ".xml")

If you click on the Verify Formula button, your formula should look like the following:

 So based on these instructions, your instructions say that the above code will find what it needs.....  so i copied and pasted as it states but get the error.  This also is required for step 6.(a)

 

Add a button with rules to check in the form; you can label this button ‘Check In’. Similar to what we’ve done before, this button will set the values of the CheckInFile data connection’s parameters:

Figure 22

a. First, we set the pageUrl field to same formula we used before: concat(substring-before(substring-after(xdXDocument:get-DOM()/processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'href="'), 'Forms/template.xsn"'), my:FormName, ".xml")

 

 Chris 

 

 

Can you attach your template to a reply or email it to support?

Attached is the form.   Check out button is on the switchboard view.

I've asked Ernesto to review the instructions.

I can see in your form that the pageUrl is not being set before you check out - you need to do that.

The reason you were getting an error would be because the formula uses a field you don't seem to have in your form, as well as it doesn't include the full XPath to the field.

You will need to use the field picker to select the actual field in your form that you are using for your filename when you submit the XML to SharePoint - we are trying to use a formula to create the exact URL to the submitted XML. Does that make sense?

 concat(substring-before(substring-after(xdXDocument:get-DOM()/processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'href="'), 'Forms/template.xsn"'), my:FormName, ".xml")

You would select that field (or, in the case of your form, fields, since it looks like you are concatenating several fields together for your form name in your SharePoint Submit connection) to replace my:FormName in the formula.

to simplify it for me, i redid the check-in/check-out as a template part.  Meaning creating it by itself and being able to add it into future forms as a custom control .  my thinking now, is since i am going to use this in more than just this form, i can make it a custom control.   I took out the previous check-in/check-out part and added the control according to the instructions of the pdf.  

 I did a preview.  Again, the initial error returned.... just a little different this time:

 The query cannot be run for the following DataObject: CheckOutFile_TemplatePart1
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:

Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
<detail><errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/">Invalid URI: The format of the URI could not be determined.</errorstring></detail>

My question are this

1.) I did use the file picker for setup of the pageUR which also calls for you to verify the formula which i did.  I also followed your instructions and setup the FormName to be the concatenation of the actual forms submit. 

concat(substring-before(substring-after(processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'href="'), 'Forms/template.xsn"'), concat(EventNames, "-", DateSubmitted), ".xml")

I verified it as stated in the form and it is good.   (the EventNames and DateSubmitted) are file picked.  When i clicked the Edit XPath, the actual XPath is there so i know this is right.....

I think now i am as close as ever, outside of the error.    

I'm assuming you mean you used the field picker in the formula?

I've added some controls and buttons to your view and reattched the template. Can you preview the template and first click the button named "Set page URL"? The Page URL field should then be populated. Can you see if it is a valid URL? You can copy it and paste it in your Browser's address bar to check that.

If it is a valid URL, then try the button that simply executes the query below it.

Yes I used the field picker.  Even when i started this process a few days ago, i used the field picker for the fieldname........ 

1.) I clicked "Set page URL".  Page Url = Test checkout -2012-10-18.xml

                                           Checkout to Local: true

and again, when i clicked Execute Check Out Query, i received the error as earlier.......  

so in summary..... the Set pageUrl doesn't provide a valide URL address but does set the submission formname as "concat(EventNames - DateSubmitted)." 

 

 

So, the part of the formula that is failing in your form is the part to get the href from the XML processing instructions. Can you change processing-instruction()[local-name(.) in the formula to /processing-instruction()[local-name(.) and give it another try? No need to bother clicking the button to execute the query if you can see the page URL is not set to a vaild URL.

i see that the only difference between the two is the / so yep i did that (change out that part of the formula and clicked verify.... noticed the / disappeared and back to pageUrl: = -10-18-2012.xml 

Do you have the same result when you open from the published location?

okay i did publish and it listed the entire URL.....  looks like there just needs to be an adjustment in the pdf.    thank you .... hopefully now i will be able to move forward.   Can you send the template part you created? or did you edit mine?

I simply used your form. I have asked the test team to assess the current documentation - I agree that we have some gaps there.

when they update the pdf, can you send it to me since we paid for this application? 

 

thank you