Error with multiple BCS Query to the same Entity

[jackgelo]

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:

Anyone has any idea why this happen?

Thanks for you help!

Giacomo

[#2]

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

[jackgelo]

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

[#4]

That's good idea. Thanks for the response.

[greenawayr]

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

[#6]

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.

[greenawayr]

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.

[bradleyl]

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