06 August, 2013

Unexpected error occurred while running macro in projects Web Database Site

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

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


Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.