Issues with SharePoint Audit Logs Reports after migration from SharePoint 2007 to SharePoint 2010.

Problem Description: While saving an audit logs to a library user is getting “An Unexpected error has occurred” following a correlation.

Error Message: An unexpected Error has occurred.

Troubleshooting:

We have checked this Audit logs settings and it was enabled.

We have run all the reports one by one and all of them were having problem.

There is only site which was having issue.

Based on the correlation ID in the error message, Checked the ULS logs from the server and found the below logs.

Resolution:

Tried Goggling on the same issue with the keyword: System.InvalidCastException: Specified cast is not valid. at Microsoft.Office.RecordsManagement.Reporting.ReportData.GenerateNextReport().

Found only one reference which talks about the resolution: 

http://social.technet.microsoft.com/Forums/en-US/sharepointadminprevious/thread/41bd6179-d955-4379-9509-eed0ee7b8182/

Resolution Steps:

Go to Site Actions.

Choose to select Site Settings.

Under Site collection administration tab.

Choose to select Site collections features.

Look for Reporting feature. (It should be activated by default).

Click Deactivate and a warning message would appear, Select Deactivate this feature.

You will be taken to the site collection administration Feature list. Choose to click Activate. 

And now try to run the Audit Logs Report and now you should be able to save the reports to desired library.

Note: You should have the site collection rights to perform the above given steps.

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.

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