I have a site workflow which will Query a list if any of items fallen on Today's date. And sending all items to the Team for review.
When I run the workflow manually the workflow is giving me the expected outcomes. It was scheduled to run at 9AM every day, but this scheduled run is giving us the following error: Failed to query list data. Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
We have Nintex 2013 and SharePoint with SP1.
Solved! Go to Solution.
is the user who schedule the workflow allowed to see that list?
The workflow will run as the user who has created the schedule, so he needs to access the list (or, you have to execute the query list action as the workflow owner and publish the workflow with a user with enough permission on the list)
The user who published the workflow and the one who who scheduled the workflow both are Admins. And if the same person (who scheduled the workflow) runs it manually it is succeeding. To test I scheduled the workflow and it ran successfully. Only the previous person (who is also admin) has some problem in running the workflow. Any Thoughts?
Soni - When you say the users are admins, do you mean they are "site collection administrators" or "site owners"? Is the list you are querying in the same site as the workflow? The fact that the user who schedules it does not have a problem running it manually is interesting. I don't have an answer for that.
But, Giacomo Gelosi suggested, you should put the query list action into an Action Set, and enable the "Run as Workflow Owner" setting on the Action Set. Then it won't matter who schedules it. It will always run as if you scheduled it, assuming you are the workflow owner.
We both are farm admins! And yes the list is in the same site where I'm scheduling.
One strange thing I observed is: I scheduled the workflow to run daily at 9AM, and I tested it on Friday around 1:30AM and the schedule was successful. So I changed the timing to 9AM, on Friday it went successful. But again on Saturday and Sunday I received workflow errored emails with Access Denied error. Now I'm totally confused?!!
But I will add the Action Set as you suggested and will test the scheduled run.
Note that being a farm admin doesn't grant permission to sharepoint content. Try making the the user a site owner or site collection administrator.
Sent from my iPhone
Hi, Soni Reddy, That may be an unexpected result of the merge of the Learn More space with the Getting Started space. I'm suddenly seeing lots of former questions that got turned into discussions.. I've marked this discussion as a question, however, and now the "correct answer" button has re-appeared. Hopefully I don't have to do this 4,000 times (literally). Apologies for the inconvenience. This was not a known result of merging spaces.