Archive for the ‘2010’ Category

Rename a Project in MS Project Server Part 2

Friday, January 30th, 2015

Rename a Project in Microsoft Project Server – Part 2

Version: 2.1

Applies to:
MS Project Server 2010
MS Project Server 2013
MS Project Online (Office 365)

This is the second part of the series to explain the details of different cases and how to best rename a project schedule in Microsoft Project Server EPM.

Table of Contents


Summary

1. Steps to rename a project using Project Web Access (PWA)
2. Steps to rename a project using MS Project Professional
3. Rename Project site
4. Scenarios: Renaming Project and different Statuses of Timesheets
5. Renamed Project Schedule and Business Intelligence Center Reports
Conclusion

Summary

Renaming a project using Microsoft Project Professional in a MS Project Server EPM environment requires the following procedure.

2. Steps to rename a project using MS Project Professional

To rename a project schedule, open the Microsoft Project Professional and make sure it is connected to MS Project Server.

1. Go to Filemenu and choose Open.

Microsoft Project Professional - File Open Dialog Box showing project from local cache
Microsoft Project Professional – File Open Dialog Box showing project from local cache
 
Tip: Notice in the screenshot that we renamed the EPM 2010 Rollout project in a previous step to EPM 2013 Rollout. But in the open dialog box it is still showing 2010 in the project name. That is due to local cache feature of MS Project Professional. Due to this reason, it is recommended that Project Managers publish their changes made in the project schedule using MS Project Professional before a project is renamed.
 
2. Click on the link ‘Retrieve the list of all projects from Project Server
3. Locate your project from the list and right click over it then choose Rename
Microsoft Project Professional - List of Projects - Right Click a project and choose Rename
Microsoft Project Professional – List of Projects – Right Click a project and choose Rename


4. Enter new name of project (append V2 in name as an example) and hit enter key. A message box will bring this message

The rename job was successfully submitted to server
Based on the server load, it may time some time for this to complete. You will continue to see the old name till the operation is completed.
Microsoft Project Professional - Project Renamed Confirmation Message
Microsoft Project Professional – Project Renamed Confirmation Message


5. Click OK to the message
6. Close the open dialog box and open it again. You will notice the new project name in the list.

Tip:
Notice in the Open dialog box that you are using the Working store. Select the Publishstore and locate your project in the list. You will notice that the old project name will still show in the list. What happened here?
In MS Project Server, there are multiple databases (stores) draft, published etc. Save and Publish operations update different tables in the system. To resolve the issue, you need to open the working store version of project and publish it.


Microsoft Project Professional - Previous Project name shows up in Published Store
Microsoft Project Professional – Previous Project name shows up in Published Store


7. Make sure your have Working selected under Store in the dialog box
8. Open the project (showing new project name) by double clicking on project name or by selecting it and clicking Open button at the bottom right

Microsoft Project Professional - Working Store showing new project name
Microsoft Project Professional – Working Store showing new project name

Tip:
If you get message regarding user submitted updates on the project, click No for now. You can approve those update later after the project is renamed. Update Center will show the new project name for the updates.

Microsoft Project Professional - Team Members submitted updates message
Microsoft Project Professional – Team Members submitted updates message


9. Go to File menu and choose Publish to publish the project data. That will update the new project name across all stores. (you can verify by going to file > open > ‘Retrieve the list of all projects from project server’ and then switching between working and published stores value and looking at the new project name)

Microsoft Project Professional - Publish Option
Microsoft Project Professional – Publish Option



10. Go to File > Close to close the project
11. Click Yes to any check-in message

More on this and other scenarios is coming in next parts of this series. So far we have completed the two parts. Review the third part to understand renaming the Project sites.
Summary

1. Steps to rename a project using Project Web Access (PWA)
2. Steps to rename a project using MS Project Professional

3. Rename Project site
4. Scenarios: Renaming Project and different Statuses of Timesheets
5. Renamed Project Schedule and Business Intelligence Center Reports
Conclusion

Keywords:

  • Renaming a project in Project Server
  • Renaming a project in Microsoft Project Server
  • Rename a project using MS Project
  • Rename a project using MS Project Professional
  • Rename a Project in Project Server
  • best practice to rename a project in Project Server
  • best practice to change a project name in Project Server
  • How to change a project name in Project Server
  • How To guide for renaming a project in Project Server
  • Primer on renaming a project in Project Server
  • Step by step guide to rename a project in project server
  • Edit Project details to rename a project
  • Rename a project schedule in Project Server
  • Rename a project plan in Project Server
  • How to rename projects in Project Server
  • How to rename a mpp file in Project Server
  • Renaming Projects
  • Project rename process
  • Project rename job aid
Visit www.softvative.com for professional services.

Rename a Project in MS Project Server Part 1

Thursday, January 29th, 2015

Rename a Project in Microsoft Project Server – Part 1

Version: 2.3

Applies to:
MS Project Server 2010
MS Project Server 2013
MS Project Online (Office 365)

When working on projects in a PMO environment using Enterprise Project Management (EPM) system like Microsoft Project Server, you come across situations where you might have to rename objects. Those rename item request could be for project, resource, tasks or other objects in the system.

MS Project Server has evolved as a mature EPM / PPM solution compared to its predecessor editions. In MS Project Server 2003 edition, we had to use other utilities to rename a project. Sometimes, special characters in project names used to cause so much trouble to the Cube build process.

These series of articles will explain the details of different cases and how to best rename a project schedule in Microsoft Project Server EPM.

Table of Contents

Summary

1. Steps to rename a project using Project Web Access (PWA)
2. Steps to rename a project using MS Project Professional
3. Rename Project site
4. Scenarios: Renaming Project and different Statuses of Timesheets
5. Renamed Project Schedule and Business Intelligence Center Reports
Conclusion

Summary

A project was created in Microsoft Project Server (MSPS) with a name. Later PMO / business teams wanted to change the name of the project.

1. Steps to Rename a Project using Project Web Access

Follow the steps below to rename a project using Project Web Access (PWA):

1. Go to PWA and click Project Center on left navigation

MS Project Web Access (PWA) - Project Center Link
MS Project Web Access (PWA) – Project Center Link

2. Find the project from the list that you would like to rename and then select a cell other than the project name in the row or click the first empty cell on the left of the row [Hint: Don’t click on the project name as it will bring the project details page]

Project Web Access PWA - Select the Project to Rename
Project Web Access PWA – Select the Project to Rename

3. Click on PROJECTS ribbon tab on top, Click on OPEN dropdown under Project ribbon group and select ‘In Project Web App for Editing’

Project Web Access PWA - Open Project in PWA for Editing
Project Web Access PWA – Open Project in PWA for Editing

4. On top area of left navigation, under project name, click on ‘Project Information’ or any PDP that has Name (that has project name) field in it.

Project Web Access PWA - Project Information PDP Page containing Name field
Project Web Access PWA – Project Information PDP Page containing Name field

5. Change the name of the project under NAME field
6. Click Save button in top left area of ribbon.
7. You will be presented with this message. Click OK to the following message:
“The page and left navigation titles will not be updated with the new name of the project until the page has been reloaded.”

Project Web Access PWA - Warning after Project Renamed in PWA
Project Web Access PWA – Warning after Project Renamed in PWA

You will see Save job message popping out from top right of screen.

Project Web Access PWA - Save Job Queued message
Project Web Access PWA – Save Job Queued message

then

Project Web Access PWA - Save completed successfully message
Project Web Access PWA – Save completed successfully message

At this point you can close the project and it will show the new name in PWA. I prefer to publish it just so that other database tables are updated as well.

8. Refresh the page to confirm the project has been renamed

Project Web Access PWA - Refresh the page to confirm the new project name on left nav
Project Web Access PWA – Refresh the page to confirm the new project name on left nav
9. Click on SCHEDULE link on top left
10. Under Schedule Tools > Tasks tab of ribbon, click on PUBLISH.
Project Web Access PWA - Go to Schedule PDP page and Publish the Project
Project Web Access PWA – Go to Schedule PDP page and Publish the Project
11. Watch for message popping from the top right with status message:
   a. Processing
   b. Save job queued
   c. Publish completed successfully
12. Once the Publish operation is complete, click on PROJECT ribbon tab on top
13. Click Close button
Project Web Access PWA - Close the Project in PWA
Project Web Access PWA – Close the Project in PWA
14. You will be presented with the Check-in message. Click Yes
Project Web Access PWA - Check in project in PWA
Project Web Access PWA – Check in project in PWA

Exceptions:

The TASKS page for team members will show the new project name. But the TIMESHEET page will show the old project name, if the timesheet was created prior to project rename. In that case delete / recall and create the timesheet again. It will then show the new project name.
More on this and other scenarios is coming in next parts of this series. So far we have completed the first part. Stay tuned for the second part.
Summary
1. Steps to rename a project using Project Web Access (PWA)
2. Steps to rename a project using MS Project Professional
3. Rename Project site
4. Scenarios: Renaming Project and different Statuses of Timesheets
5. Renamed Project Schedule and Business Intelligence Center Reports
Conclusion


References:
1. Back to Basics: Renaming a Project correctly in Project Server 2013


Keywords:

  • Renaming a project in Project Server
  • Renaming a project in Microsoft Project Server
  • Rename a Project in Project Server
  • best practice to rename a project in Project Server
  • best practice to change a project name in Project Server
  • How to change a project name in Project Server
  • How To guide for renaming a project in Project Server
  • Primer on renaming a project in Project Server
  • Step by step guide to rename a project in project server
  • Edit Project details to rename a project
  • Rename a project schedule in Project Server
  • Rename a project plan in Project Server
  • How to rename projects in Project Server
  • How to rename a mpp file in Project Server
  • Renaming Projects
  • Project rename process
  • Project rename job aid
Visit www.softvative.com for professional services.

MS Project cant Connect with MSPS MSProjectServer

Friday, December 26th, 2014

Microsoft Project can’t Connect with Microsoft Project Server EPM due to Version Mismatch

Version: 1.2, Modified: 12/29/2014

Microsoft Project Professional edition is the desktop client in Microsoft Project Server (MSPS). The version of the server and client software should be at a supported level in order of the two to work together. Service Pack or Cumulative Update (CU) patches if deployed without planning can cause issues in MS Project Server Enterprise Project Management (EPM) system.

There are different reasons as to why MS Project Professional can’t connect with MS Project Server EPM.

Below are some of the scenarios:

a. Not using the right edition of MS Project (Professional VS Standard)

b.  Not using the right edition of MS Project Professional with the right edition of MS Project Server (2010 VS 2013)

c. Not using the correct URL of Project Web Access (PWA)

d. Not having enough permissions (a user with team member or lower rights trying to connect MS Project Professional to MS Project Server)

e. Not using the right version of MS Project Professional with the right version allowed by MS Project Server in PWA > Server Settings

The focus of this article is about the last scenario. I’ll also cover special case of this scenario.

e. Not using the right version of MS Project Professional with the right version allowed by MS Project Server in PWA > Server Settings

There are known issue if your MS Project Server (MSPS) is at latest patch version and your desktop MS Project Professional edition used it too old.

MS Project Server 2010 / 2013 / Project Online circumvent this problem by allowing the Project Server Admins / PMO Admins / PMO Analysts to set limit on the least version of MS Project Professional that can connect with the Project Server.

Which MS Project Professional product can connect with which MS Project Server product

The short summary is:

  • MS Project Professional 2010 can only connect with MS Project Server 2010
  • MS Project Professional 2013 can connect with MS Project Server 2013 & MS Project Online
  • MS Project Standard can’t connect with MS Project Server.
Softvative Infographics - Microsoft Project Professional and MS Project Server Editions Compatibility
Softvative Infographics – Microsoft Project Professional and MS Project Server Editions Compatibility

Review the Infographic slides:

How to Control Which version of MS Project Professional Can connect with MS Project Server EPM

Microsoft Project Server 2010 / 2013 has the configuration setting that allows you to control which version of MS Project Professional within the same edition (2010 or 2013) can connect with the MS Project Server.

The settings are located in Project Web Access (PWA) > Server Settings > Additional Server Settings.

Microsoft Project Web Access (PWA) > Server Settings > Additional Server Settings link
Microsoft Project Web Access (PWA) > Server Settings > Additional Server Settings link

On that ‘Additional Server Settings’ page there is a setting to set the minimum version number of MS Project Professional that can connect with that instance of the MS Project Server EPM. Ms Project Professional versions prior to that number will not be able to connect with MS Project Server.

PWA Additional Server Settings > Project Professional Versions
PWA Additional Server Settings > Project Professional Versions

You can see this pilot instance supports a minimum of 14.0.6123.5000 version of MS Project Professional. That version is dated back to June 2012. That is little too old.

As per ITIL best practices for Configuration Management and Problem Management and also as per Information Security’s Patch Management Life cycle, the application versions should be maintained at the best possible levels. Even from Information Risk Management prospective, sometimes supporting too old version means also keeping old vulnerabilities alive in your new system. There is lot more to talk about on these best practices related to this topic. But that is little out of scope at this time for the topic.

Special Case Scenario due to version mismatch

I’ve seen a special case where a Project Manager was not able to connect to MS Project Server with everything correct as per the scenarios discussed at the beginning of this article.

The PM was getting the error listed below when launching MS Project Professional using connection with MS Project Server.

The following job failed to complete.
Job Type: Load
Error ID: 12015 (0x2EEF)
Error Description: An internal error occurred.
Cloud not load Project. Please try after some time. If the problem persists, contact your system administrator.

MS Project Error - The following job failed to complete Error ID 12015
MS Project can not connect with Project Server – Error ID 12015

Clicking more Info button reveals more details. You can see the version that is passed on to the PWA is not the right one.

MS Project can not connect with Project Server - Error ID 12015 - More Info
MS Project can not connect with Project Server – Error ID 12015 – More Info

Click OK to the first error message brings the second error:

Cloud not retrieve Enterprise global template.
There seems to be a problem with the database, please contact your server administrator.

Issue Cause

I verified that the MS Project Professional version was new relatively i.e. 14.0.7015.1000. That was higher than the minimum supported version configured in PWA.

Looking at the File > Help in MS Project Professional and reviewing the version screen in a large print out, I was able to find an anomaly. See the above screen shot again. It shows that MS Project Standard and MS Project Professional both as activated versions!

It turned out to be the Desktop Engineering person deployed MS Project Standard version first by mistake (& without any service packs or updates). Later he installed MS Project Professional over the same version as upgrade rather than removing the standard version. Now when the PM was trying to connect to MS Project Server using Ms Project Professional, somehow the desktop was passing the lower version 14.0.4751.1000 (see one of the screen shot above) and thus PWA was rejecting the connection.

Resolution

Uninstall any version of Microsoft Project from the desktop, reboot and then install the correct version of MS Project Professional with the the latest service pack and CU level as supported by the organization.

Revo Uninstaller – Free version  is one nice 3rd party application (Pro Version) to remove the stubborn applications. That helped in getting rid of the old version completely and then installing the MS Project Professional version again.

The correct version once installed and activated should only show MS Project Professional under File > Help.

MS Project Professional was able to connect with the Project Server.

References:

  1. Project Server 2013: Controlling the version of connecting clients–and PWA edits?
  2. How do I know???? Project Professional Versions and Consistency

Keywords:

  • MS Project can’t connect with Project Server
  • MS Project can’t connect with Project Online
  • MS Project can’t connect with PWA
  • Microsoft Project can’t connect with Project Server
  • MS Project can’t connect with Microsoft Project Server
  • Microsoft Project Professional can’t connect with Project Server
  • Microsoft Project Professional supported versions for Project Server
  • Microsoft Project Professional version inconsistencies with Project Server
  • Can not use MS Project with Project Server
  • Can not use MS Project with PWA
Visit www.softvative.com for professional services.

Yammer Feed Integration with SharePoint Online Common Issues

Monday, December 15th, 2014

Version: 1.3

Scenario:

I had an external Yammer Network with few groups underneath it. I had a SharePoint Online (Office 365) site collections with sub-sites. I created three pages under the main site and leveraged three different option (one on each page) to integrate the Yammer Feed with the SharePoint Online site.

a. Yammer App for SharePoint by Microsoft – http://o15.officeredir.microsoft.com/r/rlidYammerappO15?clid=1033

b. Yammer Feed Embed – By Blue Rooster – https://bluerooster.uservoice.com/forums/239290-yammer-feed-embed

c. Yammer Embed Code – Go into a Yammer Group. On bottom right look under Access Options section

Yammer Feed Integrated with SharePoint Online (in Office 365)
Yammer Feed Integrated with SharePoint Online (in Office 365)

Issue Details

Everything was working until an unknown bump caused the feed to break. I started getting the following Yammer Login message no matter even if I click on login icon and go through the Yammer login page to login using ADFS login.

Yammer Feed Integration keeps displaying Yammer login on SharePoint online page even after login
Yammer Feed Integration keeps displaying Yammer login on SharePoint online page even after login

Error 2
In one instance on a page, I got the following frame error.

content cannot be displayed in a frame
   
To help protect the security of information you enter into this website, the publisher of this content does not allow it to be displayed in a frame.

What you can try:
Open this content in a new window

Yammer Feed Integration with SharePoint Online can't display contents in frame error
Yammer Feed Integration with SharePoint Online can’t display contents in frame error

Findings:

I found the Yammer Status Check. They were quick to point me to the Yammer Status page that showed there was disruption on that day.

The issue was only happening when using Internet Explorer. Chrome was able to display the feed.

I switched to Yammer group Enterprise Social (Yammer) Help. I started a conversation on this Yammer issue there.

Resolution:

There are few pieces of the Yammer-SharePoint marriage puzzle.

  1. Add the Yammer, SharePoint Online and MicrosoftOnline login sites to the IE Trusted Sites list. That was done using AD GPO
  2. In IE settings, for the trusted sites check the box ‘Enable Protected Mode (requires restarting Internet Explorer)’
  3. Users should have access to the SharePoint site pages and the Yammer Network / Group feed that is embedded
  4. SharePoint page URL format can make or break Yammer Feed on the page

1. Adding Sites URL to Internet Explorer Trusted Sites for the Yammer Feed to work in SharePoint Online:

I found a Microsoft article that talks about adding Yammer feed to a SharePoint page. See the section ‘Having trouble with the app’ in that article. I then worked with the AD / security team to make the change in the GPO to add the Yammer, SharePoint and MicrosoftOnline links to the IE trusted zone.

We added these links to the Active Directory Group Policy for computers.

https://login.microsoftonline.com
https://*.sharepoint.com
https://*.yammer.com
https://*.assets-yammer.com

Using Group Policy Management Console (thanks to RSAT for Win7), I was able to view the changes. Once you have the RSAT installed and configured, you can use the server tools from your desktop. Open ‘Group Policy Management’ from Start > Administrative Tools or type gpmc.msc in Start > run and enter.

In the Group Policy find the GPO that applies the Internet Explorer trusted site settings to computers.

Active Directory - Group Policy Management Console
Active Directory – Group Policy Management Console

Expand the Organization Unit (OU) from left that contains the computers and click on the Group Policy. Click on Settings tab and then expand all settings by clicking Show All. Look for Internet Explorer related settings.

Active Directory - Group Policy Management Console - Settings
Active Directory – Group Policy Management Console – Settings

I found the Yammer, SharePoint and MS online urls were added there.

Active Directory - Group Policy Management Console - IE Trusted Zone Settings
Active Directory – Group Policy Management Console – IE Trusted Zone Settings

You can optionally save the GPO settings as report. Right click on the right side settings area and choose Save Report. Save the report in .htm format.

Active Directory - Group Policy Management Console - GPO Settings - Save Report
Active Directory – Group Policy Management Console – GPO Settings – Save Report

I was still getting the issue due to reason that the AD GPO policy changes were not applied to my PC. I ran the gppdate from the command line and closed IE browser windows.
Online.

Gpupdate /force /target:computer

Client side Group Policy Force Updates using gpupdate
Client side Group Policy Force Updates using gpupdate

I then logged on to SharePoint Online and Yammer again.Guess what, now the ‘feeds were feeding’ the SharePoint

Yammer Feed Integrated on a SharePoint Online page
Yammer Feed Integrated on a SharePoint Online page

2. In IE settings, for the trusted sites check the box ‘turn on protected mode in trusted zone’

In few cases, especially with IE 11, the users have to make sure the ‘Enable Protected Mode (requires restarting Internet Explorer)’ is checked for trusted sites.

a. In Internet Explorer, Go to Tools menu > Internet Options
b. Go to Security tab
c.  Click on Trusted Sites icon to highlight it and then check the box ‘Enable Protected Mode (requires restarting Internet Explorer)

Enable Protected Mode (requires restarting Internet Explorer)' in Internet Explorer for Yammer SharePoint
Enable Protected Mode (requires restarting Internet Explorer)’ in Internet Explorer for Yammer SharePoint

3. Users should have access to the SharePoint site pages and the Yammer Network / Group feed that is embedded
User visiting a SharePoint page with the Yammer network / group feed embedded on the page, should have access to Yammer network / group. Else user will get content can’t be displayed message in the app part (web part) area on that page.

This content cannot be displayed in a frame
    
To help protect the security of information you enter into this website, the publisher of this content does not allow it to be displayed in a frame.
    
What you can try:

Open this content in a new window  

Yammer Feed can not be displayed in the Frame Error on a SharePoint Online (Office 365) page
Yammer Feed can not be displayed in the Frame Error on a SharePoint Online (Office 365) page

If you click on the link ‘Open this content in a new window‘, you will see the yammer page for that network displaying ‘Join Network’ link. that indicates that the user doesn’t have permissions or is not part of the Yammer network that was embedded on that SharePoint Page.

Yammer - Join Yammer Network Page - SharePoint Integration
Yammer – Join Yammer Network Page – SharePoint Integration

Users that will be part of the network should be able to see the feed on the SharePoint online Page.

4. SharePoint page URL format can make or break Yammer Feed on the page

I’ve noticed another issue where the URL address format of the SharePoint page can make or break the Yammer feed integrated on a SharePoint page.

For a same site, notice the difference in URL:

Yammer Feed Worked:

Yammer Feed Failed:

In case of the second link, Yammer feed displays the same message ‘This content cannot be displayed in a frame’ as listed above in one of the screenshot. Investigating this issue further.

References:

  1. Yammer-App-for-SharePoint-Add-a-Yammer-feed-to-a-SharePoint-page
  2. Yammer Embed
  3. Office 365 URLs and IP address ranges
  4. Ragner Heil – Yammer App for SharePoint & Office 365 : Tips & Trick
  5. Setting Up Apps and Integrating Yammer into SharePoint 2013
  6. SharePoint Server 2013 known issues


Keywords:

  • Yammer Feed Integration with SharePoint Online
  • Yammer Feed Integration with SharePoint Online Issues
  • Yammer Feed Integration Common Issues
  • Yammer Feed Integration Issues
  • SharePoint Online with Yammer Common Issues
  • Yammer Feed Integration with SharePoint Online fixes
  • Yammer Feed Integration with SharePoint Online resolutions
  • Yammer Feed with SharePoint Online Fixes
  • How to integrate Yammer feed with SharePoint
  • How to integrate Yammer feed with SharePoint Online
  • How to integrate Yammer feed and SharePoint
  • Yammer group Feed Integration with SharePoint Online
  • Yammer network Feed Integration with SharePoint Online
Visit www.softvative.com for professional consulting services.

MS14 081 Vulnerability in SharePoint

Wednesday, December 10th, 2014

MS14 081 Vulnerability in SharePoint

Version 1.0

Seems like this year has been really hard on Office Web Apps and Word Services within SharePoint 2010 / 2013 for security reasons.

Microsoft released another security bulletin that impacts:

  • SharePoint 2010
  • SharePoint 2013
  • Office Web Apps 2013
  • Microsoft Project Server 2010 / 2013 
  • and other application that leverages SharePoint platform

Here is the security bulletin that is ranked as critical.

Microsoft Security Bulletin MS14-081 – Critical
Vulnerabilities in Microsoft Word and Microsoft Office Web Apps Could Allow Remote Code Execution (3017301)

Resources

Following are the important resources on this issue.

  1. MS14-081: Vulnerabilities in Microsoft Word and Office Web Apps could allow remote code execution: December 9, 2014
  2. MS14-081: Description of the security update for SharePoint Server 2010: December 9, 2014
  3. CVE-ID Use After Free Word Remote Code Execution Vulnerability – CVE-2014-6357
  4. National Vulnerability Database
  5. SecurityFocus
  6. US-Cert Security Bulletin

Download Updates:

  1. Security Update for Microsoft SharePoint Server 2010 (KB2899581)
  2. Security Update for Microsoft SharePoint Enterprise Server 2013 (KB2883050)


Mitigating Factors

  • An attacker who successfully exploited this vulnerability could run arbitrary code in the context of the current user. Users whose accounts are configured to have fewer user rights on the system could be less impacted than users who operate with administrative user rights.
  • The vulnerability cannot be exploited automatically through email. For an attack to be successful a user must open an attachment that is sent in an email message.
  • In a web-based attack scenario, an attacker could host a website that contains a file that is used to attempt to exploit the vulnerability. In addition, compromised websites and websites that accept or host user-provided content could contain specially crafted content that could exploit this vulnerability. An attacker would have no way to force users to visit a specially crafted website. Instead, an attacker would have to convince them to visit the website, typically by getting them to click a link in an email message or Instant Messenger message that takes them to the attacker’s site, and then convince them to open the specially crafted file in an affected version of Microsoft Office software.

Workaround

No workaround available so far.

Visit www.softvative.com for professional and Managed services for your SharePoint Farms.

Sharepoint Document Management Best Practices

Tuesday, December 2nd, 2014

SharePoint Document Management Best Practices

Version: 2.0, Last Updated: 12/03/2014

SharePoint like any document management system, has best practices that needs to be followed to get maximum value out of the system. A planned roll out of document management features helps the organization and users. A planned roll out should have some sort of discipline (Plan, Do, Check, Act) around it. In an unplanned roll out you will come across discipline (Do, check, plan, act) that cause more pain.

What are the “benefits of planned SharePoint roll out” :

  1. With planning, staff knows what is coming and when
  2. You select the features that best fit into the organization in the beginning. It might be difficult to change user behavior of how they work in the systems later if you started with rudimentary features and process
  3. Users might use a SharePoint library just like a network shared drive to dump files. Versus organizing a library with columns, content types or term store features might go long way
 4. Same department contents structured using right features might save lot of time and hence the cost (full time employees are not free, everyone has a cost associated)
  5. Structured information will help the team leads / Management make quick and intelligent decisions in short time

Now, what are some of the “common best practices around SharePoint Document Management”?

There are no hard and fast rules. Every situation and roll out might require different combination of features. Below I’ve listed some of the ‘”common best practices for Sharepoint”. This list by no mean is complete and there might be additional best practices needed around different department contents. Use this list as a reference and come up with your plan.

1. Use short Site, Library and List names

Don’t use long names in Sites, Libraries and lists in Sharepoint. Avoid having space in names. Like instead of ‘Billing Department’ use BD or Billing. Another example for site name se short name like AEC instead of An Excellent Company. Create sites, libraries and list with short names. Once created go the Title configuration areas to change to long title and add text in the description field. Creating those items with shot names conserves the URL address space.

2. 255 Characters URL Limit and Windows file / folder path Limits

There is a limit of characters in the URL address as part of web standard. It is 255 characters. Using long site, library, folders, files path can lead to situation where that limit might be reached. In Sharepoint that could cause some hard stop. Few examples could be users not able to edit files even with right permissions, previous versions of file not working etc.
References:
a. URL path length restrictions  
b. You receive a “The specified file or folder name is too long” error message when you create a new folder or a new document in a document library in SharePoint Portal Server or in Windows SharePoint Services http://support.microsoft.com/kb/894630
c. A webpage that has a long URL may not print to a network printer in Internet Explorer 9
d. You cannot delete long URLs from the browsing history in Internet Explorer on a computer that is running Windows 7 or Windows Server 2008 R2
e. Maximum URL length is 2,083 characters in Internet Explorer

3.  Avoid Using Special Characters in File, Folders , Library and Site names

Special characters cause special problems. To make a file / folder on the top of the list, use Sharepoint views, filters and sorts option. If you really need to make something on top of the list manually, use period (.) or underscore (_) in the beginning of the name. But it is better to use simple names.

Reference:
Information about the characters that you cannot use in site names, folder names, and file names in SharePoint

4. Avoid Using Spaces in Names and avoid having space in beginning

If you need to use two words in names, avoid space in the middle. That one space takes three character (i.e. %20) in the URL address. For example use BestDocument instead of Best Document. You can use underscore (_) in the middle of two words without adding spaces. In same example that will look like Best_Document.

5. Don’t add version number of file at the end of name

It is a common scenario users do on network shared drives. Don’t use the same practice in a content management system like Sharepoint. Instead turn on the versioning feature at the library or list level and use it to your advantage. Let the Sharepoint do its job of maintaining versions. Add those versioning columns in the view for users. On the side note, when you turn on the versioning feature don’t turn on unlimited versions, set a limit on the last number of versions to keep. For example 5 or 10 [Sharepoint site Admin can setup versioning for libraries and lists.].

6. Use Metadata instead of Folders

Metadata is much better way of working with contents compared to organizing contents in folders. Using Columns, Content Types, Metadata Term store feature of Sharepoint are recommend ways.
Reference:
a. SharePoint 2013 Best Practices: Using Folders [same concepts can apply to other Sharepoint editions]

7.  Don’t use long folder names

I’ve seen examples where people used kind of whole history of the folder as part of folder name. For  example “A Long Company Name, Contract Number, Customer Number, Customer Location” as part of folder name. Compare it to having a folder with just the short company name  ABC Company and using rest of the information as part of the metadata properties at file level to classify contents is much better and faster approach. You will run into long URL issues if you will have hierarchical chain of folders with longs names and long file names inside those folders.
Just like people don’t use long names. They use first and last name or maybe middle name. But people don’t add their grandfather, great grandfather and whole ancestral names as part of their name. Another example, book writers don’t add the full summary of the book on the title. It is usually in next few pages.

8. Think Before you Act

Always think and plan before you would like to do any important thing in SharePoint. Try to get your information organized from the beginning. Unplanned start can cause you lots of rework later that might take twice or thrice the efforts and costs. It is like plan and pay early and save a lot later versus do it without planning and keep paying forever.

9. Use Site, Library, List Templates

SharePoint comes with lots of templates for sites, libraries and lists. You can create a customized site, library or list using out of the box features and then save it as template. Those template can then be used later by other department and team. Thus saving lots of time and efforts later.

10. Know you SharePoint Document Management features

SharePoint offers lots of features for document management that help in different scenarios. Content Types, Content Organizer Rule, Documents Sets, Document ID, workflows and others are some of the advanced features that can bring value to your contents. Know what you have at your disposal, before users start using your libraries.

11. Learn about Content Management Features of SharePoint
SharePoint has lots of Enterprise Content Management (ECM) features that you may not be aware of it or you may not aware of other ways to leverage those features for your contents.

Learn about these features and jargon in SharePoint that will help your in the Document Management.

  • Metadata Term Store
  • Content Type Hub
  • Site Columns
  • Content Types
  • Document Center
  • Record Center
  • Content Organizer and Document Routing
  • eDiscovery and hold
  • Information Rights Management (IRM)
  • Versioning, Major & minor versions
  • Document Approval
  • Check-in / checkout
  • Folder Based automatic metadata
  • Metadata driven navigation
  • Workflows on Documents
  • Email Alerts on Documents, Folders , Libraries
  • SharePoint Search to locate documents
  • Social Aspects (Tagging, Ratings, Like It)
  • Audit Trails
  • Retention Schedule
  • Deletion
  • Storage (BLOB)
  • Large Document Sizes
  • Documents with most versions
  • Office Web Apps to view documents without any client

Common Errors in SharePoint Visio Services

Wednesday, November 26th, 2014

Common Errors in SharePoint Visio Graphics Services

Version: 1.0

Applies to: SharePoint 2010, SharePoint 2013

What is Visio Graphics Services

Visio Graphics Services is a service application in Enterprise editions of SharePoint Server 2010 and 2013. The service application allows SharePoint users to:

  1. view the Visio drawings without having MS Visio installed on their PCs
  2. allows data connected Visio drawings that can be refreshed from data sources
  3. allows users to view the SharePoint Workflow Visualizations

Common Issues with Visio Graphics Services

Following list shows common Visio Graphics Services errors, causes and resolutions.

  1.  The server failed to process the request

1. The server failed to process the request

A user tries to view Visio in browser (or view the Workflow Visualization page) from SharePoint and gets the error message:

The server failed to process the request

SharePoint Visio Graphics Service Error - The server failed to process the request
SharePoint Visio Graphics Service Error – The server failed to process the request

At this point a user tries to click on ‘Open in Visio’ link on top left of the workflow Visualization section to open the file in MS Visio on their desktop. The Visio file opens up in MS Visio.

In one scenario I was able to open the Workflow Visualization file in MS Visio on my desktop only in read only mode. I was getting a warning message:

Visio Standard does not support savings files of this type. When saving the file, you will be prompted to save as a different file type.

The reason of this warning is clear from the warning message. I had standard version of MS Visio on my PC. The Workflow Visualization file had .visio web drawing file extension (.VDW). The users with Ultimate, Premium and other higher version would be able to open and edit the web drawing format Visio files.

SharePoint Workflow Visualization - Web Drawing VDW can't be edited with Visio Standard
SharePoint Workflow Visualization – Web Drawing VDW can’t be edited with Visio Standard

Event Viewer Errors on Servers

Event Viewer Error 01

Log Name:      Application
Source:        System.ServiceModel 3.0.0.0
Date:          11/19/2014 4:44:00 PM
Event ID:      3
Task Category: WebHost
Level:         Error
Keywords:      Classic
User:          domainSPFarmAdminAct
Computer:      SPAppServer02.domain.com
Description:
WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/5426204
 Exception: System.ServiceModel.ServiceActivationException: The service ‘/20bf95936ed944db89431a9d16459372/VisioGraphicsService.svc’ cannot be activated due to an exception during compilation.  The exception message is: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401). —> System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)
   at Microsoft.Office.Visio.Server.GraphicsServer.VisioGraphicsServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   — End of inner exception stack trace —
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)
 Process Name: w3wp
 Process ID: 4724

Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”System.ServiceModel 3.0.0.0″ />
    <EventID Qualifiers=”49154″>3</EventID>
    <Level>2</Level>
    <Task>5</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime=”2014-11-19T22:44:00.000000000Z” />
    <EventRecordID>730921</EventRecordID>
    <Channel>Application</Channel>
    <Computer>SPAppServer02.domain.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data>System.ServiceModel.ServiceHostingEnvironment+HostingManager/5426204</Data>
    <Data>System.ServiceModel.ServiceActivationException: The service ‘/20bf95936ed944db89431a9d16459372/VisioGraphicsService.svc’ cannot be activated due to an exception during compilation.  The exception message is: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401). —&gt; System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)
   at Microsoft.Office.Visio.Server.GraphicsServer.VisioGraphicsServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   — End of inner exception stack trace —
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)</Data>
    <Data>w3wp</Data>
    <Data>4724</Data>
  </EventData>
</Event>

Causes:

There can be different reasons for the error ‘failed to process request’. Some of those are listed below:

  1. Service Account running Visio Services doesn’t have access to SharePoint Content Databases
  2. Application ID under Visio Graphics Service is not not correct or missing (Go to Central Administration  > Manage Service Applications > Visio Graphics Services > Global Settings)
  3. Secure Store Service application ID that is configured for Visio Graphics Services doesn’t have correct Permissions
  4. Visio Graphics Services on SharePoint Server are not running
  5. Some other failing services causing issue

Resolution:

In one of my scenario, everything was right except the fact that Secure Store Service was having some issues. That lead to issues for Visio Graphics Services. An IISReset /noforce on SharePoint Servers helped in resolving this issue.

Visio drawing started working in Workflow Visualization and also in Visio Web Part.

SharePoint Visio Graphics Services - Visio Web Access Web Part
SharePoint Visio Graphics Services – Visio Web Access Web Part

Workflow Visualization page showing the visio workflow

SharePoint Visio Graphics Services - Workflow Visualization Showing Process in Visio
SharePoint Visio Graphics Services – Workflow Visualization Showing Process in Visio

References:
1. Visio Graphics Service administration in SharePoint Server 2013
http://technet.microsoft.com/en-us/library/ee524059(v=office.15).aspx

2. SharePoint 2013 Visio Service: the server failed to process the request
http://alstechtips.blogspot.com/2014/05/sharepoint-2013-visio-service-server.html

3. Share Point 2013 – Visio Graphics Not Displaying – The server failed to process the request
http://squarelogics.com/share-point-2013-visio-graphics-not-displaying-the-server-failed-to-process-the-request/

4. Troubleshooting workflow visualization in SharePoint 2010
http://www.robertseso.com/2012/02/troubleshooting-workflow-visualization.html

5. Visio 2010 Services Error – The server failed to process the request
http://www.sathishtk.com/blog/post/2010/02/04/Visio-2010-Beta-Services-Error-The-server-failed-to-process-the-request.aspx

Keywords:

  • Common Errors in SharePoint Visio Graphics Services
  • Troubleshooting workflow visualization in SharePoint 2010
  • SharePoint 2013 Visio Service the server failed to process the request
  • SharePoint 2010 Visio Service the server failed to process the request
  • Visio Graphics Not Displaying
  • workflow visualization error
  • workflow visualization not displaying visio
  • workflow visualization errors out
  • Visio Web Access errors
  • Visio Web Access can not display visio
  • Visio Web Access issues
Visit www.softvative.com for professional services.

Excel Web Services Unable to process request

Thursday, November 20th, 2014

Excel Web Services error in SharePoint

Unable to process the request. Wait a few minutes and try performing this operation again – Event Viewer Error 5231, 5239, 5240

Version: 1.5, Created: 11/20/2014, Last Updated: 12/15/2014

Error:

When you click on an excel file to open it in Excel web services, you get this error:
Unable to process the request. Wait a few minutes and try performing this operation again.

SharePoint Excel Services - Unable to Process Request Error
SharePoint Excel Services – Unable to Process Request Error

Few Suggestions from other sources:
1. Stopped and started Excel Calculation services from SharePoint Central Admin > Servers in Farm page > ServerName > Services

2. Make sure Excel Service app is associated with the SharePoint web app

3. Under CA > SA > Excel Services > Global Settings > Load Balancing Scheme > change the settings from ‘Workbook URL’ to ‘Local’. but same issue

4. App Pool Recycle
http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/01/24/excel-services-2010-quot-unable-to-process-the-request-quot-maximum-private-bytes-size-exceeded-unable-to-complete-the-operation.aspx

5. Excel Service Account for CDB permisions
http://support.microsoft.com/kb/981293

6. Edit host entry and loopback FQDN
7. IISReset
8. Reboot
9. Re-run psconfigui

10 no route site collection had been create when testing the service. https://<your application name>/_layouts/EwaStringsHandler.ashx/

11. Disable ASP.Net Impersonation in IIS http://blog.armgasys.com/?p=133

ULS Log Errors:

System.TypeInitializationException: The type initializer for ‘Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp’ threw an exception. —> System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)     at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException,

TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean

fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp..ctor()     at Mic…

There was an error in communicating with Excel Calculation Services

http://SPAppServer013:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx exception: An error has occurred. [Session:  User: domainSPFarmAdmSvcAct].

ServerSession.ProcessServerSessionException: An exception thrown during ExecuteWebMethod failed to convert to ECSException for server:

http://SPAppServer013:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx, method: GetHealthScore, ex:

Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException: An error has occurred. —>

System.ServiceModel.FaultException: The server was unable to process the request due to an internal error.  For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the se…..

Event Viewer Logs

Error 1:
I saw this error logged every 5 mins in on a WFE server.

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Server
Date:          12/15/2014 1:04:20 PM
Event ID:      2159
Task Category: Unified Logging Service
Level:         Error
Keywords:      
User:          companySPFarmSvcAct
Computer:      SPWFEServer01.company.com
Description:
Event 5240 (Excel Services Application) of severity ‘Error’ occurred 10 more time(s) and was suppressed in the event log
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-SharePoint Server” Guid=”{C33B4F2A-64E9-4B39-BD72-F0C2F27A619A}” />
    <EventID>2159</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>31</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-12-15T19:04:20.673990100Z” />
    <EventRecordID>510279</EventRecordID>
    <Correlation />
    <Execution ProcessID=”7012″ ThreadID=”6000″ />
    <Channel>Application</Channel>
    <Computer>SPWFEServer01.company.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”int0″>5240</Data>
    <Data Name=”string1″>Excel Services Application</Data>
    <Data Name=”int2″>10</Data>
  </EventData>
</Event>

Error 2:
On WFe 3 server:

Log Name:      Application
Source:        Microsoft-SharePoint Products-Excel Services Application
Date:          12/15/2014 1:13:41 PM
Event ID:      5240
Task Category: Web Front End
Level:         Error
Keywords:      
User:          companySPFarmSvcAct
Computer:      SPWFEServer03.company.com
Description:
There was an error in communicating with Excel Calculation Services 

http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx exception: An error has occurred.
[Session: 
User: companySPFarmSvcAct].
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-Excel Services Application” Guid=”{278E40D0-FDAA-4EB4-AB6B-9E0AD6BDBE79}” />
    <EventID>5240</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>8</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-12-15T19:13:41.610718500Z” />
    <EventRecordID>529546</EventRecordID>
    <Correlation />
    <Execution ProcessID=”5588″ ThreadID=”7280″ />
    <Channel>Application</Channel>
    <Computer>SPWFEServer03.company.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx</Data>
    <Data Name=”string1″>An error has occurred.</Data>
    <Data Name=”string2″>
    </Data>
    <Data Name=”string3″>companySPFarmSvcAct</Data>
  </EventData>
</Event>

Error 3:
Log Name:      Application
Source:        Microsoft-SharePoint Products-Excel Services Application
Date:          12/15/2014 11:28:31 AM
Event ID:      5239
Task Category: Web Front End
Level:         Error
Keywords:      
User:          companySPFarmSvcAct
Computer:      SPWFEServer02.company.com
Description:
There was an error in communicating with Excel Calculation Services 

http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx exception: The remote server returned an error: (503) Server 

Unavailable.
[Session: 
User: companySPFarmSvcAct].
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-Excel Services Application” Guid=”{278E40D0-FDAA-4EB4-AB6B-9E0AD6BDBE79}” />
    <EventID>5239</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>8</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-12-15T17:28:31.611714800Z” />
    <EventRecordID>502287</EventRecordID>
    <Correlation />
    <Execution ProcessID=”2068″ ThreadID=”8976″ />
    <Channel>Application</Channel>
    <Computer>SPWFEServer02.company.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx</Data>
    <Data Name=”string1″>The remote server returned an error: (503) Server Unavailable.</Data>
    <Data Name=”string2″>
    </Data>
    <Data Name=”string3″>companySPFarmSvcAct</Data>
  </EventData>
</Event>

Error 4:
Log Name:      Application
Source:        Microsoft-SharePoint Products-Excel Services Application
Date:          12/15/2014 11:28:31 AM
Event ID:      5231
Task Category: Web Front End
Level:         Error
Keywords:      
User:          companySPFarmSvcAct
Computer:      SPWFEServer02.company.com
Description:
Unable to reach Excel Calculation Services http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx.
[Session: 
User: companySPFarmSvcAct]
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-Excel Services Application” Guid=”{278E40D0-FDAA-4EB4-AB6B-9E0AD6BDBE79}” />
    <EventID>5231</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>8</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-12-15T17:28:31.611714800Z” />
    <EventRecordID>502286</EventRecordID>
    <Correlation />
    <Execution ProcessID=”2068″ ThreadID=”8976″ />
    <Channel>Application</Channel>
    <Computer>SPWFEServer02.company.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>http://SPAppServer03:32843/0753ec6cff654ce09f369241f98d06a7/ExcelService*.asmx</Data>
    <Data Name=”string1″>
    </Data>
    <Data Name=”string2″>companySPFarmSvcAct</Data>
  </EventData>
</Event>

Resolution:

There are few different resolutions you can try. In my case mostly restarting the Excel Calculation Services resolved the issue.

1. Restart excel calculations services
2. Recycle app pool
3. Make sure the account running excel calculation service is not locked
4. Reboot the server

1. Restart excel calculations services

I stopped and started the Excel Calculation services from within SharePoint Central Administration on following servers in this order:

SPAppServer01 – App
SPAppServer02 – App
SPAppServer03 – App

To stop and then start the Excel Calculation Services follow steps:
1. Go to SharePoint Central Admin site

2. Click System Settings > Manage Servers in This Farm

3. Find the servers in the farm that are running ‘Excel Calculation Services’

4. Click on one server name from that list that is running the service. Start with Web Server (if one is running the service),

5. On next page titled ‘Services on Server: servername ‘ locate the ‘Excel Calculation Services’ and click stop under action column

SharePoint Excel Services Restart Excel Calculation Services in Central Admin
SharePoint Excel Services Restart Excel Calculation Services in Central Admin

6. Refresh the page after few seconds and make sure the service is in stopped status

7. Once the Service show stopped status, click on Start under action column to start the service

8. Refresh the page for few seconds to make sure the Excel Calculation Service shows Started under status column

9. Go back to the page under step 2 above and follow steps for next server

10. Test one Excel file on the Sharepoint site by opening it in browser

Instead of restarting the servers or performing doing IISReset, stopping and starting the Excel service helped resolve the issue. Due to farm serving other critical apps out of SharePoint, server reboot and IISReset were not an option.

References:

  1. Error communicating with Excel Services Application – Events 5231 5239 5240
  2. Stefan Johansson – http://www.stefanjohansson.org/2013/03/excel-services-unable-to-process-the-request-wait-a-few-minutes-and-try-performing-this-operation-again/
  3. Armgasys – http://blog.armgasys.com/?p=133

Keywords:
  • SharePoint Unable to process the request
  • Excel Unable to process the request
  • error in communicating with Excel Calculation Services
  • Excel Services Unable to process the request
  • SharePoint farm Unable to process the request
  • SharePoint Excel Services Gotchas
  • SharePoint Excel Services issues
  • SharePoint Excel Services remedies
  • SharePoint Excel Services fixes
  • Event Viewer Error 5231
  • Event Viewer Error 5239
  • Event Viewer Error 5240
  • Event Viewer Error 2159
  • Event ID 5231
  • Event ID 5239
  • Event ID 5240
  • Event ID 2159
  • Fix for Event Viewer Error 5231
  • Fix for Event Viewer Error 5239
  • Fix for Event Viewer Error 5240
  • Fix for Event Viewer Error 2159

SharePoint Excel Services Unable to Save Workbook

Friday, November 14th, 2014

SharePoint Excel Services Unable to Save Workbook

Version: 1.0

Scenario:

A user opens an Excel file for editing using ‘Edit in Browser’ option.

SharePoint Excel Web Services - Edit In Browser an Excel File
SharePoint Excel Web Services – Edit In Browser an Excel File

Error:

After sometime in the edit mode, the user gets the message

Unable to Save Workbook

We will try again automatically, but you should try to save your workbook to another location or click Open in Excel.

There will be an error dialog box that says:
Your changes could not be saved. It is recommended that you select Open in Excel or try to save your changes to a different location immediately. If your changes can still not be saved after a few more minutes, your session will be ended to prevent any more loss of data.

SharePoint Excel Web Services - Unable to Save Workbook Error
SharePoint Excel Web Services – Unable to Save Workbook Error

Event Viewer Errors on SharePoint Application Servers running Excel Services:

1. Error on App Server 1 Event ID 7935

Log Name:      Application
Source:        Microsoft-SharePoint Products-Excel Services Application
Date:          11/6/2014 1:53:25 PM
Event ID:      7935
Task Category: Excel Calculation Services
Level:         Information
Keywords:    
User:          domainSPFarmAct
Computer:      SPAppServer1.domain.com
Description:
Unable to save the following workbook: http://sharepoint.domain.com/sites/BizSegment/Dept1/Financial

Documents/MonthlyKPIReport2015.xlsx.
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-Excel Services Application” Guid=”{278E40D0-FDAA-4EB4-AB6B-9E0AD6BDBE79}” />
    <EventID>7935</EventID>
    <Version>14</Version>
    <Level>4</Level>
    <Task>2</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-11-06T19:53:25.232766900Z” />
    <EventRecordID>720780</EventRecordID>
    <Correlation ActivityID=”{00020DF6-D14B-13A9-0000-000050F7B00B}” />
    <Execution ProcessID=”5088″ ThreadID=”7456″ />
    <Channel>Application</Channel>
    <Computer>SPAppServer1.domain.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>http://sharepoint.domain.com/sites/BizSegment/Dept1/DocumentLib/MonthlyKPIReport2015.xlsx</Data>
  </EventData>
</Event>

2. Error on App Server 1 with Event ID 0 – Symantec Protection for SharePoint Servers

Log Name:      Application
Source:        Symantec Protection for SharePoint Servers Service
Date:          11/6/2014 1:57:35 PM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SPAppServer1.domain.com
Description:
Module=ScanObject.Scan | Exception message=Failed to connect to an IPC Port: The system cannot find the file specified.
  | Stack=
Server stack trace:
   at System.Runtime.Remoting.Channels.Ipc.IpcPort.Connect(String portName, Boolean secure, TokenImpersonationLevel impersonationLevel,

Int32 timeout)
   at System.Runtime.Remoting.Channels.Ipc.ConnectionCache.GetConnection(String portName, Boolean secure, TokenImpersonationLevel

level, Int32 timeout)
   at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream

requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
   at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Symantec.Sharepoint.Shared.InterfaceLibrary.ILoadBalancingService.GetAvailableScanEngine(ScanEngine& oScanEngine)
   at Symantec.Sharepoint.RTCommandClient.RTCommand.GetAvailableScanEngine(ScanEngine& oScanEngine)
   at Symantec.Sharepoint.ScanLibrary.ScanObject. (IntPtr inILockBytes, Int32& pdwStatus, String& wzVirusInfo)
Event Xml:
<Event xmlns=’http://schemas.microsoft.com/win/2004/08/events/event’><System><Provider Name=’Symantec Protection for SharePoint Servers

Service’/><EventID Qualifiers=’0′>0</EventID><Level>2</Level><Task>0</Task><Keywords>0x80000000000000</Keywords><TimeCreated

SystemTime=’2014-11-

06T19:57:35.000000000Z’/><EventRecordID>720783</EventRecordID><Channel>Application</Channel><Computer>SPAppServer1.domain.com</Computer

><Security/></System><EventData><Data>Module=ScanObject.Scan | Exception message=Failed to connect to an IPC Port: The system cannot

find the file specified.
  | Stack=
Server stack trace:
   at System.Runtime.Remoting.Channels.Ipc.IpcPort.Connect(String portName, Boolean secure, TokenImpersonationLevel impersonationLevel,

Int32 timeout)
   at System.Runtime.Remoting.Channels.Ipc.ConnectionCache.GetConnection(String portName, Boolean secure, TokenImpersonationLevel

level, Int32 timeout)
   at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream

requestStream, ITransportHeaders&amp; responseHeaders, Stream&amp; responseStream)
   at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&amp; msgData, Int32 type)
   at Symantec.Sharepoint.Shared.InterfaceLibrary.ILoadBalancingService.GetAvailableScanEngine(ScanEngine&amp; oScanEngine)
   at Symantec.Sharepoint.RTCommandClient.RTCommand.GetAvailableScanEngine(ScanEngine&amp; oScanEngine)
   at Symantec.Sharepoint.ScanLibrary.ScanObject. (IntPtr inILockBytes, Int32&amp; pdwStatus, String&amp; wzVirusInfo)

</Data></EventData></Event>

3. Error on App Server 2 – Event ID 8031

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          11/6/2014 2:15:01 PM
Event ID:      8031
Task Category: Topology
Level:         Error
Keywords:    
User:          domainSPFarmAct
Computer:      SPAppServer2.domain.com
Description:
An exception occurred while updating addresses for connected app {6457c0c9-76ff-4fb6-a94e-4ca7928efa06_65529aa3-7640-40b8-b262-

e557c37f87e9}. The uri endpoint information may be stale. System.InvalidOperationException: The requested application could not be found.
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName,

Exception ex, SPServiceLoadBalancerContext context)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBlock codeBlock)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.GetEndPoints(Guid serviceId)
   at Microsoft.SharePoint.SPConnectedServiceApplicationAddressesRefreshJob.Execute(Guid targetInstanceId)
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-SharePoint Foundation” Guid=”{6FB7E0CD-52E7-47DD-997A-241563931FC2}” />
    <EventID>8031</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>13</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-11-06T20:15:01.064016600Z” />
    <EventRecordID>864875</EventRecordID>
    <Correlation ActivityID=”{7C78DFF9-926C-43B6-AEEF-60EDDB502CA2}” />
    <Execution ProcessID=”13816″ ThreadID=”18532″ />
    <Channel>Application</Channel>
    <Computer>SPAppServer2.domain.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>6457c0c9-76ff-4fb6-a94e-4ca7928efa06_65529aa3-7640-40b8-b262-e557c37f87e9</Data>
    <Data Name=”string1″>System.InvalidOperationException: The requested application could not be found.
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName,

Exception ex, SPServiceLoadBalancerContext context)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBlock codeBlock)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.GetEndPoints(Guid serviceId)
   at Microsoft.SharePoint.SPConnectedServiceApplicationAddressesRefreshJob.Execute(Guid targetInstanceId)</Data>
  </EventData>
</Event>

Remedy:

During the issue the users impacted can use the Save As option in Excel Web Viewer to save the file locally if they want to edit the file and upload it later after issue is fixed.
Excel Web Services - Save As option
Excel Web Services – Save As option
The user will loose the changes they will do during this issue if they will not save a copy and then edit the saved copy.
If you continue making changes in Excel file within Excel Web Viewer, you will get a prompt with following message. At this point you have lost the changes you would have made during this session.
Either due to communication issues or a server problem, you need to be rejoined to your editing session. You may have lost changes that you made recently.
Excel Web Viewer - Session Lost and Lost recent changes Message
Excel Web Viewer – Session Lost and Lost recent changes Message
At this point go to your document library location where your Excel file is located and review the Modified date. You will notice that the modified date will not reflect that it was modified. Same will be true for version number if versioning was enabled for that library.
Excel Web Services issue - File changes not Saved
Excel Web Services issue – File changes not Saved
At this point the user will feel angry, frustrated or a lost soul based no their work. Don’t loose hope. There is some green light. Its coming in next section.

Resolution:

The above issue with Excel Web View not able to save could happen due to number of reasons. In this case when I started reviewing the SharePoint Farm for the application servers running Excel Services, I found that whenever there was error in Excel web viewer for this issue, around the same time there was an error log for Symantec Protection for SharePoint Servers. Now you know why I listed the Symantec error in the Errors section. 
I went to SharePoint Central Admin website and looked at the Symantec settings. I noticed the service was showing as stopped on one application server.
SharePoint Central Admin - Symantec Protection Service Stopped on one App Server
SharePoint Central Admin – Symantec Protection Service Stopped on one App Server
Next I looked into the Windows Services console and found the service ‘Symantec Protection 6.0 for SharePoint Servers’ in STOPPING status. In that state you can not start, stop or restart that service.
Windows Services Console - Symantec Protection Service in STOPPING State
Windows Services Console – Symantec Protection Service in STOPPING State
I terminated the Symantec Protection SPSS process using Windows Task Manager on the server. Then I started that service successfully. Later I went to SharePoint Central Admin website > Symantec Protection section and looked at that server and it was showing as Started.
SharePoint Central Admin - Symantec Protection Service in Started state on an App Server
SharePoint Central Admin – Symantec Protection Service in Started state on an App Server
Next I opened the Excel file from SharePoint location in Excel Web services in edit mode. I was able to edit the file and Excel Web Services saved the changes back to the file. I then reviewed the Modified date and it was showing the file was modified at recent time with my name under Modified Bu field. 
Excel Web Services - File changes Saved
Excel Web Services – File changes Saved
Finally the Excel Services came back on track.
Keywords:
  • Excel can not save changes
  • Excel services can not save changes
  • Excel web services can not save changes
  • Excel services lost changes
  • SharePoint Excel services lost changes
  • SharePoint Excel services not saving changes
  • SharePoint Excel services not able to edit files
  • SharePoint Excel services not able to update file
  • SharePoint Excel services oddies
  • SharePoint Excel services issues
  • Can not modify Excel in SharePoint
  • Can not modify Excel in Excel Web Services

MS14 073 Vulnerability in SharePoint

Tuesday, November 11th, 2014
Today Microsoft released a patch for vulnerability in Microsoft SharePoint Foundation Could Allow Elevation of Privilege under Microsoft Security Bulletin MS14-073.

What:
An attacker who successfully exploited the vulnerability could execute arbitrary script in the security context of the logged-on user. The script could then, for example, take actions on the affected SharePoint site on behalf of the logged-on user with the same permissions as the logged-on user.

How:
An attacker could modify certain lists within SharePoint to exploit this vulnerability, and then convince users to browse to the modified list.

Risk:
Systems running an affected version of SharePoint Server that also support the mobile browser view are primarily at risk.

Mitigation:
In a web-based attack scenario, an attacker could host a specially crafted website that is designed to exploit these vulnerabilities and then convince a user to view the website. The attacker could also take advantage of compromised websites and websites that accept or host user-provided content or advertisements. These websites could contain specially crafted content that could exploit these vulnerabilities. An attacker would have to convince users to take action, typically by getting them to click a link in an email message or in an Instant Messenger message that takes users to the attacker’s website, or by getting them to open an attachment sent through email.

Workaround:
None identified

References