Filler form works in a Preview but fails when accessed through URL

CCBSFranco — Fri, 08 Aug 2014 20:01:24 GMT

Hey everyone,

I have a IP 2013 filler form, injected with Qdabra, integrated with SQL. It contains a nested repeating group structure. e.g.:

IG - First Repeating Group

Phase - Second Repeating group within the First

Task - Third Repeating group within the second, within the first

Org - Fourth Repeating group within the third, within the second, within the first

I have a field in the myFields for a project entry. At this "Project" field I have a rule that first acquires my data from SQL then deletes and inserts the IG groups. At the IG group it inserts the Phases and at the Phase it inserts the Task and Task it inserts the Orgs. All of this is a beautiful thing..... in preview.... It works great all my rows are inserted as I wanted and all the data is exactly as is should be within its correct groupings.

Now the problem. I published my form into a SharePoint library and I created a quick URL link to the form template in excel. The "Project" parameter is passing through yet when it attempts to open the form and insert the groups, It gives me 6 errors, Operation Aborted. When the form opens we have almost all the data in the groups except for the last 3 tasks and last 3 orgs. When I check the data view to see if the data coming from SQL was broken or missing, it's all there. If I goto the SharePoint library and open a "New Document" then type in the project into the "Project" field, it queries and inserts all the rows properly just as it did in preview.

I have created many forms in the past passing a parameter into it and querying against SQL databases for the data. All have never performed in this manner when accessed through a URL. I am unsure as to what could cause it to fail when trying to access the form through a URL.

Quick reminder: IP2013 Filler Form. SP2010 library set to open in client and not in browser.

Any help is appreciated and I will happily any questions I may not have covered.

General

Filler form works in a Preview but fails when accessed through URL