Eeyore145

I am trying to use SQL Server 2005 Native XML Services with MOSS and InfoPath 2007.

Currently this is the behavior I am seeing:

1) I can create a receive secondary data source and if I view the document in InfoPath, it seems to work

2) After I publish the document to a SharePoint library and use Forms Services to invoke the document, the fields are empty or it appears the SQL Server 2005 XML Native Services webservice call isn't working.

So my questions are this:

1) Is InfoPath Forms Services or browser compatible InfoPath documents not compatible with SQL Server 2005 XML Services Is there any work around

2) Or might this be a permissions issue/where should I be looking if that is the case.

Please let me know your thoughts, because if this is not compatible it will change my overall design approach.

Thanks

MK




Re: SharePoint - InfoPath Forms Services Urgent: InfoPath Forms Services and SQL Server XML Native Services

Paul Galvin

The diagnostic log should provide better detail: http://paulgalvin.spaces.live.com/Blog/cns!1CC1EDB3DAA9B8AA!154.entry






Re: SharePoint - InfoPath Forms Services Urgent: InfoPath Forms Services and SQL Server XML Native Services

Eeyore145

Hello Paul:

Well I know what the errors are, because they are consistent. As is the behavior I am seeing, which is why I am trying to determine if InfoPath Forms Service is compliant with SQL Server 2005 XML Services. I would be surprised if its not, considering I would assume we are just dealing with standard SOAP. These are the errors in the "12 hive":

****************************************************************************************

09/19/2007 22:16:06.20 w3wp.exe (0x1AFC) 0x1C4C Forms Server Forms Services Data Objects 13zh Exception System.Net.WebException: The remote server returned an error: (500) Internal Server Error. at System.Net.HttpWebRequest.GetResponse() at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest request, DataAdapterTimer dataAdapterTimer, DataAdapterCredentials credentials, Stopwatch timer, ExecWebRequestExceptionState state, String adapterName, Boolean isQuery) at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest request, String adapterName, Boolean isQuery) at Microsoft.Office.InfoPath.Server.FormsServiceProxy.Proxy.HandleRequest(DataAdapterCredentials credentials, WebRequest webRequest, HttpContext context, SolutionDeploymentModel solutionDeploymentModel, String adapterName, Boolean isQu... fc898818-09e3-4532-a37d-8f9136212e40
09/19/2007 22:16:06.20* w3wp.exe (0x1AFC) 0x1C4C Forms Server Forms Services Data Objects 13zh Exception ...ery) at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM, Boolean resultUseDataset, XPathNavigator fc898818-09e3-4532-a37d-8f9136212e40
09/19/2007 22:16:06.31 w3wp.exe (0x1AFC) 0x1C4C Forms Server Forms Services Runtime - Busine 82g6 Warning Business logic failed due to an exception. (User: E-74A5FA73CDE24\MossDev, Form Name: UEPP, IP: , Request: http://e-74a5fa73cde24:27273/_layouts/Postback.FormServer.aspx, Form ID: urnTongue Tiedchemas-microsoft-comSurpriseffice:infopath:UEPP:-myXSD-2007-05-15T19-20-08, Type: WebException, Exception Message: The remote server returned an error: (500) Internal Server Error. There was an error in the incoming SOAP request packet: Client, LoginFailure, AccessDenied SOAP-1_2-ENVTongue Tiedendersqlsoapfaultcode:LoginFailuresqlsoapfaultcode:AccessDeniedThere was an error in the incoming SOAP request packet: Sender, LoginFailure, AccessDeniedhttp://e-74a5fa73cde24:1024/sql/UEPPhttp://schemas.microsoft.com/sqlserver/2004/SOAP The remote server returned an error: (500) Internal Server Error. There was an error in the ... fc898818-09e3-4532-a37d-8f9136212e40
09/19/2007 22:16:06.31* w3wp.exe (0x1AFC) 0x1C4C Forms Server Forms Services Runtime - Busine 82g6 Warning ...incoming SOAP request packet: Client, LoginFailure, AccessDenied SOAP-1_2-ENVTongue Tiedendersqlsoapfaultcode:LoginFailuresqlsoapfaultcode:AccessDeniedThere was an error in the incoming SOAP request packet: Sender, LoginFailure, fc898818-09e3-4532-a37d-8f9136212e40
09/19/2007 22:16:06.32 w3wp.exe (0x1AFC) 0x1C4C Forms Server Forms Services Object Model 7tge Assert Exception thrown from business logic event listener StackTrace: at Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.CallFormCodeWithExceptionHandling(UserMessages userMessages, OMCall d) at Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.<>c__DisplayClass2.<Click>b__0() at Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.Click(Document document, XPathNavigator container) at Microsoft.Office.InfoPath.Server.DocumentLifetime.EventClick.Play(Document document, BindingServices bindingServices, EventLogProcessor eventLogProcessor) at Microsoft.Office.InfoPath.Server.DocumentLifetime.Event.PlayEvent(Document document, BindingServices bindingServices, EventLogProcessor eventLogProcessor) at Microsoft.Office.InfoPath.Server... fc898818-09e3-4532-a37d-8f9136212e40
09/19/2007 22:16:06.32* w3wp.exe (0x1AFC) 0x1C4C Forms Server Forms Services Object Model 7tge Assert ....DocumentLifetime.EventLogProcessor.<>c__DisplayClass1.<ExecuteLog>b__0() at Microsoft.Office.InfoPath.Server.DocumentLifetime.EventLogProcessor.ExecuteLog(Int32 expectedEventLogID) at Microsoft.Office.InfoPath.Serv fc898818-09e3-4532-a37d-8f9136212e40

***************************************************************************************************

I have been getting this SOAP Packet access denied error. I've got a good deal of experience with web services and I've never had trouble like this before.

To add more regarding what I am seeing:

1) Per best practices I am using a UDC data connection file. This data connection file is relative to the site collection, I'm not going advanced and placing it in Central Administration.

2) If I set the forms services proxy parameter in the UDC (don't remember the exact nomenclature, but its like UseFormsServerProxy="false") to false, or its default value when converting the wsdl to a udcx file from within InfoPath this is the result I see:

I CAN get data from the SQL Server XML Web Service if I go through the InfoPath rich client. Whether the document is officially published to a forms library, doesn't matter, its works FINE.

Using Fiddler I see SharePoint is invoking the UDC in the data connection library, the SQL Server Xml Web Service is invoked, everything is fine.

When I render the same InfoPath document via Forms Services or browser enable it, the SQL Server Xml Web Service isn't even invoked. I notice in Fiddler the UDC isn't even being called by InfoPath Forms Services.

3) So I then set UseFormsServerProxy=true. Now I get this error above, when trying to invoke the SQL Server Xml Web Service from the InfoPath client OR the browser/InfoPath Forms Services.

So in summary it appears if I don't use the FormsServerProxy, InfoPath Forms Services doesn't even try to connect to the SQL Server End Point/XML Web Service. However, from the InfoPath client, its works fine. When I then try to use the FormsServerProxy, I can't connect.

There is NO domain involved, and everything is currently on the same machine, my local VPC. I have set the SQL Server End Point to use a specific port and NTLM. I doubt this is the problem, since I can browse to the wsdl fine and log into sql server. In desperation I even did a GRANT CONNECT on the public role. And since I *can* connect through InfoPath as long as I don't go through InfoPath Forms Services, I don't think the End Point is the problem. I only have a few accounts on this development box, all local, and I can't figure out how any account would be getting "locked out".

This is why I am trying to verify that InfoPath Form Services can connect to a SQL Server 2005 Native XML Web Service, maybe there is some sort of compatibility problem. If so, I need to know desperately, I can't wrap my head around this problem. Sure, I could write my own web service to using ADO.net and feed that into InfoPath but I had a good reason for wanting to use End Points and XML Services...and I'm struggling to figure out the problem here.

Any ideas, thoughts, confirmations (is this compatible out of the box ) are greatly appreciated.

MK






Re: SharePoint - InfoPath Forms Services Urgent: InfoPath Forms Services and SQL Server XML Native Services

Eeyore145

Well, FYI.

I've ditched communicating directly with SQL Server XML Native Services. I have created my own web services which feeds back the needed data to InfoPath, this works fine. I believe there is a problem with how SQL Server XML Native Servies authenticates and the "multi-hop" nature of InfoPath Forms Services authentication. Even with this theory, all logical attempts to fix that would not work. So I rolled my own Web Service, and it seems to be working fine.

Thanks Paul for your initial input.

MK