Wednesday, November 26, 2014

“Could not find Stored Procedure Search_GetRepositoryTimePerCrawl” error in SharePoint 2013

In Crawl Log page of Search Service Application, when I clicked on Content Source “Local SharePoint Sites”, I got an error which said “"Could not find Stored Procedure Search_GetRepositoryTimePerCrawl”.

Search Servie Log

This was how Something went wrong screen look like.

SearchError

After searching on different sites, I found a solutions which suggests to check “Search Health Monitoring - Trace Events” Timer Job. When I checked it in Jobs Definitions page, I found it was disabled.

SearchTimerJobDisabled

After enabling and running the timer job, issue was resolved.

TimerJob

This is how Search Crawl Log page looks like

SearchLogs

Reference : http://www.wictorwilen.se/sharepoint-2013-fix-to-the-could-not-find-stored-procedure-search_getrepositorytimepercrawl-error

Stop forcefully SharePoint Search Crawl through PowerShell

Sometime, it happens that we want to stop search crawl but from Central Administration Site, Stop Crawl link doesn’t work. To stop Search Crawl forcefully in SharePoint, we can use this script.

Get-SPEnterpriseSearchCrawlContentSource -SearchApplication "Search Service Application" | ForEach-Object {
    if ($_.CrawlStatus -ne "Idle")
    {
        Write-Host "Stopping : Crawl is currently running for content source $($_.Name)..."
        $_.StopCrawl()
    }
}

Wednesday, November 19, 2014

DateTime picker issue in Nintex Forms

While customizing SharePoint Forms using Nintex Forms, we found that DateTime control in not displaying date in correct manner and form cannot be submitted if DateTime column is a mandatory field. Digits for month were being displayed twice.

1

After doing some search and a after a discussion with my good friend Vahid Taslimi who is Product Manager at Nintex, we started looking into locale and regional settings of SharePoint as it could be potential cause of this issue. We found that their is a conflict between locale settings of OS and locale settings of SharePoint site. When we opened regional settings of the site, we found that locale for the site is English (United States).

2

When we changed Locale from English (United States) to Arabic (U.A.E), issues with DateTime control was not there.

3

Here is the form after this change.

4

Sunday, November 16, 2014

Contents of emails disappeared in Nintex Workflows after SharePoint 2013 SP1 installation

After installing Service Pack 1 for SharePoint 2013, I found an issue with all workflows developed using Nintex Workflows 2013. For some reason, body of email notifications was not visible and it seems contents have been deleted.

image

Nintex Workflows 2013 was installed in June 2014 and that build is not compatible with SP1 for SharePoint 2013. After installing the latest build, issue got resolved and all text for emails are visible as earlier.

image