Controls

Re: Submit button - Error on Validation

jcrosetto — Fri, 22 Dec 2023 22:09:33 GMT

Hello, I have an InfoPath form with 2 Date and Time columns, named Created and Target Implement Date. The request is to make the form accept a submission with a Target Implement Date greater than or equal to today. Currently only future dates are allowed. Creating a Validation Rule Condition of Target Implement Date is less than now(), but this does not allow us to choose today. This works for limiting to future dates, but if we pick today's date, the form fails to submit with the following error: "One or more fields have invalid values and cannot be submitted to the list."

Re: Submit button - Error on Validation

lockettc — Thu, 07 Nov 2013 18:45:08 GMT

I had the same thing happen to me today. I had marked 2 fields as required in my form, but then changed them when I realized I didn't want them required. However, InfoPath kept insisting that I had fields that were not completed that were marked required. There was no red fuzzies, or dotted lines. just the error. So I tried the above.. I exported the files locally, then deleted the template.xsn from the forms folder, then republished from my local copy. And there you have it: a working form. Not that I spent the last 4 hours trying to figure it out! Oh well.. Thanks for this post! Without it, I would be another 4 hours in before I finally give up and start over!

Re: Submit button - Error on Validation

Kiwiboer — Mon, 07 Oct 2013 01:01:17 GMT

Same issue here. We running InfoPath 2007. Developer has left and I am a bit stuck. I check the rules behind the Submit button and spot something of concern. There are 5 stage fields (stage1, stage2 .... stage5) being set but the value looks corrupted. Set a fields values: stage1 = "ðððþððð" 2 questions: 1. Could this cause the form to error thinking that a field needs to be set? 2. How do I find the meaning of these values?

Re: Submit button - Error on Validation

qed59 — Thu, 13 Dec 2012 03:17:10 GMT

if you have a control, and you applied rules against that control, and then later you delete that control, the rules will still be active against that control.

One way to check if the above is causing the validation error is go to Data->Rule Inspector and check if there are rules still been applied to control that are no longer in your form.

Re: Submit button - Error on Validation

Hilary Stoupa — Wed, 05 Dec 2012 23:38:06 GMT

Okay - just tried this - and my form updated correctly. That is, I modified my IP SharePoint List form to make a field required and published. I verified when I opened an item, the field is now required. I modified the form to make the field not required - republished, and the field is no longer required. You may want to let your SharePoint admin know about this (if you are the admin, check your logs and see if you can figure out what's going on ....)

Re: Submit button - Error on Validation

Hilary Stoupa — Wed, 05 Dec 2012 16:17:36 GMT

Oh, I'm glad you have a work around! I still want to try this sometime this week, see if I can repro on one of our servers... :-)

Re: Submit button - Error on Validation

texrat — Wed, 05 Dec 2012 16:15:37 GMT

I have a usable solution: under SharePoint Form settings, I change to the default SharePoint form and delete the InfoPath form. Then republish the InfoPath form: no more error message!

So apparently, as suspected, SOMEthing is not being overwritten completely, unless the InfoPath form is deleted.

Re: Submit button - Error on Validation

texrat — Fri, 30 Nov 2012 23:44:45 GMT

Hilary Stoupa:
No, this should be fine - is this a SharePoint list form then? I might give this a try next week, see if I have something similar happen. Regular ShP 2010, not Office 365?

Yes to all. I have also contacted our site admin to see if something changed to cause this; waiting for a response. Spent hours searching online and I swear I must be the only person this has happened to... :(

Thanks!

Re: Submit button - Error on Validation

Hilary Stoupa — Fri, 30 Nov 2012 23:38:28 GMT

No, this should be fine - is this a SharePoint list form then? I might give this a try next week, see if I have something similar happen. Regular ShP 2010, not Office 365?

Re: Submit button - Error on Validation

texrat — Fri, 30 Nov 2012 23:28:02 GMT

Hilary Stoupa:
Not to be silly - but did you republish the form after correcting the error?

Yep, used Quick Publish after every update. I'm new to InfoPath with zero training-- is there a step or option I'm maybe missing?

Note: I've actually created several forms, and all were working fine until this week. Still no clue what broke-- but this is the first time I've had forms not update after republishing, and my methods have not changed. So I'm flabbergasted.

Re: Submit button - Error on Validation

Hilary Stoupa — Fri, 30 Nov 2012 23:09:39 GMT

Not to be silly - but did you republish the form after correcting the error?

Re: Submit button - Error on Validation

texrat — Fri, 30 Nov 2012 23:03:21 GMT

I'm starting to get a handle on the problem, and it took building a new list to do so. But I still don't get what's going on.

Somehow SharePoint (or InfoPath, or both) is not letting go of old, obsolete error situations.

For instance, in the original problem, even after I deleted everything that could have caused the problem, it persisted.

So next I built a new list, and tested it column by column. At one point I added a concatenated value to a field, but I screwed up: I added it as a default value to an existing bound text box instead of a new Calculated Value control. The result was that the concatenated text went on forever and generated a time out when I Previewed the form. Oops.

I realized my error and corrected it-- but from that point on, I now receive this error:

Default values, rules or code may be running in an infinite loop. To prevent this, ensure that the default value, rule action or event handler does not update the data which causes the same rule action or event handler to execute.

So once again I stripped out any possible offenders (the original problem had already been fixed) but SharePoint refuses to acknowledge that the problem no longer really exists.

This has me completely stumped. It seems that SharePoint is "seeing" the old, error-afflicted form rather than the newly published one(s). Do you know if it's a SharePoint or InfoPath problem? Any idea how to correct this?

Re: Submit button - Error on Validation

texrat — Fri, 30 Nov 2012 15:01:47 GMT

Hilary Stoupa:
Check that description field again - does it have any custom validation on it? Attach your template to a reply (under the Options tab) if you want me to take a quick look.

No validation whatsoever. This error just popped up out of the blue-- I had made no changes since it last worked. The only thing I can see is that the "people picker" is acting weird: if you make ANY changes to ANY field on the form, the picker quits working-- i.e., it will not allow you to select anyone. No idea how or why this started happening. Again, no changes from me, and none of my colleagues can change anything.

I deleted the Description field after I posted, and the problem persists. This is really jacked up. Rather than trouble you further, I'm just going to restart from scratch. Fortunately there were only 4 projects created (PM solution). But I'm worried this will happen again, and I have no clue what to tell my boss to put his mind at ease... really, really hate Microsoft's useless error messages.

Thanks

Re: Submit button - Error on Validation

Hilary Stoupa — Fri, 30 Nov 2012 00:03:34 GMT

Check that description field again - does it have any custom validation on it? Attach your template to a reply (under the Options tab) if you want me to take a quick look.

Re: Submit button - Error on Validation

texrat — Thu, 29 Nov 2012 23:35:25 GMT

I wish my problem was that identifiable.

I get:

The form cannot be submitted because it contains validation errors. Errors are marked with either a red asterisk (required fields) or a red, dashed border (invalid values). Field or group: my:Description Error: Cannot be blank
Click OK to resume filling out the form. You may want to check your form data for errors.
An error occurred while using the form. For more information, contact the site administrator.

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

Correlation ID:3066c9d5-e7de-43ce-a692-accc95aecdda

There are no red asterisks or dashed borders. I have turned every field into not required. I have tried putting a value in every field anyway. I stripped out every lookup (they have been problematic). I turned off every rule. I eliminated every default value. I don't know how to identify"Field or group: my:Description"; there IS a Description field, but I have received this exact same error on Lookups where the field had a different name (?). And again, I made even Description not required.

Yet this problem persists-- and I have no apparent way of identifying how or why! (site admin will be no help on this one). Meanwhile boss is probably thinking I'm inept after 2 days troubleshooting...

I really, really wish Microsoft would give us useful error messages... :(