I am trying the DD example (book reviews) where the primary record goes to one table and them a second (set of reviews) goes to a second table. The data gets inserted into my primary table, but the child table stays empty.
Config: Win 2K TS 6.7.1, OD 6.1, MS SQL Server.
Log:
DBD: Table [BOOKS] exists.
DBD: Table [REVIEWERS] exists.
DBD: Running deployment [TTD]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/test/workarea/content
DBD: filelist=[/interwoven/iw-home/tmp/ddexample.txt]
DBD: /default/main/test/workarea/content/templatedata/internet/book/data/andy.xml
DBD: Generate DirectoryContents start:Thu Nov 09 08:34:00 PST 2006
DBD: Generate DirectoryContents end :Thu Nov 09 08:34:01 PST 2006
DBD: Retrieving TeamSite metadata for \\vmware2k\default\main\test\WORKAREA\Content/templatedata\internet\book\data\andy.xml
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={record/0/item/2/value/0=Andy, record/0/type=content, record/0/item/8/value/2/item/1/name=Review Reader E-Mail, record/0/item/8/value/2/item/1/value/0=pot@thekettleisblack.com, record/0/item/7/value/0=Good work, record/0/item/8/value/0/item/2=,record/0/item/8/value/0/item/1= ,record/0/item/8/value/0/item/0/name=Review Reader, record/0/item/0/value/0=Life of Andy, record/0/item/8/value/0/item/0= , record/0/item/8/value/1/item/1/value/0=someone@else.com, record/0/item/8/value/0/item/2/name=Reader Comments, record/0/item/8/value/0/item/1/value/0=me@here.com, record/0/item/0/name=Title, record/0/item/8/value/1/item/2= , record/0/item/8/value/1/item/1= , record/0/item/2/name=Author, record/0/item/8/value/1/item/0= , record/0=
, record/0/item/4/name=ISBN, record/0/name=andy.xml, record/0/item/5/value/0=Paperback, IWOV_PROC_FLAG=true, record/0/item/8/value/2/item/2= , record/0/item/8/value/2/item/1= , record/0/item/8/value/2/item/0=, record/0/item/6/name=Price, record/0/item/8/name=Reviews, record/0/item/8/value/1/item/1/name=Review Reader E-Mail, record/0/item/8= , record/0/item/7=, record/0/item/6= , record/0/item/5= , record/0/item/4= , record/0/item/3/value/0=1961-05-22, record/0/item/3= , record/0/item/2=, record/0/item/1= , record/0/item/0= , record/0/item/8/value/2=, record/0/item/8/value/2/item/0/name=Review Reader, record/0/item/8/value/1=
, record/0/item/8/value/0=
, record/0/item/8/value/2/item/2/value/0=yea the pot is calling the kettle black, record/0/item/8/value/2/item/2/name=Reader Comments, record/0/item/1/value/0=/templatedata/internet/book/images/warpieces.gif, record/0/item/8/value/1/item/2/value/0=Another great work, record/0/item/8/value/0/item/2/value/0=great stuff Manyard, record/0/item/8/value/0/item/1/name=Review Reader E-Mail, record/0/item/8/value/2/item/0/value/0=pot, record/0/item/6/value/0=12.34, record/0/item/1/name=Cover Picture, record/0/item/8/value/1/item/0/value/0=Someone, record/0/item/3/name=Publication Date, record/0/item/8/value/0/item/0/value/0=me, record/0/item/5/name=Cover, path=templatedata\internet\book\data\andy.xml, record/0/item/7/name=Plot Summary, record/0/item/8/value/1/item/0/name=Review Reader, record/0/item/4/value/0=12345, TeamSite/Templating/DCR/Type=internet/book, record/0/item/8/value/1/item/2/name=Reader Comments, state=Original}
DBD: Starting SchemaHelperCache Cleanup Thread...
DBD: TTableSchemaHelper not found in cache for [BOOKS]. Creating new.
DBD: RowsExistForPath
ELECT COUNT(*) FROM BOOKS WHERE Title = ?
DBD: Performing delete+insert
DBD: DELETE
ELETE FROM REVIEWERS WHERE Title = ?
DBD: TTableSchemaHelper not found in cache for [REVIEWERS]. Creating new.
DBD: Column: Title, field: path, Index: 1,Converting 'templatedata\internet\book\data\andy.xml' to CHAR
DBD: DeleteForUpdate: Skipping root group
DBD: TTableSchemaHelper object for [BOOKS] found in cache.
DBD: TTableSchemaHelper object for [BOOKS] found in cache.
DBD: SelectCurrentRowsUsingPath: SELECT Author,ISBN,Price,Title FROM BOOKS WHERE Title = ? ORDER BY Title
DBD: SelectCurrentRowsUsingPath: 1 rows selected.
DBD: -- Updated
DBD: Filelist walk done
DBD: Stat for group [book]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Stat for group [reviewers]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Event reporting turned off
DBD: Committing database [vmware2k:1433?database=DDTest]...
DBD: Deployment[TTD]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 1
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DD config:
[html]
match="^Y
.*)/WORKAREA/[^/]+/(.*)"
replace="/$2" />
[/html]
Clues ? Tips/Pointers/RTFMs appreciated.
Andy
