Office 365 SharePoint Online new blog : www.t-collaboration.com/blog/

Good blog around Office 365 SharePoint Online Issues and possible solution : http://www.t-collaboration.com/blog/

Office 365 SPO : Programatically set ‘Shared with me’ column e.g. during migration of document to Skydrive PRO Onedrive

Visit: https://www.google.co.uk/?gfe_rd=cr&ei=-jwoVPKyEs_H8gee6YHQBQ&gws_rd=ssl#q=www.t-collaboration.com+Office+365+SPO+%3A+Programatically+set+%E2%80%98Shared+with+me%E2%80%99+column+e.g.+during+migration+of+document+to+Skydrive+PRO+onedrive

Office 365 – SPO/SharePoint Online – Platform Type : ‘SharePoint 2013 workflow’ option missing from SharePoint Designer 2013

Visit: https://www.google.co.uk/?gfe_rd=cr&ei=-jwoVPKyEs_H8gee6YHQBQ&gws_rd=ssl#q=www.t-collaboration.com+Office+365+%E2%80%93+SPO%2FSharePoint+Online+%E2%80%93+Platform+Type+%3A+%E2%80%98SharePoint+2013+workflow%E2%80%99+option+missing+from+SharePoint+Designer+2013

Group Cannot be found (SharePoint 2013)

Visit: https://tcollaboration-public.sharepoint.com/Blog/Post/35/Group-Cannot-be-found-(SharePoint-2013)

SharePoint Lockdown – Restrict user’s direct access on SharePoint lists and libraries

Scenario – in intranet SharePoint 2010 application i wanted to restrict users who have  ‘Reader’ access on list and library from having direct access on list and libraries pages like allitems.aspx/allpages.aspx/viewlsts.aspx page

Solution: followed below steps against that intranet site

1.       Run below STSADM command from SharePoint server: (perform below for all site collections)

 Stsadm –o activatefeature –url “https://intra.app.co.uk” –filename ViewFormPagesLockDown\feature.xml

Ref article: http://technet.microsoft.com/en-us/library/cc263468%28v=office.12%29.aspx#section6

Example:

 2.       Remove ‘View application pages’ permission from ‘Read’ permission level.

a.       Click on Site Action à Site permission à Click ‘Permission level’

b.      Click on ‘Read’ permission level and Uncheck ‘View Application Pages’ permission from this permission level.

 

Important: Perform #b step for all site collection if you are planning to configure same for all site collections under intranet web application

 

Cheers!!

SharePoint 2010 ‘500 Internal Server Error’

From last many days customer stated facing intermittet issue of ‘500 internal server error’.  Organization have user from multiple geographical location e.g. USA/UK/JAPAN/INDIA

Strange : user from UK only faced ‘500 internal server error’ during specific GMT time duration i.e. 3:00 pm to 4:00 pm and at that same time user at USA was not facing any issue like this.

Final Solution: I started investigation from ULS log/eventviewr/Fiddler2 but no luck, after investigating for 2-3 days i found that one of entry in web.config did not have closing tag and that was really strange and it this internmittent behaviour because of configured H/W based load balancer and missing closing tag – that is why USA  based user was not facing ‘500 internal server error’ between 3:00 pm to 4:00 pm GMT and same time UK based user was facing that issue.

Note: ‘500 internal server error’ can have multiple number of reason and above one is one of them.

Cheers!!

SharePoint – SQL Interaction – performance troubleshooting from SQL Side

Case: While working on one of custom SharePoint portal on SP 2010 we started facing lot of performance related hit, we started investigating different areas like Windows Crash dump, SharePoint ULS log, Multiple Third-party tool e.g. Jmeter and then we realize that something going wrong from SQL side and we have used below to get more detail about who is consuming more resource in SQL side and what is blocking in SQL:

Note: user required sysadmin and view server state permission on db server.

Note: sp_who is provides information about current MS SQL users and it processes

1. sp_who2 (system stored procedure) or sp_who3 to find out which SPID is taking a lot of resources.

2. DBCC INPUTBUFFER(SPID)

“EventInfo” column is showing last statement/current statement executed by SPID

More Detail – SQL Server slowness

 

Cheers!!

 

Business Intelligence Tools

Yesterday i was just looking for what Business Intelligence tool that Microsoft is providing and found below something very interesting and useful from microsof’t’s one of article: Excel Services/PowerPivot for Excel, Reporting Service, PerformancePoint Services

 

Score Card:

Search service is not able to connect to Administration component server – SP 2010

Action – I tried to create new SharePoint Search Application from central Administration and after trying to explore search service application e.g. search service application diag below is the error that i saw for Crawl field:

Error : The search service is not able to connect to the machine that hosts the administration component. Verify that the administration component ‘abff6ca0-1e01-4bf4-9653-b26ea54d1e5f’ in search application ‘SP2010 – Search Service Application’ is in a good state and try again.

Solution: 

Execute below command from SharePoint 2010 powershell command and refresh page from central administration where you were getting error:

Cheers!!

 

After migrating site from SP 2007 to SP 2010 Publishing page ‘Edite Page’ not working

Error:

‘Publishing page’ link not working from path –> http://server/managedpath/sitecollection/_layouts/create.aspx
clicking on ‘Edit Page’ link keep loading and will throw error of ‘Unexpcted error..’ from Ribbon ‘Edit’ Button

Solution:

its fixed now with below solution with changing version number from 12.0… to 14.0….. The problem was with the custom page layout, have changed this for one layout.
@ Page language=”C#” Inherits=”Microsoft.SharePoint.Publishing.PublishingLayoutPage,Microsoft.SharePoint.Publishing,Version=12.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c” meta:progid=”SharePoint.WebPartPage.Document”

Was changed to

@ Page language=”C#” Inherits=”Microsoft.SharePoint.Publishing.PublishingLayoutPage,Microsoft.SharePoint.Publishing,Version=14.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c” meta:progid=”SharePoint.WebPartPage.Document”