cancel
Showing results for 
Search instead for 
Did you mean: 
Automation Master
Automation Master

Error with multiple BCS Query to the same Entity

Hi,

 

I'm trying to do a workflow that queries a BCS multiple times during the execution, passing each time a different filter, so I can retrieve different information for different rows..

My first Query BCS action executes fine and it gets the values correctly but if I do a second Query BCS Action (even copying the previous one), it errors with Access Denied:

 

BCS Error.PNG

Anyone has any idea why this happen?

 

Thanks for you help!

 

Giacomo

Labels: (1)
Tags (2)
0 Kudos
Reply
7 Replies
Not applicable

Re: Error with multiple BCS Query to the same Entity

Were you able to fix this ? I have the same issue.

0 Kudos
Reply
Automation Master
Automation Master

Re: Error with multiple BCS Query to the same Entity

Hi, unfortunately I've not been able to solve this.

Because I was using BCS to read from a SQL table, I've changed my Query BCS actions to a more direct Execute SQL and I query my source in that way instead of using BCS

Reply
Not applicable

Re: Error with multiple BCS Query to the same Entity

That's good idea. Thanks for the response.

Reply
Automation Master
Automation Master

Re: Error with multiple BCS Query to the same Entity

Is there a timing issue with this? Is there a time gap between the actions?

Reply
Not applicable

Re: Error with multiple BCS Query to the same Entity

I did not want to add any time gap between actions, because the Wait Action will pause the workflow for at least 5 minutes (default timer) even though we say wait for 1 minute.

Reply
Automation Master
Automation Master

Re: Error with multiple BCS Query to the same Entity

Yes, that's down to the timer service. If it had been a "show-stopper" you could have looked at changing the timing intervals for the timer service, but that's a farm change obviously, and you have got around it.

How about the Commit Pending Changes action? I can't say for sure that it is a timing issue, but that would have been my first thought to rule out. You might also be able to find something in the ULS logs, even though there is no correlation ID, that error code would have been produced and with time and date you could investigate any further details in the logs.

Reply
Nintex Newbie

Re: Error with multiple BCS Query to the same Entity

yes, I seem to have the same problem. Querying the BCS once is fine but after that, it gives the error "Access is denied"

0 Kudos
Reply