So here it comes another issue that
we faced as well as resolved it by taking some proper configuration steps as
per recommendations from Microsoft. It was not a trickiest one but still took
some time to drill down to resolution.
What was the exact issue? / Problem
description?
User was trying to add new projects
on SharePoint 2010 “Projects Web Database” site.
Error Message:
Unexpected error occurred while running
macro.
Here are some links that i have read
before starting troubleshooting on this issue. Following links will help you to
understand the detail background of project web database as well as role of
access services.
Troubleshooting steps:
-Issue was restricted to project web
database site.
-checked the access services are
activated or not.
-If they are activated then on which
servers they are a part of i.e. are they activated on the app server or front
end server.
-checked the SP logs to find out the
root cause.
-checked the event logs to look out
for any specific event id’s
Resolution:
As per the Microsoft recommendations,
whichever the server is- access services and foundation web application
services should be running on the same server.
When we checked the status of access
services, they were activated on the APP server but if it’s an app server then
Foundation web application service should be in stopped state, so we can’t start
the foundation web application services on the app server. If we do this then
we are converting the app server into another WFE which is totally wrong and
not required.- This is a wrong configuration!
What we did?
We have stopped the access services
on the app server and started them on the front ends where the foundation web
application service is already running…
That’s it- after this issue has been
resolved and we are able to add new projects in a project web database site in
SharePoint 2010.
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 issues.
If you have some different resolution
apart from the above mentioned then request you to share the same so that it
would be beneficial to others as well. Thank you…
Product Applies To:
-SharePoint Server 2010
-SharePoint Foundation 2010
-SharePoint
Server 2013
