Pending execution

Question

From this morning, one of our main SSIS jobs started to always return fail when executed. When we check in the log, it seems that all execution of the job stacked with the status "Pending execution."

We are using this SQL Server version:

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
Dec 28 2012 20:23:12 
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

We have tried several things and are now out of ideas.

We've read the connect: http://connect.microsoft.com/SQLServer/feedback/details/629684/ssis-denali-need-a-way-to-recover-perpetually-pending-executions.

We restarted the MSSQL server and we still getting the same issue.

Has anyone experienced this behavior before? If yes, how did you solve it?

Thank you, Sebastien

Solution 1

We open a case with Microsoft. The solution was a security issue probably related to a GPO on the network.

We reassign the user rights of:

- Act as part of the operating system
- Adjust memory quotas for a process 
- Bypass traverse checking 
- Log on as batch job
- Log on as a service 
- Replace a process-level token 

Everything run perfectly now.

Thanks!

Solution 2

I had the same problem here, turns out my user got his permissions removed by the infrastructure guys.

it's all about permissions.