Archive for the ‘SharePoint’ Category

SharePoint Project Server 2016 Resources

Monday, August 24th, 2015

V: 3.1, Updated on: 03/19/2016

On Jan 21, 2016 Bill Baer – Microsoft’s Senior SharePoint Product Manager announced the availability of the SharePoint Server 2016 on Yammer. On Mar 14 2016 Microsoft released the RTM for SharePoint and Project Server.

SharePoint 2016 comes with lots of improvements, enhancements and features.

SharePoint 2016 Preview

You can use the following resources to start your game plan for SharePoint 2016 and Project Server 2016. The game is on…..

SharePoint Server 2016 Resources

  1. SharePoint 2016 – Technet Center – https://technet.microsoft.com/en-us/library/cc303422(v=office.16).aspx
  2. SharePoint 2016 Technet Forums – https://social.technet.microsoft.com/Forums/en-us/home?forum=SP2016
  3. Announcing availability of SharePoint Server 2016 and cloud hybrid search – https://blogs.office.com/2015/08/24/announcing-availability-of-sharepoint-server-2016-it-preview-and-cloud-hybrid-search/
  4. SharePoint Server 2016 Datasheet – http://www.microsoft.com/en-us/download/details.aspx?id=48715
  5. SharePoint Server 2016 Quick Start Guide – http://www.microsoft.com/en-us/download/details.aspx?id=48714
  6. SharePoint Server 2016 Reviewer Guide – http://www.microsoft.com/en-us/download/details.aspx?id=48713
  7. SharePoint Server 2016 Download – https://www.microsoft.com/en-us/download/details.aspx?id=51493
  8. Language Packs for SharePoint Server 2016 – https://www.microsoft.com/en-us/download/details.aspx?id=51492
  9. SharePoint 2016 RTM and the Future of SharePoint event – https://blogs.office.com/2016/03/14/sharepoint-2016-rtm-and-the-future-of-sharepoint-event/
  10. Technet Forums – SharePoint 2016 – https://social.technet.microsoft.com/Forums/office/en-US/home?forum=SP2016
  11. What’s new for admins in SharePoint Server 2016 – https://blogs.office.com/2016/03/14/whats-new-for-admins-in-sharepoint-server-2016/
  12. First look at SharePoint Server 2016 IT Preview – Youtube video – https://www.youtube.com/watch?v=rV6PVzGs51I
  13. Hybrid Center – http://hybrid.office.com/

 

Project Server 2016 Resources

Project Server 2016 is a service application in SharePoint 2016. That will makes its installation and deployment easier. SharePoint Server 2016 resources apply to ProjectServer 2016 as well. Below are some of the additional resources specific to Project Server 2016,

  1. Project Server 2016 – Technet Center – https://technet.microsoft.com/en-us/library/cc303399(v=office.16).aspx
  2. Project Forums – https://social.technet.microsoft.com/Forums/projectserver/en-us/home?category=project
  3. Project Online – https://products.office.com/en-us/Project/project-online-portfolio-management
  4. Find information about Project Online – https://support.office.com/en-us/article/Find-information-about-Project-Online-e33e2273-dfaf-4eb7-aacc-393e80e58a97
  5. What’s new in Project 2016 – https://blogs.office.com/2015/09/30/whats-new-in-project-2016/
  6. Users Voice – Office 365 Project & Portfolio Management (PPM) – https://microsoftproject.uservoice.com/forums/218133-office-365-project-portfolio-management-ppm

 

Office Online Server 2016 Resources

Office Online Server 2016 is a next version of Office Web Apps Server.

  1. Office Online Server 2016 on Technet – https://technet.microsoft.com/en-us/library/jj219456(v=office.16).aspx

 

Keep watching this space for updated information, resources and news.

logo 250x250

Keywords:

  • Download SharePoint Server 2016
  • Download Project Server 2016
  • Resources on SharePoint Server 2016
  • Resources on Project Server 2016
  • Resources on SharePoint 2016
  • How to Start with SharePoint Server 2016
  • How to Start with Project Server 2016
  • Play the game of SharePoint 2016
  • Help with SharePoint Server 2016
  • Help with Project Server 2016
  • Project Server PPM 2016
  • ProjectServer PPM 2016
  • Best resources on SharePoint 2016
  • Helpful resources on SharePoint 2016

Exporting Performance Point Data Throws Duplicate Headers Received Error

Friday, April 17th, 2015

Version 1.0

Error

Recently I came across a situation where a user was trying to export a SharePoint Performance Point dashboard data to Excel and was getting the Duplicate Header Received error.

Duplicate headers received from server

ERR-RESPONSE_HEADERS_MULTIPLE_CONTENT_DISPOSITION

Duplicate Headers Received Error When Exporting PerfPoint.jpg

 

Details

I looked into the PerformancePoint dashboard and used the export to Excel option.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_02.png

 

I was able to export the data to excel and view it in there.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_03.png

 

Under one instance, when I used ‘Export to Excel’ option, the file download dialog box showed an extremely long file name with lots of special characters.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_01.png

 

Root Cause

It turns out to be the user was using the Chrome browser instead of Internet Explorer. The error is specific to Chrome as other browsers ignore the duplicate headers.

Enclosing the file names in ” ” or using underscore instead of spaces or comma (,) is one solution.

Read the following articles for little mode details on the issue.

a. Fix for Duplicate Headers Erro 349

b. Duplicate Headers received from Server

 

Keywords
  • PerformancePoint data export error
  • PerformancePoint data export error in Chrome
  • PerformancePoint Export to Excel does not work in Chrome
  • SharePoint PerformancePoint Dashboard Error
  • SharePoint PerformancePoint BI data export Error
  • SharePoint Duplicate Header Received error
  • SharePoint Duplicate Header error
  • SharePoint with Internet Explorer VS Chrome

SharePoint File Upload Error Due to Symantec Protection Engine Service Failure

Friday, March 20th, 2015

Version: 1.0

Issue Summary

This has been a little tricky issue. Symantec Protection Engine (SPE) that is part of Symantec Protection for SharePoint Servers (SPSS) product has dependency on JAVA JRE component. A Java update caused the Symantec Protection Engine service on the SharePoint Server to fail. Service fails to start with Error 1053. That lead to file uploads in SharePoint to throw error.

Error Details

Symantec Protection Engine (SPE) component depends on Java JRE as you have to use the web browser to get to the Symantec Protection Engine Console. That web console is by default at this location on SharePoint Servers.

https://localhost:8004/

The issue started in this order:
a. A user was trying to upload a file to SharePoint and got the error
b. Symantec Protection Engine service on server was stopped and failed to start with Error 1053
c. Java update caused issue for the Symantec Protection Engine to fail

a. A user was trying to upload a file to SharePoint and got the error

The user received this error in browser.

Error Found
The installed virus scanner is currently unavailable. If the problem persists, contact your administrator.

SharePoint File Upload Error due to SharePoint Antivirus Failure
SharePoint File Upload Error due to SharePoint Antivirus Failure

b. Symantec Protection Engine service on server was stopped and failed to start with Error 1053

Looking at the Symantec Protection Engine (SPE) service under Windows Service console on SharePoint showed the service as stopped. When I tried to start the service, I got following error:

Error:
Windows could not start the Symantec Protection Engine service on local Computer.
Error 1053: The service did not respond to the start or control request in a timely fashion.

SharePoint Server - Symantec Protection engine service stopped and failed to start with error 1053
SharePoint Server – Symantec Protection engine service stopped and failed to start with error 1053

Following errors were logged in Event View log.

Error 1
Log Name:      System
Source:        Service Control Manager
Date:          2/05/2015 2:17:10 PM
Event ID:      7000
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SPAppServer01.svlab.com
Description:
The Symantec Protection Engine service failed to start due to the following error: 
The service did not respond to the start or control request in a timely fashion.
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Service Control Manager” Guid=”{69908d1-a6d7-4795-8e1e-26931d2012f4}” EventSourceName=”Service Control Manager” />
    <EventID Qualifiers=”49152″>7000</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime=”2015-02-26T15:17:10.310766100Z” />
    <EventRecordID>187359</EventRecordID>
    <Correlation />
    <Execution ProcessID=”580″ ThreadID=”5204″ />
    <Channel>System</Channel>
    <Computer>SPAppServer01.svlab.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data Name=”param1″>Symantec Protection Engine</Data>
    <Data Name=”param2″>%%1053</Data>
  </EventData>
</Event>

Error 2
Log Name:      Application
Source:        Application Error
Date:          2/05/2015 2:17:10 PM
Event ID:      1000
Task Category: (100)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SPAppServer01.svlab.com
Description:
Faulting application name: symcscan.exe, version: 7.0.2.4, time stamp: 0x5167b609
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x00000000
Faulting process id: 0xf38
Faulting application start time: 0x01d051d7416d9dad
Faulting application path: C:Program Files (x86)SymantecScan Enginesymcscan.exe
Faulting module path: unknown
Report Id: 88260445-bdca-11e4-91bc-0050569300d1
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Application Error” />
    <EventID Qualifiers=”0″>1000</EventID>
    <Level>2</Level>
    <Task>100</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime=”2015-02-26T15:17:10.000000000Z” />
    <EventRecordID>331301</EventRecordID>
    <Channel>Application</Channel>
    <Computer>SPAppServer01.svlab.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data>symcscan.exe</Data>
    <Data>7.0.2.4</Data>
    <Data>5167b609</Data>
    <Data>unknown</Data>
    <Data>0.0.0.0</Data>
    <Data>00000000</Data>
    <Data>c0000005</Data>
    <Data>00000000</Data>
    <Data>f38</Data>
    <Data>01d051d7416d9dad</Data>
    <Data>C:Program Files (x86)SymantecScan Enginesymcscan.exe</Data>
    <Data>unknown</Data>
    <Data>88140445-bdca-11e4-91bc-0050569300d1</Data>
  </EventData>
</Event>

c. Java update caused issue for the Symantec Protection Engine to fail

It turned out to be that the last Java update that updated the Java JRE from some 7.x version to 8.x version caused the issue. After seeing the service failure error and reading Symantec KB articles, I removed and tried to redeploy Symantec Protection Engine component. I got the following error during SPE’s redeployment:

Error:
The Java Runtime Environment could not be found.
Please install the java runtime, 1.5 family, preferably build 13 or higher.

SharePoint File Upload Failure - Symantec Protection Engine re-installation error for Java JRE
SharePoint File Upload Failure – Symantec Protection Engine re-installation error for Java JRE

Keep reading the next section for the resolution.

Resolution

I removed the Java JRE version, rebooted the server and then installed a version from 7.x series 7u60. After that I was able to re-install Symantec Protection Engine. The re-installation fixed the service issue as well.

Make sure you review the Symantec KB resources listed below. In my case just removing version 8.x java and putting back the 7.x would have fixed the issue without re-installation of Symantec Protection Engine.

References

Keywords:

  • SharePoint File Upload error
  • SharePoint File Upload error due to antivirus failure
  • Symantec Protection engine service fails to start with error 1053
www.Softvative.com
Visit www.softvative.com for professional services.

Marrying CSV file type with Microsoft Excel with SharePoint as the Chaperone

Tuesday, February 24th, 2015

Version: 1.3, Modified On: 03/25/2015

The title of this post can be read as following in SharePoint terms:
How to open CSV files in Microsoft Excel when using CSV from SharePoint?

Scenario

.CSV file type is not tied with Microsoft Excel in SharePoint. When users click on a CSV file in a SharePoint Library, it opens the CSV file in Notepad on the user’s computer. In contrast, if user clicks on a .CSV file on their PC, it opens the file in Microsoft Excel.

Antoher scenario where a user has the CSV file checked out, but he closed the CSV file without checking in the file. Now the users clicks on the checked out CSV and it opens in the notepad.

Another issue, the CSV files don’t have any icon associated with the file in SharePoint.

CSV File in SharePoint – Default Behavior

Let’s review the default behavior of CSV file in SharePoint. We have a test CSV file already uploaded to a library in SharePoint.

1. You can see there is no descriptive icon associated with the CSV file unlike Excel file. See the Excel file and .TXT file has relevant icon.

SharePoint - CSV File with no icon - Default behavior
SharePoint – CSV File with no icon – Default behavior

2. Click on the CSV file and you will get a prompt to open, save or save as the file

SharePoint - CSV File type clicked - Default behavior
SharePoint – CSV File type clicked – Default behavior

3. Click Open and it will open the CSV file in Microsoft Excel.

SharePoint – CSV File Opened in MS Excel – Default behavior

4. Now let’s check out the CSV file

SharePoint - Check Out CSV File - Notice Edit in Excel not an Option in menu - Default behavior
SharePoint – Check Out CSV File – Notice Edit in Excel not an Option in menu – Default behavior

5. Click on the checked out CSV file

SharePoint – Check Out CSV File – Click to open – Default behavior

6. Click ok on the Open Document dialog box

SharePoint - Check Out CSV File opens Document dialog box - Default behavior
SharePoint – Check Out CSV File opens Document dialog box – Default behavior

7. The opens up in Notepad!!!

SharePoint - Check Out CSV File opens up in Notepad - Default behavior
SharePoint – Check Out CSV File opens up in Notepad – Default behavior

We will review the inside behavior and how we can enhance the user experience for the CSV files.

Different Areas To Review and Resolution

We’ll review few areas related to this issue:

a. Default Programs settings on the user’s PC
i. Set your default programs
ii. Associate a file type or protocol with a program
b. IIS Web Server MIME Settings for .CSV on SharePoint Servers
c. Adding line item for CSV file and behavior in DocIcon.xml on SharePoint Servers
d. Changing Hkey_Classes_Root.csv on user’s PC

a. Default Programs settings on the user’s PC

Excel is the default program for CSV and is usually not the issue for the .CSV file to open in Microsoft Excel when the CSV file is on the PC or network share.

i. Set your default programs

1. Go to Control Panel > Default Programs
2. Click on Set your default programs

CSV File Association - Control Panel > Default Programs
CSV File Association – Control Panel > Default Programs

3. Click on Excel from the list of program on left side. Then click on ‘Choose defaults for this program’

CSV File Association – Control Panel > Default Programs – Excel Defaults

4. Make sure the csv extension is checked for Excel. Then click Save.

CSV File Association – Control Panel > Default Programs – Excel Defaults

ii.    ii. Associate a file type or protocol with a program

Let’s review the file type association under Default Programs.

1.  Go to Control Panel > Default Program
2. Click on ‘Associate a file type or protocol with a program’

CSV File Association - Control Panel > Default Programs - Associate File Type or Protocol
CSV File Association – Control Panel > Default Programs – Associate File Type or Protocol

3. On next page, make sure .csv file type is associated with Excel. Click on Change Program button if it is not or if you want to change it.

CSV File Association - Control Panel > Default Programs - CSV File Type Associate
CSV File Association – Control Panel > Default Programs – CSV File Type Associate

4. From Open With dialog screen, choose Excel. If Excel is not listed then expand ‘Other Programs’ section by clicking on the small arrow on right side. If Excel is not listed there then use Browse button to go to folder location where Microsoft Excel is installed and select the Excel.exe executable file. Make you to check the box that says ‘Always use the selected program to open this kind of file’

CSV File Association - Control Panel > Default Programs - CSV File Type Association with Excel
CSV File Association – Control Panel > Default Programs – CSV File Type Association with Excel

5. Click OK and close Default Program window.

b. IIS Web Server MIME Settings for .CSV on SharePoint Servers

We’ll now review the MIME type in IIS.

1. On SharePoint Servers, open IIS Manager
2. Click on the Server name on the left side of the console. On the right side of console make sure you have Features View tab highlighted

Note: You can make this change for selective web application (IIS site) rather than to the whole server.

3. From the features list, click on the MIME Types

SharePoint Servers - IIS Manager > MIME Types for CSV Changes
SharePoint Servers – IIS Manager > MIME Types for CSV Changes

4. Look for .CSV under the MIME Types. [Hint: You can select the first item in list and type .csv on kleyboard. It will take you right to the CSV extension]

The default .CSV MIME Type config is set to: application/octet-stream

5. Double click on the .CSV (or select .cSV and choose Edit from actions area on right).
Enter this value for CSV: application/vnd.ms-excel

Note: I’ve also noticed few people used below .CSV MIME Type value:
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

SharePoint Servers - IIS Manager > Updated MIME Types for .CSV Extension
SharePoint Servers – IIS Manager > Updated MIME Types for .CSV Extension

The IIS MIME type change will make the CSV file open in Microsoft Excel. Read below for details. Some scenarios may require below changes as well.

c. Adding line item for CSV file and behavior in DocIcon.xml on SharePoint Servers

Now to better user experience, we would like to add some icon with CSV file and enabled ‘Edit in Microsoft Excel’ in file menu in SharePoint. Look into the icon for CSV file in the first image at the top of this post.

On SharePoint Servers, we have DocIcon.xml file at following location that holds the key to the file type and behavior.

Location:
C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions14TEMPLATEXMLDOCICON.xml

Under the ByExtension section add the line for CSV file type. Notice the CSV16.gif is the icon file that I’m using for the CSV. You can use other icons like icxltx.png
<Mapping Key=”csv” Value=”CSV16.GIF” EditText=”Microsoft Excel” OpenControl=”SharePoint.OpenDocuments”/>

The location to store your own file icon or use one already there:
C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions14TEMPLATEIMAGES

Note:
I’ve noticed people have used one of these configuration for the CSV file type in DocIcon.xml. I choose the above line entry.
<Mapping Key=”csv” Value=”CSV16.GIF” OpenControl=””/>

<Mapping Key=”csv” Value=”CSV16.GIF” OpenControl=”SharePoint.OpenDocuments”/>

<Mapping Key=”csv” Value=”CSV16.GIF” EditText=”Microsoft Excel” OpenControl=”SharePoint.OpenDocuments” OpenApp=”ms-excel”/>

Important:
After performing the MIME Type change and this DocIcon.xml addition on all SharePoint Servers, make sure to perform the IISreset/noforce on SharePoint Servers.

d. Changing Hkey_Classes_Root.csv on user’s PC

On few user systems, I noticed the checked out files will still open in notepad if clicked by the same user.

To resolve that issue, I had to delete “PerceivedType”=”text” from the following registry location. [Use at your own risk and with backups].

HKEY_CLASSES_ROOT.csv

SharePoint - Deleted PerceivedType entry from Registry for .CSV Extension on user PC
SharePoint – Deleted PerceivedType entry from Registry for .CSV Extension on user PC

That registry location had these value:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT.csv]
“PerceivedType”=”text”
@=”Excel.CSV”
“Content Type”=”application/vnd.ms-excel”

[HKEY_CLASSES_ROOT.csvExcel.CSV]

[HKEY_CLASSES_ROOT.csvExcel.CSVShellNew]

[HKEY_CLASSES_ROOT.csvPersistentHandler]
@=”{guid}”

Few other notable Registry Location:
HKEY_CLASSES_ROOT.***
HKEY_CLASSES_ROOT<ProgId>shellopencommand
HKEY_CLASSES_ROOTMIMEDatabaseContent Type

HKEY_LOCAL_MACHINESOFTWAREClasses.csv

After these changes, the CSV filetypes will show the icon on the left, the SharePoint file menu will show Edit in Microsoft Excel as an option and edit the file will open the file in Microsoft Excel.

SharePoint - CSV File Types Showing Icon, Menu Showing Edit in Microsoft Excel Option
SharePoint – CSV File Types Showing Icon, Menu Showing Edit in Microsoft Excel Option

The short summary of this overall jargon can be explained in this Softvative Graphics.

Quick Process to Make CSV filetype work in MS Excel on SharePoint
Quick Process to Make CSV filetype work in MS Excel on SharePoint

@@@@@ At the end, the CSV and MS Excel lived happily ever after. 🙂  @@@@@

Few good resource to read on MIME Types and CSV

Keywords:

  • How to open CSV file in Sharepoint
  • How to open CSV file in Microsoft Excel
  • How to open CSV file in Excel
  • Open CSV in Excel
  • Open CSV from SharePoint
  • open .CSV from in Excel
  • open .CSV from SharePoint
  • CSV MIME Type changes
  • CSV MIME Type changes in SharePoint
  • CSV MIME Type changes for SharePoint
  • CSV MIME Type changes for Excel
  • CSV open document behavior
  • CSV default program association
  • Marry the CSV to Excel
  • CSV Registry locations
Visit www.softvative.com for professional services.

Four ways to Get Report of SharePoint Folders and Files for a Library

Wednesday, February 11th, 2015

Version: 1.0

Scenario

You might have many layers of folders insides folders and files insides those folders in a SharePoint Library. How to get a quick report of folders and files for a single Document Library?

There are different ways to get that information:

a. Using Generate File Plan Report Feature of Document Library
b. Using Mapped Drive with Dir Command
c. Using SQL Query
d. Using Power Shell

a. Using Generate File Plan Report Feature of Document Library

SharePoint has a feature in Document Library called ‘Generate File Plan Report’. Follow the steps below:

1. Go to a document library for which you need to get the list of folders and files
2. Go to Library > Library Settings
3. Click on ‘Generate File Plan Report‘ under Permissions and Management

SharePoint Document Library - Generate File Plan Report
SharePoint Document Library – Generate File Plan Report

5. On next page, Save location field will default to the same library. That is the place where the system will generate and save the report file. Click Ok
6. Report will be generated and you will see a link on next page. Click on the page to open the report in MS Excel

SharePoint Document Library - Click the link to review report
SharePoint Document Library – Click the link to review report

7. Click OK and you will back to the Document Library. You can locate the file in the same library or to a place you picked in step 5

Example Report File

b. Using Mapped Drive with Dir Command

The above report doesn’t show you the folders and files that are inside those folders. It just reports the Total # of items at each folder layer.

To get the full hierarchy of folders including files inside each level of hierarchy, you need to switch back to basics. My 1992 study of  Peter Norton’s Dos Guide came to rescue from here.

1. Copy the URL http://sharepoint.svlab.com/sites/biz1/project1/ProjectsDocLib/                                [notice I removed .aspx view file and form folder that contains the view pages]
2. Map an available drive letter on your PC say W: and use the above URL
3. Open a command prompt and go to W: drive
4. Use the command
dir /s > c:FilesFolders.txt

You can add /b switch to get rid of file / folder details and just get the files / folder names.
dir /s /b > c:FileFolders.txt

5. Open the txt file and you will see the folders and files in hierarchical structure
6. Make sure to disconnect the W: drive.

Navigating using Windows Explorer with SharePoint is not the fastest way to work with SharePoint.

c. Using SQL Query

You can use the SQL query to get the list of files and folders. Run at your own risk in a pre-production system.

— Query to list Files and Folders within Sites
— By Faisal Masood
SELECT 
Webs.Title AS ‘WebApp’,
AllLists.tp_Title AS ‘ListName’,
AllDocs.DirName AS ‘URL’,
AllDocs.LeafName AS ‘FileName’,
AllDocs.ExtensionForFile AS ‘FileType’,
AllDocs.TimeCreated
FROM AllDocs 
JOIN AllLists
ON AllLists.tp_ID = AllDocs.ListId
JOIN AllDocStreams
ON AllDocStreams.Id = AllDocs.Id
JOIN Webs
ON Webs.Id = AllLists.tp_WebId
WHERE — Webs.Title LIKE ‘%SharePoint Company Sitet%’ AND
AllDocs.DirName like ‘documents%’
–AND AllDocs.TimeCreated > ‘2010-05-10 00:00:00.000’
ORDER BY Webs.Title

c. Using Power Shell

PowerShell might be the best option to get customized report with selective information. The PowerShell code below will get show all documents under a document library names that has Documents in name and that are under site sharepoint.svlab.com site.

# List Files and Folders under a Documents Library
# By: Faisal Masood – PMP, MCSE, MCITP, MCSA
#Add SharePoint PowerShell SnapIn if not already added
 if ((Get-PSSnapin “Microsoft.SharePoint.PowerShell” -ErrorAction SilentlyContinue) -eq $null) {
    Add-PSSnapin “Microsoft.SharePoint.PowerShell”
}

# http://sharepoint.svlab.com/
Get-SPWeb http://sharepoint.svlab.com/ |
  Select -ExpandProperty Lists |
    Where { $_.GetType().Name -eq “SPDocumentLibrary” -and
            -not $_.Hidden } |
    Select -ExpandProperty Items |
    Where { $_.Url -like “*Documents*” } |
    Select Name, {$_.File.Length}, url

Download .ps1 PowerShell Script File

Keywords:

  • get report of files and folders in SharePoint
  • report folders and files in SharePoint
  • Four ways to get Files Folder structure
  • SQL query to get Files Folder structure
  • PowerShell to Files Folder structure
Visit www.softvative.com for professional services.

SharePoint Server 2016 Announcement and My Wish List

Tuesday, February 3rd, 2015

Version: 1.1,

Updated: 2/3/2015

Microsoft has been pushing for Office 365 and SharePoint Online for last few recent years. They recently announced that next version of SharePoint Server will be released in 2016.

SharePoint Server 2016 will offer customers enhanced, flexible deployment options, improved reliability and new IT agility, enabled for massive scale. SharePoint Server 2016 is expected to provide rich hybrid capabilities with Office 365 version.

SharePoint Server 2016 – My Wish List of Feature

I wish for many new and improved features in next version of SharePoint Server in 2016. Following are some of the top wishes based on my experience with customers.

  1. More enriched workflows
  2. Document Scanning Feature
  3. Making Project Server as completely independent application that can be used without the need of full SharePoint Enterprise. (in recent years we have seen Office Web Apps as an application that requires separate server for deployment now)
  4. Making better across the farm security reporting (without the need to 3rd party tools)
  5. Better Forms solution that has better cross platforms compatibility (InfoPath replacement)
  6. Making an On-Prem version of Yammer as a service application or separate app that can be tightly integrated with SharePoint
  7. Making Video Encoding features available for more enriched video publishing within on-prem
  8. Making Delve available in On-Prem as well

I’ll be adding more items later. Read the following Office blog post with recent announcement details.

References:

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.