Re: Designer 6 error cdi-11306 How to respond?

No, you do not need to recreate the complete database, just ignore the warning
when you include the DETAILS table...
The script will have references to DETAILS table (which you could edit out), and your FK will be generated.
IFAIK, you could even just include the PK of DETAILS. Don't have V6 here, so can't
try - all from memory
:] alter head flush pool, spiderwebs;
;) done

--
Frank
Mike Dwyer <dwyermj_at_co,larimer.co.us> schreef in berichtnieuws
o3Ut5.84$wU6.18377_at_wdc-read-01.qwest.net...


> In Designer 6, I am trying to add a table to an existing database, in a


> schema that was just generated with Designer. The new table has a foreign

> key that relates it to one of the previously-created tables.

>

> When the DDL scripts are being generated, I receive error "CDI-11306

> Warning: Foreign Key 'PD_GL_DETAIL_FK' not processed because dependent

 table


> 'FIN_GL_DETAILS' not processed or does not exist in target database."


 Cause:


> Object processing depends on another object. Action: Re-capture /


> re-generate both objects. For generation, if generation of foreign keys is

> required without generating the target table, then set Server Generator

 User


> Preference FK Generation needs to 'one end'.


>

> A search of the help files does not turn up any other reference to the

> phrases "one end' or "FK Generation" except this error message.

>

> I have been able to display a preferences palette with the title bar

> "Generator Preferences: Foreign Key - FIN_PAYROLL.PD_GL_DETAIL_FK," so I

> seem to be on the right track. However, there is nothing in that palette

> that resembles "FK Generation needs ... 'one end'." There is one entry (?)

> in the main window (?) of the palette that shows a crow's foot and the

 text,


> "There are no Server Generator preferences for Foreign Key -


> FIN_PAYROLL.PD_GL_DETAIL_FK."

>

> I am at a loss. I know (suppose) I can regenerate the DETAILS table, but

 it


> also has similar foreign keys; I would essentially have to rebuild the


> entire database. This workaround will not be applicable once there is data

> in the tables, so I really need to know the right way to generate an

> incremental table.

>

> TIA

>

>

>