Amol Ghuge's SharePoint Blog

08 July, 2014

Microsoft MVP Award: 5th Times in Row

I am very happy to inform you all that I have been awarded Microsoft Most Valuable Award five times in a row. First time, I got this award on 1st July 2010 and getting it consecutively since then.

The novelty of receiving the famous “Congratulations! We are pleased to present you with the 2014 Microsoft MVP Award! ” email may fade by the fifth time, but the feeling of being honored by the Award, being humbled by the amazing fellow MVPs I can be associated with, and the whole-day grin on my face does not fade at all.

Starting my fifth MVP year feels special. Five years is a lot! I am humbled and honored to have been presented with this award. There are too many people for me to name here to whom I owe a debt of thanks & appreciation, so I will simply say thank you to the SharePoint Community as a whole. I have to give the credit for this award to the people who have given them most, and that is my amazingly supportive parents, without-whom I would not be able to do any of the community work that I do.

Grateful to Microsoft and to everyone that have been supporting me in my professional and personal growth. THANK YOU!

16 June, 2014

The PerformancePoint Services service application has not been configured

If you have configured your farm recently and planning to use Performance Point functionality then you must have notice this error:

The PerformancePoint Services service application has not been configured and is required to use the PerformancePoint features. The service can be configured from "Manage Service Applications" in SharePoint Central Administration.

The above error message is self-explanatory as it’s conveying that the performance point service application has not yet configured in your farm and we need to do the configuration first before we go ahead and use it in full fledged manner.

Note:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Today in this article, I will elaborate how to configure this service application and get rid of this error message.

Two core points are mandatory to get this working as:

1. Performance Point Service application

2. Performance Point Services

How to configure Performance Point Service application?

a) Open the Central Administration

b) Application Management section

c) Click on Manage Service Applications.

d) Click New

e) Click PerformancePoint Service Application.

f) Type a name for the service application

g) Select the Add this service application's proxy to the farm's default proxy list check box.

h) Select the Create new application pool option

i) Type a name for the application pool.

j) Under the Configurable option, select the managed account to run the application pool.

k) Click Create.

l) Click OK.

That’s it – by this way PPS service application will be created.

Finally second most important point i.e. Performance Point Services

1. In Central Administration

2. System Settings section

3. Click Manage services on server.

4. Select the server that you want.

5. Click Start next to PerformancePoint Service.

Done – check your performance point functionality now and it should be up & running without any issues.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product Applies To:

· SharePoint Server 2010

· SharePoint Server 2013

06 June, 2014

Backup Site collection, Subsite, List / Library - SharePoint 2013

Hello Guys, today I am going to share one of my interesting topics in SharePoint 2013. This is an important one that you have to be ‘aware of’ as it belongs to recovery model. Yes, you are absolutely right; I am talking about Backup-Restore methods in SharePoint 2013.

Microsoft SharePoint 2013 has comes up with so many enhancements and backup restore is one of them. I will try my best here to cover the backup-restore based on GUI (Graphical User Interface) and Powershell so that you will be proficient enough to work on these mentioned methods independently.

Backup Operations

Backup operations are associated with:
-Site collection
-Subsite
-List and Document Libraries

[How to take the backup of SharePoint 2013 site collection using PowerShell]

Here is the complete syntax:-

Backup-SPSite -Identity <SiteCollectionGUIDorURL> -Path <BackupFile> [-Force] [-NoSiteLock] [-UseSqlSnapshot] [-Verbose]

Backup-SPSite http://server_name/sites/site_name -Path C:\Backup\site_name.bak

[How to take the backup of SharePoint 2013 subsite /List / Library using PowerShell]

Here is the complete syntax:-
Export-SPWeb http://site –Path "site export.cmp"

[LIST / LIBRARY BACKUP]
export-spweb -identity http://URLOFYOURSITE -path \\servershare\AMOL\AMYLIST.cmp -itemurl /NAMEOFYOURLIST

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Office 365 Videos

Watch these videos to become familiar with Office 365 and how to read email, share documents, and more.

Download | Watch online

Share or publish your Office 365 calendar

Share or publish your calendar so others can view your appointments and meetings.

Download | Watch online

OFFICE 365 FOR SMALL BUSINESS ADMIN
Create a shared mailbox You can create a shared mailbox in Office 365 so that a group of people can view and respond to email from a common mailbox. Download \| Watch online
Manage passwords Learn how to manage passwords for your organization. Change password expiration and reset forgotten passwords, for yourself and others. Download \| Watch online
Manage user accounts As an admin, you need to perform a variety of tasks to keep your organization running smoothly. Learn how to add users, update user information, and transfer licenses and buy new licenses. Download \| Watch online
Set up your custom domain in Office 365 Set up your own domain name with Office 365 Small Business so your customers and partners can use an easy-to-remember email address to contact you. Download \| Watch online

MCSA: Office 365

Earning an MCSA: Office 365 certification qualifies you for a position as a software as a service (SaaS) administrator or cloud applications administrator focused on managing Office 365 business productivity products like Exchange, SharePoint, and Lync

Managing Office 365 Identities and Requirements: Required Exam: 70-346

http://www.microsoft.com/learning/en-us/exam-70-346.aspx

Enabling Office 365 Services: Required Exam: 70-347

http://www.microsoft.com/learning/en-us/exam-70-347.aspx

Resources:

· Visit the Office 365 product site

· Get free training on Office programs

· Find a practice test at MeasureUp

· Find a practice test at Kaplan SelfTest

· Find a practice test at Transcender

Training resources for Office 2013 and Office 365

Training resources for Office 365:

If your organization signed up for Office 365 and you need to start reading email, sharing documents, and more, see the following resources to get started with Office 365:

· Get started with Office 365

· Get started with the new Office

· Install Office with Office 365

· Use my Office desktop applications with Office 365

· Set up and use Office 365 on your phone or tablet

· Start using Office and Office Online

· Start using SharePoint sites, OneDrive for Business, and Newsfeed to share documents and ideas

· Start using Outlook Web App for email and calendars

· Start using Lync for IM and online meetings

· Change your account settings in Office 365 like your password or language

Office 365 Videos:

The following Office 365 videos are available:

For more videos, see Training courses for Office 365 for business.

Office 2013 Suite:

Access 2013 Suite:

Excel 2013:

Lync 2013:

Office offline:

OneNote 2013

Outlook 2013:

PowerPoint 2013:

Project 2013:

Publisher 2013:

Word 2013:

Visio 2013:

03 June, 2014

The URL for this file is too long for the application

One of our business owners has reported an issue “SharePoint reporting these errors when I open an Excel file, you can support me in check if not missing any site configuration.”

Error #1:

The URL for this file is too long for the application. A temporary copy of this file will be opened on your computer. You must save this copy as a new file. – This is the most common one where many levels of nested sub folders in a library. If your folder paths start exceeding 120 characters by themselves, it's time to reorganize your content folders.

Error #2:

The specified file or folder name is too long. The URL path for all files and folders must be 260 characters or less (and no more than 128 characters for any single file or folder name in the URL). Please type a shorter file or folder name.

Troubleshoot issues with Windows SharePoint Services.

Error #3:

The URL for this file is too long for the application. A temporary copy of this file will be opened on your computer. You must save this copy as a new file

I think this is an old (in fact very old) / generic error message which come while editing the office documents. Let’s try to understand a little background behind this issue!

What’s the cause behind this issue?

Here is the reference: http://support.microsoft.com/kb/894630

What the above article saying?

This behavior occurs if the number of characters in the URL exceeds the maximum number of characters that is supported for URLs in SharePoint Server 2007 / 2010, in SharePoint Portal Server 2003, and in Windows SharePoint Services.

To determine the length of a URL, SharePoint Server 2007, SharePoint Portal Server 2003, and Windows SharePoint Services convert the string in the URL to Universal Character Set (UCS) Transformation Format 16 (UTF-16) format, and then count the number of 16-bit characters in the string. A URL that contains more than 260 characters is not supported.

Additionally, a URL that contains one or more of the following components is not supported:

1. A folder name that has more than 256 UCS-2 characters

2. A file name that has more than 128 characters

More details on “Understanding URL and path lengths”, “URL path and restrictions”, “Resolving URL length problems”:

http://technet.microsoft.com/en-us/library/ff919564(v=office.14).aspx

Resolution:

Make sure that the names of folders and of files do not exceed the maximum lengths that are supported for URLs in SharePoint Server 2007, in SharePoint Portal Server 2003, and in Windows SharePoint Services.

Workaround:

Reduce the SharePoint URL’s, How to do this? – Here is the reference:

https://portal.slac.stanford.edu/sites/inc_public/pages/how-to-shorten-url.aspx

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Note:

Reference:

http://sharepointknowledgebase.blogspot.com/2013/02/url-path-length-restrictions-sharepoint.html

Product applies to:

· SharePoint 2010

· SharePoint 2013

02 June, 2014

Remove quick launch in SharePoint 2013

I think this is the most common request for end users in which they want to remove the quick launch from the site in SharePoint 2013!

Note:

So thought of sharing this article with all of you so that everybody can get the benefit of the same:

Here is the script that you are looking for!

/* Hide quick launch bar */

#sideNavBox {

display: none;

}

/* Hide quick launch bar */

#contentBox {

margin-left:20px !important;

}

If you don’t want to go for code approach then here are some other ways!

To enable or disable Quick Launch through the user interface

1. Click Site Actions, and then click Site Settings.

2. Under Look and Feel, click Tree view.

3. To display the control, select the Enable Quick Launch check box. Or, to hide Quick Launch, clear the check box.

To enable or disable Quick Launch using SharePoint Designer

1. Open the website in SharePoint Designer 2010.

2. On the site settings page, under Settings

3. Select the Display Quick Launch check box to enable the menu.

4. To hide the menu -> clear the check box

5. Click File, and then click Save to save the change.

If you have any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Open Videos in a new window/tab - SharePoint 2013

New digital asset content types, Thumbnail–centric views, Image previews, Automatic metadata extraction for image files, Podcasting support through RSS – You must be wondering what’s this? J Quite obvious! These are all the features of asset library which is there in SharePoint 2013.

Note:

Asset Library: Additional functionality to support the storage and organization of rich media, such as images, videos, or audio files.

Every time I tried opening the video files, they opened in the same window which I don’t want, there has to be a separate window in which I can open & view these video files!

How to do this? – Thank you for reading this article as this will give you the exact guidelines to achieve this!

There are two ways to achieve this end result:

1. Out of box way | Default functionality

2. Programming way

Out of box way:

1. Open your asset library

2. Change the view options

3. Switch to “All Assets” view

4. Right click on the Video file

5. Open in a new window

Programming way:

Two references which are pretty awesome and useful too!

http://365.webbrewers.com/blog/Lists/Posts/Post.aspx?ID=9

http://www.eliostruyf.com/adding-a-custom-action-to-a-callout-in-sharepoint-2013/

http://junestime.wordpress.com/2013/02/26/javascript-open-links-in-new-windowtab-in-sharepoint-2010/

I hope the above information will be helpful for all of you! In case of any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product applies to:

SharePoint 2013

References:

http://technet.microsoft.com/en-us/library/ee414275(v=office.15).aspx

Maximum upload size in SharePoint 2013

As the SharePoint can be use one of best repository tool in today’s market, we uploads so many files to SharePoint document library on regular basis and face some generic error message also “you have cross the upload limit which has been configured by web administrator” & so many others!

Today’s article is based on this “maximum upload” information and what’s under the hood? Where is this setting coming from?

Here is the information that you are looking for!

The maximum file upload size is a web application setting that specifies the maximum size of a file that a user can upload to the server. You configure the maximum file upload size for every web application by using Central Administration to specify the size of files that will be uploaded to asset libraries.

By default, the maximum video file upload size is 250 MB. You can increase the video file upload size to 2 GB.

How to change this in CA?

1. Central Administration

2. Application management

3. Manage web applications

4. Select the correct web application in which you wanna do the changes

5. General settings (from the ribbon)

6. You will see the section named as “Maximum upload size”

7. Change the value as per the requirement and click OK.

8. That’s it & you are done!

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

27 May, 2014

The site collection could not be restored - Resolved!

We have a sharepoint site in our staging environment & the exact replica in production. We made few change to the staging site and tried to restore that staging site to production. But restoration never got completed and we received the below.

Error: The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space.

Troubleshooting done:

-Check the disk space on the SQL server where LDF athe nd MDF files are stored.

-Check the partition on the SQL Server in reference to data files.

-Make sure the content database has enough space allocated.

-Make sure the database does not have restrictive growth.

-Make sure to check the disk space on the SP server where restore is running. Approximately it should be 2 times the DB Size.

-Also try doing the below

Go to “SQL Server Properties-> connections” and uncheck ‘Use query governor to prevent long running queries’. Also set ‘Remote Query timed out to 0’.

Stop and restart the “Windows SharePoint service timer”

Restart the IIS.

But still i received the same error.

Resolution: There would be a possibility of existing PRD site might be orphaned. If the site is orphaned and if we try to restore upon that site, it will throw the above error.

Steps to identify the Orphan sites/Site Collection:

Step 1: Execute the below command.

stsadm -o enumallwebs -databasename DatabaseName -databaseserver Servername > c:\ContentDatabaseNameOrphans.xml

Step 2: XML File will be generated. It will be displaying all the site collections and sites present in the Content DB with their GUID’s

</Webs>

</Site>

InSiteMap="False" indicates site collection (www.abc.com) is orphaned. If you try to restore upon the site collection www.abc.com , you will receive “site collection could not be restored again” error.

Step 3: To remove orphan objects , I tried running the below script.

$database = Get-SPContentDatabase “Content_DB”

$database.Repair($false)

$database.update()

Note : $false parameter is used to view the list of orphan object related to the Conten DB and $true parameter will actually delete orphan objects.

But unfortunately all the orphan object related to the site collection www.abc.com are not removed completely.

Step 4: To verify the orphan site collection is completely removed or not,Go to your SQL Server and open your database and then tables àright click on the table “dbo.AllSites” à select top 1000 rows.

Step 5: It will display the list of Site Collection’s GUID present in the database. You need to verify the existing orphaned site collection GUID in the database(Which we found out it in step2).If it is present, remove that using the below command.

But before executing the below command , be sure that you are deleting the correct site.

stsadm -o deletesite -siteid "SiteCollectionGUID" -databasename “ContentDB_Name" -databaseserver "DB_ServerName" –force

After executing the above command , you can verify the site GUID is removed from “dbo.AllSites” table.

Then try to restore the Staging back up. Now this times, restoration got completed successfully :)

Amol Ghuge's SharePoint Blog

Pages

08 July, 2014

Microsoft MVP Award: 5th Times in Row

16 June, 2014

The PerformancePoint Services service application has not been configured

06 June, 2014

Backup Site collection, Subsite, List / Library - SharePoint 2013

Office 365 Videos

MCSA: Office 365

Training resources for Office 2013 and Office 365

03 June, 2014

The URL for this file is too long for the application

02 June, 2014

Remove quick launch in SharePoint 2013

Open Videos in a new window/tab - SharePoint 2013

Maximum upload size in SharePoint 2013

27 May, 2014

The site collection could not be restored - Resolved!

Search This Blog

Last 7 Days Hits!

Recent Posts

Popular Posts

Microsoft Translation