My Oracle Support Banner

Error During Delivering Dev Workspace To Integration Workspace , .S_RR_WORKFLOW' with unique index 'S_RR_WORKFLOW_U1 (Doc ID 2472094.1)

Last updated on FEBRUARY 04, 2019

Applies to:

Siebel CRM - Version 17.5 [IP2017] and later
Information in this document applies to any platform.

Symptoms

On :  17.5 [IP2017] version, Siebel Workflow

Error during delivering Dev workspace to integration workspace  



ERROR
-----------------------

This operation is not allowed when there are no records displayed. Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)".

Cannot insert duplicate key row in object 'dbo.S_RR_WORKFLOW' with unique index 'S_RR_WORKFLOW_U1'. The duplicate key value is (1-xxxx, Service Agreement Doc Generation - Synchronous, 1-xxxxx,



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.open tools and create one workspace
2 modified 'Service Agreement Post Approval - Awaiting Publication' workflow version 29 in dev workspace and . Then i tried to deliver my dev workspace but getting unique key violation error .
3.then published workflow from siebel tools4 . deliver dev workspace

Changes

 

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
References


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