Archive for November, 2014

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.

Implementing Microsoft Azure Infrastructure Solutions 70-533

Sunday, November 23rd, 2014

Implementing Microsoft Azure Infrastructure Solutions 70-533

Azure is the cloud solution from Microsoft.

Microsoft Azure - Cloud Solution
Microsoft Azure – Cloud Solution

Following are some of the great resources to study the Implementing Microsoft Azure Infrastructure Solutions 70-533 exam.

1. https://www.microsoft.com/learning/en-us/exam-70-533.aspx
2. http://www.microsoftvirtualacademy.com/product-training/microsoft-azure
3. http://www.amazon.com/70-533-Implementing-Microsoft-Infrastructure-Solutions/dp/073569706X
4. Microsoft Learning Instructor Led Course 20533A: Implementing Microsoft Azure Infrastructure Solutions (five days)
5. Azure Subscription and Service Limits, Quotas, and Constraints
http://azure.microsoft.com/en-us/documentation/articles/azure-subscription-service-limits/
6. Azure Documentation Center
http://azure.microsoft.com/en-us/documentation/
7. Azure Free Trial
http://azure.microsoft.com/en-us/pricing/free-trial/

The 70-533 Exam focused on following six knowledge areas with each area covering 15-20% of the exam.

  1. Implement websites
  2. Implement virtual machines
  3. Implement cloud services
  4. Implement storage
  5. Implement an Azure Active Directory
  6. Implement virtual networks

1. Implement websites

How to Manage Websites
http://azure.microsoft.com/en-us/documentation/articles/web-sites-manage/

Deploy websites
Define deployment slots; roll back deployments, configure and deploy packages, deploy web jobs, schedule web jobs

Staged Deployment on Microsoft Azure Websites
http://azure.microsoft.com/en-us/documentation/articles/web-sites-staged-publishing/
Azure Websites Backups
http://azure.microsoft.com/en-us/documentation/articles/web-sites-backup/
Restore a Microsoft Azure website
http://azure.microsoft.com/en-us/documentation/articles/web-sites-restore/
How to Deploy an Azure Website
http://azure.microsoft.com/en-us/documentation/articles/web-sites-deploy/
Use WebJobs to run background tasks in Microsoft Azure Websites
http://azure.microsoft.com/en-us/documentation/articles/web-sites-create-web-jobs/

Configure websites
Configure app settings, connection strings, handlers, and virtual directories; configure certificates, custom domains, and traffic manager; configure SSL bindings and runtime configurations; manage websites by using Windows PowerShell and Xplat-CLI

How to Configure Websites
http://azure.microsoft.com/en-us/documentation/articles/web-sites-configure/
Custom configuration and application settings in Azure Web Sites – with Stefan Schackow
http://azure.microsoft.com/en-us/documentation/videos/configuration-and-app-settings-of-azure-web-sites/
Windows Azure Webs Sites: How Application Strings and Connection Strings Work
http://azure.microsoft.com/blog/2013/07/17/windows-azure-web-sites-how-application-strings-and-connection-strings-work/
Configuring a custom domain name for an Azure Website
http://azure.microsoft.com/en-us/documentation/articles/web-sites-custom-domain-name/
Enable HTTPS for an Azure Website
http://azure.microsoft.com/en-us/documentation/articles/web-sites-configure-ssl-certificate/
Using Azure Traffic Manager with Azure Web Sites
http://blogs.msdn.com/b/waws/archive/2014/03/18/using-windows-azure-traffic-manager-with-waws.aspx
Managing Windows Azure Web Sites with PowerShell
http://channel9.msdn.com/Series/Windows-Azure-Web-Sites-Tutorials/Managing-Windows-Azure-Web-Sites-with-PowerShell
Install and Configure the Azure Cross-Platform Command-Line Interface
http://azure.microsoft.com/en-us/documentation/articles/xplat-cli/

Configure diagnostics, monitoring, and analytics
Retrieve diagnostics data; view streaming logs; configure endpoint monitoring, alerts, and diagnostics; monitor website resources

How to Monitor Websites
http://azure.microsoft.com/en-us/documentation/articles/web-sites-monitor/
How to: Receive Alert Notifications and Manage Alert Rules in Azure
http://msdn.microsoft.com/library/azure/dn306638.aspx

Configure scale and resilience
Configure auto-scale using built-in and custom schedules; configure by metric; change the size of an instance

How to Scale Websites
http://azure.microsoft.com/en-us/documentation/articles/web-sites-scale/
When to Scale Azure Websites – with Stefan Schackow
http://azure.microsoft.com/en-us/documentation/videos/azure-web-sites-free-vs-standard-scaling/
Auto Scaling Azure Websites, CPU or Scheduled – with Stefan Schackow
http://azure.microsoft.com/en-us/documentation/videos/auto-scaling-azure-web-sites/
How Azure Websites Scale – with Stefan Schackow
http://azure.microsoft.com/en-us/documentation/videos/how-azure-web-sites-scale/

Manage hosting plans
Create hosting plans; migrate websites between hosting plans; create a website within a hosting plan

What is a Web Hosting Plan?
http://azure.microsoft.com/en-us/documentation/articles/web-sites-web-hosting-plan-overview/
Azure Websites Web Hosting Plan In-Depth Overview
http://azure.microsoft.com/en-us/documentation/articles/azure-web-sites-web-hosting-plans-in-depth-overview/

Related Courses and Resources:

2. Implement virtual machines

Azure Virtual Machines FAQ
http://msdn.microsoft.com/en-us/library/azure/dn683781.aspx

Deploy workloads on Azure virtual machines (VMs)
Identify supported Microsoft workloads; deploy and connect to a Linux VM; create VMs

Microsoft Azure Documentation – Virtual Machines
http://azure.microsoft.com/en-us/documentation/services/virtual-machines/
Microsoft server software support for Microsoft Azure virtual machines
http://support2.microsoft.com/kb/2721672
Create a Virtual Machine Running Windows
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-windows-tutorial/
Create a Virtual Machine Running Linux
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-linux-tutorial/
Azure Service Management Cmdlets – Deploying and Managing Virtual Machines
http://msdn.microsoft.com/en-us/library/azure/dn495240.aspx#sectionSection3

Implement images and disks
Create specialized and generalized images for Windows and Linux; copy images between storage accounts and subscriptions; upload VHDs

Creating and Uploading a Virtual Hard Disk that Contains the Linux Operating System
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-linux-create-upload-vhd/
Creating and Uploading a Windows Server VHD to Azure
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-create-upload-vhd-windows-server/
About Disks and Images in Azure
http://msdn.microsoft.com/library/azure/jj672979.aspx
AzCopy – Using Cross Account Copy Blob
http://blogs.msdn.com/b/windowsazurestorage/archive/2013/04/01/azcopy-using-cross-account-copy-blob.aspx

Perform configuration management
Automate configuration management by using PowerShell Desired State Configuration and custom script extensions; enable puppet and chef extensions

Introducing the Azure PowerShell DCS (Desired State Configuration) extension
http://blogs.msdn.com/b/powershell/archive/2014/08/07/introducing-the-azure-powershell-dsc-desired-state-configuration-extension.aspx
Automating VM Configuration using PowerShell DSC Extension
http://azure.microsoft.com/blog/2014/08/08/automating-vm-configuration-using-powershell-dsc-extension/
Automating VM Customization tasks using Custom Script Extension
http://azure.microsoft.com/blog/2014/04/24/automating-vm-customization-tasks-using-custom-script-extension/
Puppet and Azure: Bringing DevOps to the Enterprise
http://channel9.msdn.com/Events/Build/2014/2-658
Puppetlabs: Microsoft Windows and Azure
http://puppetlabs.com/solutions/microsoft
Chef and Microsoft Windows
http://www.getchef.com/solutions/windows/
Using Chef to Manage Azure Resources
http://msopentech.com/blog/2014/03/31/using-chef-to-manage-azure-resources/

Configure VM networking
Settings include reserved IP addresses, access control list (ACL), internal name resolution, DNS at the cloud service level, load balancing endpoints, HTTP and TCP health probes, public IPs, firewall rules, direct server return, and Keep Alive

Azure Virtual Network Overview
http://msdn.microsoft.com/library/azure/jj156007.aspx
Azure Virtual Network Configuration Tasks
http://msdn.microsoft.com/en-us/library/azure/jj156206.aspx
How to Set Up Endpoints to a Virtual Machine
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-set-up-endpoints/
About Network Access Control Lists (ACLs)
http://msdn.microsoft.com/library/azure/dn376541.aspx
Configure a Static Internal IP Address (DIP) for a VM
http://msdn.microsoft.com/en-us/library/azure/dn630228.aspx
Microsoft Azure – Name Resoulution (DNS)
http://msdn.microsoft.com/en-us/library/azure/jj156088.aspx
Azure Load Balancer
http://msdn.microsoft.com/en-us/library/azure/dn655058.aspx
Raj’s Cloud Musings – Setting up DMZ in Windows Azure
http://www.rajinders.com/2013/06/11/setting-up-dmz-in-windows-azure/
New: Configurable Idle Timeout for Azure Load Balancer
http://azure.microsoft.com/blog/2014/08/14/new-configurable-idle-timeout-for-azure-load-balancer/

Configure VM resiliency
Scale up and scale down VM sizes; auto-scale; configure availability sets

How to Scale an Application
http://azure.microsoft.com/en-us/documentation/articles/cloud-services-how-to-scale/
Azure Auto-Scale for IaaS
http://windowsitpro.com/azure/azure-auto-scale-iaas
Manage the availability of virtual machines
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-manage-availability/

Design and implement VM storage
Configure disk caching; plan storage capacity; configure operating system disk redundancy; configure shared storage using Azure File service; configure geo-replication; encrypt disks

About Virtual Machine Disks in Azure
http://msdn.microsoft.com/library/azure/dn790303.aspx
Setting up a File Share for the new Azure File Service
http://blogs.technet.com/b/uspartner_ts2team/archive/2014/06/09/setting-up-a-file-share-for-the-new-azure-file-service.aspx
Introducing Microsoft Azure File Service
http://blogs.msdn.com/b/windowsazurestorage/archive/2014/05/12/introducing-microsoft-azure-file-service.aspx
Azure Virtual Machine Disk Encryption using CloudLink
http://azure.microsoft.com/blog/2014/08/19/azure-virtual-machine-disk-encryption-using-cloudlink/
Disk Encryption in Azure VMs
http://clemmblog.azurewebsites.net/disk-encryption-azure-vms/

Monitor VMs
Configure endpoint monitoring, alerts, and diagnostics

How to Set Up Endpoints to a Virtual Machine
http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-set-up-endpoints/
Create and Use Performance Counters in an Azure Application
http://msdn.microsoft.com/library/azure/hh411542.aspx
Understanding Monitoring Alerts and Notifications in Azure
http://msdn.microsoft.com/en-us/library/azure/dn306639.aspx

3. Implement cloud services

Microsoft Azure Documentation – Cloud Services
http://azure.microsoft.com/en-us/documentation/services/cloud-services/
MSDN: Microsoft Azure Documentation – Cloud Services
http://msdn.microsoft.com/en-us/library/azure/jj155995.aspx

Configure cloud services and roles
Configure instance count and size, operating system version and family, upgrade and fault domains, ACLs, reserved IPs, and network access rules; configure local storage; configure dedicated and co-located caching, local and cloud configurations, and local disks; configure multiple websites; configure custom domains

Virtual Machine and Cloud Service Sizes for Azure
http://msdn.microsoft.com/en-us/library/azure/dn197896.aspx
About Network Access Control Lists (ACLs)
http://msdn.microsoft.com/library/azure/dn376541.aspx
How to: Use an Azure In-Role Caching in Azure Cloud Service
http://msdn.microsoft.com/en-us/library/azure/jj131262.aspx
Set Up a Cloud Service for Azure
http://msdn.microsoft.com/en-us/library/azure/hh124108.aspx
Configure Local Storage Resources
http://msdn.microsoft.com/en-us/library/azure/ee758708.aspx
Configure a Web Role for Multiple Web Sites
http://msdn.microsoft.com/en-us/library/azure/gg433110.aspx

Deploy and manage cloud services
Upgrade a deployment; VIP swap a deployment; package a deployment; modify configuration files; perform in-place updates; perform runtime configuration changes using the portal; scale a cloud service; create service bus namespaces and choose a tier; apply scalability targets

Cloud Services – Manage Deployments in Azure
http://msdn.microsoft.com/en-us/library/azure/gg433027.aspx
Manage Upgrades to the Azure Guest Operating System (Guest OS)
http://msdn.microsoft.com/en-us/library/azure/ff729422.aspx
How to Manage Cloud Services
http://azure.microsoft.com/en-us/documentation/articles/cloud-services-how-to-manage/
How to Scale an Application
http://azure.microsoft.com/en-us/documentation/articles/cloud-services-how-to-scale/
Microsoft Azure – Service Bus Documentation
http://azure.microsoft.com/en-us/documentation/services/service-bus/

Monitor cloud services
Monitor service bus queues, topics, relays, and notification hubs; configure diagnostics

Collect Logging Data by Using Azure Diagnostics
http://msdn.microsoft.com/en-us/library/azure/gg433048.aspx
Monitoring an Azure Application
http://msdn.microsoft.com/en-us/library/azure/hh694039.aspx
Troubleshooting and Debugging in Azure Cloud Services
http://msdn.microsoft.com/en-us/library/azure/gg465380.aspx
Service Bus Queues, Topics, and Subscriptions
http://msdn.microsoft.com/library/azure/hh367516.aspx

4. Implement storage

Implement blobs and Azure files
Read data; change data; set metadata on a container; use encryption (SSL); perform an async blob copy; configure a Content Delivery Network (CDN); implement storage for backup and disaster recovery; configure Azure Backup; define blob hierarchies; configure custom domains; configure the Import and Export Service

Microsoft Azure Documentation – Storage
http://azure.microsoft.com/en-us/documentation/services/storage/
How to Create a Storage Account
http://azure.microsoft.com/en-us/documentation/articles/storage-create-storage-account/
Configure a custom domain name for blob data in an Azure storage account
http://azure.microsoft.com/en-us/documentation/articles/storage-custom-domain-name/
Using the Microsoft Azure Import/Export Service to Transfer Data to Blob Storage
http://azure.microsoft.com/en-us/documentation/articles/storage-import-export-service/
Migrate Data to Microsoft Azure Files
http://azure.microsoft.com/blog/2014/07/24/migrating-data-to-microsoft-azure-files/
Microsoft Azure Documentation – Backup
http://azure.microsoft.com/en-us/documentation/services/backup/

Manage access
Create and manage shared access signatures; use stored access policies; regenerate keys

How To Manage Storage Accounts
http://azure.microsoft.com/en-us/documentation/articles/storage-manage-storage-account/
Authentication for the Azure Storage Services
http://msdn.microsoft.com/en-us/library/azure/dd179428.aspx
Configure diagnostics, monitoring, and analytics

Configure retention policies and logging levels; analyze logs
How to Monitor a Storage Account
http://azure.microsoft.com/en-us/documentation/articles/storage-monitor-storage-account/

Implement SQL databases
Choose the appropriate database tier and performance level; configure point in time recovery and geo-replication; import and export data and schema; design a scaling strategy

Microsoft Azure Documentation – SQL Database
http://azure.microsoft.com/en-us/documentation/services/sql-database/
Choosing between SQL Server in Windows Azure VM & Windows Azure SQL Database
http://azure.microsoft.com/blog/2013/02/14/choosing-between-sql-server-in-windows-azure-vm-windows-azure-sql-database/
Azure SQL Database Service Tiers (Editions)
http://msdn.microsoft.com/library/azure/fea26432-7462-48a0-b58d-a6e3e36da165
Active Geo-Replication for Azure SQL Database
http://msdn.microsoft.com/en-us/library/azure/dn741339.aspx
Azure SQL Database Standard Geo-Replication
http://azure.microsoft.com/blog/2014/09/03/azure-sql-database-standard-geo-replication/
Standard Geo-Replication for Azure SQL Database
http://msdn.microsoft.com/en-us/library/azure/dn758204.aspx
Azure SQL Database Performance and Scaling
http://msdn.microsoft.com/en-us/library/azure/dn741338.aspx
Windows Azure SQL Database
http://www.microsoftvirtualacademy.com/training-courses/windows-azure-sql-database

Implement recovery services
Create a backup vault; deploy a backup agent; back up and restore data

Microsoft Azure Documentation – Backup
http://azure.microsoft.com/en-us/documentation/services/backup/
Microsoft Azure Documentation – Site Recovery
http://azure.microsoft.com/en-us/services/site-recovery/
Azure Backup Overview
http://msdn.microsoft.com/en-us/library/azure/hh831419.aspx
Configure Azure Backup to quickly and easily back-up Windows Server
http://azure.microsoft.com/en-us/documentation/articles/backup-configure-vault/
Use backup vaults to protect items
http://msdn.microsoft.com/en-us/library/azure/dn168843.aspx

5. Implement an Azure Active Directory

Microsoft Azure Documentation – Azure Active Directory
http://azure.microsoft.com/en-us/documentation/services/active-directory/

Integrate an Azure AD with existing directories
Implement DirSync, O365 integration, and single sign-on with on-premises Windows Server 2012 R2; add custom domains; monitor Azure AD

Azure Active Directory – Directory integration
http://msdn.microsoft.com/en-us/library/azure/jj573653.aspx
Directory Sync with Single Sign-On Scenario
http://technet.microsoft.com/en-us/library/dn441213.aspx
Azure Active Directory – Add your domain
http://technet.microsoft.com/en-us/library/hh969247.aspx
About Office 365 and Azure Active Directory
http://technet.microsoft.com/en-us/library/dn509517.aspx

Configure the Application Access Panel
Configure single sign-on with SaaS applications using federation and password based; add users and groups to applications; revoke access to SaaS applications; configure access; federation with Facebook and Google ID

MSDN: Microsoft Azure Active Directory Application Access
http://msdn.microsoft.com/en-us/library/azure/dn308590.aspx
Azure AD – Introduction to the Access Panel
http://msdn.microsoft.com/en-us/library/azure/dn308586.aspx
Application access enhancements for Azure AD
http://msdn.microsoft.com/en-us/library/azure/dn308588.aspx
Azure AD – User Management
http://msdn.microsoft.com/en-us/library/azure/hh967609.aspx
Azure AD – Group Management
http://msdn.microsoft.com/en-us/library/azure/dn532279.aspx
Access Control Service 2.0
http://msdn.microsoft.com/library/azure/hh147631.aspx

Integrate an app with Azure AD
Web apps (WS-federation); desktop apps (OAuth); graph API

Authentication Scenarios for Azure AD
http://msdn.microsoft.com/en-us/library/azure/dn499820.aspx
Azure Active Directory Authentication Protocols
http://msdn.microsoft.com/en-us/library/azure/dn151124.aspx
Azure AD Graph API
http://msdn.microsoft.com/en-us/library/azure/hh974476.aspx

6. Implement virtual networks

Configure a virtual network
Deploy a VM into a virtual network; deploy a cloud service into a virtual network; configure static IPs; configure internal load balancing; design subnets

Microsoft Azure Documentation – Virtual Network
http://azure.microsoft.com/en-us/documentation/services/virtual-network/
Connection Web or Worker Roles to a Simple Virtual Network in Windows Azure
http://michaelwasham.com/2012/08/06/connecting-web-or-worker-roles-to-a-simple-virtual-network-in-windows-azure/
About Virtual Network Settings in the Management Portal
http://msdn.microsoft.com/en-us/library/azure/jj156074.aspx
Microsoft Azure Network Services – IP Addressing
http://msdn.microsoft.com/en-us/library/azure/dn376542.aspx
Microsoft Azure Network Services – Azure Load Balancer
http://msdn.microsoft.com/en-us/library/azure/dn655058.aspx
Microsoft Azure Network Services – Internal load balancing
http://msdn.microsoft.com/en-us/library/azure/dn690121.aspx
Create a Virtual Network in Azure
http://azure.microsoft.com/en-us/documentation/articles/create-virtual-network/

Modify a network configuration
Modify a subnet; import and export a network configuration

View and Edit Virtual Network Properties
http://msdn.microsoft.com/en-us/library/azure/jj156211.aspx
Import a Network Configuration File
http://msdn.microsoft.com/en-US/library/azure/jj156213.aspx
Export Virtual Network Settings to a Network Configuration File
http://msdn.microsoft.com/en-US/library/azure/dn133804.aspx
Configure a Virtual Network Using a Network Configuration File
http://msdn.microsoft.com/en-US/library/azure/jj156097.aspx
Move a VM or Role Instance to a Different Subnet
http://msdn.microsoft.com/en-us/library/azure/dn643636.aspx

Design and implement a multi-site or hybrid network
Choose the appropriate solution between ExpressRoute, site-to-site, and point-to-site; choose the appropriate gateway; identify supported devices and software VPN solutions; identify networking prerequisites; configure regional virtual networks and multi-site virtual networks

About Secure Cross-Premises Connectivity
http://msdn.microsoft.com/en-us/library/azure/dn133798.aspx
About VPN Devices for Virtual Network
http://msdn.microsoft.com/en-us/library/azure/jj156075.aspx
Configure a Multi-Site VPN
http://msdn.microsoft.com/en-us/library/azure/dn690124.aspx
Configure a VNet to VNet Configuration
http://msdn.microsoft.com/library/azure/dn690122.aspx

 

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

Softvative Microsoft Office365 Applications Brainstorming Plan

Sunday, November 16th, 2014

Office 365 Applications Brainstorming Plan

Version: 1.1

Microsoft Office 365 has lots of applications based on the plan you choose. To make it easy to plan and understand, Softvative created a brainstorming plan. the initial version if focused on external user interactions with corporate users.

Soon that plan will be offered as a full version download for registered users. The full version will be a MS Visio based version covering Visio plan, clickable links to important articles, comments on key areas and expanded plan with more details.

Review the current version of the Office 365 brainstorming plan that includes key Microsoft Online apps including:

  • Office 365
  • SharePoint Online
  • Project Online
  • Yammer
  • OneDrive for Business
  • Skype for Business (Lync)
  • Exchange Online
  • CRM Online
  • Power BI

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

SharePoint Excel Data Refresh Common Issues

Monday, November 3rd, 2014

SharePoint Excel Data Refresh – Common Issues

Version: 1.0

SharePoint Excel Services requires different bits and pieces to work correctly in order for it to deliver your BI Reports correctly. There are times when you have to review and update the configurations in order to make it work.

I’ll cover some of my experiences related to issues and fixes in working with the SharePoint Excel Services in this publication.

Common SharePoint Excel Services Issues

Following are the few common issues that can happen with SharePoint Excel Services and the resolution of those issues.

a. Unable to refresh data for a data connection in the workbook. … The following connections failed to refresh

a. Unable to refresh data for a data connection in the workbook. … The following connections failed to refresh

I created a nice report in Microsoft Excel using the SSAS (SQL Server Analysis Services) as the data source. I was able to refresh the data connection within MS Excel file to pull the latest data or apply filters to get the data I wanted. No issue so far and every thing looks great.

MS Excel Report with SSAS Data Connection - Data Refresh Option
MS Excel Report with SSAS Data Connection – Data Refresh Working

I uploaded my report to a Business Intelligence (BI) Center site on SharePoint. I launched the report using Excel Web Services and I was able to see the data. I got the following error when I tried to do the Data connection refresh in an attempt to pull the latest data from SSAS data source.

Error:
Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh:
SSASserverName – InstanceName SSAS database ProjectDW TimeReport

SharePoint Excel Service Excel Report with SSAS Data Connection - Data Refresh Error
SharePoint Excel Service Excel Report with SSAS Data Connection – Data Refresh Error

More precisely, here is the what the screen looked like. Also I couldn’t apply the filters and my nice report turned out to be ‘acting not so nicely’.

SharePoint Excel Service Excel Report with SSAS Data Connection - Data Refresh Error Fullpage
SharePoint Excel Service Excel Report with SSAS Data Connection – Data Refresh Error Fullpage

Issue Cause

I started the SharePoint Log Viewer on the server and then launched my Excel report again in Excel Web services to reproduce the error. Paused the live monitoring of the ULS logs and started reviewing the log information. I found the line item in the log pertaining to data refresh issue.

Area: Excel Services Application
Category: External Data
Event ID: 2052
Level: Information

Highlighting the log entry revealed the message detail about it.

The workbook ‘http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx’ attempted to access external data using the unsupported provider ‘Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=SSAS Project Control;Data Source=SSASServerNameInstanceName;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error’. [Session: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N User: 0#.w|domainfmasood]

SharePoint LogViewer - Excel Data Refresh error with SSAS Cube - Unsupported Data Provider Used
SharePoint LogViewer – Excel Data Refresh error with SSAS Cube – Unsupported Data Provider Used

Though, above information is sufficient clue to go about fixing the issue, I’m putting few more log entries that were logged for the same session.

Few ULS Log Entries:

1. 
ExternalSource.GetExternalKeyAndStateAndMarkUsed: Populating the session’s credentials for external data. Index=0, Credentials=[8126098, domainfmasood]

2. 
ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx, Version=Thursday, 23 October 2014 19:19:17

3.
The workbook ‘http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx’ attempted to access external data using the unsupported provider ‘Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=SSAS Project Control;Data Source=SSASServerNameInstanceName;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error’. [Session: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N User: 0#.w|domainfmasood]

4. 
Refresh failed for ‘SSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports’ in the workbook ‘http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx’. [Session: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N User: 0#.w|domainfmasood]

5.
ExternalSource.ValidateConnection: Unable to get a connection: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown.     at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.ValidateConnectionInfo(ConnectionRequest connectionRequest, ConnectionInfo connectionInfo)     at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.GetConnection(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Int64 privateConnectionId, Boolean auditConnection)     at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.TryGetValidatedConnection(Request request, Credentials credentials, Extended…

6.
…ConnectionInfo extendedConnectionInfo, Boolean shouldReportFailure, Boolean auditConnection, Connection& connectionOut). sessionId=1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N, externalSource=SSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports

7.
ConnectionInfoManager.InitConnInfoFromOdcFile: ODC File Uri is local: C:UsersfmasoodDocumentsMy Data SourcesSSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports.odc

8.
ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException’ was thrown.     at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure)     at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe…

9.
…ration, Boolean verifyPreOperationConnection), Data Connection Name: SSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports, SessionId: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N, UserId: 0#.w|domainfmasood

10.
ExcelService.PostProcessRequest: finished request of type RefreshAll

Issue Resolution

I went to SharePoint Central Administration site and reviewed the Trusted Data Providers under Excel Services. The location of the configuration is Central Admin home > Application Management > Manage Service Applications > Click on your Excel Service Application > Trusted Data Providers.

In SharePoint 2010, MSOLAP.5 data provider is not present default. See the screenshot below.

SharePoint Excel Services - Trusted Data Provider - MSOLAP.5 not present by default
SharePoint Excel Services – Trusted Data Provider – MSOLAP.5 not present by default

Click on Add Trusted Data Provider link on top left and configure the MSOLAP.5 data provider.

SharePoint Excel Services - Trusted Data Provider - Configure MSOLAP.5 Data Provider
SharePoint Excel Services – Trusted Data Provider – Configure MSOLAP.5 Data Provider

Once added, you should see the MSOLAP.5 data provider in the list.

SharePoint Excel Services - Trusted Data Provider - MSOLAP.5 Data Provider Added
SharePoint Excel Services – Trusted Data Provider – MSOLAP.5 Data Provider Added

Once I had the MSOLAP.5 added as the Trusted Data Provider, in excel services, refresh all data connection feature started working. At that point I was also able to use filters in my report without any errors.

My SharePoint BI report lived happily ever after.

References:
1. Primer on SharePoint Excel Data Refresh Settings
2. SQL Server Version Numbers
3. Excel Services Data Refresh Flowchart – Review the screenshot titled E and section E in the table at bottom right for information related to this issue.
4. Add MSOLAP.5 as a Trusted Data Provider in Excel Services
5. How to: Install the Analysis Services OLE DB Provider on an Excel Services Computer

Keywords:

  • Fix Excel Data Refresh Issue
  • Fix Excel Data Refresh error
  • Fix Excel Data Refresh connection failure
  • Excel Data Refresh Issue
  • Excel Data Refresh connection failure
  • Data refresh issue due to MSOLAP.5
  • Missing Data Provider MSOLAP.5
  • Adding a new Trusted Data Provider
  • Trusted Data Provider in Excel Services
  • Trusted Data Provider in SharePoint Excel Services
  • Unable to Refresh SSAS Data from Excel
  • Event ID 2052
  • External Data Connection Failure
  • External Data Refresh Failure
  • SharePoint BI Report Refresh Issue
  • SharePoint BI Report data Refresh Issue
  • How to fix Excel Data Connection issue
  • How to fix Excel Data refresh issue
  • How to fix Excel Data Connection refresh issue
  • Get the real time data in Excel Services

SQL Server Version Numbers

Monday, November 3rd, 2014

SQL Server Version Numbers

Version 1.0

Review the list containing Microsoft SQL Server version numbers by editions for each service pack. The list shows versions starting from SQL Server 7.0 to SQL Server 2014.

SQL Server Version Number List