Solved

CDG-01170

Posted on 2004-09-01
4
534 Views
Last Modified: 2013-12-11
CDG-01170 when I generate some modules migrated from 6.0

Oracle Designer 6i
Oracle Developer 6i with patch 1 installed

We have table A, B and C. Table C is a child table of parent table A and B. The 2 Fks of table C are part of a mandatory arc.

If you try to generate a module having the master-detail components "A and C" or "B and C" you will get error CDG-01170.

We have many modules like that, migrated from Oracle Designer 6.0. There were no problems in Oracle Designer 6.0.

In Oracle Designer 6i I need to remove the arc to make it works.

Is this a bug or a new behavior ? We need to know before performing the official migration to 6i.
0
Comment
Question by:krishbest
  • 2
4 Comments
 
LVL 1

Expert Comment

by:bestoracleexpert
ID: 11951717
Hi,

You cannot have mandatory ARC relationship, the FKs should be optional. Check the FK property in the child table.

Tried this steps,

Designer 6.0 ,

1. Created P1 and P2 tables with child CH1 table,
P1 and P2 have arc relationship with CH1. set the validate FK =client,

2. Created form module based on P1 and CH1 ,
Generated form based on default template/olb and default settings,
This generated fine and was able to insert into CH1 table,

3. Migrated the application into 6i,
No discrepencies found,
Was able to generate the form based on default template/olb and the form behaved the as in 6.0 ,

Didnot get CDG-1170 error in 6i,

Confirm if I am missing something,

There are no problems logged on this issue using ARC and 6i is expected to behave the same as in 6.0 ,


0
 

Accepted Solution

by:
ramaswamymorla earned 130 total points
ID: 11963735
Hi,

You cannot have mandatory ARC relationship, the FKs should be optional. Check the FK property in the child table.

Tried this steps,

Designer 6.0 ,

1. Created P1 and P2 tables with child CH1 table,
P1 and P2 have arc relationship with CH1. set the validate FK =client,

2. Created form module based on P1 and CH1 ,
Generated form based on default template/olb and default settings,
This generated fine and was able to insert into CH1 table,

3. Migrated the application into 6i,
No discrepencies found,
Was able to generate the form based on default template/olb and the form behaved the as in 6.0 ,

Didnot get CDG-1170 error in 6i,

Confirm if I am missing something,

There are no problems logged on this issue using ARC and 6i is expected to behave the same as in 6.0 ,
0
 

Author Comment

by:krishbest
ID: 11963751
Can you tell me a test case?
0
 

Author Comment

by:krishbest
ID: 11963759
Can you tell me a test case?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query question 8 93
make null the repeated levels 2 31
Creation date for a PDB 5 39
Toad 12.10 Enterprise visual interface 4 22
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question