Data Update Job Error #1205 [...deadlocked on lock resources with another[...}

Title

The Data Update Job failed or took a longer time than usual to complete, this can be observed in the Alert List in Snow License Manager or in the Data Update Job section of the Snow Management and Configuration Center

To find the relevant error from the Data Update Job run the below query in SQL and match the date of the error with the date of the failed Data Update Job:

select * from SnowLicenseManager.dbo.tblErrorLog
order by LogDate desc

The following error is displayed in tblErrorLog:

Error #1205 in procedure ### line #. [Transaction (Process ID #) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]

Environment

Snow Inventory 3.2/5.x
Snow License Manager (SLM) Version 7.x/8.x

Analysis

The system requirements for the SQL server are met as per Snow System Requirements , if they are not then this could be the cause. This is a one-off occurrence, this error hasn't appeared many times

Resolution

Ensure there is nothing scheduled to run at the same time as the Data Update Job on the SQL server. This is probably safe to leave and the Data Update Job will run successfully in the following run.

Cause

There was a deadlock in the database too many resources were being consumed at the same time.
This is likely due to something else running at the same time as the Data Update Job causing it to fail or run longer.
This could be a backup or a maintenance job was running at the same time on the database.

Was this helpful?

Support Hub

Product

Snow License Manager

Visibility

Guest

URL Name

DataUpdateJobError1205deadlockedonlockresourceswithanother-v2

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

Products	Region	Phone Numbers
FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield	North America *	+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America)
	Europe *	+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe)
	Japan *	+81 3-4540-5335 (select option 2)
	Australia *	+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics) Compliance Intelligence	Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.

Environment

Analysis

Resolution

Cause

Related Articles

Please wait...

Case id: 00001065