Access denied by Business Data Connectivity - BCS - Resolved

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

Product Applies To:
- SharePoint 2010
- SharePoint 2013

SharePoint 2010: Change Regional settings in Central administration as well as at the site collection level

Regional settings plays a very vital role as the SharePoint has been 

extensively used all over the world with different languages.

So many requirements can arise such as:

-How can we set the default regional settings for the new site collections?

-How can we change the default regional settings once the site collection created?

-How can we change the default time zone?

-How can we change the default calendar?

-How can we set the alternate calendar?

-How can we change the time format? 12 hour/24 hour?

Primarily we are going to focus as how we can change the regional settings in central administration as well as at the site level.

Change Time Zone settings in Central Administration:

-Open the central administration

-Application management

-Manage web applications

-Select the appropriate web application on which you need to change the default regional settings

-General settings from the top dropdown

-Default time zone

-change it as per your requirement.

Change Regional settings at the site collection level:

-Open the site collection

-site actions

-site settings

-site administration

-Regional settings

-change any settings as per your requirements.

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.

Security token service is not available- SharePoint 2010

Security token plays an important role with respect to authentication purpose, if this stops functioning then you will start getting so many tickets regarding access as well as critical tickets which are dependent on the same as few other services are also dependent on this service i.e. security token.

Here is the Microsoft link which talks about in details on security token:

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

While doing the sanity check across all front ends, we have noticed the security token service exception in the event viewer logs with respect to one of the server.

Here are the details:

Error message: Security token service is not available.

Checked the IIS status and found all the application pools and websites were in stopped status.

Started all the SharePoint entities which were in stopped status.

Checked the rule again and it was not there in the HA list anymore.

Issue resolved, we are good now. Thank you.

Few IMP points which are essential while troubleshooting this issue:

In our case, the security token service was working initially without any issues and the farm was already built properly. But in your case, if it’s a newly built farm then it might be a hotfix issue as per this Microsoft article:

http://support.microsoft.com/kb/2493524

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

If you have any queries 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.

Also-if you have a different resolution regarding the same issue then request you to share the same so that it would be useful to other as well. Thank you.

Error in creating a SharePoint Wiki site in SharePoint 2010

Problem Description: Error in creating a SharePoint Wiki site in SharePoint 2010

Creating a subsite underneath site collection by using ‘enterprisewiki’ throws an exceptions.

Please refer the following exceptions which is a series of error messages and helpful to understand the cause behind it.

Error Messages:

Error#1: Failed to activate site-scoped features for template 'ENTERWIKI#0' in site ‘http://sharepoint2007/sites/SP2010Projects’.    a41b91e6-385b-42a9-a10f-c69e15de613a

Error#2: Failed to activate web features when provisioning site at url " http://sharepoint2007/sites/SP2010Projects" with site definition "ENTERWIKI#0"

               

Error#3: Failed to apply template "ENTERWIKI#0" to web at URL " http://sharepoint2007/sites/SP2010Projects".  a41b91e6-385b-42a9-a10f-c69e15de613a

Error#4: SPContentTypeBindingElement.ElementActivated(). ContentType '0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF39004C1F8B46085B4D22B1CDC3DE08CFFB9C' not found on web ' http://sharepoint2007/sites/SP2010Projects'.              a41b91e6-385b-42a9-a10f-c69e15de613a

Error#5: specified argument was out of the range of valid values. Parameter name:content type not found(‘0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF39004C1F8B46085B4D22B1CDC3DE08CFFB9C’).

Analysis:

Wiki template is a dependency section of Publishing Infrastructure as per the following articles:

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

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

Resolution:

Activate publishing infrastructure at the site collection level as well as at the site level.

How to do this:

Activate Publishing Infrastructure @site collection level:   

-Open the site

-site actions

-Site settings

-site collection Administration

-activate “SharePoint Server Publishing Infrastructure”

Activate Publishing Infrastructure @site level:   

-Open the site

-site actions

-Site settings

-site actions

-manage site features

-activate “SharePoint Server Publishing Infrastructure”

That’s it; your issue will be resolved.

If you have any queries 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.

Product Applies To:

SharePoint Server 2010

SharePoint Foundation 2010