SharePoint Integration

Re: The form cannot run the specified query. The remote server returned an error: (500) Internal Server Error.

bilja — Fri, 21 Sep 2018 08:55:18 GMT

This seemed to resolve the issue:

$f = Get-SPInfoPathFormsService
$f.Properties.Add("AllowEventPropagation", $false)
$f.Update()

Reference link: https://support.microsoft.com/en-us/help/2984138/forms-timeout-or-take-a-long-time-to-open-in-infopath-2010-or-infopath

Re: The form cannot run the specified query. The remote server returned an error: (500) Internal Server Error.

bilja — Thu, 26 Jul 2018 08:34:01 GMT

Recent issue is high cpu of 100% for w3wp.exe and top requests for worker process are REST data connections from infopath form.

Re: The form cannot run the specified query. The remote server returned an error: (500) Internal Server Error.

bilja — Wed, 11 Apr 2018 06:39:10 GMT

Not the first time. He usually has opened forms already, but at some point when he tries to open the form he gets this error.

Re: The form cannot run the specified query. The remote server returned an error: (500) Internal Server Error.

Hilary Stoupa — Tue, 10 Apr 2018 15:04:45 GMT

And for this user, the issue is consistent? The first time they try the form they get an error, and when they try the form again it works?

The form cannot run the specified query. The remote server returned an error: (500) Internal Server Error.

bilja — Tue, 10 Apr 2018 10:02:02 GMT

Hi, We have admin-approved InfoPath 2010 form with code deployed on Sharepoint 2010. The form has a few REST data connections which execute on form load. One user keeps getting this error when opening form: XML data that is required for this form to function correctly cannot be found. An entry has been added to the Windows event log of the server. Log ID:5566 Correlation ID gives these errors in Sharepoint log: Data adapter failed during OnLoad: The form cannot run the specified query. The following query failed: REST ... Type: DataAdapterException, Exception Message: The form cannot run the specified query. The remote server returned an error: (500) Internal Server Error. When the user tries to open the same form after a few seconds everything works as expected. I couldn't reproduce the issue. Does anyone have any clue what could be the reason for this? Thank you.