nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD not working fully

jstephan

Hi,

The following is the DCR data.

[HTML]

123456789

987654321

1
/images/1.jpg

2
/images/2.jpg

3
/images/3.jpg

[/HTML]

The following is the DD schema:

[HTML]

[/HTML]

I am expecting the following as the result in the database table for this particular DCR.

---------------------------------
article_id | image_id
---------------------------------
123456789 | 1
123456789 | 2
123456789 | 3
987654321 | 1
987654321 | 2
987654321 | 3
---------------------------------

But it inserts only 2 rows and those are

---------------------------------
article_id | image_id
---------------------------------
123456789 | 1
987654321 | 2
---------------------------------

What is the change has to be done in DCR or in DD CONFIG to get the expected result on the table?

Thanks in advance,
John

Find more posts tagged with

Comments

nipper

It should, can you post the log ?

jstephan

ENG: 2010-07-21 18:12:31 PDT GMT-07:00 Begin logfile [d:\iwhome\OpenDeployNG\log\DataDeploy/test\src.Gallery_DD_temp1.Gallery.devdb.to.database.log] ---------
ENG: 2010-07-21 18:12:31 PDT GMT-07:00 Job ID=m10084 Deployment=DataDeploy/test/Gallery_DD_temp1
ENG: 2010-07-21 18:12:31 PDT GMT-07:00 DataDeploy Version is 6.2.0.0.0
ENG: 2010-07-21 18:12:31 PDT GMT-07:00 Owner started the deployment is SYSTEM
ENG: 2010-07-21 18:12:31 PDT GMT-07:00 DD args iwdd="Gallery" databaseUse="devdb" filelist="D:\iwhome/tmp/dd_file" area="/default/main/Article/50/WORKAREA/content" cfg=d:\iwhome\OpenDeployNG\conf\DataDeploy/test\Gallery_DD.xml need-result=yes depuuid=33ed7b00-952e-11df-a14f-d5c82547366f leglabel=database

ENG: 2010-07-21 18:12:31 PDT GMT-07:00 Proceed to execute the database deployment

ENG: 2010-07-21 18:12:31 PDT GMT-07:00 Exec'ing [cmd.exe /E:1900 /C d:\iwhome\OpenDeployNG\lib\iwddexec iwdd="Gallery" databaseUse="devdb" filelist="D:\iwhome/tmp/dd_file" area="/default/main/Article/50/WORKAREA/content" cfg=d:\iwhome\OpenDeployNG\conf\DataDeploy/test\Gallery_DD.xml need-result=yes depuuid=33ed7b00-952e-11df-a14f-d5c82547366f leglabel=database svrlogfile=d:\iwhome\OpenDeployNG\log\DataDeploy/test\src.Gallery_DD_temp1.Gallery.devdb.to.database.log execProcess=yes loadhopi="yes"]
DBD: Server log file d:\iwhome\OpenDeployNG\log\DataDeploy/test\src.Gallery_DD_temp1.Gallery.devdb.to.database.log
DBD: DD module version: 6.2.0.0.0 Build 70056 Interwoven 20080320
DBD: In Thread: Thread[OpenDeploy Main,5,main]
DBD: Run in Thread: Thread[DDThread,5,main]
DBD: Database Vendor set to rdbms
DBD: SQL datatype for column article_id is INT(30)
DBD: SQL datatype for column image_path is VARCHAR(125)
DBD: # of columns: 2
DBD: # of primary key columns specified: 2
DBD: # of groups defined in element: 1
DBD: [Wed Jul 21 18:12:32 PDT 2010] Begin executing Gallery
DBD: Area VPath:/default/main/Article/50/WORKAREA/content
DBD: Setting up TDbSchemaAgent.
DBD: >>> Loading drivers <<<
DBD: Loading com.informix.jdbc.IfxDriver
DBD: Loading oracle.jdbc.driver.OracleDriver
DBD: Loading com.sybase.jdbc2.jdbc.SybDriver
DBD: Loading COM.ibm.db2.jdbc.net.DB2Driver
DBD: Loading sun.jdbc.odbc.JdbcOdbcDriver
DBD: Loading com.mysql.jdbc.Driver
DBD: url : jdbc:mysql://db1.stg.com:3306/devdb?autoReconnect=true
DBD: login : gr
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:mysql://db1.stg.com:3306/devdb?autoReconnect=true...
DBD:
Connected to jdbc:mysql://db1.stg.com:3306/devdb?autoReconnect=true
DBD: Driver MySQL-AB JDBC Driver
DBD: Version mysql-connector-java-5.1.7 ( Revision: ${svn.Revision} )
DBD: Connected to [db1.stg.com:3306/devdb?autoReconnect=true]
DBD: Building mappings cache...
DBD: Built mapping cache(s) successfully.
DBD: # column mappings: 0
DBD: # table mappings: 0
DBD: # view mappings: 0
DBD: # constraint mappings: 0
DBD: Table [GALLERY] exists.
DBD: Running deployment [Gallery]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/Article/50/WORKAREA/content
DBD: filelist=[D:\iwhome/tmp/dd_file]
DBD: /default/main/Article/50/WORKAREA/content/templatedata/Internet/Gallery/data/sample.xml
DBD: Generate DirectoryContents start:Wed Jul 21 18:12:34 PDT 2010
DBD: Generate DirectoryContents end :Wed Jul 21 18:12:34 PDT 2010
DBD: Generate TCustomDCRTupleProducer start:Wed Jul 21 18:12:34 PDT 2010
DBD: Generate TCustomDCRTupleProducer end :Wed Jul 21 18:12:34 PDT 2010
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={TeamSite/Templating/DCR/Type=Internet/Gallery, state=Original, gallery/0/article/1= , gallery/0/article/0= , gallery/0/folder/0/image/1/path/0=/images/2.jpg, gallery/0/folder/0/image/2= , gallery/0/folder/0/image/1= , gallery/0/folder/0/image/0= , gallery/0/article/0/id/0=123456789, path=templatedata\Internet\Gallery\data\sample.xml, gallery/0/article/1/id/0=987654321, gallery/0/folder/0/image/0/id/0=1, gallery/0/folder/0= , gallery/0/folder/0/image/2/path/0=/images/3.jpg, gallery/0/folder/0/image/1/id/0=2, gallery/0/folder/0/image/0/path/0=/images/1.jpg, IWOV_PROC_FLAG=true, gallery/0= , gallery/0/folder/0/image/2/id/0=3}
DBD: TDbSchemaGroupCfg:RowsExistForTuple Smiley Frustrated

ELECT COUNT(*) FROM GALLERY WHERE article_id IN ( ? , ? ) AND image_path IN ( ? , ? , ? )
DBD: TTableSchemaHelper not found in cache for [GALLERY]. Creating new.
DBD: TTableSchemaHelper object for [GALLERY] found in cache.
DBD: INSERT:INSERT INTO GALLERY(article_id,image_path) VALUES (?,?)
DBD: Column: article_id, field: gallery/0/article/0/id/0, Index: 1,Converting '123456789' to INTEGER
DBD: Column: image_path, field: gallery/0/folder/0/image/0/id/0, Index: 2,Converting '1' to VARCHAR
DBD: INSERT:INSERT INTO GALLERY(article_id,image_path) VALUES (?,?)
DBD: Column: article_id, field: gallery/0/article/1/id/0, Index: 1,Converting '987654321' to INTEGER
DBD: Column: image_path, field: gallery/0/folder/0/image/1/id/0, Index: 2,Converting '2' to VARCHAR
DBD: 5 rows inserted into iwdeltracker for templatedata\Internet\Gallery\data\sample.xml, /default/main/Article/50/WORKAREA/content
DBD: -- Inserted
DBD: Filelist walk done
DBD: Stat for group [GALLERY]:
DBD: -----------------------------------
DBD: Rows inserted : 2
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Committing database [db1.stg.com:3306/devdb?autoReconnect=true]...
DBD: Deployment[GALLERY]
DBD: -----------------------------------
DBD: DCRs inserted : 1
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Wed Jul 21 18:12:32 PDT 2010
DBD: Finished: Wed Jul 21 18:12:34 PDT 2010
ENG: 2010-07-21 18:12:35 PDT GMT-07:00 DBD: 2010-07-21 18:12:31 PDT GMT+01:00 OpenDeploy install location d:\iwhome\OpenDeployNG
DBD: 2010-07-21 18:12:31 PDT GMT+01:00 OpenDeploy install location d:\iwhome\OpenDeployNG
DD Home : d:\iwhome\OpenDeployNG
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[0]:iwdd=Gallery
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[1]:databaseUse=devdb
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[2]:filelist=D:\iwhome/tmp/dd_file
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[3]:area=/default/main/Article/50/WORKAREA/content
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[4]:cfg=d:\iwhome\OpenDeployNG\conf\DataDeploy/test\Gallery_DD.xml
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[5]:need-result=yes
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[6]:depuuid=33ed7b00-952e-11df-a14f-d5c82547366f
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[7]:leglabel=database
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[8]:svrlogfile=d:\iwhome\OpenDeployNG\log\DataDeploy/test\src.Gallery_DD_temp1.Gallery.devdb.to.database.log
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[9]:execProcess=yes
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 args[10]:loadhopi=yes
DBD: 2010-07-21 18:12:32 PDT GMT+01:00 numArgs=11

ENG: 2010-07-21 18:12:35 PDT GMT-07:00 Database deployment execution returned 0

ENG: 2010-07-21 18:12:35 PDT GMT-07:00 <<< Completed database deployment Invocation>>>

ENG: 2010-07-21 18:12:35 PDT GMT-07:00 doTask returned 0

ENG: 2010-07-21 18:12:35 PDT GMT-07:00 Setting final state to TASKDONE

ENG: 2010-07-21 18:12:35 PDT GMT-07:00 Job ID=m10084 Deployment leg=database Elapsed Time=3359 ms <<<
ENG: 2010-07-21 18:12:35 PDT GMT-07:00 End logfile [d:\iwhome\OpenDeployNG\log\DataDeploy/test\src.Gallery_DD_temp1.Gallery.devdb.to.database.log]

jagadesh

Hi,

The following is the DCR data.

[HTML]

123456789

987654321

1
/images/1.jpg

2
/images/2.jpg

3
/images/3.jpg

[/HTML]

The following is the DD schema:

[HTML]

[/HTML]

I am expecting the following as the result in the database table for this particular DCR.

---------------------------------
article_id | image_id
---------------------------------
123456789 | 1
123456789 | 2
123456789 | 3
987654321 | 1
987654321 | 2
987654321 | 3
---------------------------------

But it inserts only 2 rows and those are

---------------------------------
article_id | image_id
---------------------------------
123456789 | 1
987654321 | 2
---------------------------------

What is the change has to be done in DCR or in DD CONFIG to get the expected result on the table?

Thanks in advance,
John

Image is one replicant field and article is another replicant field, it has no relation in DCR.
If in your DCR contains three article id then it will insert three rows,
if it has only one article then it will insert only one record

As per your requirement the replicant should be in this format then only inserts those rows as expected
[html]

123456789

1
/images/1.jpg

2
/images/2.jpg

987654321

1
/images/1.jpg

2
/images/2.jpg

[/html]
Change to your dd schema
[HTML]

[/HTML]

jstephan

Thanks Jagadish, it worked.

jstephan

Hi,

I added couple more fields to the DD schema and now i am getting OUT OF MEMORY ERROR in DD.

The error is : ENG: 2010-07-22 10:41:38 PDT GMT-07:00 ErrorString java.lang.OutOfMemoryError

The following is the schema:

[HTML]

[/HTML]

Thanks
John

nipper

Can you trim down the limits [0-50] and [0-100]

DD allocates all the data for that data (whether the DCR has it or not). Since one contains the other, you are looking at 5151 of each

jstephan

Can you trim down the limits [0-50] and [0-100]

DD allocates all the data for that data (whether the DCR has it or not). Since one contains the other, you are looking at 5151 of each

Thanks for the response. But the DD schema was working fine with two fields, but not working when i added two more. Does that cause the issue?

nipper

Well you just doubled the amount of data. So it could have. It make 5151 of each field (and none of the fields are small). I am surprised it is out of memory. It will take a long time to run with that number of data points.