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

InfoPath Dev

Use our Google Custom Search for best site search results.

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

Last post 09-21-2018 01:55 AM by bilja. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 04-10-2018 03:02 AM

    • bilja
    • Not Ranked
    • Joined on 02-22-2018
    • Posts 4

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

    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.
  • 04-10-2018 08:04 AM In reply to

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

    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?
    Hilary Stoupa

  • 04-10-2018 11:39 PM In reply to

    • bilja
    • Not Ranked
    • Joined on 02-22-2018
    • Posts 4

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

    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.
  • 07-26-2018 01:34 AM In reply to

    • bilja
    • Not Ranked
    • Joined on 02-22-2018
    • Posts 4

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

    Recent issue is high cpu of 100% for w3wp.exe and top requests for worker process are REST data connections from infopath form.
  • 09-21-2018 01:55 AM In reply to

    • bilja
    • Not Ranked
    • Joined on 02-22-2018
    • Posts 4

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

    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

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.