Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
305 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 6 57
DataTables Form Input issue. 3 92
How can I detect any broken links on various pages on SP Online on O365. 4 58
JavaScript waiting 14 84
A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

839 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