Welcome to the Galaxy...: SharePoint

1. BDC does not support structs that are not simple types. Using non-primitive structs will cause data loss and inconsistencies. Do not use non-primitive structs.

2. BDC does not support nested collections (for example, array of arrays or collections, where the elements of which are also collections). You can have these types, but you cannot model these types as collections. One of the levels must be modeled as a structure with the IsCollection="false" workaround.

3. BDC does not support multidimensional arrays.

4. BDC does not support dynamic programming introduced in .NET Framework 4. BDC works only with .NET Framework 3.5. However, you can use the DynamicType class, which works in a similar way.

5. BDC does not support the ICollection or IEnumerable interfaces to represent collections in data structures, as well as the generic ICollection<T>, IEnumerable<T>, and IList<T> interfaces. All collections must implement IList. This applies to data structures in input and inout parameters, and fields of external items. For the return types of method instances, such as a Finder returning multiple items, we require the return value to implement either IEnumerable or IEnumerator (except for database, where we support onlyIDataReader). BDC does not support generic versions of these IEnumerable<T> and IEnumerator<T>. So for example, for a Web service or .NET assembly, the Finder method can return an enumerator that contains customer objects; however, the customer object cannot contain an enumerable of addresses to represent the list of addresses. Also for the restrictions mentioned in this paragraph, "BDC does not support" means: It will not work if you implement only the not supported interfaces; however, it will work if you implement these not supported interfaces and the ones that BDC requires.

rdl cannot be found + PerformancePoint +Dashboard Designer: SharePoint2010/SharePoint2013

If you are facing the following error then make sure you have the following hotfix installed in your environment.

Hotfix link: http://support.microsoft.com/kb/2597076/en

OR make sure that your environment updated with the latest patch.

Let me know in case of any queries/questions, Thank you.

backup-restore in SharePoint 2010

Hello All,

I know backup-restore is a very important entity in SharePoint 2010 and is being heavily used by Administrators/Developers/IT Pros. Its my responsibility to share my thoughts on such a important topic so thats why i am sharing this by means of knowledgebase forums.

please refer the following articles and let me know in case of any queries/questions, Thank you

SharePoint 2010: Backup/Restore with PowerShell Command
http://sharepointknowledgebase.blogspot.in/2012/06/sharepoint-2010-backuprestore-with.html

Backup Restore in SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2012/06/backup-restore-in-sharepoint-2010.html

EXCEL + OFFICE + Ribbon grayed out features

knowledgebase to share the break fixing solutions as well as what kind of troubleshooting I have executed towards that specific issue. Today’s KB is based on EXCEL + OFFICE that we use on regular basis by means of SharePoint site.

Workbooks fail to load + Event 5231 + Event 5239 + Event 5240 + Error communicating with Excel Services Application + Unable to process the request = SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/workbooks-fail-to-load-event-5231-event.html

The specified file is not a valid spreadsheet or contains no data to import - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/the-specified-file-is-not-valid.html

An Excel workbook that contains a PowerPivot table is corrupted after you upload the Excel workbook to a SharePoint PowerPivot gallery
http://sharepointknowledgebase.blogspot.in/2013/09/an-excel-workbook-that-contains.html

The list cannot be displayed in DataSheet view – SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/the-list-cannot-be-displayed-in.html

Your client does not support opening this list with Windows Explorer + IE10 + Windows 7
http://sharepointknowledgebase.blogspot.in/2013/09/your-client-does-not-support-opening.html

SharePoint 2010- New Document requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater. To add a document to this document library click the Upload Document button
http://sharepointknowledgebase.blogspot.in/2013/08/sharepoint-2010-new-document-requires.html

Ribbon grayed out features (Extremely imp on day 2 day functionality)

Connect to office disabled in SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/connect-to-office-disabled-in.html

Sync to SharePoint workspace greyed out - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/sync-to-sharepoint-workspace-greyed-out.html

To export a list, you must have a Microsoft SharePoint Foundation-compatible application - SharePoint 2010 + SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/to-export-list-you-must-have-microsoft.html

Upload Multiple Documents is disabled in Document Library- SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/upload-multiple-documents-is-disabled.html

How to enable ‘New Folder’ option in document library + Custom list + New Folder disabled - SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/how-to-enable-new-folder-option-in.html

Datasheet view is disabled SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/datasheet-view-disabled-sharepoint-2010.html

Authentication provider disabled SharePoint 2010
http://sharepointknowledgebase.blogspot.in/2013/09/authentication-provider-disabled.html

"Connect to Outlook" Disabled - SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/connect-to-outlook-disabled-sharepoint.html

Open with Explorer is disabled - SharePoint 2010 and SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/open-with-explorer-is-disabled.html

Upload Multiple Documents is disabled - SharePoint 2013
http://sharepointknowledgebase.blogspot.in/2013/09/upload-multiple-documents-is-disabled_1.html

access services problem in SharePoint 2010

Access services is unable to process the request
http://sharepointknowledgebase.blogspot.in/2013/08/access-services-is-unable-to-process.html

Cannot publish access database to SharePoint 2010 Server
http://sharepointknowledgebase.blogspot.in/2013/02/cannot-publish-access-database-to.html

If you are facing this error:
There was an error in communicating with Access Database Service Access Database Service URL exception: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server

Then request you to refer the following KB:
http://support.microsoft.com/default.aspx?scid=kb;en-us;2398833&sd=rss&spid=14944

If you are facing the following symptoms:

1- Event ID: 24 Description: There was an error in communicating with Access Data Services exception: <exception description> [Session: <session ID> User: <username>].

2- Event ID: 25. Description: There was an error in communicating with Access Data Services exception: <exception description> [Session: <session ID> User: <username>].

3- Event ID: 26. Description: Unable to reach Access Data Services. [Session: <session ID> User: <username>].

then request you to check the following article:
http://technet.microsoft.com/en-us/library/ee513086(v=office.14).aspx

if you have any queries/questions then please let me know, Thank you!

How to overcome the limitation of content database size limit in sharepoint 2010?

Ultimately space is the problem and you need to add more space to the SQL Server. As you are using Express edition, very soon you will face the database size limitation. for more details- http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx

Here is another document which highlights the supported features:
http://technet.microsoft.com/en-us/library/cc645993%28v=sql.120%29.aspx

Backup-Restore in SharePoint 2013 + Backup & Recovery Tools

http://sharepointknowledgebase.blogspot.in/2013/08/backup-restore-in-sharepoint-2013.html

if you face any problems in executing any command or any error after executing the command then please let me know. I will try my best to help you as well as resolves the issue as soon as possible!

manage access request

Does "manage access request" functionality still available in SP2013?

Yes, you are right- still there!

Here are the details:
1. Open the site collection on which you are working.
2. Site actions
3. Site settings
4. Under ‘users and permissions’ section
5. Site permissions
6. Please refer the Ribbon on the top
7. Permission tools
8. Manage access requests
9. Select the checkbox ‘allow request for access’ and enter the appropriate email id as per your requirements and click OK

InfoPath Error: This session has exceeded the amount of allowable resources

Hello,

I have published an infopath form on my SharePoint 2010 site collection and getting the following error message while opening:
InfoPath Error: This session has exceeded the amount of allowable resources

Resolution is very simple.

Here are the details:
Increase the form actions in configuring InfoPath services section as mentioned below:-

Go to Central Administration of the SharePoint server.

Click on Application Management

In the section "InfoPath Forms Services"-->select Configure InfoPath Forms Services.

In the Number of Actions per Post back, enter some max value around 250 or 300 depends on your project form requirement.

Last Access date / time for site collection

How to find out dead sites?

How to find out unused sites?

How to find out the sites which has not been updated from a long time?

http://sharepointknowledgebase.blogspot.com/2014/02/last-access-date.html

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

If you are using an excel workbook with pivot in it, along with the Excess Webpart to display it. As you click on the Refresh all data connection.

It throws an error. The data connection uses windows authentication and user credentials could not be delegated. The following connection failed to refresh

Here is the resolution for this problem:

http://sharepointknowledgebase.blogspot.com/2012/05/data-refresh-failed.html

The server was unable to save the form at this time. Please try again - SharePoint 2013

SharePoint 2013 is always full of mysteries as it’s a starting time and most of the firms are doing the migration of their SharePoint 2010 environment to SP2013 platform. So it’s quite obvious it will take some time to make your farm stable!

Note:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Problem description:

We have recently done the migration from SP2010 -> SP2013 in our development environment and given access to limited number of high profile users and developers for the testing. While doing the testing, one of the developers has reported an incident mentioning he is facing some error while editing the list item. Further exploration reveals that we can’t add a new item also.

So bottom line, this error comes up while: Adding a new item in a list or at the time of editing the item

Error Message:

The server was unable to save the form at this time. Please try again.

Troubleshooting done:

1. Tried creating different list with some different template / type but same issue.

2. Checked the list in SharePoint Designer 2013 but didn't find anything relevant.

3. Checked the site settings for any customized content type but it was using default settings

4. Checked the event viewer for any critical errors but didn't not find anything

5. Checked the services console, did some try & error funda but that did the trick. Later I did some research on my “trial and error method” and understood the complete process via Microsoft articles (reference article –bottom of this page)

Resolution:

1. Go to your SharePoint Server

2. Start

3. Run

4. Type – services.msc

5. It will open the services console

6. Search for this service - SharePoint Search Host Controller

7. Restart it.

It fixed the issue and I was able to create new items as well as edit the existing items too.

Happy SharePoint once again!

Few suggestions if the above solution doesn’t work:-

1) IISRESET on SharePoint Servers

2) Restart all the SharePoint Servers

3) Enable anonymous authentication for the website in IIS.

I hope the above information works for you also! But in case of any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Reference:
http://technet.microsoft.com/en-us/library/jj219591(v=office.15).aspx

Product applies to:

a) SharePoint 2013

b) SharePoint Foundation 2013

access denied business data connectivity

Create an External Content type based on backend SQL Server Database and create an External list based on it.

Open the Site in SharePoint Designer 2010: http://portal.contoso.com

Provide username and password in the promotion for open the site

Opening the site http://portal.contoso.com by communicating with the Web service

Retrieving External Content type Report

Create new external content type: Define General Properties for External Content type

Content type name: Contact; Name Space: http://portal.contoso.com; Office Item Type: Contact; Enable offline Sync to External list

External System: Click here to discover external data sources and define operations

Add Connection

Managing Connections to external data sources and the operations for this external content type

External Data Source Type Selection: SQL Server -> Open the SQL Server Connection

SQL Server Connection: Populate the Database Server and Database name in the box

Navigate to the appropriate database (AdventureWorks) and scroll through the required table (Contact)

Table: Verify the available operations for that table

Operations for External content type means action that can be performed on the data associated with the external system -> Click on Create all Operations

Specify the parameters for the Operation

Example: Get the “Last Name” parameter-> Office property: Last Name; Check the Show in Picker box.

Filter Parameter Configuration

Add Filter Parameter: Add a Limit filter to the Query Item List Operation

Add Filter Type: Limit (Strongly Recommended to add a filter of type ‘Limit’ for this operation type)

Filter Filed: None; Default value given as “100” for the limit filter type

Save the Content type to the Business Data Connectivity Metadata Store

Create an External List for the External Content type

External List : Business Contacts ; System Instance : AdventureWorks

External List: Business Contacts Created

Set Business Connectivity Store Permissions

List and Libraries -> External List-> Business Contacts -> Open Preview in Browser

Access is being denied by Business Data Connectivity Service (Reason: There is no permission for viewing this list)

Set the permission: Open CA->App mgmt. ->Manage Service Applications-> Business Data Connectivity Service->Manage->Set Metadata Store Permissions

Add Contoso\Administrator and feed all the (Edit, Execute, Selectable in Clients, Set Permissions) permission to the user.

Propagate permissions to all BDC Models, External Systems and External Content types in the BDC Metadata Store.

Work with External Content type in the Browser: Navigate to the http://portal.contoso.com

List will display with the no permission error now

Edit Item: Edit any of the lists and include any data in the list.

Example: Data Included in one of the List

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.

SharePoint Server 2013 Licensing + Downloads + Prerequsites + Browser Support

Volume Licensing: http://www.microsoft.com/en-in/licensing/about-licensing/briefs/SharepointServer2013.aspx

Licensing How To: http://blogs.technet.com/b/volume-licensing/archive/2013/08/08/licensing-how-to-sharepoint-server-2013-licensing-changes.aspx

Difference between SharePoint Standard CAL and SharePoint Enterprise CAL:

http://office.microsoft.com/en-in/sharepoint/sharepoint-licensing-overview-collaboration-software-FX103789438.aspx

Download SharePoint Server 2013 (180 day trail): http://technet.microsoft.com/en-in/evalcenter/hh973397.aspx

Download SharePoint Foundation 2013 (180 day trail):

http://www.microsoft.com/en-in/download/details.aspx?id=35488

Available in:

1. 64-bit ISO

2. These languages: Arabic, Chinese (Simplified), Chinese (Traditional), Dutch, English, French, German, Hebrew, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish

Download SharePoint 2013 Pre-requisites:

http://blogs.technet.com/b/meamcs/archive/2012/12/26/install-and-download-sharepoint-2013-prerequisites-offline-manually.aspx

SharePoint 2013 Web browser support/ Supported web browsers:

Internet Explorer 8 or later: supported

Google Chrome (latest version): supported

Mozilla Firefox 19 or later: supported

Safari (latest version): supported

IE 6 is not supported to work with any SharePoint 2010 or later, but will work with SharePoint 2007 and before. IE 8 and below has issues with SharePoint 2013 or below. Some functionality in SharePoint 2013 requires ActiveX controls which results in restrictions to all browser versions that are not Internet Explorer with 32 bit, Internet Explorer 10 has to be in desktop mode.

Welcome to the Galaxy...

Pages

Sandboxed Solutions - SharePoint 2010

Business Data Connectivity: SP2010 + SP2013

Data Types Not Supported By the Business Data Connectivity Service