Solved

The workflow could not update the item in the external data source. Make sure the user has permissions to access the external data source and update items.

Posted on 2014-11-26
6
298 Views
Last Modified: 2014-12-10
We have SharePoint 2013 On-Premise. I am setup External Content Type which connects to a table in SQL database. An External List has been setup correctly in SharePoint 2013 designer which displays data from this SQL Table. The connectivity to SQL table from this external list is working correctly. I have another list which needs to update this external list via a simple workflow action. This is where I receive this "The workflow could not update the item in the external data source. Make sure the user has permissions to access the external data source and update items." error. Now all the permissions are setup correctly on the SQL table, SQL database, Set Object permissions (in BCS) and Set Metadata Store permissions. Secure Store services is also working correctly. Still no luck updating the External list from workflow.

Any hint, suggestion or has anyone resolved this
0
Comment
Question by:Snehal Rana
  • 4
  • 2
6 Comments
 
LVL 15

Expert Comment

by:colly92002
ID: 40468899
Can the user edit the BCS data in a datasheet view?

Are you using kerberos?  If not, have you configured BCS to use SQL accounts or NT impersonation?  NT will potentially be problematic because of double hop.  

Check ULS logs for more detailed error.  If it complains about anonymous user its probably a kerberos/double hop issue.
0
 
LVL 1

Author Comment

by:Snehal Rana
ID: 40469683
>Are you using kerberos?
We are using NTLM. There is Kerberos authentication present but not for the main Web Application.

> If not, have you configured BCS to use SQL accounts or NT impersonation?
No I have not tried using SQL Accounts nor NT impersonation

>Check ULS logs for more detailed error.  If it complains about anonymous user its probably a kerberos/double hop issue.
I did check ULS logs for this but will check for anonymous user

Appreciate your response
0
 
LVL 15

Expert Comment

by:colly92002
ID: 40469799
If using NTLM you must also configure Secure Store Service, which is very poorly documented and a pain to get working in my experience.

Here is a good walkthrough:
http://www.fabiangwilliams.com/2010/04/16/how-to-create-configure-consume-sharepoint-2010-secure-store-in-business-connectivity-services/

If no kerberos then I strongly recommend setting up a test connection using SQL accounts and getting that working first.  I have never got impersonation to work in a farm environment without kerberos support (beucase of the aforementioned "double hop" problem).  SQL experts may be able to suggest best practice.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Accepted Solution

by:
Snehal Rana earned 0 total points
ID: 40484205
I was able to configure this using the latest Service Pack update from Microsoft which fixes this issue.
0
 
LVL 1

Author Comment

by:Snehal Rana
ID: 40484210
I have to close this question because the resolution of the issue was provided by Microsoft Support as I have mentioned above.
0
 
LVL 1

Author Closing Comment

by:Snehal Rana
ID: 40490930
We had to involve Microsoft Support in resolving this issue. There is a Service Pack update out there which resolves the exact same issue. Below are the patches that will resolve this issue successfully:

[1] https://support.microsoft.com/kb/2767999  (this update needs to be applied first before the second one)

[2] http://support.microsoft.com/kb/2882987/en-us 

[3] https://www.microsoft.com/en-us/download/details.aspx?id=42898
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question