Problem Updating a child table.Foreign key

Digger

Running DD 6.1 with TS 6.7.1 on windows, loading on a SQLserver 2005 DB.
See Attachment:
tableSQL2005.txt for the table definition.(runnable from SQLServer if needed)
ddconfig.xml
log_file.log

Here what's working:
1.New content get loaded properly(Update both tables: showcase and showcaseRole)
2.Delete of the content works for both table.
3.Update of content on table showcase work fine

My Problem is when I'm trying to Update on table showcase_role then it doesn't work... any ideal, what's wrong.

I've been working for a certain time now, any suggestion will be appreciated.

Michel

Migrateduser

your foreign key config is wrong your column pair element has parent-group instead of parent-column.

you see this error in the log:

DBD: Invalid parent-column element/attribute.
DBD: ERROR:Invalid element found

This:

<column-pair parent-group="showid" child-column="showid"/>

should be:

<column-pair parent-column="showid" child-column="showid"/>

also, athough I dont know that it actually matters or if anything is case sensitive as it is on Unix and Oracle, you have your columns as showID and showid and various versions.. you should refer to them as they actually exist in the DB.

also, I would add the table attrib

  <group name="showcase_Role" table="showcase_role" root-group="no">