Joy's Blog Learning never stops…!!!

31Aug/150

Article – Fix it – SharePoint 2013 User Profile Synchronization Service cannot be started with SQL Server 2014

Posted by Joy

I wrote an article on configuring User Profile Service for SharePoint 2010 and I have been using/ following the same steps for so many implementations up until last week.

For those who have not read it before – http://www.sharepoint24x7.com/2011/01/09/configuring-user-profile-services-in-sharepoint-server-2010/

However, I installed a new environment for one of our client last week and tried to start the User Profile Synchronization Service using Manage services on server page in Central Administration web site and it did not work.

Problem:

When I click Start link to start the User Profile Synchronization Service, it stays in “Starting” state for some time (actually little longer) and then goes back to “Stopped” state. Sad smile Sad smile

Troubleshooting steps:

I executed all the following troubleshooting tasks and made sure that I tried all the possible solutions based on my experience and others experience:

  • Adding Farm service account in to the Administrators group
  • Deleting User Profile Services service application and recreating it
  • Verify the password of Farm service account
  • Clearing SharePoint Configuration Cache
  • Changing the Log On As account for Forefront Identity Manager Service and Forefront Identity Manager Synchronization Service
  • Etc…

I did all these but no luck Sad smile Sad smile Sad smile

Hhhmmmmm Thinking smile Thinking smile Thinking smile

I started investigating further and noticed following:

  • I managed to successfully start/ configure User Profile Synchronization Service on 03 VMs with Windows Server 2012 R2, SharePoint Server 2013 with Service Pack 1 and SQL Server 2012 R2
  • I failed to start/ configure User Profile Synchronization Service in 03 VMs with Windows Server 2012 R2, SharePoint Server 2013 with Service Pack 1 and SQL Server 2014
Solution:

I downloaded and applied June 2015 Cumulative Update for SharePoint Server 2013.

Woooohhhhooooo…!!!! It worked…!!! Smile Smile Smile

Conclusion

Based on my investigation, I believe that SQL Server 2014 is the culprit and applying June 2015 CU resolved the issue.

25Aug/150

Announcements – SharePoint Server 2016 IT Preview

Posted by Joy

I have been trying the new SharePoint Server 2016 bits for few months through the TAP programs and now time has come to talk about in public.

Microsoft released SharePoint Server 2016 preview build 16.0.4316.1217 on 10th August for TAP participants and now the same build has been released to public.

It’s pointless recreating the same blog and visit Bill Baer’s post about to get more information on the SharePoint Server 2016 IT Preview.

Announcing availability of SharePoint Server 2016 IT Preview and cloud hybrid search - https://blogs.office.com/2015/08/24/announcing-availability-of-sharepoint-server-2016-it-preview-and-cloud-hybrid-search/

SharePoint Server 2016 IT Preview Reviewer Guide - http://www.microsoft.com/en-us/download/details.aspx?id=48713

Download SharePoint Server 2016 IT Preview - http://www.microsoft.com/en-us/download/details.aspx?id=48712

This preview meant and focuses on infrastructure new features and enhancements and I believe that’s why they call is as IT Preview.

16Jul/150

Sri Lanka SharePoint Forum – July, 2015

Posted by Joy

Yesterday we had our July monthly user group gathering for Sri Lanka SharePoint User Group. We had 02 sessions – Business Continuity and Office 365 API.

Dinusha delivered a session on Office 365 API.

I delivered a session on implementing a business continuity for SharePoint and I covered topics such as monitoring SharePoint using Health Analyzer, Diagnosing logging, Usage and health data collection, implementing high availability using distributing servers and services using SharePoint WFEs, Application services servers, network load balancing, database mirroring, backup SharePoint and SQL Server databases and scheduling using Windows Task Scheduler.

7Jul/150

Industrial Training – University of Moratuwa

Posted by Joy

Industrial training for year 2015/ 2016 is just about to begin. University of Moratuwa organized a series of sessions (“Pitch Your Company”) for various registered companies to present their industrial training offerings to all the students.

We presented today our industrial training offerings and opportunities available at Totalamber and we were the only to showcase capabilities of SharePoint and Microsoft Dynamics platforms and who offered opportunities to them in SharePoint and Dynamics as a career path.

Presenting at University of Moratuwa

2Jul/150

Article – Tips and Tricks – reducing the SharePoint Config Log file

Posted by Joy

Today we came across with a situation where we keep getting a runtime error when we try to perform our normal day-today operations in our SharePoint 2013 based solution. It started throwing a runtime error with a error code - HRESULT: 0x80131904 and it failed to save data into the SharePoint database.

The reason was the SharePoint Configuration database LOG file has grown to 91 GB and there was not enough free space in the physical disk. Because of this, SharePoint was unable to commit database changes and there was a huge performance impact. The solution we found was:

  1. Change the recovery model for the Database from Full to Simple
  2. Shrink the database

I executed the following SQL command and it brought the database log file from 91GB to 1 MB which solved my issues.

USE [master]
Go

ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT
Go

USE [SharePoint_Config]
Go

DBCC SHRINKFILE ('SharePoint_Config_Log')
Go

18Jun/150

Announcements – Totalamber launches Nintex in Sri Lanka

Posted by Joy

Organized by Totalamber, in association with Nintex and Microsoft, Sri Lanka, the Launch of ‘Nintex’ in Sri Lanka took place at the Galle Face Hotel, Colombo on 4th June, 2015.

The keynote presentation was given by Mr. Kok Koon Gan, Technical Evangelist for Nintex, with Mr. Imran Vilcassim, Country Manager of Microsoft Sri Lanka, as a guest speaker. Invitees for the event included CIOs, IT Managers and decision makers from leading blue chip companies, financial organizations and other recognized companies in the island.

I delivered a session – “Bringing Experiences together”, highlighting the availability of new developments and capabilities including Cloud-Inspired Experiences, in the upcoming release of SharePoint – SharePoint 2016 as well as Office 365. It is expected for Nintex to benefit extensively by leveraging on the new cloud and on premise features.

Nintex Launch

Keynote

Nintex demos

WebQuarters and SharePoint

Totalamber team

12Mar/150

Sri Lanka SharePoint Forum – March, 2015

Posted by Joy

Yesterday we had our March monthly user group gathering for Sri Lanka SharePoint User Group. We had 02 sessions lined up – Search and Branding.

Malin delivered a session around Branding and Design Manager capabilities. I delivered a session around SharePoint Search which covered configuring multiple content sources, result sources, query rules, etc…

16Jan/150

Article – Tiles (Metro UI) Navigation web part in SharePoint 2013

Posted by Joy

Did you know that we can implement Metro UI in SharePoint 2013? It can be implemented very easily with out-of-the-box features in SharePoint 2013.

Learn how to implement Tiles navigation in SharePoint 2013:

http://www.sharepoint24x7.com/2015/01/20/article-tiles-metro-ui-navigation-web-part-in-sharepoint-2013/

30Dec/140

Article – Tips and Tricks – navigating through SharePoint ULS logs using PowerShell

Posted by Joy

Learn how to navigate through SharePoint ULS logs using PowerShell.

http://www.sharepoint24x7.com/2014/12/30/tips-n-tricks-navigating-through-sharepoint-uls-logs-using-powershell/

28Nov/140

Southeast Asia SharePoint Conference, 2014 – Singapore

Posted by Joy

I was very fortunate to take part in the 4th episode of Southeast Asia SharePoint Conference held on 25th and 26th November, 2014 in Singapore.

I was fortunate to deliver the one and only session on SharePoint Search and there was a very good no of attendees even if it was the very first session on the 2nd day. I demonstrated lot of new features of SharePoint 2013 Search including Result Sources, Query Rules, KQL, etc…

It was my pleasure being part of this great event and I am happy a lot since there were 02 other speakers from Sri Lanka.

Myself at SharePoint Conference, Singapore

My session

My demos