InfoPath 2010 Form Error on Submit Data to SharePoint 2010 Form Library

DC Forms — Thu, 27 Sep 2012 21:16:56 GMT

I have an InfoPath 2010 web based form that first submits data via qRules to a SharePoint list using SharePointListSubmit and then submits the entire form to a SharePoint form (document) library via a data connection. The form is set to Full Trust, published as an Administrator Approved Template, and tied to the document library as a content type (the default content type was deleted). I've done the same for other forms without issue.

The qRules portion works. It is the submit via the SharePoint document library data connection that generates an error. The error occurs in both the web browser and from preview in the InfoPath client. My research eludes to the possibility it is a lookup column issue, see below. The form makes use of over 20 fields that are SharePoint lookup lists. (For the list qRules is writing to, I had to set some fields to not enforce relationship behavior because doing so would exceed the 20 indexed column limit for lists.)

In addition to the reported entry in the event log, there is an entry for a SQL error, “Error converting data type nvarchar to uniqueidentifier.”

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

InfoPath 2010 Form on SharePoint 2010 Browser Error:

The URL 'DDE Forms Swaps/2012-09-27T15_36_32[XXXXX_XXXX].xml' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.

An entry has been added to the Windows event log of the server.
Log ID:5567

Correlation ID:4c4a56ea-b2a2-40e2-8cc7-3b536e61dec1

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

InfoPath 2010 Client Error:

InfoPath cannot submit the form.
An error occurred while the form was being submitted.
The form cannot be submitted to the following location: http://sharepoint/DDE/DDE Forms Swaps/2012-09-27T16_52_10[XXXX_XXXX].xml
The URL 'DDE Forms Swaps/2012-09-27T16_52_10[XXXX_XXXX].xml' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.
The filename, directory name, or volume label syntax is incorrect.

=================================

Log Name:      Microsoft-SharePoint Products-Shared/Operational
Source:        Microsoft-SharePoint Products-InfoPath Forms Services
Date:          9/27/2012 3:38:17 PM
Event ID:      5567
Task Category: Runtime - Data Connections
Level:         Warning
Keywords:
User:          XXXX\XXXX
Computer:      XXXX.XXXX.com
Description:
Form submission failed. (User: XXXX\XXXX, Form Name: DDE-Swap_Form, IP: , Request: http://sharepoint/DDE/_layouts/FormServer.aspx?XsnLocation=http://sharepoint/FormServerTemplates/DDE-Swap_Form.xsn&SaveLocation=http://sharepoint/DDE/DDE Forms Swaps&ClientInstalled=true&Source=http://sharepoint/DDE/DDE%2520Forms%2520Swaps/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:DDE-Swap-Form:-myXSD-2012-09-14T15-17-06, Type: DataAdapterException, Exception Message: The form cannot be submitted to the following location: http://sharepoint/DDE/DDE%20Forms%20Swaps/2012-09-27T15_36_32%5BXXXX_XXXX%5D.xml. There is a problem with the Web server. Make sure the Web server exists, try again later or contact the Web server administrator.
The URL 'DDE Forms Swaps/2012-09-27T15_36_32[XXXX_XXXX].xml' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Microsoft-SharePoint Products-InfoPath Forms Services" Guid="{A3499A35-DB34-421A-94FC-4D76522BEAB3}" />
    <EventID>5567</EventID>
    <Version>14</Version>
    <Level>3</Level>
    <Task>5</Task>
    <Opcode>0</Opcode>
    <Keywords>0x2000000000000000</Keywords>
    <TimeCreated SystemTime="2012-09-27T20:38:17.585369400Z" />
    <EventRecordID>6123</EventRecordID>
    <Correlation ActivityID="{4C4A56EA-B2A2-40E2-8CC7-3B536E61DEC1}" />
    <Execution ProcessID="3988" ThreadID="3316" />
    <Channel>Microsoft-SharePoint Products-Shared/Operational</Channel>
    <Computer>XXXX.XXXX.com</Computer>
    <Security UserID="S-1-5-21-1474651832-2131563176-1848903544-7678" />
</System>
<EventData>
    <Data Name="string0">XXXX\XXXX</Data>
    <Data Name="string1">DDE-Swap_Form</Data>
    <Data Name="string2">
    </Data>
    <Data Name="string3">http://sharepoint/DDE/_layouts/FormServer.aspx?XsnLocation=http://sharepoint/FormServerTemplates/DDE-Swap_Form.xsn&SaveLocation=http://sharepoint/DDE/DDE Forms Swaps&ClientInstalled=true&Source=http://sharepoint/DDE/DDE%2520Forms%2520Swaps/Forms/AllItems.aspx&DefaultItemOpen=1</Data>
    <Data Name="string4">urn:schemas-microsoft-com:office:infopath:DDE-Swap-Form:-myXSD-2012-09-14T15-17-06</Data>
    <Data Name="string5">DataAdapterException</Data>
    <Data Name="string6">The form cannot be submitted to the following location: http://sharepoint/DDE/DDE%20Forms%20Swaps/2012-09-27T15_36_32%5BXXXX_XXXX%5D.xml. There is a problem with the Web server. Make sure the Web server exists, try again later or contact the Web server administrator.
The URL 'DDE Forms Swaps/2012-09-27T15_36_32[XXXX_XXXX].xml' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.</Data>
</EventData>
</Event>

=================================

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          9/27/2012 3:38:17 PM
Event ID:      5586
Task Category: Database
Level:         Error
Keywords:
User:          XXXX\XXXX
Computer:      XXXX.XXXX.com
Description:
Unknown SQL Exception 8114 occurred. Additional error information from SQL Server is included below.

Error converting data type nvarchar to uniqueidentifier.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <EventID>5586</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2012-09-27T20:38:17.460357400Z" />
    <EventRecordID>68773</EventRecordID>
    <Correlation ActivityID="{4C4A56EA-B2A2-40E2-8CC7-3B536E61DEC1}" />
    <Execution ProcessID="3988" ThreadID="3316" />
    <Channel>Application</Channel>
    <Computer>XXXX.XXXX.com</Computer>
    <Security UserID="S-1-5-21-1474651832-2131563176-1848903544-7678" />
</System>
<EventData>
    <Data Name="int0">8114</Data>
    <Data Name="string1">Error converting data type nvarchar to uniqueidentifier.</Data>
</EventData>
</Event>

=================================

Possible Clues

http://bernado-nguyen-hoan.com/2011/03/22/sharepoint-evil-1-the-url-url-is-invalid-it-may-refer-to-a-nonexistent-file-or-folder-or-refer-to-a-valid-file-or-folder-that-is-not-in-the-current-web/

http://stackoverflow.com/questions/1295050/add-a-lookup-field-to-a-content-type-in-sharepoint

SharePoint Integration

InfoPath 2010 Form Error on Submit Data to SharePoint 2010 Form Library