Posts

Showing posts from February, 2016

Internal server error exception when users perform a search in SharePoint

Symptoms When users perform a search in a Microsoft SharePoint environment, they receive the following error message: Internal server error exception: Troubleshoot issues with Microsoft SharePoint Foundation Additionally, the following critical exception may be written to the ULS log of the SharePoint Web front-end server:  Process : OWSTIMER.EXE (0x1CE0) Product : SharePoint Foundation Category : Topology EvendID : 8031 Message : An exception occurred while updating addresses for connected app {eaf6c00c-cc3f-460e-8bf2-ad9b991ea6ea_aa16845d-045a-46bc-bbc6-d701ff13950d}. 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

Configure a Windows Firewall for Database Engine Access SQL Server Port

This topic describes how to configure a Windows firewall for Database Engine access in SQL Server 2016 by using SQL Server Configuration Manager. Firewall systems help prevent unauthorized access to computer resources. To access an instance of the SQL Server Database Engine through a firewall, you must configure the firewall on the computer running SQL Server to allow access. For more information about the default Windows firewall settings, and a description of the TCP ports that affect the Database Engine, Analysis Services, Reporting Services, and Integration Services, see  Configure the Windows Firewall to Allow SQL Server Access . There are many firewall systems available. For information specific to your system, see the firewall documentation. The principal steps to allow access are: Configure the Database Engine to use a specific TCP/IP port. The default instance of the Database Engine uses port 1433, but that can be changed. The port used by the Database Engine is liste

Failed to get the server time zone id. Exception: Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application

Error : Failed to get the server time zone id. Exception: Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application.  When I check the View Web Analytics Reports from Central Admin on Production, it throws the above error though it works on Test environment. To resolve this, I have performed the following steps by looking at the ULS Logs. Navigate to  Central Administration   System Settings  and click on  Manage Services on Server Stopped  the following two services though it was already started Web Analytics Data Processing Service Web Analytics Web Service Started  the above two services but when I check View Web Analytics Report, doesn’t seem to work. On Further checks found the  Manage Metadata Service App  wasn’t able to retrieve the metadata Stopped and Started  the  Managed Metadata Web Service This resolved the issue for me now able to view the Web Analytics Reports from Central Admin If it doesn’t

Managed Metadata in SharePoint 2013

Image
To prevent Enterprise keyword fields from offering suggestions from a team set then unckeck this setting  Office 2010/2013 can integrate with Managed Metadata site column If you want to use Content type hubs then you need to activate this site collection feature :Content Type Hub Syndication feature.

Sorry,we can't open this document because there was a problem talking to the service - Office Web Apps 2013

Image
Farm Information: Web Application published internally and externally (so make sure both URLs added to  Alternate Access Mapping ) Office Web Apps 2013 (Published externally via  TMG 2010  and internally) I have a farm which connected to Office Web Apps 2013 and It's working fine internally so then we decided to enable it to open Office Web Apps externally by the following steps : 1- In Office Web Apps Server , Open Power Shell and run this command to add the External URL to existing Farm: Set-OfficeWebAppsFarm -ExternalURL  http://test.com/  2-In SharePoint Server , Open SharePoint 2013 Management Shell and run the following commands:  Remove-SPWOPIBinding –All:$true New-SPWOPIBinding -ServerName OfficeWebAppServer.com -AllowHTTP Set-SPWopiZone internal-http $c = Get-SPSecurityTokenServiceConfig $c.AllowOAuthOverHttp = $true $c.Update()  then when I tried to access the Office documents from External URL I got the following error : "Sorry,we can't o

New WCM Features in SharePoint 2013

Image Renditions Good Ref : http://blog.mastykarz.nl/image-renditions-sharepoint-2013/ http://msdn.microsoft.com/en-us/library/jj720398.aspx http://msdn.microsoft.com/en-us/library/jj720392.aspx http://sp2013.blogspot.com/2012/07/image-renditions.html Required to enable Blob Cache IFrame Support Good Ref : http://www.learningsharepoint.com/2012/11/24/how-to-use-iframes-in-sharepoint-2013/ SEO ,Friendly URLs and SiteMap Good Ref : http://blog.mastykarz.nl/search-engine-optimization-sharepoint-2013/ http://www.informedconsulting.nl/blog/?p=283 Managed Navigation Good Ref : http://blog.robgarrett.com/2012/09/23/sharepoint-2013-managed-navigation / Cross Site Publishing Good Ref : http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=1038 http://blogs.msdn.com/b/justinvoels/archive/2012/09/24/sharepoint-2013-search-driven-publishing-and-cross_2d00_site-collection-publishing-overview.aspx http://blog.mastykarz.nl/easier-working-assets-cross-si

This SQLServer instance does not have the required "max degree of parallelism" setting of 1

Image
I have got this error while trying to install SharePoint 2013 What is Max Degree of Parallelism ? When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the  max degree of parallelism  option to limit the number of processors to use in parallel plan execution. SQL Server considers parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population. Read this for more details http://technet.microsoft.com/en-us/library/ms189094.aspx How to fix it ? Open Microsoft SQL Server Management Studio Login with sysadmin user Right Click on instance name and select properties >> Advanced Change  Max Degree of Parallelism  to 1 Restart the SQL Service

Integrating ServiceNow with SharePoint 2013

Image
It goes without saying that every part of an enterprise relies on technology. With more and more technology providers coming to the fore, it is not uncommon to find a variety of technology platforms across the units of an enterprise. To keep the pieces of the enterprise moving together there is often a need for integrating the platforms, which are built by different providers. This blog provides a brief overview of ServiceNow, and what is involved in integrating ServiceNow and SharePoint 2013. What is ServiceNow? ServiceNow is a software platform that supports IT Service Management and automates common business processes. It’s a software as a service (SaaS) platform that offers targeted solutions for various units of an enterprise like IT, HR, Operations and IT Business Management. More than two thousand enterprises around the world use the ServiceNow platform extensively for their daily operations. ServiceNow brings the following key benefits for an enterprise: • Improves service

Access Denied Error after migrating to SharePoint 2013

Image
Scenario : We were working for a client, they had many groups and we had to build a collaboration portal for all the groups. Key thing was few sites of some groups were already present in SharePoint 2010 in different standalone servers. Migration was a key thing here as the existing sites has huge data, and huge user base. The Requirement was to build a portal /web application which will have migrated sites and new set of sites as per agreed site structure. According to the agreed architecture and design we created a new web application and started building the site hierarchy. As part of this we followed the regular approach database detach –attach method and migrated the existing SharePoint 2010 site .Migration was successful and we were able to access the site  with the system account. Later we tried with couple of site admin accounts, to our surprise we were getting “ACCESS DENIED” with any other user id. Background: By default when we create a web application in SharePo