Troubleshooting large list in SharePoint 2007

We never forgot about the basic in our life which we have learnt, but sometime there are some things which were left behind in our day to day experiences and sometimes they are regarded as stepping stone.

I am taking about a learning experience I had yesterday whilst working with a user who was seeing some delays on the SharePoint list.

Issue: User mentioned that they had some delays on their sites. When opening the list it takes allot of time.

Initial Checks: Checked on the site that list is quite odd with 22000 numbers of items and it also depends how many users were accessing the site at the same time. It was having 100 + custom columns, 50+ odd content types.

It was clear that this list is causing the issue; however, user demanded the analysis of the logs from Server or sees what exactly went wrong at that time.

Detailed troubleshooting: We always know that the best piece of information which always gives us this information is IIS and ULS logs.

IIS logs: can tell us about the number of user and load server was having at that time.

ULS logs: can tell us about the how List was behaving at that time.

To analyse the IIS logs for user load, I had used very effect tool Log Lizard also named as Log Parser (will talk about the functioning o these tools in detailed in some other article)

But to analyse the large list queries how we should go by looking at ULS logs???

I found a very useful article on this http://blogs.msdn.com/b/ronalg/archive/2012/03/12/troubleshooting-large-list-performance-sharepoint-2007.aspx, written byRon Grzywacz.

I used the reference of EventID 8sli in the ULS Logs and found the many queries like

06/30/2014 11:30:30.60 w3wp.exe (0x2A24)                       0x29DC Windows SharePoint Services   Database                             8sli                Monitorable      List item query elapsed time: 9484 milliseconds, Additional data (if available).

From this it was very clear the large list had caused the issue. Now time was to educate the user on how to handle the large list.

Guidelines: On the guidelines to manage large list you can refer to the link. http://office.microsoft.com/en-gb/windows-sharepoint-services-help/manage-lists-and-libraries-with-many-items-HA010173667.aspx  

Also you can refer to while paper to work with large list: http://technet.microsoft.com/en-us/library/cc262813(v=office.12).aspx.

Please read the best practice from MS http://technet.microsoft.com/en-us/library/cc262787(v=office.12).aspx, around the list and list items.

Refer to the column limit KB from MS http://support.microsoft.com/kb/823555.

If you have any experience to share please pass on the comment below.

Applies to:

• SharePoint 2007
• Office 2007

Application virtualization client could not launch the application you requested: SharePoint Server 2010, SharePoint Server 2013.

Issue
When opening a SharePoint document library user gets the below error message.

The Application Virtualization Client could not launch the application you requested. The specified application does not exist. Check the name you specified and then try again.

Background

User reported that whenever he tries to open a document library on the SharePoint site he get error message. Recently the Office 2010 was deployed on some user machines but some part of it was launched as Office 2010 virtualization.

The point may come in mind is what is Office 2010 Virtualization as we have seen most of the office packages installed locally.

You can read about the Application Virtualization here: http://www.microsoft.com/en-gb/windows/enterprise/products-and-technologies/virtualization/application/default.aspx

Troubleshooting

As a part of basic troubleshooting, user was able to open the documents from his local machine but SharePoint library was giving the error message.

Tried to delete the IE History, Reset o default, added the site to trusted zone etc.

It seems to be another issue so, as always relayed on one source of information, I call in internet or Google.

Resolution

while searching on internet found the KB http://support.microsoft.com/kb/2481474, which talks about the Known issues and limitations when using virtualized Office 2010 applications on App-V 4.6 and App-V 4.5 SP2 clients.

It also enlists the issue faced by our user. To resolve this issue, we need to uninstall the Deployment Kit, restart the system and reinstall the Deployment Kit.

Asked user to open the SharePoint library and it was opening fine.

Some reference link for the issue which helped in troubleshooting the issue: http://blogs.technet.com/b/appv/archive/2010/12/13/known-issues-and-limitations-when-using-virtualized-office-2010-applications-on-app-v-4-6-and-app-v-4-5-sp2-clients.aspx

How to troubleshoot applications failing to stream from an App-V management server:  http://blogs.technet.com/b/appv/archive/2011/09/07/how-to-troubleshoot-applications-failing-to-stream-from-an-app-v-management-server.aspx

You can read more on Virtualization on the following links:

Microsoft Desktop Optimization Pack: http://www.microsoft.com/en-gb/windows/enterprise/products-and-technologies/mdop/default.aspx

The Microsoft App-V Team Blog: http://blogs.technet.com/b/appv  

Your guide to App-V 5.0 application publishing and client interaction: http://blogs.technet.com/b/appv/archive/2014/01/20/your-guide-to-app-v-5-application-publishing-and-client-interaction.aspx

Applies To

Office 2010, SharePoint Server 2010 SharePoint Server 2013. 

See Also

• SharePoint 2013 Portal
• SharePoint 2013 - Service Applications
• SharePoint 2013 - Resources for Developers
• SharePoint 2013 - Resources for IT Pros

Setting up Redirector in IIS 8 for SharePoint Sites.

Today, I was given a task to work on setting up a redirector in IIS 8 based on setting up an outage page for our upcoming maintenance for SharePoint farm. I had a looked at my IIS 8 functionalities and could not find none.

So, this leads me to check the basic installation of IIS 8 on windows Server 2012 machine.

I will not be discuss about the How to install the IIS 8 and its components on your machine, for that you can take a look at the http://www.iis.net/learn/get-started/whats-new-in-iis-8/installing-iis-8-on-windows-server-2012.

But an important component HTTP Redirection, you need to install when installing IIS 8 to set-up redirector.

You can click on Next to finish Installation. Let all the necessary components installed on.

If it requires a restart then do it.

Click on Run and type Inetmgr, to open the IIS manager console, you can see HTTP Redirect.

Double click on this. You can see the HTTP Redirect console. In my example I am redirecting it to google.com and click Apply on the right hand side of the console.

Now open you IE and type: http://localhost and hit enter and you will be redirected to google.com.

You can choose any URL based on your needs.

If you face any issue, while following any steps, I would be happier to help you.

Applies to:

·         SharePoint Server 2013

·         IIS 8

·         Windows Server 2012

"Sign in as Different User" menu option is missing in SharePoint Server 2013

It’s been quite a while that I have posted on the blog. Being busy with the some project work it was way long. But I am back with some new stories for the project work.

I was doing exploring some of the sites settings but when I found that I can’t see the settings options and realizes that I don’t even have the full control permissions.

We can’t elevate the permissions of the basic user account to the higher level as one of the constraints of the project work. Then I decided to login on the site with the different user account, but when trying to sign in as a different user the option is missing.

I was not what the issue could be related to the what. One of my colleague at work suggested to use the IE in 32 bit, but no luck.

MS KB has suggested, http://support.microsoft.com/kb/2752600 suggested either to run the IE as administrator, use the admin account to log in to the site or using this URL http://siteurl/_layouts/closeConnection.aspx?loginasanotheruser=true.

Same option was also discussed on the blog http://blogs.msdn.com/b/odabasi/archive/2013/08/16/missing-quot-sign-in-as-different-user-quot-option-in-sharepoint-2013.aspx

Applies to: SharePoint Server 2013, SharePoint foundation 2013.