SharePoint Integration

Re: Secondary data connection on web browser form

infopathdever — Tue, 06 Oct 2009 17:43:46 GMT

After spending 4 days with the "There are multiple root elements" error from submitting from infopath (browser enabled through sharepoint) through a webservice and to a sql server, my team was able to fix this.

We fixed it by changing the submit in the data connection wizard to include "xml subtree, including selected element" in the drop down in the parameter options for the "include" for the field or group. (We also removed the UDC, but I don't think this had anything to do with this specific issue).

Good Luck!

Re: Secondary data connection on web browser form

warrtalon — Mon, 13 Jul 2009 21:45:06 GMT

Ah, in the case of needing a specific row in a repeating table, I don't think there is any easy way to do it without a custom solution. I build all my forms without code as I am not a dev, so anything in SYM Wong-A-Ton's realm would probably require her help or help from one of the Qdabra devs here.

Re: Secondary data connection on web browser form

warrtalon — Mon, 13 Jul 2009 21:42:32 GMT

In the GUI, data connections are defined as full URLs, so you can't do relative paths without doing it programmatically (as far as I know).

Re: Secondary data connection on web browser form

ccarns — Mon, 13 Jul 2009 21:38:25 GMT

Dang it I think I already have a flaw in the solution (at least for my scenario)

The data I am after in Form A is a few child nodes in and I need to filter it for a row (example where ID=5).

-----------------------

A solution path I was headed down was to use a SharePoint web service call "GetItem" in the COPY web service page (https://{yoursharepointsite}/_vti_bin/Copy.asmx) Then bring back the data and convert back into XML to traverse and filter the data I needed. It accepts one parameter which is the URL to the XML file.

See this link for reference:

http://www.bizsupportonline.net/infopath2007/programmatically-retrieve-infopath-form-from-sharepoint.htm

Re: Secondary data connection on web browser form

ccarns — Mon, 13 Jul 2009 21:21:20 GMT

@warrtalon GENIUS IDEA - seriously!

That would solve the issue and yes Form A is a infopath form.

Do you happen to know if you can save that secondary data source path as a relative path. The reason I ask is I have multiple instances of Form A which contain different data - but there is only one per folder. So Form B will be trying to pull Form A's (read only data) from the same folder Form B is currently in.

I was succesfull at changing the datasource path in code during testing so I can try that - but using a relative URL would not require any code.

Thanks a million for your reply!

PS The Form A data I am pulling in is purely forthe users reference - Form B's data is unique. Each of the 4 fields I need can be a few paragraphs so passing them in the URL as parametes is not an option.

{ NOTICE THERE IS A PAGE 2 >>> I already commented again}

Re: Secondary data connection on web browser form

warrtalon — Mon, 13 Jul 2009 17:33:47 GMT

Is Form A an InfoPath form? if so, can't you publish it to SharePoint, promote all the fields to the SharePoint form library where it resides, and then create a data connection to that list for consuming its data? The data in Form B would always pull real time data from Form A.

If not, then what actually is your Form A, and why do you need to duplicate the data in Form B instead of using Views in Form A?

Re: Secondary data connection on web browser form

ccarns — Mon, 13 Jul 2009 17:03:50 GMT

OK does anybody have any creative work arounds?

My requirements are that I am trying to display some of the results/data(xml) of form A as a secondary data source for form B (read only). This would be using Form Services 07 - so web enabled is a required.

It seems like a simple enough request that other people have had to accomplished.

Work arounds that I might look into are:

1) Creating a Web Service that grabs the data of form A(a plain old XML file) and passes them through - because it works through web services

2) Take the data of form A and dump them into a SharePoint List. This is not the best options for two reasons a) my data could change (someone updates form A) and b) I dont know a way of automating it.

Thanks for any advice any experts out there might have

Re: Secondary data connection on web browser form

ccarns — Fri, 10 Jul 2009 23:55:19 GMT

OK I am having the exact same issue as the first poster(happydigit). Is there any solution for this issue - because if not I am going to have to a major redesign to my application to work around the issue.

It seems crazy to think I cant talk to a XML as a secondary data source when it is sitting in the same folder my form instance resides. (no cross domain issues here).

Re: Secondary data connection on web browser form

norale — Mon, 26 Nov 2007 03:59:41 GMT

Hi,

I'm facing with the same problem, where i've created drop down list that connected to the database to retrieve user full name. I've created UDC file in the sharepoint but still it prompt the same error.

My log file store this error:

11/26/2007 11:33:25.19 w3wp.exe (0x0C5C) 0x04DC Forms Server Forms Services Data Objects 7tfk Medium Data adapter failed during OnLoad: The form cannot connect to the data source. 254d3fde-8a55-43be-a655-02d2f4cc3497
11/26/2007 11:33:25.26 w3wp.exe (0x0C5C) 0x04DC Forms Server Forms Services Runtime - Data C 82fy Warning The following query failed: get_requestor (User: VWORKDEMO\shahril, Form Name: Travel Approval and Cash Advance Requisitions, IP: , Request: http://demomoss/_layouts/FormServer.aspx?XsnLocation=http://demomoss/mafc/Travel+Approval+and+Cash+Advance+Requisitions/Forms/template.xsn&SaveLocation=http://demomoss/mafc/Travel+Approval+and+Cash+Advance+Requisitions&Source=http://demomoss/mafc/Travel%2520Approval%2520and%2520Cash%2520Advance%2520Requisitions/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:Travel-Approval-and-Cash-Advance-Requisitions:-myXSD-2007-07-27T05-23-45, Type: DataAdapterException, Exception Message: The form cannot connect to the data source. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.) 254d3fde-8a55-43be-a655-02d2f4cc3497

Any suggestion for this kind of error?

Thanks.

Re: Secondary data connection on web browser form

tonedogg02 — Tue, 20 Nov 2007 23:40:34 GMT

Has anyone found a solution for this? I'm having the exact same problem and I get event ID's 7tfk and 82fy. I have been troubleshooting with MSFT for a few days now and they seem to be coming up empty handed. The only thing I havn't tried is publishing the form with a certificate...

Re: Secondary data connection on web browser form

tagorenet — Tue, 27 Feb 2007 16:21:13 GMT

quote:
Originally posted by Patrick Halstead

Hi HappyDigit,
I think you need to either convert the data connection to be a) UDC file (see Tools\Data Connections\Convert) or b) include the XML file in the solution. You could also just use a SharePoint list for dropdown controls. Take a look at ourhttp://formsboard.com/ site it has a couple samples of this - Sales Order and Sales Leads. Login using demo@qdabra.com and pw=InfoPath2007. Good luck.

Hi,
Can you please tell me how to create an UDCX file and I tried with the given site but its not opening..

Thanks in advance

Re: Secondary data connection on web browser form

happydigit — Tue, 13 Feb 2007 11:39:15 GMT

Oh don't know how to find out forms server version but we use the forms server which is in SharePoint 2007 Version: 12.0.4518.1016

quote:
Originally posted by Patrick Halstead

What version of Forms Server are you running?

Re: Secondary data connection on web browser form

Patrick Halstead — Tue, 13 Feb 2007 09:16:13 GMT

What version of Forms Server are you running?

Re: Secondary data connection on web browser form

happydigit — Mon, 12 Feb 2007 10:41:37 GMT

Hello David,

I did what you said and here is the error log :-)


02/12/2007 11:34:11.53 	w3wp.exe (0x1218)                       	0x162C	Forms Server                  	Forms Services Data Objects   	7tfk	Medium  	Data adapter failed during OnLoad: The form cannot run the specified query.	2fb3a625-7564-4df0-8d84-a94089e36924
02/12/2007 11:34:11.53 	w3wp.exe (0x1218)                       	0x162C	Forms Server                  	Forms Services Runtime - Data C	82fy	Warning 	The following query failed: Master (User: WUM41200\Administrator, Form Name: CreateEMail, IP: , Request:http://wum41200/_layouts/FormServer.aspx?XsnLocation=http://wum41200/hr/Bewerbermanagement/FormServerTemplates/CreateEMail.xsn&openin=browser&Source=http://wum41200/hr/Bewerbermanagement&itemid=28, Form ID: urn:schemas-microsoft-com:office:infopath:CreateEMail:-myXSD-2007-01-31T20-48-46, Type: DataAdapterException, Exception Message: The form cannot run the specified query. There are multiple root elements. Line 2, position 2.)	2fb3a625-7564-4df0-8d84-a94089e36924

The Error "There are multiple root elements" is not right. I checked the XML file with a tool and it is well formed. Actualy the XML file cames from InfoPath ;) In this file are a repeating section.

my:email
- my:templates

templates is the repeating section.
Note: If I open the form in InfoPath client all worked well, if I open the form with formserver I got this error.

Re: Secondary data connection on web browser form

davidair — Mon, 12 Feb 2007 04:21:47 GMT

I would recommend checking the log file to see exactly what the problem is first:
Go to "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS" (or wherever your SharePoint logs are)
Repeat the operation that causes a failure in IPFS and check the latest entry in the log (it should have "Forms Server" in it). It should give you a clue to what specifically is wrong. You can also use the Application Event Viewer to get some more details.

To check your IPFS settings, do the following in SharePoint Central Admin:
Application Management | Configure InfoPath Forms Services

You might need to check "Allow cross-domain data access for user form templates that use connection settings in a data connection file"

Finally, make sure your UDC is correct. You might read more on the format here:http://blogs.msdn.com/infopath/archive/2006/10/30/the-anatomy-of-a-udc-file.aspx

Hope it helps