SSIS 2012 package execution fails - create_execution timeout error 27195.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS 2012 package execution fails -...

SSIS 2012 package execution fails - create_execution timeout error 27195.

Rate Topic

Display Mode

Topic Options

Author

Message

greenantim

Posted Monday, March 04, 2013 8:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 7:21 AM
Points: 138, Visits: 195

Hi,

I've just upgraded my SSIS packages from SQL2005 to SQL2012 and I'm using SQL Agent to execute the pacakges. The jobs are failing about 20% of the time with a timeout error. I ran a trace to see what was causing the problem and the error occurs in the SSISDB.catalog.create_execution procedure when it calls sp_getapplock.

EXEC @lock_result = sp_getapplock
@Resource = 'MS_ISServer_Create_Execution',
@LockTimeOut= 5000,
@LockMode = 'Exclusive'

The timeout occurs in sp_getapplock when it calls sys.xp_userlock, the error number is 27195.

exec @result = sys.xp_userlock 0, @dbid, @DbPrincipal, @Resource, @mode, @owner, @LockTimeout

I have 11 packages that are all executed every minute so I suspect that this is 'causing' the problem. I had no issues when I execute 11 packages concurrently in SQL2005 or SQL2008.

Has anyone run into this problem? Do you have any idea how I can prevent this error other than scheduling the packages to run less frequently?

Thanks,

Tim

Post #1426287

« Prev Topic | Next Topic »

Permissions