Archive for the ‘SharePoint’ Category

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

SharePoint Document Conversion Services

Wednesday, October 29th, 2014

SharePoint Document Conversion Services

Version: 1.0

Applies to:

  • SharePoint 2010
  • SharePoint 2013
  • SharePoint Office 365

Overview of Document Conversion Services

SharePoint has Document Conversion Service that allows to convert files like Microsoft Word .docx into SharePoint webpages.

Office Web Apps (web version of Office) that works in SharePoint and allows users to view Office files even if they don’t have MS Office installed on their PC. In the absence of Office Web Apps (OWA), SharePoint Document Conversion Service will be handy to view the MS Office files.

Document Conversion services are not enabled by default. There are two services for Document Conversion.

1. Document Conversion Launcher Service
2. Document Conversion Load Balancer Service

Configuring Document Conversion Services

To enable the document conversion, you have to first configure its Load Balancer Service and then the Launcher service.

a. Configure Document Conversion Load Balancer service on SharePoint Application Server (Central Admin > Services on Server: ApplicationServer)

b. Configure Document Conversion Launcher Service on SharePoint Application Server (Central Admin > Services on Server: ApplicationServer)

c. Configure the Document Conversions (Central Admin > General Application Settings > Configure Document Conversions)

Issues in Configuring Document Conversion Services

Some times you get into issue during initial configuration of Document Conversion service or even later during operations where these services fail to start.

Error Starting Document Conversion Services

You go to SharePoint Central Administration site > System Settings > Manage Servers in this Farm > Click on an application server name (not SharePoint Web Front End). That will bring you to the Services on Server: ServerName page. In one of my scenario, I tried to start the Document Conversion Load Balancer service and got Error Starting status. I tried different ways but couldn’t start the service.

SharePoint Document Conversion Launcher Service - Error Starting status
SharePoint Document Conversion Launcher Service – Error Starting status

I went into Event Viewer logs first on the SharePoint application server and found following errors.

Event Viewer Error 1

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          10/28/2014 3:12:46 PM
Event ID:      7034
Task Category: Topology
Level:         Critical
Keywords:      
User:          softvativeSPFarmServiceAccount
Computer:      SharePointAppSrv.softvative.com
Description:
An attempt to start/stop instance  of service Document Conversions Load Balancer Service on server 

SharePointAppSrv did not succeed.  Re-run the action via UI or command line on the specified server. 

Additional information is below.

Operation is not valid due to the current state of the object.
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>7034</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>13</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-10-28T20:12:46.879677800Z” />
    <EventRecordID>858925</EventRecordID>
    <Correlation ActivityID=”{4A13B121-2470-406B-ADCB-2A97903E8D0D}” />
    <Execution ProcessID=”19412″ ThreadID=”788″ />
    <Channel>Application</Channel>
    <Computer>SharePointAppSrv.softvative.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>
    </Data>
    <Data Name=”string1″>Document Conversions Load Balancer Service</Data>
    <Data Name=”string2″>SharePointAppSrv</Data>
    <Data Name=”string3″>Operation is not valid due to the current state of the object.</Data>
  </EventData>
</Event>

SharePoint Document Conversion Error - Event ID 7034
SharePoint Document Conversion Error – Event ID 7034

Event Viewer Error 2

Log Name:      Application
Source:        Microsoft-SharePoint Products-Document Management Server
Date:          10/28/2014 3:12:11 PM
Event ID:      7953
Task Category: Document Conversions
Level:         Critical
Keywords:      
User:          softvativeSPFarmServiceAccount
Computer:      SharePointAppSrv.softvative.com
Description:
The Office HTML Load Balancing Service experienced a problem.

Error:  Not launching Document Conversions Laod Balancer because registry key acknowledging service 

running on app server (‘AcknowledgedRunningOnAppServer’) is not set.
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-Document Management Server” Guid=”{F78D66EC-09A9-

42A2-AC7A-5EE2062DE7E4}” />
    <EventID>7953</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>8</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-10-28T20:12:11.098100000Z” />
    <EventRecordID>858923</EventRecordID>
    <Correlation />
    <Execution ProcessID=”10552″ ThreadID=”16556″ />
    <Channel>Application</Channel>
    <Computer>SharePointAppSrv.softvative.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>Not launching Document Conversions Laod Balancer because registry key 

acknowledging service running on app server (‘AcknowledgedRunningOnAppServer’) is not set.</Data>
  </EventData>
</Event>

SharePoint Document Conversion Error - Event ID 7953
SharePoint Document Conversion Error – Event ID 7953

Event Viewer Error 3

Log Name:      Application
Source:        Microsoft-SharePoint Products-Document Management Server
Date:          10/28/2014 3:12:11 PM
Event ID:      7960
Task Category: Document Conversions
Level:         Critical
Keywords:      
User:          softvativeSPFarmServiceAccount
Computer:      SharePointAppSrv.softvative.com
Description:
The Office HTML Load Balancing Service could not be started.

Error:  Not launching Document Conversions Laod Balancer because registry key acknowledging service 

running on app server (‘AcknowledgedRunningOnAppServer’) is not set.
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-Document Management Server” Guid=”{F78D66EC-09A9-

42A2-AC7A-5EE2062DE7E4}” />
    <EventID>7960</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>8</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-10-28T20:12:11.095099700Z” />
    <EventRecordID>858922</EventRecordID>
    <Correlation />
    <Execution ProcessID=”10552″ ThreadID=”16556″ />
    <Channel>Application</Channel>
    <Computer>SharePointAppSrv.softvative.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data Name=”string0″>Not launching Document Conversions Laod Balancer because registry key 

acknowledging service running on app server (‘AcknowledgedRunningOnAppServer’) is not set.</Data>
  </EventData>
</Event>

SharePoint Document Conversion Error - Event ID 7960
SharePoint Document Conversion Error – Event ID 7960

Services in Console

In one of my scenario, I went into Windows Services console to review the Document Conversion services. Both the services were not running. Don’t try to start the services from Windows Service console.

SharePoint Document Conversion Services in Windows Services Console
SharePoint Document Conversion Services in Windows Services Console

Root Cause

It turns out there are registry keys that were needed to acknowledge that you configured the services to run on the application server.

Registry Location:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice ServerversionLauncherSettings
HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice ServerversionLoadBalancerSettings

Replace version based on SharePoint version:
SharePoint 2007 -> 12.0
SharePoint 2010 -> 14.0
SharePoint 2013 -> 15.0

You need to add the new key AcknowledgedRunningOnAppServer of type dword and set it to 1. That will let you start the Document Conversion services from Central Admin site.

SharePoint Document Conversion Launcher Settings - AcknowledgedRunningOnAppServer Key
SharePoint Document Conversion Launcher Settings – AcknowledgedRunningOnAppServer Key

SharePoint Document Conversion Load Balancer Settings - AcknowledgedRunningOnAppServer Key
SharePoint Document Conversion Load Balancer Settings – AcknowledgedRunningOnAppServer Key

My Registry Script

I created the AcknowledgedRunningOnAppServer registry entries as a registry file for easy import on new servers in future.

Download the Document Conversion Registry Fix files (.reg or .zip)

Download the .reg file or .zip file and extract the zip file contents to a folder. Locate the DocumentConversion_RegSettingKB2910363.reg file and double click on it. Click Yes to the message box.

Add the Document Conversion Registry Keys to SharePoint Application Server Registry
Add the Document Conversion Registry Keys to SharePoint Application Server Registry

Click OK to the successful message box.

Added Document Conversion Registry Keys to SharePoint Application Server Registry
Added Document Conversion Registry Keys to SharePoint Application Server Registry

After adding the registry entries, try to start the Document Conversion Load Balancer Service from the Central Admin site > Services on Server page. Click on Start under action column to start the Load Balancer service.

SharePoint Document Conversion Load Balancer Service Started
SharePoint Document Conversion Load Balancer Service Started

Now click on Start under action column for the Document Conversion Launcher Service. That will brig the Launcher Service Settings page. Select the same server from Load Balancer dropdown field and click OK.

SharePoint Document Conversion Launcher Service Settings
SharePoint Document Conversion Launcher Service Settings

You should now see the two Document Conversion services with the status of started.

SharePoint Document Conversion Services with Started Status
SharePoint Document Conversion Services with Started Status

Let take a peak at the Windows Service console for these services.

SharePoint Document Conversion Services -Started in Services Console
SharePoint Document Conversion Services -Started in Services Console

Configure Document Conversions

Once the Document Conversion services are running, its time to configure it. You go to Central Admin site > General Application Settings > Configure Document Conversions to configure the conversions.

SharePoint - Configure Document Conversions link
SharePoint – Configure Document Conversions link

On Configure Document Conversions page, you select the web application, enable document conversion, select a load balancer, schedule conversion and set converter settings. Click Apply. Once you are done with changes, then click OK.

SharePoint - Configure Document Conversions Settings
SharePoint – Configure Document Conversions Settings

Under Converter Settings, click on one of the link for the installed converters to review and adjust settings.

SharePoint Document Converter - From Word Document to Web Page Converter Settings
SharePoint Document Converter – From Word Document to Web Page Converter Settings

I’ll demonstrate more including some the limitations on Document Conversion in next version of the this article. Hop over to this page later to review the updated version.

References

  1. Configure Document Conversions Load Balancer and Launcher Services
  2. Document conversion load balancer unavailable
  3. Configure the Document Conversions Load Balancer Service
  4. Manage document conversions
  5. Some document-conversion services in SharePoint Server are not secure when they run in a particular environment

Recover Symantec Protection Engine Lost Password

Wednesday, October 15th, 2014

Recover Symantec Protection Engine Lost Password

Version: 1.2

Symantec Protection for SharePoint Servers (SPSS) is an antivirus solution for SharePoint. SPSS uses Symantec Protection Engine (SPE) as the underlining solution to provide the security framework to SPSS.

On each SharePoint Server running SPSS, usually you also have Symantec Protection Engine (SPE) there as well running under https://localhost:8004. SPE portal is usually password protected.

I came across a scenario where the password for the Symantec Protection Engine (SPE) portal was lost. We were using the right password but somehow SPE was not accepting it. On top of that the Symantec license was about to expire in few days. It was a race against the time!

Error Message

Login failed or Symantec Protection Engine server is not running.

SPE and SPSS services in Windows services console were running.

Symantec Protection Engine Portal Password Failure
Symantec Protection Engine Portal Password Failure

Method 1

I looked at the Symantec Protection for SharePoint Servers implementation guide and under chapter-7 found the section titled ‘Unable to remember the console password’. That is the one method to recover lost password for Symantec Protection Engine (SPE). It didn’t work in my case.

If you forget the console password, you can reset the password. The command line tool CmdSymScan lets you remove the password. It is located at the location
<installdir>:Program FilesSymantecSharePoint.

Type the following command in the command prompt:
cmdsymscan clearconsolepassword

You are not prompted for a password again.

Time was ticking….

Method 2

I went to the Symantec Scan Engine folder location and opened the configuration.xml file.
C:Program Files (x86)SymantecScan Engine

I then searched for the password parameter. Guess what, I found the encrypted password there. I cleared the value and saved the file. The password parameter should look like this.

<password value=””/>

After that I restarted the Symantec Protection Engine (SPE) services under Windows Services console.

Symantec Protection for SharePoint - Windows Services
Symantec Protection for SharePoint – Windows Services 

I closed and relaunched the Symantec Protection Engine (SPE) portal and I was able to successfully log in without the password. From there, I saved the new password, updated the license file and SPSS time clock stopped ticking.

Symantec Antivirus for SharePoint Blocked Linked Excel Files

Wednesday, October 8th, 2014

Symantec Protection for SharePoint Blocked Linked Excel Files

Issue Summary

Symantec Protection for SharePoint Servers (SPSS) 6.0 was deployed in the SharePoint farm. After deployment, certain files are getting blocked by it even though Symantec Antivirus on desktop had cleared those as clean files.

In one of my previous post Linked Excel Files and SharePoint, I covered the details on how linked files work in SharePoint.

Error:

2 – The file: FileNameByFM.xlsx -contains Unscannable Content. Reason: Container Size Violation | Container Size Violation -Status: Blocked

This file cannot be saved to the document library. If you want to save this file to the document library, clean the file using alternative virus scanning software and try saving it again.

Troubleshoot issues with Microsoft SharePoint Foundation.

File can not be uploaded to SharePoint dueto Symantec Antivirus for SharePoint SPSS
File can not be uploaded to SharePoint dueto Symantec Antivirus for SharePoint SPSS

If you are trying to upload a new file, the file is not uploaded. If you are trying to save after edit / checking out, file, it doesn’t work either.

Cause:

The issue is due to the linked MS Excel files that were on user desktop. Only container file was uploaded to the SharePoint. The file was 25 MB in size.

How to find linked files in MS Excel

Follow the steps listed below to find the linked files:
1. Open the Microsoft Excel file from SharePoint
2. Go to Data ribbon tab and then click Edit Links under Connections group
3. Review the linked file(s) for Location. Update / remove as it applies to your container file
4. Save and close the file

Microsoft Excel - Edit Linked Files
Microsoft Excel – Edit Linked Files

You might have to do these step by downloading a copy of that file on your desktop and then make above changes.

Microsoft Excel - Edit Linked Files - Review Location
Microsoft Excel – Edit Linked Files – Review Location

Resolution:

Even removing the linked file didn’t help in this case. The linked file was unnecessary in this scenario. Symantec Protection for SharePoint was still treating that file as a container file. Make sure you review the data in container Excel file that might be coming from the linked file.

I found that Symantec Protection Engine portal on the SharePoint server (http://localhost:8004) has a default filter policy for container handling. Symantec Protection Engine is a separate component of Symantec Protection for SharePoint Servers.

Container File Processing Limits:
Following filter policies were defined by default.

Stop processing a container file when any of the following limits is met or exceeded.
a. Time to extract file meets or exceeds: 180 seconds
b. Maximum extract size of the file meets or exceeds: 100 MB
c. Maximum extract depth of the file meets or exceeds: 10 levels

When processor limit is met or exceeded: Deny access to the file and generate a log entry.

Symantec Protection for SharePoint Servers - Filtering Policies on Container Handling
Symantec Protection for SharePoint Servers – Filtering Policies on Container Handling

I changed the container file  policy to: Allow access to the file and generate a log entry.

That seemed to resolve the issue.

Risk Assessment:

In this scenario, due to internal only SharePoint, the decision was made to allow access to files in case of container file processing limits are reached or exceeded. The decision was in favor of application availability rather strict security.

Keywords:

  • Symantec Antivirus for SharePoint
  • Symantec Protection for SharePoint
  • Symantec Protection for SharePoint blocks file
  • Symantec Protection for SharePoint does not allow file upload
  • Symantec Protection blocks file upload in SharePoint
  • File upload blocked by Symantec antivirus
  • File upload blocked in SharePoint
  • Unscannable Contents in SharePoint
  • Container Size violation in SharePoint
  • SharePoint File upload blocked by antivirus

Primer on SharePoint Hosting for External Collaboration

Wednesday, September 24th, 2014

Primer on SharePoint Hosting for External Collaboration

V: 1.0

Scope:

The scope of this document covers the On-Premises SharePoint and using it for your external partners, vendors and customers in compliance scenarios or public organization where they decide to keep the data internal only rather than on the cloud. This topic doesn’t cover the hybrid approaches either.

It does not imply that the Office 365, Azure or other recent cloud services are short of features. These services offer so much robust features, time & cost savings and other benefits that can be beneficial to any organization. [Review my blog post and presentation on the comparison of On-Premises, Office 365 and Hybrid]

This document can be used as a case study to persuade the company management to cloud based solutions. On-Premises SharePoint deployment, operation, management and support may require a wide knowledge of different technologies, processes and best practices [Review my article on SharePoint Brainstorming Plan]. You need more breadth of skills versus depth of skills in most if not all situations.

Pieces of the SharePoint Puzzle:

In order to do the SharePoint hosting for external collaboration, you need to know different elements. Following are some of the skills, knowledge and experience that are needed to host the On-Premises SharePoint for external collaboration.

  1. IIS Web Server
  2. SQL Server Database
  3. Windows Servers
  4. Firewall – CISCO ASA or others
  5. Authentication – Active Directory
  6. Claims / FBA (Riolinx Extradium)
  7. IP Addressing
  8. DNS – Internal
  9. DNS – External (Zone Edit or others)
  10. Wildcard SSL certificates with SAN (DigiCert or others)
  11. URL address name space and A records
  12. SharePoint ins and outs
  13. WebApp, Site collections, sites
  14. Office Web Apps
  15. .NET

Not knowing all these pieces, will require additional skills in the company. Below is our pieces of puzzle pyramid diagram.

Softvative Plan - SharePoint Pieces of Puzzle Pyramid
Softvative Plan – SharePoint Pieces of Puzzle Pyramid

One important thing, this is just a framework we created and have been using. In different scenarios, customer needs and integration requirements, you might have little more in the plate.

Plan your SharePoint Pieces:

Once you know what pieces are involved, then you have architect the plan on how you will be connecting the pieces. I use white boarding and Microsoft Visio for that purpose. Below is the abstract of one of the implementation  we worked on.

Sharepoint Hosting for External Collaboration - Architecture Planning on white board
Sharepoint Hosting for External Collaboration – Architecture Planning on white board

After this stage, you move on to the next stage of the project planning and execution. I’ll cover more on this topic in future versions.