Translate
Thursday, February 19, 2015
Tuesday, February 10, 2015
To find all the large lists with items count - PowerShell
I have seen many times you have the immediate requirement of getting the large list for any or all the web apps in your SharePoint farm.
Please run this PowerShell for each content database - Best practice is off production hours
Please run this PowerShell for each content database - Best practice is off production hours
Use wss_content_relatedDBName
SELECT ItemChildCount
+ FolderChildCount
as Items, DirName +'/' + LeafName as RelativePath FROM alldocs WITH(NOLOCK) WHERE ItemChildCount + FolderChildCount > 5000 ORDER BY Items DESC
Thank you!
Thank you!
SharePoint Designer Performance Issue at the client side
Sometimes i have seen SharePoint performance issue at the client side - this can be due to many reason but you can give a try for below steps at client side and see if this helps you !
1. Close SharePoint
Designer.
2. Clear your
Internet Explorer's temporary Internet cache and close the browser.
3. Remove content in
Folder %System Drive%\Users\%user%\AppData\Local\Microsoft\WebSiteCache).
4. Type %temp% at a
run prompt and delete all the temp files in there.
5. Type temp at a
run prompt and delete all the temp files in there.
6. Delete
%APPDATA%\Microsoft\SharePoint Designer\ProxyAssemblyCache
7. Delete the
contents of: %APPDATA%\Microsoft\Web Server Extensions\Cache
8. Delete contents
of %USERPROFILE%\AppData\Roaming\Microsoft\SharePoint Designer
you can also check @ server side - change with your URL
$app = Get-SPWebApplication http://abhi.interest.com
$app.ClientCallableSettings.ExecutionTimeout
Try to increase ClientCallableSettings.ExecutionTimeout values -
$app.ClientCallableSettings.ExecutionTimeout
= 5400000000
$app.Update()
Best of LUCK!
ProcDump v7.01
ProcDump is a command-line utility whose primary purpose is monitoring an application for CPU spikes and generating crash dumps during a spike that an administrator or developer can use to determine the cause of the spike. ProcDump also includes hung window monitoring (using the same definition of a window hang that Windows and Task Manager use), unhandled exception monitoring and can generate dumps based on the values of system performance counters. It also can serve as a general process dump utility that you can embed in other scripts.
Download URL- https://technet.microsoft.com/en-us/sysinternals/dd996900.aspx
Tiny tool and you can run at client side - I was trying to test the this for SPD with the below syntax
1. Put the binary to c:\
2. Open DOS shell
3. Use this command for SPD - procdump.exe -f "" -e 1 -w spdesign.exe > proc.txt
4. Open SharePoint Designer and open the site
5. Once done - Ctr+C to terminate the dump collection process
6. Open proc.txt and see the result for further analysis
Download URL- https://technet.microsoft.com/en-us/sysinternals/dd996900.aspx
Tiny tool and you can run at client side - I was trying to test the this for SPD with the below syntax
1. Put the binary to c:\
2. Open DOS shell
3. Use this command for SPD - procdump.exe -f "" -e 1 -w spdesign.exe > proc.txt
4. Open SharePoint Designer and open the site
5. Once done - Ctr+C to terminate the dump collection process
6. Open proc.txt and see the result for further analysis
Unable to parse page for field values: The 'mso:CustomDocumentProperties' start tag on line 2 does not match the end tag of
When you have upgraded from SP 2007 to SP 2010 and trying to access customized any .aspx pages you might receive the the below errors -
1. List does not exist. The page you
selected contains a list that does not exist. It may have been deleted by
another user.
2.w3wp.exe (0x5C30) 0x62A8 SharePoint Foundation Performance btw0 Medium Unable to parse page for field values: The 'mso:CustomDocumentProperties' start tag on line 2 does not match the end tag of 'mso:PSD_x0020_Product_x0020_Mgr'. Line 354, position 7., pageContent =
3. System.ArgumentException: Value does
not fall within the expected range.
Unexpected
System.ArgumentException: Value
does not fall within the expected range. at
Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient
pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String
bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback,
ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback,
ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback,
ISPDataCallback pRowCountCallback, Boolean&
pbMaximalView) at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient
pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String
bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback,
ISPDataCallback ... b38ad70a-09d7-420e-b3fc-d91ebbff39d9
You can try the below steps -
1) Deactivate the features
- publishing
2) delete the
"Relationships List"
3) Activate the features using PowerShell. It creates the
"Relationships List" again
Or
you can also try to copy the problematic .aspx page from explorer view and paste at the same location with different name and then browse it.
seems the below tag is automatically updated in copied page and it works -
<mso:_dlc_DocIdItemGuid
msdt:dt="string">620c31d7-5d91-40d2-9c60-d08101fcc0d8</mso:_dlc_DocIdItemGuid>
Note - this is in my case so please first check the situation and error and then try these above options.
Thank you !
Subscribe to:
Posts (Atom)