none
SharePoint InfoPath on PageLoad getting 401 Unauthorized error after restoring with Produciton DB on other environment RRS feed

  • Question

  • The SharePoint system is In-place upgraded on Prod environment from 2007-->2010 from there we are trying to take backup and restore on Other environments(DEV/TEST) with the same setup. Only the In path in SharePoint is giving below error when try to create a new list, actually On Page Load there are couple of User information is been retrieved where we were receiving a warning alert "An error occurred querying a data source" and with the error details:

    System.Net.WebException: The remote server returned an error: (401)
    Unauthorized.
    at System.Net.HttpWebRequest.GetResponse()
    at
    Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterSharepointListQuery.SendSoapRequestAndReturnResultSync(DataAdapter
    adapter, WebRequest request)

    Interestingly,InfoPath Preview is working as expected without any issues only it is failing when we open in SharePoint(All Published InfoPath). Web services are accessible and retrieving data when we access in Browser or outside of InfoPath. We have tried adding DisableLoopbackCheck in registry but no luck. Any help on this would be great!


    Madhu M.


    • Edited by Madhu_M Friday, October 16, 2015 3:36 PM Added more Info
    Thursday, October 15, 2015 8:49 PM

All replies

  • did you do a bulk update sites ?

    Also - could you give a little more than just the error?  Can you please talk about the process you went through - most people cant see how the error is produced and dont know errors off the top of their head... plus this could be easily solved if you're doing a step out of place  that might be it .. which it seems whats going on here.. 

    Please mark as answer if this answers your question

    Friday, October 16, 2015 11:15 AM
  • thanks, I have added more info.

    Madhu M.

    Friday, October 16, 2015 3:40 PM
  • You might want to redirect your question to the SharePoint section of this forum - they may be able to better assist you -

    this forum is for Project Server related questions

    Sunday, October 18, 2015 4:14 PM