My Oracle Support Banner

Initial Deployment Fails with SQL Server Deadlock on Insert into DCS_ROOT_CATS table (Doc ID 1644307.1)

Last updated on NOVEMBER 07, 2018

Applies to:

Oracle Commerce Platform - Version 9.4.0.4 and later
Information in this document applies to any platform.

Symptoms

The initial deployment failed with the following error:

 

Changes

You want to carry out the initial catalog data deployment on a new schema.
This article is irrelevant when not carrying out the initial deployment on this environment.

This has only been observed on MS SQL Server database environments.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Allow Transient Error Retries
 Temporarily relax table constraints
 Prevent Parallelism During Deployment
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.