Solved

CDG-01170

Posted on 2004-09-01
4
524 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

762 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now