Access Services is unable to process the request.

Few days before I worked on one access issue but at that time the exception was different and this time we faced new error message.

Problem description:

While working on asset database site, trying to create new item and got the following exception.

Error message:

Access Services is unable to process the request. Click here to try again

Let me tell you access service application was already created and properly working without any issues.

Troubleshooting done:

-Checked the status of the access service application

-Checked the access SA proxy-whether it’s been properly associated with that web application or not.

-Checked the SharePoint logs as it is the most important location where we can find the cause behind it.

-Checked the event logs for any noticeable event id based on access.

-Try opening your SharePoint website in Firebug (Firefox utility) and check what exactly it’s blocking.  

IMP POINT:

Make sure that your foundation web application service and access services are running on the same box.

Please refer this for detail information: http://sharepointknowledgebase.blogspot.in/2013/08/unexpected-error-occurred-while-running.html

Resolution:

-Do IISRESET and check the results.

-If you check the logs and find any traces on security token service not working then you need to provision the security token service application.

Get-SPServiceApplication

$sts = Get-SPServiceApplication | ?{$_ -match "Security"}

$sts

$sts.Status

$sts.Provision()

If you have any different resolution apart from mentioned above then please share here so that it would be useful as well as beneficial to others as well.

If you have any queries/questions regarding the above mentioned information then please let me know, I would be more than happy to help you as well as resolves your issue, Thank you.