DD Problem 6.1.0

OD 6.1.0
TeamSite 6.7
Solaris 10

When trying to a DataDeploy based on extended attributes on a file, we are getting following error:

DBD: Server log file /usr/OpenDeployNG/log/src.wft_datadeploy3678.ea-to-db.SG-IV-BAK.to.database.log
DBD: DD module version: 6.1.0.0.0 Build 56030 Interwoven 20060325
DBD: In Thread: Thread[OpenDeploy Main,5,main]
DBD: Run in Thread: Thread[DDThread,5,main]
DBD: Database Vendor set to oracle
DBD: [Fri Jul 21 12:43:31 SGT 2006] Begin executing ea-to-db
DBD: Area VPath:/default/main/mansion/WORKAREA/content
DBD: Setting up consumer TDbAgent
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: url : jdbc Smiley Surprised

racle:thin:@10.234.89.20:1521:mansion
DBD: login : portal_poc
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc Smiley Surprised

racle:thin:@10.234.89.20:1521:mansion...
DBD:
Connected to jdbc Smiley Surprised

racle:thin:@10.234.89.20:1521:mansion
DBD: Driver Oracle JDBC driver
DBD: Version 9.2.0.1.0
DBD: Connected to [10.234.89.20:1521:mansion]
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
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: SELECT * FROM USER_TABLES WHERE TABLE_NAME='DOCUMENT_METADATA'
DBD: Table exists.
DBD: Running deployment [ea-to-db]
DBD: extraction type=full
DBD: tuple mode=narrow
DBD: area=/default/main/mansion/WORKAREA/content
DBD: /default/main/mansion/WORKAREA/content/generated/content/editorial/Test_Edit_setmetadata.html
DBD: Generate TFullEAExtractor start:Fri Jul 21 12:43:32 SGT 2006
DBD: Generate TFullEAExtractor end :Fri Jul 21 12:43:32 SGT 2006
DBD: Path not found -- interpret as 'NotPresent'
DBD: TUPLE={state=NotPresent, path=generated/content/editorial/Test_Edit_setmetadata.html}
DBD: TTableSchemaHelper not found in cache for [DOCUMENT_METADATA]. Creating new.
DBD: SELECT ID,NAME, VALUE,STATE FROM DOCUMENT_METADATA WHERE ID=? AND NAME=?
DBD: TTableSchemaHelper object for [DOCUMENT_METADATA] found in cache.
DBD: WHERE clause parameter 1: generated/content/editorial/Test_Edit_setmetadata.html
DBD: Column: ID, field: path, Index: 1,Converting 'generated/content/editorial/Test_Edit_setmetadata.html' to
VARCHAR
DBD: ERROR:Value for key column (NAME) is NULL
DBD: Error occured in NarrowInsertUpdate: Select() returned null ResultSet
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source generated/content/editorial/Test_Edit_setmetadata.html
DBD: ERROR:deployment [ea-to-db] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Rollback database [10.234.89.20:1521:mansion]...
DBD: Deployment[ea-to-db] Table[DOCUMENT_METADATA]
DBD: -----------------------------------
DBD: Tuples inserted : 0
DBD: Tuples updated : 0
DBD: Tuples deleted : 0
DBD: Tuples failed : 0
DBD: Tuples rolled back : 0
DBD: Tuples skipped : 0
DBD: -----------------------------------
DBD: Started : Fri Jul 21 12:43:31 SGT 2006
DBD: Finished: Fri Jul 21 12:43:32 SGT 2006
ENG: 2006-07-21 12:43:32 SGT GMT+08:00 nullDBD: 2006-07-21 12:43:30 SGT GMT+00:00 OpenDeploy install location /
usr/OpenDeployNG
DBD: 2006-07-21 12:43:30 SGT GMT+00:00 OpenDeploy install location /usr/OpenDeployNG
DD Home : /usr/OpenDeployNG
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[0]:infile=generated/content/editorial/Test_Edit_setmetadata.html
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[1]:dbpass1=portal_poc
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[2]:dbase1=10.234.89.20:1521:mansion
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[3]:iwdd=ea-to-db
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[4]:area=/default/main/mansion/WORKAREA/content
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[5]:dbuser1=portal_poc
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[6]:db1=oracle
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[7]:cfg=/Interwoven/TeamSite/local/config/wft/externalcmds/wft_datad
eploy.cfg
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[8]:need-result=yes
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[9]:depuuid=7503ca90-1873-11db-9ba2-9edb3de47154
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[10]:leglabel=database
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[11]:svrlogfile=/usr/OpenDeployNG/log/src.wft_datadeploy3678.ea-to-d
b.SG-IV-BAK.to.database.log
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 args[12]:execProcess=yes
DBD: 2006-07-21 12:43:31 SGT GMT+00:00 numArgs=13
Database Deployment error state: false

Attached is the DD configuration file that we are using and we are firing followign command:

/usr/OpenDeployNG/bin/iwodcmd start wft_datadeploy -k iwdd="ea-to-db" -k infile="generated/content/editorial/Test_Edit_setmetadata.html" -k area="/default/main/mansion/WORKAREA/content" -k db1="oracle" -k dbase1="10.234.89.20:1521:mansion" -k dbuser1="portal_poc" -k dbpass1="portal_poc" -inst 3678

Find more posts tagged with

Comments

Bill Klish

Looks like the file you are referencing does not exist, which means there are no EAs to pull, causing the Name attribute to be NULL and your deployment to fail.

The file path is default/main/mansion/WORKAREA/content/generated/content/editorial/Test_Edit_setmetadata.html

kshitiz

That is the first thing I checked when I encountered the error. The file is existing in TeamSite. Any other pointers?

nipper

It may exist in TS but DD does not think it is there.

Check your workarea path. I have also seen issues when there is not a trailing slash on the WA, if there is not, try adding one.

FooterLevel.ppt

sample.rptdesign

dana1

Hi,

Have you specify TS version in the deploy.cfg file? This is a new "feature" in OD 6.1. If you open the deploy.cfg file, go to the last line, un-comment out the TeamSite version. You may need to restart OD service for the change to be in effect.

Dana Le.

bookmark_and_link.html

bookmark_and_link.zip

kshitiz

Hi,

Have you specify TS version in the deploy.cfg file? This is a new "feature" in OD 6.1. If you open the deploy.cfg file, go to the last line, un-comment out the TeamSite version. You may need to restart OD service for the change to be in effect.

Dana Le.

Dana,

We have tried the deployment with OD 6.0.2 SP1 as well but we are getting the same error.
Will the un-commenting of TS version solve the problem?

dana1

Hi,
This feature is applicable only to 6.1. Does my suggestion resolve your issue on 6.1?

Dana.