The Values Inserted Into The CATALOGID Column Of The CATALOG Table Are Not Unique.

(Doc ID 2348360.1)

Last updated on JANUARY 18, 2018

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms