deltagen or basearea when iwsyncdb.ipl run

I can register specific branch with DAS for metadata . But for the another one , every time I run iwsyncdb.ipl -initial vpath teamsite/metadata , the deployment in command turns to deltagen like messages below

DataDeploy Command=[cfg="/usr/iw-home/local/config/mdc_dd.cfg" deploymen
t=deltagen myarea="/default/main/test/WORKAREA/wa" mybasearea="/default/main/tes
t/STAGING" mytable=DEFAULT_TEAMSITE_METADATA__MAIN_TEST_WORKAREA_WA mybasetable=
DEFAULT_TEAMSITE_METADATA__MAIN_TEST_STAGING mybasetablenameprefix=DEFAULT_TEAMS
ITE_METADATA mybasetablenamesuffix=MAIN_TEST_STAGING mytablenameprefix=DEFAULT_T
EAMSITE_METADATA mytablenamesuffix=MAIN_TEST_WORKAREA_WA mysubpath=. ]

I just see nothing in the table it generated .
Did I mis-configure something or miss some parameter ?

Find more posts tagged with

Comments

Migrateduser

check the logfile iwddd.log if there are any errors.

Migrateduser

You might be interested in this .
The Column "DEFAULT_RULE_TITLE" comes from TeamSite/Metadata/Title . And that should be "test title" . But DD just can not retrieve that ?

<DeltaUpdate>
TUPLE={TeamSite/Templating/PrimaryPT=pr1.tpl, TeamSite/Templating/PrimaryDocumen
tType=internet/pr, TeamSite/Templating/Encoding=, IWOV_PROC_FLAG=true, state=Ori
ginal, path=test.html, TeamSite/Templating/PrimaryDCR=test}
RowsExistForPath Smiley Frustrated

ELECT COUNT(*) FROM IWT_15063760CEBA WHERE Path = ?
Starting SchemaHelperCache Cleanup Thread...
TTableSchemaHelper not found in cache for [IWT_15063760CEBA]. Creating new.
INSERT:INSERT INTO IWT_15063760CEBA(IW_State,Path,News_Category,Main_Headline,Ca
t_Headline,Default_Rule_Title,Default_Rule_Description,Default_Rule_Type,Default
_Rule_Category,Default_Rule_Languages,Default_Rule_Source,Default_Rule_Launch_Da
te,Default_Rule_Expiration_Date,Default_Rule_Keywords) VALUES (?,?,?,?,?,?,?,?,?
,?,?,?,?,?)
Column: IW_State, field: state, Index: 1,Converting 'Original' to VARCHAR
Column: Path, field: path, Index: 2,Converting 'test.html' to VARCHAR
Column: News_Category, field: TeamSite/Metadata/News_Category, Index: 3,null
Column: Main_Headline, field: TeamSite/Metadata/Main_Headline, Index: 4,null
Column: Cat_Headline, field: TeamSite/Metadata/Cat_Headline, Index: 5,null
Column: Default_Rule_Title, field: TeamSite/Metadata/Title, Index: 6,null
Column: Default_Rule_Description, field: TeamSite/Metadata/Description, Index: 7
,null
Column: Default_Rule_Type, field: TeamSite/Metadata/Type, Index: 8,null
Column: Default_Rule_Category, field: TeamSite/Metadata/Category, Index: 9,null
Column: Default_Rule_Languages, field: TeamSite/Metadata/Languages, Index: 10,nu
ll
Column: Default_Rule_Source, field: TeamSite/Metadata/Source, Index: 11,null
Column: Default_Rule_Launch_Date, field: TeamSite/Metadata/Launch Date, Index: 1
2,null
Column: Default_Rule_Expiration_Date, field: TeamSite/Metadata/Expiration Date,
Index: 13,null
Column: Default_Rule_Keywords, field: TeamSite/Metadata/Keywords, Index: 14,null

*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-01400: Can not insert NULL in ("METADATA"."IWT_15063760CEBA"."D
EFAULT_RULE_TITLE")

Vendor Error Code: 1400
SQL state: 23000

================================
root@[iw-home/bin]%./iwextattr -l /default/main/test/WORKAREA/wa/test.html
TeamSite/Metadata/Category=financial_internet
TeamSite/Metadata/Description=test description
TeamSite/Metadata/Expiration Date=2003-10-01
TeamSite/Metadata/Keywords=found
TeamSite/Metadata/Languages=
TeamSite/Metadata/Launch Date=2003-08-29
TeamSite/Metadata/Source=
TeamSite/Metadata/Title=test title
TeamSite/Metadata/Type=white_paper
TeamSite/Templating/Encoding=
TeamSite/Templating/PrimaryDCR=test
TeamSite/Templating/PrimaryDocumentType=internet/pr
TeamSite/Templating/PrimaryPT=pr1.tpl
===================================

Any response is appreciated .
Sean

Migrateduser

could you post the log for the complete deployment. Looking at the log there doesnt seem to be any EA's set on file test.html. Can you double check if you are looking at the right test.html.

Migrateduser

I found the errors occured when the required column is inserted with null.
Then I check the file with null attribute which is required .
I found it's generated by TPL/DCT . After I set up the metadata to this file , the deployment completes .

I was wondering , how the DD identified which file should be deployed and which one is not ?
We cannot set metadata to all the files in workarea . Does that means the deployment will fail always ? I don't think so .

Any response is appreciated .