IBM Support

Load Management fails with error: DM-DBM-0400, UDA-SQL-0564

Troubleshooting


Problem

Load Management may fail with deadlock errors on SQL Server: DM-DBM-0400 UDA driver reported the following on connection ALIAS_: UDA-SQL-0564 [Microsoft SQL Native Client]Transaction (Process ID ) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE=40001, SQLERRORCODE=1205)

Cause

This issue may occur if lock escalation is occuring on the dsb_jobnode_run table in the Data Warehouse.

Environment

SQL Server

Diagnosing The Problem

The Database Administrator will first need to confirm which table the lock escalation is occuring on. If it is the dsb_jobnode_run table, the issue can be resolved by creating a clustered index on the job_audit_id and node_id columns of the dsb_jobnode_run table.

Resolving The Problem

Create a clustered index on the job_audit_id and node_id columns of the dsb_jobnode_run table.

[{"Product":{"code":"SSCRDM","label":"Cognos Analytic Applications"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adaptive Warehouse","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4.2;8.4.1;10.1","Edition":"All Editions","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 June 2018

UID

swg21584744

Page Feedback