Wednesday, September 24, 2014
Wednesday, September 17, 2014
SharePoint Configuration wizard error after an Cummulative Update (CU) or service pack (SP) install: Solution Dismount database then run wizard then remount DB
When you have large content databases on your web application, the Configuration Wizard can error out or just never seem to finish.
If that is the case, you can un-mount the content databases then run the wizard, then re-mount the databases with the script that is produced by the script below. don't forget to replace the <<DatabaseServer>> with your database server name. ex. mySQLServer.mydomain.com
and
Add-PSSnapin Microsoft.SharePoint.Powershell
$data = Get-SPContentDatabase
foreach($d in $data)
{
write-host 'Dismount-SPContentDatabase -Identity' $d.Id ' -WarningAction SilentlyContinue'
}
foreach($d in $data)
{
write-host 'Mount-SPContentDatabase -Name '$d.Name '-WebApplication '$d.WebApplication.Url' -DatabaseServer <<DatabaseServer>> -WarningAction SilentlyContinue'
}
Tuesday, September 9, 2014
SharePoint Error in people picker in Infopath filler for SSL termination at F5 rather than at the web application/IIS level
The error occurs in the InfoPath filler people picker: calls fails /_vti_bin/spclaimproviderwebservice.https.svc
when the SSL termination is done at the F5.
To resolve, you'll need to create a iRule in F5 or in IIS to strip of the .https for the following two services:
spclaimproviderwebservice.https.svc
and
cellstorage.https.svc
IIS:
<rule name="SpClaimProviderWebService" stopProcessing="true">
<match url="^(.*)spclaimproviderwebservice.https.svc$" />
<action type="Rewrite" url="{R:1}spclaimproviderwebservice.svc" />
</rule>
<rule name="cellStorage" stopProcessing="true">
<match url="^(.*)cellstorage.https.svc$" />
<action type="Rewrite" url="{R:1}cellstorage.https.svc" />
</rule>
F5:
when the SSL termination is done at the F5.
To resolve, you'll need to create a iRule in F5 or in IIS to strip of the .https for the following two services:
spclaimproviderwebservice.https.svc
and
cellstorage.https.svc
IIS:
<rule name="SpClaimProviderWebService" stopProcessing="true">
<match url="^(.*)spclaimproviderwebservice.https.svc$" />
<action type="Rewrite" url="{R:1}spclaimproviderwebservice.svc" />
</rule>
<rule name="cellStorage" stopProcessing="true">
<match url="^(.*)cellstorage.https.svc$" />
<action type="Rewrite" url="{R:1}cellstorage.https.svc" />
</rule>
F5:
when HTTP_REQUEST {
if { [[string tolower] [HTTP::path]] contains "spclaimproviderwebservice.https.svc"} {
HTTP::path [string map {.https ""} [HTTP::path]]
}
}when HTTP_REQUEST {
if { [[string tolower] [HTTP::path]] contains "cellstorage.https.svc"} {
HTTP::path [string map {.https ""} [HTTP::path]]
}
}Tuesday, September 2, 2014
SharePoint 2013 Infopath browser form, people picker error in IE 11: JSON is undefined
This is a strange compatibility issue so have a ticket open with Microsoft so will update with the real fix (i'm assuming that it will be a hot fix).
When you open a people picker in IE 11 for a infopath form in the browser, the error get's thrown, JSON is undefined.
the temporary fix is to add teh following to the pickerdialog.master in the layouts folder.
Add this to the top of the page:
<!DOCTYPE html>
Replace the meta tag where it has
<meta http-equiv="X-UA-Compatible" content="IE=10" />
with the following:
<meta http-equiv="X-UA-Compatible" content="IE=edge;chrome=1" />
<!--[if lt IE 9]>
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<![endif]-->
<!--[if gte IE 9]><!-->
<script src="http://code.jquery.com/jquery-2.0.3.js"></script>
<!--<![endif]-->
Save.
Test your people picker on infopath browser form.
When you open a people picker in IE 11 for a infopath form in the browser, the error get's thrown, JSON is undefined.
the temporary fix is to add teh following to the pickerdialog.master in the layouts folder.
Add this to the top of the page:
<!DOCTYPE html>
Replace the meta tag where it has
<meta http-equiv="X-UA-Compatible" content="IE=10" />
with the following:
<meta http-equiv="X-UA-Compatible" content="IE=edge;chrome=1" />
<!--[if lt IE 9]>
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<![endif]-->
<!--[if gte IE 9]><!-->
<script src="http://code.jquery.com/jquery-2.0.3.js"></script>
<!--<![endif]-->
Save.
Test your people picker on infopath browser form.
Monday, August 25, 2014
SharePoint 2013 SP or CU error install error: An error occurred while running detection
While installing SP1 or any other CU, the error pops up saying that an "error occurred while running detection".
There are a lot of articles out there to run the repair on SharePoint, run the configuration, etc. but none of those worked.
Hmmm... so i decided to unpack the SP1 and create a batch file and run the msp files on all the servers, then run the configuration and wooo hooo.
Everything works (installing the CU, or SP no more problems).
Here is the example for SP1: the contents of the batch files that i created with SP1:
Officer server: I extracted it to D:\off\
with the command: officeserversp2013-kb2880552-fullfile-x64-en-us.exe /extract:"D:\off"
D:\off\acsrvmuisp-en-us.msp /quiet
D:\off\acsrvwfesp-x-none.msp /quiet
D:\off\coreservermuisp-en-us.msp /quiet
D:\off\coreserversp-x-none.msp /quiet
D:\off\edumuisp-en-us.msp /quiet
D:\off\eduwfesp-x-none.msp /quiet
D:\off\ifsmuisp-en-us.msp /quiet
D:\off\ifswfesp-x-none.msp /quiet
D:\off\lpsrvmuisp-en-us.msp /quiet
D:\off\lpsrvwfesp-x-none.msp /quiet
D:\off\oserversp-x-none.msp /quiet
D:\off\osfservermuisp-en-us.msp /quiet
D:\off\osfserversp-x-none.msp /quiet
D:\off\ppsmamuisp-en-us.msp /quiet
D:\off\ppsmawfesp-x-none.msp /quiet
D:\off\pptservermuisp-en-us.msp /quiet
D:\off\pptserversp-x-none.msp /quiet
D:\off\smsmuisp-en-us.msp /quiet
D:\off\smssp-x-none.msp /quiet
D:\off\sqlemuisp-en-us.msp /quiet
D:\off\stssp-x-none.msp /quiet
D:\off\svrproofsp-en-us.msp /quiet
D:\off\svrproofsp-ar-sa.msp /quiet
D:\off\svrproofsp-az-latn-az.msp /quiet
D:\off\svrproofsp-bg-bg.msp /quiet
D:\off\svrproofsp-bs-latn-ba.msp /quiet
D:\off\svrproofsp-ca-es.msp /quiet
D:\off\svrproofsp-cs-cz.msp /quiet
D:\off\svrproofsp-cy-gb.msp /quiet
D:\off\svrproofsp-da-dk.msp /quiet
D:\off\svrproofsp-de-de.msp /quiet
D:\off\svrproofsp-el-gr.msp /quiet
D:\off\svrproofsp-es-es.msp /quiet
D:\off\svrproofsp-et-ee.msp /quiet
D:\off\svrproofsp-eu-es.msp /quiet
D:\off\svrproofsp-fi-fi.msp /quiet
D:\off\svrproofsp-ga-ie.msp /quiet
D:\off\svrproofsp-gl-es.msp /quiet
D:\off\svrproofsp-gu-in.msp /quiet
D:\off\svrproofsp-he-il.msp /quiet
D:\off\svrproofsp-hr-hr.msp /quiet
D:\off\svrproofsp-id-id.msp /quiet
D:\off\svrproofsp-it-it.msp /quiet
D:\off\svrproofsp-kk-kz.msp /quiet
D:\off\svrproofsp-kn-in.msp /quiet
D:\off\svrproofsp-ko-kr.msp /quiet
D:\off\svrproofsp-lt-lt.msp /quiet
D:\off\svrproofsp-lv-lv.msp /quiet
D:\off\svrproofsp-mk-mk.msp /quiet
D:\off\svrproofsp-mr-in.msp /quiet
D:\off\svrproofsp-ms-bn.msp /quiet
D:\off\svrproofsp-ms-my.msp /quiet
D:\off\svrproofsp-nb-no.msp /quiet
D:\off\svrproofsp-nl-nl.msp /quiet
D:\off\svrproofsp-nn-no.msp /quiet
D:\off\svrproofsp-pa-in.msp /quiet
D:\off\svrproofsp-pl-pl.msp /quiet
D:\off\svrproofsp-pt-br.msp /quiet
D:\off\svrproofsp-ro-ro.msp /quiet
D:\off\svrproofsp-ru-ru.msp /quiet
D:\off\svrproofsp-sk-sk.msp /quiet
D:\off\svrproofsp-sl-si.msp /quiet
D:\off\svrproofsp-sr-cyrl-cs.msp /quiet
D:\off\svrproofsp-sv-se.msp /quiet
D:\off\svrproofsp-sr-latn-cs.msp /quiet
D:\off\svrproofsp-ta-in.msp /quiet
D:\off\svrproofsp-te-in.msp /quiet
D:\off\svrproofsp-th-th.msp /quiet
D:\off\svrproofsp-tr-tr.msp /quiet
D:\off\svrproofsp-uk-ua.msp /quiet
D:\off\svrproofsp-ur-pk.msp /quiet
D:\off\svrproofsp-vi-vn.msp /quiet
D:\off\svrproofsp-zh-cn.msp /quiet
D:\off\vsrvmuisp-en-us.msp /quiet
D:\off\vsrvwfesp-x-none.msp /quiet
D:\off\wasrvmuisp-en-us.msp /quiet
D:\off\wasrvwfesp-x-none.msp /quiet
D:\off\wdsrvmuisp-en-us.msp /quiet
D:\off\wdsrvsp-x-none.msp /quiet
D:\off\wssmuisp-en-us.msp /quiet
D:\off\xlsrvmuisp-en-us.msp /quiet
D:\off\xlsrvwfesp-x-none.msp /quiet
Project server: I extracted it to D:\proj\
with the command: projectserversp2013-kb2880553-fullfile-x64-en-us.exe /extract:"D:\proj"
D:\proj\projectservermuisp-en-us.msp
D:\proj\projectserverwfesp-x-none.msp
D:\proj\pserversp-x-none.msp
Language Pack: I extracted it to D:\lang\
with the command: serverlpksp2013-kb2880554-fullfile-x64-en-us.exe /extract:"D:\lang"
D:\lang\acsrvmuisp-en-us.msp /quiet
D:\lang\coreservermuisp-en-us.msp /quiet
D:\lang\edumuisp-en-us.msp /quiet
D:\lang\ifsmuisp-en-us.msp /quiet
D:\lang\lpsrvmuisp-en-us.msp /quiet
D:\lang\osfservermuisp-en-us.msp /quiet
D:\lang\osmuisp-en-us.msp /quiet
D:\lang\ppsmamuisp-en-us.msp /quiet
D:\lang\pptservermuisp-en-us.msp /quiet
D:\lang\projectservermuisp-en-us.msp /quiet
D:\lang\smsmuisp-en-us.msp /quiet
D:\lang\svrproofsp-ar-sa.msp /quiet
D:\lang\svrproofsp-az-latn-az.msp /quiet
D:\lang\svrproofsp-bg-bg.msp /quiet
D:\lang\svrproofsp-bs-latn-ba.msp /quiet
D:\lang\svrproofsp-ca-es.msp /quiet
D:\lang\svrproofsp-cs-cz.msp /quiet
D:\lang\svrproofsp-cy-gb.msp /quiet
D:\lang\svrproofsp-da-dk.msp /quiet
D:\lang\svrproofsp-de-de.msp /quiet
D:\lang\svrproofsp-el-gr.msp /quiet
D:\lang\svrproofsp-en-us.msp /quiet
D:\lang\svrproofsp-es-es.msp /quiet
D:\lang\svrproofsp-et-ee.msp /quiet
D:\lang\svrproofsp-eu-es.msp /quiet
D:\lang\svrproofsp-fi-fi.msp /quiet
D:\lang\svrproofsp-fr-fr.msp /quiet
D:\lang\svrproofsp-ga-ie.msp /quiet
D:\lang\svrproofsp-gl-es.msp /quiet
D:\lang\svrproofsp-gu-in.msp /quiet
D:\lang\svrproofsp-he-il.msp /quiet
D:\lang\svrproofsp-hi-in.msp /quiet
D:\lang\svrproofsp-hr-hr.msp /quiet
D:\lang\svrproofsp-hu-hu.msp /quiet
D:\lang\vsrvmuisp-en-us.msp /quiet
D:\lang\wasrvmuisp-en-us.msp /quiet
D:\lang\wdsrvmuisp-en-us.msp /quiet
D:\lang\wssmuisp-en-us.msp /quiet
D:\lang\xlsrvmuisp-en-us.msp /quiet
D:\lang\xsmuisp-en-us.msp /quiet
--------------------------------------------------------------
Tuesday, August 5, 2014
Sharepoint List view showing raw html
This is a simple fix. Modify the webpart settings:
Go to Miscellaneous:
Check the "Server Render"
Ok or Apply.
Stop editing the page.
Done!!!!
:)
Go to Miscellaneous:
Check the "Server Render"
Ok or Apply.
Stop editing the page.
Done!!!!
:)
Tuesday, July 29, 2014
Create a new the crawl database and replace the old or corrupted crawl database in SharePoint 2013 Search
Recently the crawl database in sharepoint search got corrupted. After we fixed the indexes, it kept getting corrupted so we just recreated the database and the issues went away. Here are the steps and power shell.
#You will need to change the search service application name, also your sql server name, and the guid of you crawl store.
Add-PSSnapin Microsoft.SharePoint.PowerShell
#List all crawl database:
Get-SPEnterpriseSearchCrawlDatabase -SearchApplication "Search service Application"
#Create a new Crawl database:
New-SPEnterpriseSearchCrawlDatabase -DatabaseName "Search_Service_Application_CrawlStoreDB" -DatabaseServer "SQLServerName" -SearchApplication "Search Service Application"
#Delete the crawl store that is corrupted or old.
$ssa = Get-SPEnterpriseSearchServiceApplication -Identity "Search service Application"
$cs = $ssa.CrawlStores
#list the crawl stores to find the corrupted or old one
$cs
#delete the old/corrupted store
$cs1 = $cs.Item("GUID of Old database")
$cs1.Delete()
# if the search is in a System paused for refactoring, use the command below to normal
#$ssa = Get-SPEnterpriseSearchServiceApplication -Identity "Search service Application"
#$ssa.ForceResume($ssa.IsPaused())
#You will need to change the search service application name, also your sql server name, and the guid of you crawl store.
Add-PSSnapin Microsoft.SharePoint.PowerShell
#List all crawl database:
Get-SPEnterpriseSearchCrawlDatabase -SearchApplication "Search service Application"
#Create a new Crawl database:
New-SPEnterpriseSearchCrawlDatabase -DatabaseName "Search_Service_Application_CrawlStoreDB" -DatabaseServer "SQLServerName" -SearchApplication "Search Service Application"
#Delete the crawl store that is corrupted or old.
$ssa = Get-SPEnterpriseSearchServiceApplication -Identity "Search service Application"
$cs = $ssa.CrawlStores
#list the crawl stores to find the corrupted or old one
$cs
#delete the old/corrupted store
$cs1 = $cs.Item("GUID of Old database")
$cs1.Delete()
# if the search is in a System paused for refactoring, use the command below to normal
#$ssa = Get-SPEnterpriseSearchServiceApplication -Identity "Search service Application"
#$ssa.ForceResume($ssa.IsPaused())
Subscribe to:
Posts (Atom)
