ERROR when running SSRS subscription (SQL Agent job)
this is permission issue.... I recently resolved the same issue by changing the permission to that proxy account. check this ... http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/0288216e-73dd-43cb-a1fb-1bee3184f1ff let us know your observation.... Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
June 12th, 2012 8:03am

Hi, it wasn't such case but thanks anyway. I have solved my issue by deleting RunID property value of all EXECUTE SQL AGENT JOB tasks from configuration table and it works fine now.
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2012 10:37am

Hi, I have package, which in one of it's way runs few report subscriptions () from SSRS. It works on my machine from BIDS, but when I run it on server, it says error Code: 0xC0014054 Source: Run SSRS subscription Description: Failed to lock variable "RunId" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created." Similar error is for other subscriptions, that are run by package. Proxy User which run package has sysadmin rights. Thanks a lot
June 15th, 2012 7:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics