Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

DB Script creation compiling error : Constraint Name Uniqueness

1,084 views

Skip to first unread message

unread,

Jul 12, 2004, 7:48:21 AM7/12/04

We get a compilation error message while trying to generate
the Database script from a PDM.

The cause is that Contraint Names generated automatically by
PowerDesigner when we create a PDM from a CDM are TRUNCATED.

e.g
Constraints names appears like CKC_<attribute name>_<table
name>
CKC_BLOCKADE_NBR_T_BLOCKA

where BLOCKADE_NBR is the attribute name
and T_BLOCKADE_MEMBER is the table name.

Thanks

unread,

Jul 12, 2004, 8:10:23 AM7/12/04

The constraint name length is set to 128 definition: in the
MaxConstLen entry (in the Object category) and in each
object category !

Is there another general option I forgot ?

unread,

Jul 12, 2004, 8:37:15 AM7/12/04

The solution can be found here :

In Check Model Parameters Options, set "Automatic
Correction" the Package-->"Contraint name uniqueness" error.

unread,

Jul 12, 2004, 9:15:08 AM7/12/04

THIS IS ONLY A WORKAROUND....

I still not have found the source of the problem, why
CONSTRAINTS name are truncated.

unread,

Jul 12, 2004, 3:34:40 PM7/12/04

What DBMS is the target?
What version/build of PowerDesigner?

<Wim Suijkerbuijk> wrote in message
news:40f28edc.ad...@sybase.com...

0 new messages