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
287 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

943 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now