Server Site Dependencies Common Issue After Upgrade

Event ID 6398, Event ID 7043, Event ID 2137, Event ID 7362, Event ID 57, Event ID 5586, Server Site Dependencies Common Issue After Upgrade

http://social.technet.microsoft.com/wiki/contents/articles/15302.event-id-6398-event-id-7043-event-id-2137-event-id-7362-event-id-57-event-id-5586-server-site-dependencies-common-issue-after-upgrade.aspx?Sort=MostUseful&PageIndex=1

Microsoft SharePoint Foundation Subscription

The Microsoft SharePoint Foundation Subscription Setting service is one element of a concept known as multi-tenancy in SharePoint 2010.  The service provides a means of creating and managing logical groups of site collections based on the need to share settings, features and service data.

         Service provides a means of creating and managing logical groups of site collections based on the need to share settings, features and service data. 

How to start it

1.     The service “Microsoft SharePoint Foundation Subscriptions Settings Service” is stop

2.     Start service “Microsoft SharePoint Foundation Subscriptions Settings Service” by Open Management Shell input the script below

<# Start Microsoft SharePoint Foundation Subscriptions Settings Service #>

Get-SPServiceInstance | where{$_.GetType().Name -eq “SPSubscriptionSettingsServiceInstance”} | Start-SPServiceInstance

3.     Service “Microsoft SharePoint Foundation Subscriptions Settings Service” is started

Get-SPServiceInstance | where{$_.GetType().Name -eq “SPSubscriptionSettingsServiceInstance”} | Start-SPServiceInstance

For more Go to

http://www.microsofttechnology.net/2013/04/sharepoint-2010-microsoft-sharepoint.html

Fusion Charts Free for SharePoint (FCFS) provides a set of 22 different charts (2D & 3D) that integrates easily into your SharePoint environment (WSS 3.0 / MOSS 2007 / Sharepoint Foundation 2010 / Sharepoint Server 2010).

FCFS provides you a powerful way to display very nice looking charts into SharePoint with minimum effort.

Fusion source

Main Features

• Very nice looking charts (see below)
  
  
• 1 WebPart to display directly charts from SharePoint Lists (no coding)
  
  
• 1 WebPart to display charts from XML input (very flexible)
  
  
• Can export data to CSV or XML
  
  
• Easy installation and deployment
  
  
• Compatible with Sharepoint Foundation 2010 & Sharepoint Server 2010 (manual deployment, see 2.0 release)
  
  

  For picture gallery
  
  

  Fusion gallery
  
  

First we need to add the solution then deploy it

Open the sharepoint power shell then run the following to add the solution

Add-spsolution “path of solution”

Then go to central admin farm solutions choose the solution fusionchartssharepoint.wsp

Then doploy the solution 

Choose now and choose the web application you want to deploy on

Then go to your SharePoint site

Site actions site settings

Site collection features under site collection administration

Search for the fusion charts SharePoint then activate 

Site action edit page

Insert web part choose fusion chart

Chart from list And chart from xml as a test 

You can edit the web part and chose the chart type you need

In the edit web part go to fusion charts add the name of the list to be displayed

And the name of the columns

At the end you will get the charts

Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”

This resulted from the fact that apparently the Business Data Connectivity Service wasn’t passing the current user’s credentials to access the external data, although the “Connect with User’s Identity” had been selected on the external content type creation.

Problem

Pass through authentication not working for BCS on a WebApplication which is Claims based and using Kerberos.

While you try to access the External List based on User’s Identity  you received the following error

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

PreReq

In this post I will talk about the reason and what are the different workarounds for this issue. I will not be discussing the steps of how to create Web Application in Kerberos or how to set up SPN

Reason

For Service Applications which are not claims aware have the ability to utilize claims to windows token service to convert Claims token. At this time BCS does not leverage C2WTS. More details can be found in the following Guide

http://download.microsoft.com/download/B/B/F/BBF0C6F3-6E36-4979-8C43-DE165AD7AE34/SP2010%20Kerberos%20Guide.docx

Workaround 1 –  Revert to Self (BCS Authentication)

By Default Revert to Self is disabled. We will need to run following CMDlets from PowerShell to enable it

Get-SPServiceApplication

#Copy the ID of BCS Service Appliction

$bcs = Get-SPServiceApplication -ID “BCS ServiceApp ID”

$bcs.RevertToSelfAllowed = $true

$bcs.update()

PS C:\Users\SPSadmin> Get-SPServiceApplication

$abc = Get-SPServiceApplication –id ID

PS C:\Users\SPSadmin> $bdc.RevertToSelfAllowed = $true

PS C:\Users\SPSadmin> $bdc.Update()

Afterwards, restart the Business Data Connectivity Service and the list should be working fine.

We will need to modify External Content type by using SharePoint designer and have it use BDC Identity

Select BDC Identity under Default and Client TAB and click on OK.

Now it will let all the users browse to the external list.

Note – Whenever end user brows to the external list, it is the BCS AppPool account which is used to pull the data and not the User’s Identity. Please ensure that BCS App Pool have permissions on the database.

Now it will use the user account which is assigned to the Apppool to connect to SQL

So make sure to give it permission on SQL

References:

http://blogs.technet.com/b/harmeetw/archive/2011/08/28/getting-login-failed-for-user-nt-authority-anonymous-logon-when-browsing-external-list-on-a-claims-kerberos-web-application.aspx

http://blog.ozzie.eu/2012/04/sharepoint-2010-bcs-login-failed-for.html

SharePoint 2010: Connecting to SQL Server Using the External Content Type Feature

Prerequisites:

• Sql Server 2008 R2.
• SharePoint 2010 Server.
• SharePoint 2010 Designer.

Step 1: Browse the site created by you > Select ‘Site Actions’ and select ‘Edit in SharePoint Designer’. This will start the SharePoint Designer.

Step 2: SharePoint 2010 Designer now shows the Site Information. From the left side pane, select ‘External Content Types’ as below:

This step will retrieve the External Content type.

Step 3: To create a new ‘External Content Type’, click on ‘External Content Type’ in the Top left corner of the Ribbon as below:

This will show the window from where you can set the External Content Type Information. Here in this window, you can set the following Information:

1. Name of the External Content Type Information

• Display Name.
• Office Item Type, this is a List type e.g. Contact, Task, Post, Appointment and Generic List.
• External System, using which the Data Source can be discovered, in this case our Data Source will be Sql Server.

2. External Content Operations: This is used to define Operations which can be performed on the External Data Source e.g. Create, ReadList, ReadItem, Update and Delete etc.

Step 4: Set the External Content Type information as below:

Now Click on the ‘Click Here to discover external Data sources and define operations ‘ as shown above, you will get the following window using which you can add connections to external content type:

Click on ‘Add Connection’. You will see a window using which you can select ‘External Data Source type’ > Select Sql Server as below:

After clicking OK, you will be asked to enter Database information as shown below:

Click on ‘OK’ and you will get the Database Connection in Data Source Explorer. Expand it and locate the ‘Customer’ table as shown below:

In this step, you have completed the Connection part.

Step 5: Now after establishing the connection withan External Data Source, it’s time for us to define possible operations on the Data Source. So right click on ‘Customer’ and select all Operations from the Context menu as shown below:

The above image shows self-describing operation types. After selecting ‘Create All Operations’, the wizard will start as shown below. Please read the Instructions.

Click on ‘Next’. The next window will show the Parameter Configuration as shown below. Note: Here you can ignore the Warnings.

Click on ‘Next’. Here it is optional for you to set filter parameters which allows you to set the size of the result set. Click on ‘Finish’. The following operations will get generated as shown below:

Step 6: Once it is done, click on the ‘Save’ button on the top-lfet.

Step 7: Now to create the List, click on ‘Create List & Form’ button on the Ribbon

After clicking on ‘Create List & Form’, you will see a form where you can enter List name and other information as shown below. If you want to create an InfoPath form, you can check the CheckBox ‘Create InfoPath Form’

Step 8: Now go back to the Web Site and Refresh. You will see the ‘CustomerInfoList’ in the Quick Launch window as shown below:

Step 9: Click on the ‘CustomerInfoList’ and you will get the following result:

You must be wondering why did this happen? What does the error ‘Access denied by Business Data Connectivity’ mean? The reason for this error is that, BCS is an external web service which is hosted on IIS and to establish connectivity between the Service Hosted on IIS and a database, an explicit authorization is required. So now we need to do some configuration here.

Step 10: Open SharePoint 2010 Central Administration and Select Application Management. From ‘Application Management’ > select ‘Service Applications’ and click on ‘Manage Service Applications’. You will get a list all the services which are running. From this page, click on ‘Business Data Connectivity Service’ > you will get ‘Service Application Information’ as shown below:

Step 11: Select the ‘CustomerListInfo’ and click on ‘Set Object Permissions’ from the Ribbon. You will get a window for Setting Object Permissions. Add the user info as shown below:

object-permission

Click ‘OK’

Step 12: Now go back to your site and click on the CustomerInfoList from Quick Launch. You will get the following result:

Result

From here, you can perform ‘Create’, ‘Update’, ‘Delete’ and ‘Read’ operations.

Reference

http://www.dotnetcurry.com/ShowArticle.aspx?ID=794