Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Posts Tagged ‘error’

BCS Error – Access denied by Business Data Connectivity

Posted by Paul on January 23, 2016

You will get the following error while first time configuring BCS.

· Access denied by business data connectivity.

image

Solution

Following would be the solution.

Open Central Administration > Manage Service applications > Click Business Data Connectivity Service.

image

In the appearing page click on the Set Metadata Store Permissions ribbon item.

image

You will get the following page. Here do the following:

· Enter Everyone and click Add button

· Check all the permissions listed below

· Check the Propagate Permissions too

Click OK button.
image

Now retry your BCS List in SharePoint.

Summary

In this post we have explored a common error while configuring BCS & steps to resolve it.

Advertisements

Posted in SharePoint, SharePoint 2013 | Tagged: , , | Leave a Comment »

BCS Error – Login Failed for User

Posted by Paul on December 27, 2015

You will get the following error while first time configuring BCS.

Error

Message from External System: ‘Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’.’.

image

Solution

Following would be the solution.

Open SharePoint Designer. Go to External Content Types > Open BCS item > Click Connection Properties button.
Choose the Authentication Mode as BDC Identity as shown below.

image

Save changes & Retry opening your BCS List.

Summary

In this post we have explored a common error while configuring BCS & steps to resolve it.

Posted in SharePoint, SharePoint 2013 | Tagged: , , | Leave a Comment »

BCS Error – AuthenticationMode RevertToSelf

Posted by Paul on October 18, 2015

In this post we can examine a common error while configuring BCS for SharePoint 2013.

Error

You will get the following error while first time configuring BCS.

image

Solution

Following would be the solution.

You need to update the property RevertToSelfAllowed at Service Application level.

image

You can use PowerShell to update this.

image

Run the following code.

$bcs = Get-SPServiceApplication -Name “Business Data Connectivity Service”

$bcs.RevertToSelfAllowed = $true;

$bcs.Update();

Now retry opening your BCS List. The error should disappear.

Summary

In this post we have explored a common error while configuring BCS & steps to resolve it.

Posted in SharePoint, SharePoint 2013 | Tagged: , , | Leave a Comment »

Ensure Services are Running

Posted by Paul on April 15, 2015

SharePoint Apps requires the following Services to be running:

  1. App Management Service
  2. Subscription Service

Ensure Services are Running

You can open Central Administration > Manage Services link as shown below.

image

In the appearing page, ensure the following services are Started.

image

image

If they are not started, click the Start link to start them.

Note: If any of the services are not running, you will get the following error message.

“The Subscription Settings service and corresponding application and proxy needs to be running in order to make changes to these settings”

image

Posted in SharePoint, SharePoint 2013 | Tagged: , , , , | Leave a Comment »

JavaScript Cross Domain Issue in App Part

Posted by Paul on March 17, 2015

In this article we can explore the JavaScript cross domain issue while using App Parts.

Scenario

Following is the scenario:

1. You have a page with a JavaScript method

2. The page have an App Part too which displays from a PHA application

3. App Part need to invoke the JavaScript method in page

4. Due to cross-domain issue the App Part cannot invoke the parent page’s method

App Parts are rendered in IFrames. The scenario is depicted below:

image

Security Aspects

By default SharePoint prevents cross-domain script calls to avoid following security vulnerabilities:

1. An IFRAME code can manipulate the parent page’s HTML DOM objects

2. An IFRAME code can unwantedly invoke parent page’s script methods

image

Please note that the cross-domain issue won’t occur if the page & IFRAME page happens to be in the same SharePoint library. In our case the IFRAME content is an App Part which is coming from an externally hosted PHA application.

Solutions

Following are the solutions possible here:

1. Use Allow Framing control in the page

2. Use SP.RequestExecutor wiring

3. Use JavaScript Post Message functionality

Here I would like to show the JavaScript Post Message functionality.

JavaScript Post Message

The window.PostMessage() method allows safe communication across cross-boundary pages. Here the invoker is passing a message string to the target. The target may choose to process or ignore the message.

Implementation

For simplicity I am avoiding creating the PHA application. I would like to show the core functionality. Create a new page in SharePoint.

Add a content web part & insert the following code into it. (See parent.html)

function parentmethod()

{

alert(“Parent Method Invoked!”);

}

window.onmessage = function(e)

{

if (e.data == ‘ok’)

{

parentmethod();

}

};

/SiteAssets/frame.html

The code above performs the following:

1. Create a method named parentmethod() which displays an alert message

2. Create a message listener method for any incoming messages

3. Create an IFRAME displaying the child page

Now you need to upload the following content to the Site Assets library. Name it as frame.html. (See frame.html)

<input type=”button” value=”Click Me to invoke Parent Method”

onclick=”parent.postMessage(‘ok’, ‘*’);”>

</input>

Save changes & your page looks like below now.

image

Click on the button & you should be able to see the message box shown below.

image

Following is the functionality summary depiction.

image

This resolves the cross-domain script call issue.

References

https://msdn.microsoft.com/en-us/library/office/fp179921.aspx

Summary

In this article we have explored cross-domain issue of App Part and a Solution for it. The scripts are added to the article.

Posted in SharePoint, SharePoint 2013 | Tagged: , , , | Leave a Comment »

Excel Error :: This workbook cannot be opened..

Posted by Paul on December 28, 2014

While working with Excel Services we might often get an error shown below:

This workbook cannot be opened because it is not stored in a trusted location.

image

Problem

The location of excel file (library) may not be a trusted file location.  You can have to add the library location to the Trusted File Locations through SharePoint Central Administration.

 Solution

Central Administration > Service Applications > Excel Service Application > Trusted File Locations for this.

image

Create a new item with http:// as the string.

image

Check the Children Trusted label and Save the item.  Your new item will look like  below.

image

References

http://technet.microsoft.com/en-us/library/jj219698%28v=office.15%29.aspx

Summary

In this post we have explored a common Excel Services error scenario & solution.

Posted in SharePoint, SharePoint 2013 | Tagged: , , | Leave a Comment »

Search Error: The content for this address was excluded by the crawler because this item was marked with a no-index meta-tag. To index this item, remove the meta-tag and recrawl.

Posted by Paul on April 29, 2014

While indexing a SharePoint site, I encountered the following error:

The content for this address was excluded by the crawler because this item was marked with a no-index meta-tag. To index this item, remove the meta-tag and recrawl.

Solution

If the mentioned URL is a Document Library > Change > Advanced Settings >

Allow items from this document library to appear in search results > To Yes

image

If the mentioned URL is a Site > Change > Site Settings > Search and Offline Availability >

Allow this site to appear in search results? > To Yes

image

After making the changes, Go to Central Administration > Service Applications > Search Service Application > Content Sources > Start Full Crawl

Problem Solved!

Posted in SharePoint, SharePoint 2013 | Tagged: , , , | Leave a Comment »

How to create Team Site under Publishing Site?

Posted by Paul on February 18, 2014

In this article, I will take you through the quick-tip of activating Team Site under a Publishing Site.

Problem

When we create a Publishing site template, the non-publishing site templates are not available for site creation.

image

When we choose the New Site option, we can see only Publishing Site templates.

image

How to get back the other templates like Team Site?

Solution

Open Site Actions > Site Settings

image 

Choose the Page layouts and site templates link.  In the appearing page choose Subsites can use any site templates option.

image

Click the Ok button to save changes.

Now you will be able to see all the templates in the New Site dialog box.

image

Problem is Solved now.

Root Cause

There is an option in the Site Settings which prevents seeing the other site templates.

Underlying Reason

While creating site collection, the root site is created using the selected template.  Each site collection have a root site & we can have sub sites underneath.  Each site can be of any available template.

Summary

In this article, I will take you through the quick-tip of activating Team Site under a Publishing Site.

Posted in SharePoint, SharePoint 2010 | Tagged: , , , | Leave a Comment »

SharePoint 2010 > MS Word > New Document > Save Dialog > ‘Not Showing’ Document Library

Posted by Paul on September 26, 2013

Problems

For the past 2 years, I was seeing following problems reported by client.

  1. From SharePoint 2010 the user opened a document library & clicked on the ‘New Document’ toolbar item.  Microsoft Word was launched & while using the Save command, the original document library is not listed.  Instead a local folder being shown.
  2. From SharePoint 2010 the user opened a document in edit mode.  But while using the save command, it is prompting for save dialog, instead of saving automatically to SharePoint document library. 

Under the Hood

SharePoint rich client side features like open in Explorer, save directly to web server etc. are provided through WebDAV which represents Web Distributed Authoring and Versioning.  more

The client operating system should be running the WebClient service to enable this feature.

Solution

A typical set of solutions should be applied one-by-one to address the problem.  You can start with following.

  1. Internet Explorer Ensure you are using Internet Explorer 32-bit version.  If not start the appropriate version from start menu.
  2. Office Version Ensure you have a compatible MS Office version.  Office 2010 32 bit is best compatible with SharePoint 2010.
  3. Trusted Sites In the Internet Explorer Security Settings, ensure you have add the site url to trusted sites list.image 
  4. WebClient Open run window > services.msc & ensure WebClient service is running.  (If you are using server operating system as client, you need to install the Desktop Experience role to find WebClient service)
  5. Word Trust Center Open Microsoft Word > Options > Trust Center > Trust Center Settings.  Uncheck the 4 check boxes.image
  6. Install Patch Some client operating system requires a patch for the web folders to function properly.  You can download this from here.

Note

After each step, please restart the browser & test.

Posted in SharePoint, SharePoint 2010 | Tagged: , , , , , , , , , | Leave a Comment »