Recommended guidelines for lists and libraries

Limit	Maximum value	Limit type
List row size	8,000 bytes per row	Boundary
File size	2 GB	Boundary
Documents	30,000,000 per library	Supported
Major versions	400,000	Supported
Minor versions	511	Boundary
Items	30,000,000 per list	Supported
Rows size limit	6 table rows internal to the database used for a list or library item	Supported
Bulk operations	100 items per bulk operation	Boundary
List view lookup threshold	8 join operations per query	Threshold
List view threshold	5,000	Threshold
List view threshold for auditors and administrators	20,000	Threshold
Subsite	2,000 per site view	Threshold
Coauthoring in Word and PowerPoint for .docx, .pptx and .ppsx files	10 concurrent editors per document	Threshold
Security scope	50,000 per list	Threshold

Cannot logon with credentials obtained from Secure Store Provider

Problem Description:

I'm using SPD 2010 to connect to an external SQL database hosted on a different server. External data source type selection is SQL Server. I then filled up the connection properties, choose "Connect with Impersonated Windows Identity" and Secure Store Application Id. But SPD 2010 returns this error: Cannot logon with credentials obtained from Secure Store Provider

Error message:

Cannot logon with credentials obtained from Secure Store Provider

We need to set up your Secure Store service application on the server, and add a Target Application. This is an arbitrary name you assign to the set of credential mappings that you will set up in the Secure Store but getting the same error.

Troubleshooting done:

1)   I made sure that the credentials that i set in the secure store have at least db_reader access to the database.

2)   Also ensured the user making the request is a part of members group for the target application.

3)   Chekced the ULS logs and did not find anything relevant.

4)   Suspecting that there is some sort of firewall or VPN issue but, I am not sure how to proceed?

5)   Tried with different account rather than system account to ensure it reflects the same set of results.

6)   Referred the following articles again n again to make sure everything set up correctly but did not yield any results!

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

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

Thanks to Fabian Williams and Marc Anderson for the valuable articles:

http://sympmarc.com/2013/04/10/setting-up-bcs-and-the-secure-store-service-in-sharepoint-2010

http://fabiangwilliams.wordpress.com/2010/04/16/how-to-create-configure-consume-sharepoint-2010-secure-store-in-business-connectivity-services

What Resolution we have applied:-

We have created a SQL Account with SQL authentication +

Connect with impersonated custom identity and the issue has been resolved. See this useful post SharePoint 2010 using BCS with SQL Server database by Arjan Fraaij.

Reference:

1)   http://technet.microsoft.com/en-us/library/ee806889.aspx

2)   http://technet.microsoft.com/en-us/library/ee806866.aspx

Product applies to:

SharePoint Server 2010

Not able to open office documents from SharePoint

Let me describe the problem in details-

-I can open the documents from my desktop

-I can save the documents to desktop by means of SharePoint site

-But if i tried opening documents from the SharePoint site directly then I can’t open it and getting filename error message box.

-Tried opening the document in Mozilla Firefox and it works fine.

-Tried opening the document in Google chrome and it works fine.

-Now it’s clear that the problem is with the IE only. Let me tell you that I am not using 64-bit IE but using 32-bit version only!

-Tried clearing the cache and cookies in IE but same problem.

-Tried adding the site in trusted zone but same problem.

-Checked with other office documents like MS Excel, PowerPoint but same    problem.

Finally I have applied the following resolution:

1)   Run one of the Office 2010 application

2)   Click on File menu, and select Options.

3)   In the “Options” dialog, select Trust Center in the left pane.

4)   Click on Trust Center Settings in the right pane.

5)   Select Protected View in the left pane of “Trust Center” dialog.

6)   Disable any of all of the protected view options as below by uncheck the check boxes:

·         Enable Protected View for files that fail validation

·         Enable Protected View for files originating from the Internet

·         Enable Protected View for files located in potentially unsafe locations

·         Enable Protected View for Outlook attachments

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

New/Upload/Actions/Settings are not visible in library

Common FAQ’s:

1)   How To See The "New", "Upload", "Actions," And "Settings" Menu Buttons In A Folder

2)   New / Upload / Actions / Settings / View menus on a document library are hidden

3)   New/Upload/Actions/Settings are not visible in library

4)   Drop-downs no longer showing up in a document library for New, Upload,

5)   Customize the menu bar of a document

6)   How to remove [new, upload, actions, settings] from document repository Actions or Settings

Simple and easy resolution for all the above mentioned FAQ’s:

1)   Click on edit page option, select that library web part, and click on Modify shared web part.

2)   You will get a box to edit different options in right side.

3)   Under toolbar type right now it must showing Summary Toolbar or No Toolbar, so just change it and makes it Full Toolbar.

4)   Click Apply and Ok.

5)   Exit edit mode and you will get all your options back.

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