Archive for October, 2014

SharePoint Designer 2013 “All Files” missing for SharePoint Foundation 2013

October 31, 2014

You can make yourself Admin by doing the following:

  1. Log into Central Administration
  2. Go to Application Management -> Manage web applications
  3. Click on the Web Application you want to become Admin
  4. From the ribbon bar click on User Policy
  5. Click on Add Users
  6. Select All Zones and click Next
  7. Add your user name and check Full control
  8. Click on Finish and you’re done.  You’ll now have admin rights and see All Files in SPD.
Advertisements

Performance Optimization of CRM 2011 Quick Find Queries

October 21, 2014

Quick Find is a basic navigation tool to help you find specific records in CRM 2011. Quick Find optimizations have been included in Dynamics CRM 2011 Update Rollup 10 (UR10). By default, these are enabled after applying UR10; however, you can disable them using the option in System Settings:

(Settings | Administration | System Settings | General Tab)

The setting is at the bottom of the “General” tab called “Enable Quick Find Record Limits,” which is set to “Yes” by default.

Engable or disable CRM 2011 quick find records

When the optimizations are enabled, if more than 10,000 records are returned by a Quick Find query, the following error will occur:  “Quick find limit exceeded. Please use a more selective search value, or use Advanced Find for your search.”

If users need to search using terms that will potentially match over 10,000 records, this setting can be disabled. However, disabling the setting may result in slower overall performance for Quick Find queries. A more appropriate tool for such queries would be to use Advanced Find.

In order to take full advantage of the new Quick Find optimizations, customers will need to implement custom SQL indexes on their Find Columns.  As SQL indexes currently cannot be created in CRM Online, this can only be done in On Premise.

Example:

If you have a custom field on the Contact entity called po_CustomField, and you have enabled this as a Find Column for Quick Find searches.  In order to take full advantage of the new optimizations, create the index:

CREATE NONCLUSTERED INDEX IndexName

ON [dbo].[ContactExtensionBase] ([new_CustomField])

GO

You can optimize the way query performance by modifying the way CRM displays the query results. With the release of Dynamics CRM 2011 UR10, we can now limit the search results returned by quick find and also utilize the new Quick Find query structure by implementing SQL indexes on the column or set of columns used in a Quick Find query.

For more information on performance improvements in Dynamics CRM 2011 UR10 and Quick Find queries please Optimizing and Maintaining a Microsoft Dynamics CRM 2011 Server Infrastructure Performance white paper.

Source: Power Objects Blog

SharePoint 2010 how to reduce the size of logging database or how to purge the old data from Logging Database

October 15, 2014

WSS logging database grows very fast and it cause the storage problem most of the time in sharepoint server 2010.

To reduce the size of the logging database or to purge the old data from the logging database we can these steps.

To find the Logging Database Name go to following path:-

Login to Central Administration -> Monitoring -> Configure Usage and health data collection->

 

The Logging database stores the following things:-

  • ULS Logs from 14 Hive\LOGS
  • Raw Resource Usage Data

This data is used by Web Analytics in Sharepoint. Two timer jobs Microsoft SharePoint Foundation Usage Data Import and Microsoft SharePoint Foundation Usage Data Processing are used for importing and processing the raw data in the web analytics database.

By Default the system retains 14 days of Usage data in this database. By following PowerShell command we can check and change the value of retention days of this database. Get-spusagedefinition and Set-SPUsageDefinition

Try  Get-SPUsageDefinition

Now you need to find which table is taking most of the space inside the WSS logging Database.

 

You Can check the same from the SQL Server

Login to Sharepoint Management Studio -> Select your logging Database (Right Click) -> Reports- > Standard Reports -> Disk Usage by Top Tables.

 

Say RequestUsage* is taking most of the space inside WSS Logging database so  you can bring down the retention period of  Page Request Event.

Or if you want you can bring down the retention period for all the Events for any number of days from 14 to 1.

Use the following command to do so.

Set-SPUsageDefinition -Identity”Page Requests” -DaysRetained 3

Run the same Power Shell command again to cross check “Get-SPUsageDefinition” and check the Retention period is changed or not.


After that we need to run the two timer jobs to clean the old data ‘Microsoft SharePoint Foundation Usage Data Import’ and ‘Microsoft SharePoint Foundation Usage Data Processing’.

Go to Sharepoint Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

And it will take you to the timer jobs.


Now Click on both the Job Definitions one by one and hit ‘Run Now’ to run the timer jobs

 

Once the timer jobs is run you can check and confirm database has released the space.

Original Source: Manhar Sharma

Update Rollup 18 for Microsoft Dynamics CRM 2011 (KB 2958724)

October 10, 2014

Microsoft has released Update Rollup 18 for Microsoft Dynamics CRM 2011 Server, Microsoft Dynamics CRM for Microsoft Office Outlook, Microsoft Dynamics CRM 2011 Language Packs, and Microsoft Dynamics CRM 2011 Email Router.

For more information about this release, see Microsoft Knowledge Base article 2958724:

Update Rollup 18 is available for Microsoft Dynamics CRM 2011

To maintain parity between the application components of Microsoft Dynamics CRM 2011, this update rollup includes packages for Microsoft Dynamics CRM Server, Microsoft Dynamics CRM for Outlook, Microsoft Dynamics CRM Language Packs, and Microsoft Dynamics CRM Email Router.

Download

Reporting error. Report cannot be displayed. (rsProcessingAborted)

October 9, 2014

I was getting the above error while running one of the custom SSRS report inside CRM 2011.

To resolve this issue I had to follow these steps

  1. Start SQL Server Management Studio
  2. Expand Security, then expand Logins
  3. Select and right click the account under which the SQL Server Reporting Services is running.
  4. Select User Mapping and select YouOrg_MSCRM database and specify following role membership
  • CRMReaderRole,
  • db_owner
  • public.

Source: Nishant Rana’s Weblog

Microsoft SQL Server Max. Degree of Parallelism Calculator

October 6, 2014

http://blogs.msdn.com/b/sqlsakthi/p/maxdop-calculator-sqlserver.aspx

Before you use this calculator, please refer to the instructions given in the blog post

http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/24/wow-we-have-maxdop-calculator-for-sql-server-it-makes-my-job-easier.aspx

Noted: To run the Powershell command, you can launch Powershell console from Start –> Run –> Powershell
For More info on running Powershell commands, Refer http://bit.ly/7HR8YK

Refresh for Connector for Microsoft Dynamics V3 CU 3 now available

October 3, 2014

It has been brought to our attention that the Windows updates associated with KB 2977766 & KB 2977765 can cause the following issue when running the Microsoft Dynamics CRM Adapter Configuration Utility to configure a Microsoft Dynamics CRM organization.

Upon launching the Microsoft Dynamics CRM Configuration Utility from within Connector for Microsoft Dynamics you may receive an error message like the following: “Unhandled app domain exception caught”.

Installing the refreshed version of Connector for Microsoft Dynamics V3 CU 3 (3.3.823.1) will resolve this issue.  This version can be downloaded at the following links:

Please note:

If you have previously worked around this issue by copying the Microsoft.Dynamics.Xrm.Sdk.dll from the Adapters\Microsoft Dynamics CRM 2011 Adapter\ folder to the root folder of the Connector for Microsoft Dynamics installation you will need to remove that .dll from the root folder before upgrading to this or any subsequent release of Connector for Microsoft Dynamics.

Why does /_layouts/15/start.aspx appear as part of my SharePoint 2013 Site URL ?

October 2, 2014

The URL path of a newly created site collection will include “/_layouts/15/start.aspx” To avoid this it is necessary to deactivate the following site feature:

1. Go to Site Settings – Site Features page.

2. Deactivate the “Minimal Download Strategy” feature.

Why is the Minimal Download Strategy available by default on various site collection templates including the Team Site? This is a new feature for SharePoint 2013 that is designed to increase the performance of the SharePoint site.

The start.aspx page has a specific JavaScript object asyncDeltaManager (defined in start.js). This parses the URL, looks for the # sign and takes the path following that and dynamically loads that page.

Subsequent requests to pages are dynamically loaded through the asyncDeltaManager object. Once a link is clicked it will invoke a method in the JavaScript object which creates the MDS URL and appends the query string parameter AjaxDelta=1. A request is created and downloaded asynchronously and only the “delta” is returned to the client and assembled and rendered using JavaScript.

For a full explanation please read Wictor Wilen’s Blog post here: http://www.wictorwilen.se/sharepoint-2013—introduction-to-the-minimal-download-strategy-mds

Enable iFilter for TIFF OCR in SharePoint Foundation or SharePoint Server

October 1, 2014

In some companies, paper documents are scanned into TIFF formats and stored electronically.  To search for them, you’ll need to enable the TIFF OCR iFilter to allow SharePoint to index TIFF documents.

1. Install Windows Server feature Windows TIFF IFilter:

clip_image002

2. Enable OCR filter

clip_image002[7]

 

clip_image002[10]

3. You may need to restart the machine

4. Force SharePoint to perform a full crawl from Search Administration

5. Search for your file – here, I’m searching for “Therefore”

tiff-ifilter2

Source and original post