Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

CDG-01170

Posted on 2004-09-01
4
Medium Priority
?
550 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 520 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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
This video shows how to recover a database from a user managed backup

609 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