Unable to view items in the document library and list after migration: SharePoint 2010

Issue: One of my clients was having a very strange behavior where he was not able to view few of the items in his SharePoint list or Library.  

Troubleshooting:

Checked the permissions on the library and list level. 

User was having full control permissions.

Tried removing and re-adding them to list and site, no success.

This issue was not happening at my end as I have FARM admin rights.

Tried login on client machine in SharePoint site with my credentials and issue still exist.

Tried login on my machine in SharePoint site with client credentials and issue was not there. 

Based on the above steps performed this is clear that this is machine specific issue.

Tried various things on the client machine such as clear IE cache, Resetting to default settings, Adding the site to trusted zone. But no success.

Resolution:  

Go to Start.

Open Run command type CMD.

This will open command prompt for you.  

Type ipconfig /flushdns and it will flush domain name server cache from you system.  

Reboot your machine and try to access SharePoint list or document library items.

It should work for you now.

I am not sure, how this resolution had resolved the problem and what it has to do with the issue. But it finally worked and we have a happy customer.

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.

Applies to: SharePoint Foundation Server 2010, SharePoint 2010.

Hide Title column in list in SharePoint 2010

Unlike SharePoint’s predefined lists, your custom list has only one column when you first create it — the Title column. Unfortunately, you can’t delete the Title column or change its data type, but you can rename or hide it.

Here are the complete details as how to hide the title column from the list. 

Please check and let me know in case of any queries/questions so that we can discuss and proceed further, Thank you.

-It’s actually a two-step resolution-

First step: Removing from the view

1.    Open the list

2.    List settings

3.    Views Section

4.    Click on ALLITEMS view

5.    Uncheck the title column

6.    Click OK

Second Step: Actual Hiding

1.    Open the list

2.    List settings

3.    Advanced settings

4.    Check the ‘allow management of content types’ option to Yes.

5.    Click OK

6.    Now refer to ‘item’ which is present under the content type section

7.    Click on the item content type

8.    Click on ‘Item’ under the columns

9.    Here you will get the option to hide it completely 

Product Applies To:

·         SharePoint Server 2010

·         SharePoint Foundation 2010

·         SharePoint Server 2013

List View Threshold in SharePoint 2010

One of the major reasons that this List View Threshold (LVT) feature was created is to protect the server from unintentional load that may either bring it down, or at least cause other users higher latency or failures. 

The performance of any SharePoint site, especially one that contains lists and libraries with many items, is directly affected by decisions made when setting up and planning a SharePoint site.

Error Message:

SharePoint list error: lookup and workflow status columns exceed the threshold.

Problem Description:

Users get this error when accessing a SharePoint list:

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

Resolution:
Follow below steps:

1.    Open the SharePoint Central Administration

2.    Application Management

3.    Manage Web Application

4.    Select Your Web Application

5.    General Settings

6.    Resource Throttling

7.    By default List View Lookup Threshold is 8 change it as per your requirement and

8.    Finally click OK to save it.

If you have any queries/questions then please let me know, thank you.

Product Applies To:

·         SharePoint Server 2010

·         SharePoint Foundation 2010

·         SharePoint Server 2013

How to change the site collection administrators in central administration by means of PowerShell

Few days before, one of my user came to our team and requested to have a list of site collection administrators as well as to change the admins for few site collections.

In fact it's quite easy if you do by means of GUI i.e. Central Administration.

Let me brief some steps so that it would be useful to you.

-Open Central Administration

-Application Management

-change site collection administrator

-change the admins as per the requirements

this will be hectic task if you have to implement the same for more site collections i.e. bulk activity.

so that's why I come up with the solution so that it would be beneficial for everybody.

here is the script that i am talking about:

Set-SpSite "http://sharepointdemo.skylark.com" -owneralias "domain\user1" -SecondaryOwnerAlias "<domain\user2>"

If you wanna add a list of users to the site collection administrators group of every site on your SharePoint 2010 farm then please refer this:

http://basementjack.com/uncategorized/powershell-script-to-add-a-list-of-users-to-the-site-collection-administrators-group-of-every-site-on-your-sharepoint-2010-farm

If you have any queries/questions regarding the above mentioned information then please let me know, thank you.

Product Applies To:

-SharePoint Server 2010

-SharePoint Foundation 2010

References:

Remove a site collection administrator in SharePoint 2013

http://technet.microsoft.com/en-us/library/ff631156.aspx

To add a primary or secondary site collection administrator by using Windows PowerShell in SharePoint 2013

http://technet.microsoft.com/en-us/library/ff631156.aspx

Change the primary or secondary site collection administrator in SharePoint 2013

http://technet.microsoft.com/en-us/library/ff631156.aspx

add a site collection administrator by using Central Administration

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

To add a site collection administrator by using Windows PowerShell

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

Remove a site collection administrator

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

Windows could not start the SharePoint 2010 administration service on local computer.

Infrastructure:

SP Version: Microsoft SharePoint Server 2010-SP1

Server: Windows Server 2008 R2

Problem Description: Not able to start the SharePoint Administration 2010 Service by means of services.msc console.

Error Message: Windows could not start the SharePoint 2010 administration service on local computer.

Issue identified by: Central Administration's Health Analyzer

Troubleshooting done:

- Tried starting the service by means of farm account in the services console with respect to the server where it was failing but got the error message as follows:

Windows could not start the SharePoint 2010 administration service on local computer.

- Tried start the service by means of PowerShell but got the same message as above.

Resolution applied:

Increased the default service time-out

·         Click Start, click Run, type regedit in the Open box, and then click OK.

·         Locate and then select the following registry subkey:

·         HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control

·         Right-click Control, point to New, and then click DWORD Value.

·         In the New Value box, type ServicesPipeTimeout, and then press Enter.

·         Right-click ServicesPipeTimeout and then click Modify.

·         Click decimal, type the number of milliseconds that you want to wait until the service times out, and then click OK.

For example, if you want to wait 60 seconds before the service times out, type 60000.

Exit Registry Editor and then restart the computer.

-restarted the server and issue has been resolved.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

Product Applies to:

SharePoint Server 2010

SharePoint Foundation 2010

References:

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

http://blogs.technet.com/b/wbaer/archive/2007/10/15/kb934525-troubleshooting.aspx

http://www.networksteve.com/enterprise/topic.php/SharePoint_Services_don't_start_after_restart/?TopicId=8674&Posts=3

http://stackoverflow.com/questions/8388050/the-windows-sharepoint-services-administration-service-on-local-computer-started