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

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.

Product Applies To:
- SharePoint 2010
- SharePoint 2013

How to create a subsite in SP2010

Subsite is an integral part of site collection. There are several uses of subsite for which you can deal with as well as manage almost the same set of operations that you can do from the top level site.

Many organisations have some security policies and they don’t permit complete leverage to the owners to manage the complete site collection but one thing is very good that at list they can create multiple subsites as per their requirements.

Today’s topic is based on the same and would like to share this basic information with all of you so that there would not be any confusion in creation the subsite.

Here are the details:

-Open the website on which you are dealing with

-site actions

-site settings

-site administration

-sites and workspaces

-Create

-Enter the title, URL, select the appropriate template and click OK.

By this way you can create a subsite in an easy without being dependent on others / without referring any article or document/ without asking for help from anybody/ without taking any training.

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

Unexpected error while creating a Business Intelligence Center site - SharePoint 2010

Hello Guys,

Today I am going to share one more interesting issue and troubleshooting steps so that it would be helpful to all of you.

Present environment entities:

-SharePoint server 2010

-SQL Server 2008 R2

-Windows 7 Operating system

-Internet Explorer 7

Problem description: We are trying to use the performance point in SharePoint so one of the basic need is to create a site with BI template i.e. business intelligence

-We opened our site collection

-site actions

-site settings

-site administration

-sites and workspaces

-provided site name, entered the appropriate URL, selected the required template i.e. business intelligence template and clicked OK

-as soon as we clicked OK then we got the following error message

Error Message:

An Unexpected error has occurred

Correlation ID

Date and time

Troubleshooting Done:

-Tried creating different site using different template under the same site collection- it works

-so one thing is sure that problem is with creating a BI template site.

-checked numerous site collection features

-activated performance point services at the site collection level
-checked the SharePoint logs and found the following:

Publishing Feature activation failed. Exception: System.InvalidOperationException: The SharePoint Server Publishing Infrastructure feature must be activated at the site collection level before the Publishing feature can be activated.    

From the above, it’s very clear that what needs to be done to make it working.

Resolution:

Activated Publishing infrastructure at the site collection level

-site actions

-site settings

-site collection administration

-site collection features

-activated Publishing infrastructure feature

Please let me know in case of any queries/questions so that we can discuss and proceed towards the resolution, Thank you.

SharePoint master page css styles not showing for users other than site administrator- SharePoint 2010

Today I face one tricky problem in SharePoint 2010.

When I login through site administrator then CSS which I apply on master page work fine,

But when I login through other users CSS effects are not visible on master page.

Error Message:

SharePoint master page css styles not showing for users other than site administrator.

Problem Description:

        This usually happens when the CSS file or master page is not published or approved yet or it may be Check-In.

•  After system administrator login, Menu Bar from Master page look like this.

•  After normal user login, Menu Bar from Master page look like this.
•  Here CSS is not apply.

Resolution:

To Approve Master page Follow below steps:

1.             Open the SharePoint Designer using System Administrator Account.

2.             From Site Object select Master Page

3.             Select your default Master page. (E.g. V4.master)

4.             On “Site Page Gallery”, see “View” section and that click on “Approve/reject. Items” view.

5.             You will see the view is “Group By” by “Approval Status. (E.g. Draft, Approved) 

        Basically Approval Status is divided into 4 different status like Draft, Pending, Approved,Reject

6.             Then Search your default Master page in Draft section select it and send for Approval.

7.             Refresh your page, your default Master page will shown in Pending status section, Select and Approve it.

8.             Finally default master page get approved by System Administrator,

          means it get publish for all user on site.

Product Applies To:         SharePoint Server 2010

Feel free to revert in-case of any query... 

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.

Document set in sharepoint 2010

Normally banks will maintain customer’s information. They will provide customers basic info, internet banking, mobile banking, debit card facilities to their customers, they maintain separate documents for each.

We will use the same feature using Document set in SharePoint 2010.

How to enable Document Sets?

Document sets by default won't be enabled in SharePoint 2010. It's a feature and has to be enabled manualy. Then document sets Content type has to be customized (if required). After that it can be attached to Document libraries. First keep all project document templates (BasicInformation document, PhoneBanking document, InternetBanking Document, Debitcard Document) ready.

Create these documents in my documents folder.

 

Login to SharePoint 2010 site -> Site settings -> Site Administration -> Site Collection Features ->

Document Sets -> Activate.

Site Settings -> Galleries -> Site Content types -> Document Set Content Types -> Document Set.

Select Document Set Settings.

Under Default Content section select the templates. Click "Add new default content" to select and upload more template documents.

Now upload the documents that u created earlier as shown below

Now we'll create new document library. If you want to attach to existing document library then skip this step.

Open the document library -> Library (Tab) -> Library Settings.

Under General Settings select Advanced Settings. We need to enable allow management of content types setting.

Under Content types Select Yes for "Allow management of content types?" and save/Click Ok.

Now in the library settings page Content types section will be shown. Select "Add from existing site content types".

Under "Select Content types" section select "Document Set" and Add. Now click Ok.

 

Repeat the same steps and add another