Infopath form suddenly stop working

M

melon

I have an InfoPath form that used a table on the SQL server as data
source. It was working fine for 2 months, then today people start to
complain it doesn't work.

I checked and no one made any changes to the table and the InfoPath
form.

The error message is:

The query method on the Document object failed.

InfoPath cannot run the specified query.

The XML data returned from the data source does not match the XML
Schema for this form. This discrepancy might be caused by the data
source returning multiple rows when InfoPath expects only one.

Attribute 'New_Number' is not allowed on element '{http://
schemas.microsoft.com/office/infopath/2003/ado/dataFields}vwPAform',
according to Schema.

I have absolutely no idea where does the "New_Number" come from. I
extract all the schema and I don't see the "New_Number" being
referenced anywhere. The table does not has a column called
"New_Number" either. I just don't know where does this "New_number"
come from.
 
K

Kalyan G Reddy MVP (GGK Tech)

Hello

Modify the dataconnection once again with same settings. It should work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New InfoPath form using Office 2013 0
error: The form cannot be submitted because of an error. 0
InfoPath with XInclude schema import 0
Submitting InfoPath form (data) to sharepoint list 0
Creating a Word doc generated from InfoPath 2003 data 6
XML Schema (minOccu) 1
Debugging an infopath form 1
Import one Infopath Template Schema into another InfoPath Template 1

Top