I got below error on any of the infopath form used in any of the webapplication on sharepoint farm. Behavior of this error was quite confusing as sometime infopath form works and sometime it gives error.
Warning
|
An error occurred querying a data source.
|
Click OK to resume filling out the form. You may
want to check your form data for errors.
|
Hide error
details
|
|
An error occurred querying a data source.
An entry has been added to the Windows event log of the
server.
Log ID:7893
Correlation ID:473c9412-XXXX-4dd7-xxxx-1f497707bd44
|
|
|
After spending hours and hours of research even i was not able to solve issue. At last i tried below steps and whola it worked. infopath 7893 error solved.
Steps:
1) I change the User profile service running application pool identity
to someone who had access in the user profile service sharing.
Following are the steps..
Go to application server (in case of 3-tier architecture) or on server where userprofile service is running.
Go to IIS >> Applicaiton pools >> Sharepoint web services Root >> Advance settings
In advance settings change Identity to domain user. Recycle the pool in order to apply change.
2) Make sure the account has accessed in user profile service sharing.
Go to central admin >> Manage service applications >> User
Profile Service Application
This will resolve issue in most of cases. if incase issue is not resolve, please check below solution:
3) Increased the Data connection Timeouts in Configure Infopath Services
Go to Central Admin >> General Application Settings >> InfoPath Forms Services >> Configure InfoPath Forms Services. Now increase data connection timeout.
4) created a wakeup script to target
http://rootsite/_vti_bin/UserProfileService.asmx
you can find IIS Warmup scripts here:
http://spwakeup.codeplex.com
This four steps will solve the issue permanently.
Hope this helps!!
Regards,
Viral Shah