My Oracle Support Banner

The Values Inserted Into The CATALOGID Column Of The CATALOG Table Are Not Unique. (Doc ID 2348360.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Documaker - Version 12.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.5 version, Enterprise Edition

ACTUAL BEHAVIOR
---------------
The Values inserted into the CATALOGID column of the CATALOG table are not unique.  Due to this issue when using a script to promote several forms and sections in quick succession using lbyproc some resources are promoted to the incorrect form or sections.

EXPECTED BEHAVIOR
-----------------------
The Values inserted into the CATALOGID column of the CATALOG table should be unique.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) To test ODEE, after installation of ODEE, use SQL Developer to confirm that there is a Unique Constraint on the DMRES_LBYC table.

2) To test ODSE, start DM Studio and create a new workspace, using either the JDBC or ODBC driver. After the workspace is created, use SQL Developer (for an Oracle DB) or SQL Server Management Studio (for a SQL Server DB) to confirm that the CATALOG table that was created has a unique index on the CATALOGID column.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue when using a script to promote several forms and sections one at a time in quick succession using LBYPROC some resources are promoted to the incorrect form or sections.

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.