Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synchronize Domain constraints

mmagan-OracleJul 11 2021 — edited Jul 14 2021

I have a domain defined with a check constraint, defined as a Generic Constraint:
%COLUMN% = upper(%COLUMN%)
I have a table with two columns based on this domain.
When I run "Synchronize Data Dictionary with Model", the following DDL is consistently generated:
ALTER TABLE pm_data_mart.stg_worklogs DROP CONSTRAINT stg_worklogs_ck_parentkey;
ALTER TABLE pm_data_mart.stg_worklogs
ADD CONSTRAINT stg_worklogs_ck_parentkey CHECK ( parentkey = upper(parentkey) );
I.e. one of the two constraints is recreated. Is this a bug?
(Version 21.1.0.092 running against 19c database)

Comments

BluShadow

Moderator Note: @rranjith I've moved your post over to the Forms forum as it doesn't relate specifically to SQL and PL/SQL where you posted it.

Enable the Java Console and its tracing. Look closely at the output. Likely you should see why it is failing.
image.pngLook for entries like this:
basic: Loaded image: jar:http://<YOUR SERVER>/forms/java/my_icon.jar!<PATH TO IMAGE AND IMAGE FILE NAME>
If any part of that entry looks incorrect, correct it and retest.

RRanjith

@michael-ferrante-oracle I checked what you suggested. Still the issue is not resolved. Please help me to resolve it.

@rranjith I don't understand. What do you mean it didn't resolve the issue? Showing the console was not expected to resolve the problem. It is a diagnostic tool to help you find the problem. Copy the entire contents of the console to a text file then upload that text file to this thread.

RRanjith

@michael-ferrante-oracle Thanks for you reply Michael. Now Icons loaded in my application.

@rranjith In order to help others who may be experiencing a similar problem, please consider explaining what you did to identify them correct the issue.

User_Y6Y8Z

@rranjith please help ,, and share what u did i have same issue

@user-y6y8z

Read the thread and you will get your answer. You need to test like I described above to find the answer.

1 - 8

Post Details

Added on Jul 11 2021
2 comments
98 views