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; } } }

Deploy metadata

jfprince

I am deploying data using the standalone mode.

The iwextattr.exe output the following

TeamSite/Metadata/Countries=uk
TeamSite/Metadata/Countries/uk=y
TeamSite/Metadata/ExpDate=16-11-2005
TeamSite/Metadata/LaunchDate=16-11-2005
TeamSite/Templating/Encoding=
TeamSite/Templating/PrimaryDCR=test
TeamSite/Templating/PrimaryDocumentType=intranet/standard
TeamSite/Templating/PrimaryPT=presentation-xml.tpl
Teamsite/BT/StandardTemplate/PageType=wide

On my config file I indicate:

<column name="countries" data-type="VARCHAR(128)" value-from-field="TeamSite/Metadata/Countries" allows-null="yes" is-url="no"/>

But the log file output
"Column COUNTRIES not found in array"

Any ideas?

Thanks
Jeff

Find more posts tagged with

Comments

iwovGraduate

Do you have column COUNTRIES in the necessary table in the DB?

Post your complete log and config file.

jfprince

Yes I do

countries varchar 100

Config file

<data-deploy-configuration>
<data-deploy-elements filepath="c:/iw-home/OpenDeployNG/etc/database.xml"/>

<!--
Substitutions to globally run regex changes to convert
review and last updated dates.
Stored in the XML in the iso format YYYY-MM-DD (YYYY-MM-DDTHH:MM Smiley Frustrated

S)
Stored in the Database as a SMALLDATETIME Data Type (DD/MM/YYYY)
-->
<substitution name="globalsubstitution">
<field name-pattern="page/0/page.information/0/source/0/lastupdated/0"
match="(20\d\d)-((0[1-9]|1[012]))-((0[1-9]|[1-2][0-9]|3[01]))"
replace="$4/$2/$1"
/>
<field name-pattern="page/0/page.information/0/source/0/reviewdate/0"
match="(20\d\d)-((0[1-9]|1[012]))-((0[1-9]|[1-2][0-9]|3[01]))"
replace="$4/$2/$1"
/>
</substitution>

<client>
<deployment name="intranet_deployment">
<source>
<xml-source options="wide" area="#WA#" area-type="ts-filesystem" xml-type="custom">
#PATH#
</xml-source>
</source>

<substitution use="globalsubstitution"/>

<destinations>
<database use="intranet">
<dbschema>
<group name="standard" root-group="yes">
<attrmap>

<column allows-null="no" data-type="VARCHAR(255)" is-url="no"
name="standard_vpath" value-from-field="page/0/page.information/0/source/0/vpath/0"/>

<column allows-null="no" data-type="VARCHAR(128)" is-url="no"
name="content_title" value-from-field="page/0/page.center/0/page.title/0"/>

<column allows-null="no" data-type="SMALLDATETIME" is-url="no"
name="content_last_updated" data-format="dd/MM/yyyy" value-from-field="page/0/page.information/0/source/0/lastupdated/0"/>

<column allows-null="no" data-type="SMALLDATETIME" is-url="no"
name="content_review_date" data-format="dd/MM/yyyy" value-from-field="page/0/page.information/0/source/0/reviewdate/0"/>

<column allows-null="no" data-type="VARCHAR(128)" is-url="no"
name="content_owner_email" value-from-field="page/0/page.information/0/provider/0/email/0"/>

<column allows-null="no" data-type="VARCHAR(128)" is-url="no"
name="content_owner_name" value-from-field="page/0/page.information/0/provider/0/name/0"/>

<column allows-null="no" data-type="VARCHAR(128)" is-url="no"
name="content_owner_id" value-from-field="page/0/page.information/0/provider/0/ein/0"/>

<column allows-null="n0" data-type="VARCHAR(255)" is-url="no"
name="left_navigation" value-from-field="page/0/page.center/0/page.leftnav/0/xi:include/0/href"/>

<column allows-null="no" data-type="VARCHAR(255)" is-url="no"
name="right_navigation" value-from-field="page/0/page.center/0/page.rightnav/0/xi:include/0/href"/>

<column allows-null="no" data-type="VARCHAR(128)" is-url="no"
name="content_language" value-from-field="page/0/page.center/0/lang"/>

<column allows-null="no" data-type="VARCHAR(128)" is-url="no"
name="page_format" value-from-field="page/0/page.information/0/format/0/page.type/0"/>


<column name="countries" data-type="VARCHAR(128)" value-from-field="TeamSite/Metadata/Countries" allows-null="yes" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="standard_vpath"/>
</primary-key>
</keys>
</group>

</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

Log file

ENG: 2005-08-17 16:04:03 BST GMT+01:00 Begin logfile [C:\iw-home\OpenDeployNG\log\data-deploy\src.intranet_standard9252.intranet_deployment.gsintra11.to.database.log] ---------
ENG: 2005-08-17 16:04:03 BST GMT+01:00 Job ID=m26 Deployment=data-deploy/intranet_standard9252
ENG: 2005-08-17 16:04:03 BST GMT+01:00 DataDeploy Version is 6.0.2.0.0
ENG: 2005-08-17 16:04:03 BST GMT+01:00 Owner started the deployment is SYSTEM
ENG: 2005-08-17 16:04:03 BST GMT+01:00 DD args iwdd="intranet_deployment" cfg=C:\iw-home\OpenDeployNG\conf\data-deploy\intranet_standard.xml need-result=yes depuuid=261aac20-0f30-11da-868d-c33d78544481 leglabel=database

ENG: 2005-08-17 16:04:03 BST GMT+01:00 Proceed to execute the database deployment

DAS: Deployment : intranet_deployment
DAS: Database Vendor set to microsoft-inetuna
DAS: Max Identifier length set to 128 characters.
DAS: SQL datatype for column standard_vpath is VARCHAR(255)
DAS: SQL datatype for column content_title is VARCHAR(128)
DAS: SQL datatype for column content_last_updated is SMALLDATETIME
DAS: SQL datatype for column content_review_date is SMALLDATETIME
DAS: SQL datatype for column content_owner_email is VARCHAR(128)
DAS: SQL datatype for column content_owner_name is VARCHAR(128)
DAS: SQL datatype for column content_owner_id is VARCHAR(128)
DAS: SQL datatype for column left_navigation is VARCHAR(255)
DAS: SQL datatype for column right_navigation is VARCHAR(255)
DAS: SQL datatype for column content_language is VARCHAR(128)
DAS: SQL datatype for column page_format is VARCHAR(128)
DAS: SQL datatype for column countries is VARCHAR(128)
DAS: # of columns: 12
DAS: # of primary key columns specified: 1
DAS: WARNING:Assuming group name as the table name for [standard].
DAS: # of groups defined in <dbschema> element: 1
DAS: [Wed Aug 17 16:04:03 BST 2005] Begin executing intranet_deployment
DAS: Area VPath:/default/main/bt_global/intranet/uk/content/datadeploy/root/STAGING
DAS: Setting up TDbSchemaAgent.
DAS: Validating cached connection...
DAS: Cached connection OK
DAS: Connected to [intrasql11.nat.bt.com:1433?database=GS_Intranet]
DAS: Table [standard] exists.
DAS: Running deployment [intranet_deployment]
DAS: extraction type=default
DAS: tuple mode=wide
DAS: area=/default/main/bt_global/intranet/uk/content/datadeploy/root/STAGING
DAS: /default/main/bt_global/intranet/uk/content/datadeploy/root/STAGING//htdocs/test_jf.xml
DAS: Generate DirectoryContents start:Wed Aug 17 16:04:03 BST 2005
DAS: Generate DirectoryContents end :Wed Aug 17 16:04:03 BST 2005
DAS: Building replicant order column information.
DAS: Building replicant order column information... Done.
DAS: TUPLE={page/0/page.information/0/format/0/page.brand/0=default, page/0/page.information/0/provider/0/name/0=Jean Prince, page/0/page.center/0/page.leftnav/0/xi:include/0=

, page/0/page.center/0/page.metadata/0/keywords/0=, page/0/page.center/0/page.title/0=JF test datadeploy, page/0/page.center/0/page.leftnav/0/xi:include/0/xi:fallback/0=, page/0/page.information/0/source/0/lastupdated/0=17/08/2005, state=Original, page/0/page.center/0/page.leftnav/0/xi:include/0/href=left_navigation/default.xml, page/0/page.information/0=

, page/0/page.information/0/source/0=

, page/0/page.information/0/provider/0/email/0=jean.prince@bt.com, page/0/page.information/0/source/0/reviewdate/0=13/04/2005, page/0/page.center/0/page.content/0=JF test datadeploy, page/0/page.information/0/source/0/vpath/0/relativePath=, page/0/page.information/0/format/0=

, page/0/page.center/0/page.metadata/0=

, page/0/page.information/0/source/0/reviewdate/0/format=iso, page/0/page.information/0/provider/0=

, page/0/page.center/0=

, page/0/xmlns:xi=http://www.w3.org/2003/XInclude, page/0/page.information/0/source/0/lastupdated/0/format=iso, path=htdocs\test_jf.xml, page/0/page.center/0/page.metadata/0/description/0=, page/0/page.information/0/format/0/page.type/0=wide, page/0/page.information/0/source/0/vpath/0=/default/main/bt_global/intranet/uk/content/datadeploy/root/WORKAREA/maintenance/htdocs/test_jf.xml, page/0/page.information/0/provider/0/ein/0=, page/0=

, page/0/page.center/0/page.leftnav/0=

, IWOV_PROC_FLAG=true, page/0/page.center/0/lang=en}
DAS: Performing Real Update
DAS: TTableSchemaHelper object for [standard] found in cache.
DAS: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'standard_vpath')
DAS: 1 PK values retrieved from iwdeltracker for htdocs\test_jf.xml, /default/main/bt_global/intranet/uk/content/datadeploy/root/STAGING
DAS: TTableSchemaHelper object for [standard] found in cache.
DAS: TTableSchemaHelper object for [standard] found in cache.
DAS: Column COUNTRIES not found in array
DAS: TTableSchemaHelper object for [standard] found in cache.
DAS: SelectCurrentRows Smiley Frustrated

ELECT content_title,content_last_updated,content_review_date,content_owner_email,content_owner_name,content_owner_id,left_navigation,right_navigation,content_language,page_format,countries,standard_vpath FROM standard WHERE standard_vpath IN (? ) ORDER BY standard_vpath
DAS: Index: 1, value: /default/main/bt_global/intranet/uk/content/datadeploy/root/WORKAREA/maintenance/htdocs/test_jf.xml
DAS: WARNING:db-datetime-format attribute not set for [content_last_updated] in group [standard]. Assuming default: yyyy-MM-dd HH:mm:ss.S
DAS: Converted 2005-08-17 00:00:00.0 to 17/08/2005
DAS: WARNING:db-datetime-format attribute not set for [content_review_date] in group [standard]. Assuming default: yyyy-MM-dd HH:mm:ss.S
DAS: Converted 2005-04-13 00:00:00.0 to 13/04/2005
DAS: Column COUNTRIES not found in array
DAS: SelectCurrentRows: 1 rows selected.
DAS: TTableSchemaHelper object for [standard] found in cache.
DAS: GetCurrentRowsFromGroupInfo: 1 rows selected from standard
DAS: Column COUNTRIES not found in array
DAS: Column COUNTRIES not found in array
DAS: UPDATE standard SET content_title = ? , content_last_updated = ? , content_review_date = ? , content_owner_email = ? , content_owner_name = ? , content_owner_id = ? , left_navigation = ? , right_navigation = ? , content_language = ? , page_format = ? , countries = ? WHERE standard_vpath = ? AND content_title = ? AND content_last_updated = ? AND content_review_date = ? AND content_owner_email = ? AND content_owner_name = ? AND content_owner_id is null AND left_navigation = ? AND right_navigation is null AND content_language = ? AND page_format = ?
DAS: Column: content_title, field: page/0/page.center/0/page.title/0, Index: 1,Converting 'JF test datadeploy' to VARCHAR
DAS: Column: content_last_updated, field: page/0/page.information/0/source/0/lastupdated/0, Index: 2,Converting '17/08/2005' to TIMESTAMP
DAS: Column: content_review_date, field: page/0/page.information/0/source/0/reviewdate/0, Index: 3,Converting '13/04/2005' to TIMESTAMP
DAS: Column: content_owner_email, field: page/0/page.information/0/provider/0/email/0, Index: 4,Converting 'jean.prince@bt.com' to VARCHAR
DAS: Column: content_owner_name, field: page/0/page.information/0/provider/0/name/0, Index: 5,Converting 'Jean Prince' to VARCHAR
DAS: Column: content_owner_id, field: page/0/page.information/0/provider/0/ein/0, Index: 6,Converting '' to INTEGER
DAS: Column: left_navigation, field: page/0/page.center/0/page.leftnav/0/xi:include/0/href, Index: 7,Converting 'left_navigation/default.xml' to VARCHAR
DAS: Column: right_navigation, field: page/0/page.center/0/page.rightnav/0/xi:include/0/href, Index: 8,null
DAS: Column: content_language, field: page/0/page.center/0/lang, Index: 9,Converting 'en' to VARCHAR
DAS: Column: page_format, field: page/0/page.information/0/format/0/page.type/0, Index: 10,Converting 'wide' to VARCHAR
DAS: Column COUNTRIES not found in array
DAS: Column COUNTRIES not found in array
DAS: Column: countries, field: TeamSite/Templating/PrimaryDCR, Index: 11,null
DAS: Column: standard_vpath, field: page/0/page.information/0/source/0/vpath/0, Index: 12,Converting '/default/main/bt_global/intranet/uk/content/datadeploy/root/WORKAREA/maintenance/htdocs/test_jf.xml' to VARCHAR
DAS: Column: content_title, field: page/0/page.center/0/page.title/0, Index: 13,Converting 'JF test datadeploy' to VARCHAR
DAS: Column: content_last_updated, field: page/0/page.information/0/source/0/lastupdated/0, Index: 14,Converting '17/08/2005' to TIMESTAMP
DAS: Column: content_review_date, field: page/0/page.information/0/source/0/reviewdate/0, Index: 15,Converting '13/04/2005' to TIMESTAMP
DAS: Column: content_owner_email, field: page/0/page.information/0/provider/0/email/0, Index: 16,Converting 'jean.prince@bt.com' to VARCHAR
DAS: Column: content_owner_name, field: page/0/page.information/0/provider/0/name/0, Index: 17,Converting 'Jean Prince' to VARCHAR
DAS: Column: left_navigation, field: page/0/page.center/0/page.leftnav/0/xi:include/0/href, Index: 18,Converting 'left_navigation/default.xml' to VARCHAR
DAS: Column: content_language, field: page/0/page.center/0/lang, Index: 19,Converting 'en' to VARCHAR
DAS: Column: page_format, field: page/0/page.information/0/format/0/page.type/0, Index: 20,Converting 'wide' to VARCHAR
DAS: DoesRowExist Smiley Frustrated

ELECT COUNT(*) FROM standard WHERE standard_vpath = ? AND content_title = ? AND content_last_updated = ? AND content_review_date = ? AND content_owner_email = ? AND content_owner_name = ? AND content_owner_id is null AND left_navigation = ? AND right_navigation is null AND content_language = ? AND page_format = ?
DAS: Column: standard_vpath, field: page/0/page.information/0/source/0/vpath/0, Index: 1,Converting '/default/main/bt_global/intranet/uk/content/datadeploy/root/WORKAREA/maintenance/htdocs/test_jf.xml' to VARCHAR
DAS: Column: content_title, field: page/0/page.center/0/page.title/0, Index: 2,Converting 'JF test datadeploy' to VARCHAR
DAS: Column: content_last_updated, field: page/0/page.information/0/source/0/lastupdated/0, Index: 3,Converting '17/08/2005' to TIMESTAMP
DAS: Column: content_review_date, field: page/0/page.information/0/source/0/reviewdate/0, Index: 4,Converting '13/04/2005' to TIMESTAMP
DAS: Column: content_owner_email, field: page/0/page.information/0/provider/0/email/0, Index: 5,Converting 'jean.prince@bt.com' to VARCHAR
DAS: Column: content_owner_name, field: page/0/page.information/0/provider/0/name/0, Index: 6,Converting 'Jean Prince' to VARCHAR
DAS: Column: left_navigation, field: page/0/page.center/0/page.leftnav/0/xi:include/0/href, Index: 7,Converting 'left_navigation/default.xml' to VARCHAR
DAS: Column: content_language, field: page/0/page.center/0/lang, Index: 8,Converting 'en' to VARCHAR
DAS: Column: page_format, field: page/0/page.information/0/format/0/page.type/0, Index: 9,Converting 'wide' to VARCHAR
DAS: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DAS: 1 rows inserted into iwdeltracker for htdocs\test_jf.xml, /default/main/bt_global/intranet/uk/content/datadeploy/root/STAGING
DAS: -- Updated
DAS: Stat for group [standard]:
DAS: -----------------------------------
DAS: Rows inserted : 0
DAS: Rows updated : 1
DAS: Rows deleted : 0
DAS: Rows failed : 0
DAS: Rows rolled back : 0
DAS: Rows skipped : 0
DAS: -----------------------------------
DAS: Committing database [intrasql11.nat.bt.com:1433?database=GS_Intranet]...
DAS: Deployment[intranet_deployment]
DAS: -----------------------------------
DAS: DCRs inserted : 0
DAS: DCRs updated : 1
DAS: DCRs deleted : 0
DAS: DCRs failed : 0
DAS: DCRs rolled back : 0
DAS: DCRs skipped : 0
DAS: -----------------------------------
DAS: Started : Wed Aug 17 16:04:03 BST 2005
DAS: Finished: Wed Aug 17 16:04:03 BST 2005
DAS:
### IWDataDeploy DONE ###

DAS:
### Sending result ###

ENG: 2005-08-17 16:04:03 BST GMT+01:00 Database deployment execution returned 0

ENG: 2005-08-17 16:04:03 BST GMT+01:00 <<< Completed database deployment Invocation>>>

ENG: 2005-08-17 16:04:03 BST GMT+01:00 doTask returned 0

ENG: 2005-08-17 16:04:03 BST GMT+01:00 Setting final state to TASKDONE

ENG: 2005-08-17 16:04:03 BST GMT+01:00 Manifest path is C:/iw-home/OpenDeployNG/log/data-deploy/src.intranet_standard9252.intranet_deployment.gsintra11.to.database.log.mf

ENG: 2005-08-17 16:04:03 BST GMT+01:00 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@73cfb3

ENG: 2005-08-17 16:04:03 BST GMT+01:00 fHasFailedItems is set to false

ENG: 2005-08-17 16:04:03 BST GMT+01:00 TEventReportingException: com.interwoven.report100.TPublisherNotFoundException
ENG: 2005-08-17 16:04:03 BST GMT+01:00 Job ID=m26 Deployment leg=database Elapsed Time=188 ms <<<
ENG: 2005-08-17 16:04:03 BST GMT+01:00 End logfile [C:\iw-home\OpenDeployNG\log\data-deploy\src.intranet_standard9252.intranet_deployment.gsintra11.to.database.log]

iwovGraduate

You say have varchar 100 in the DB, but your DD config declares it as VARCHAR(128). Try to fix that inconsistency and see if that gets rid of the error.

Your DD logs indicate the data was updated to the DB. Do you see the updates in the DB whithout problems (execpt for the error in logs)?

jfprince

I've changed the database with no result. I must admit I am not really familiar with datadeploy. I trigger datadeploy using the command line "c:\\iw-home\\opendeployng\\bin\\iwodcmd start $ddconfig -inst $$ -k iwdd=intranet_deployment" with $ddconfig the config file I joined above. Is there another config file I should check?

Thanks
Jean-Francois