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
326 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
[X]
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
  • 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

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…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

696 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