Issue with CLOB data type.

Hello - I've posted my DataDeploy script in the hope that someone can spot the error. I did note some other posts related to this issue but they looked to be all related to versions prior to 6.0. We are on TeamSite version 6.1, Solaris 9, OpenDeploy/DataDeploy 6, and Oracle 9i.

My question: is there some issue/bug - or user error below that I've missed, in using the CLOB dataType with DataDeploy. There are articles posted on the support site but they are related to previous bug fixes that are in versions prior to 6.1 TeamSite and 6.0 OpenDeploy. I should also mention that we are new - to using DataDeploy. We have done some rather extensive testing and keep comming back to this error and this column.

I had an earlier post about this but was not far enough in testing to determine where the error was occurring and had also not posted all required information. It seemed to make more sense to put this issue in another post. - tks as always.

When I comment out the below column

<column name="DETAIL" data-type="CLOB(4000)" value-from-field="detail"/>

the dataDeploy script will excute sucessfully.

Leaving in the column will throw the error listed at the bottom of the script.

Script:

<?xml version="1.0" encoding="UTF-8"?>
<data-deploy-configuration>
<client>
<deployment name="ts-to-db">
<source>

<teamsite-templating-records options="full,wide" area="$myarea">
<path filelist="$myFileList" visit-directory="deep" delete-after-use="no"/>
</teamsite-templating-records>
</source>
<destinations>

<database name="d116" db="uslcdb01.ut.regence.com:1521:d116" vendor="oracle" user="mxp" password="mxp" delete-tracker="yes">
<dbschema>
<group name="CORPEVENT" root-group="yes">
<attrmap>
<column name="CORPEVENT_ID" data-type="NUMBER(19,0)" value-from-field="corpEventId"/>
<column name="TITLE" data-type="VARCHAR2(4000)" value-from-field="eventTitle"/>
<column name="SYNOPSIS" data-type="VARCHAR2(4000)" value-from-field="synopsis"/>
<column name="PICTUREURL" data-type="VARCHAR2(4000)" value-from-field="imageURL"/>
<column name="APPROVED" data-type="VARCHAR2(4000)" value-from-field="approved"/>
<column name="BEGINDATE" data-type="DATE" data-format="yyyy-MM-dd" value-from-field="beginDate"/>
<column name="ENDDATE" data-type="DATE" data-format="yyyy-MM-dd" value-from-field="endDate"/>
<column name="CREATEDATE" data-type="DATE" data-format="yyyy-MM-dd" value-from-field="createDate"/>
<column name="EVENTTYPE_ID" data-type="NUMBER(19,0)" value-from-field="eventType/0/eventType"/>
<column name="DETAIL" data-type="CLOB(4000)" value-from-field="detail"/>
<column name="DATELABEL" data-type="VARCHAR2(4000)" value-from-field="dateLabel"/>
<column name="DURATIONLABEL" data-type="VARCHAR2(4000)" value-from-field="durationLabel"/>
<column name="LOCATION" data-type="VARCHAR2(4000)" value-from-field="location"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CORPEVENT_ID"/>
</primary-key>
</keys>
</group>
<group name="CORPEVENT_AUDIENCE" root-group="no">
<attrmap>
<column name="CORPEVENT_ID" data-type="NUMBER" value-from-field="corpEventId"/>
<column name="AUDIENCE_ID" data-type="NUMBER" value-from-field="Audience/[0-42]/Audience" list-to-replicant="yes" list-field="Audience/0/Audience" is-replicant="yes"/>
<column name="CREATEDATE" data-type="DATE" data-format="yyyy-MM-dd" value-from-field="createDate"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CORPEVENT_ID"/>
<key-column name="AUDIENCE_ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

ERROR:

ENG: 2005-05-02 11:03:54 MDT GMT-06:00 <<< Concatenating database deployment log... >>>

ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SerialDaemon dispatch
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| TWorkItem: Smiley Very Happy

oIt --- sock=2345 id=69
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| msg [iwdd=ts-to-db myarea=/iwmnt/washington/main/engine/STAGING myFileList=/iw-home/TeamSite/tmp/deploy_fileList_9870.log cfg=/iw-home/OpenDeployNG/conf/dd_mxp_dev_mevnt_config.xml need-result=yes logfile=/iw-home/OpenDeployNG/log/src.dd_mxp_dev_mevnt_config.ts-to-db.uslcweb03.to.database.log.dd depuuid=299cd740-bb2c-11d9-8dd0-a571e82cecb8 leglabel=database]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[0]=[iwdd=ts-to-db]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[1]=[myarea=/iwmnt/washington/main/engine/STAGING]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[2]=[myFileList=/iw-home/TeamSite/tmp/deploy_fileList_9870.log]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[3]=[cfg=/iw-home/OpenDeployNG/conf/dd_mxp_dev_mevnt_config.xml]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[4]=[need-result=yes]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[5]=[logfile=/iw-home/OpenDeployNG/log/src.dd_mxp_dev_mevnt_config.ts-to-db.uslcweb03.to.database.log.dd]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[6]=[depuuid=299cd740-bb2c-11d9-8dd0-a571e82cecb8]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| id=69 fDdArgs[7]=[leglabel=database]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Database Vendor set to oracle
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column CORPEVENT_ID is NUMBER(19,0)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column TITLE is VARCHAR2(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column SYNOPSIS is VARCHAR2(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column PICTUREURL is VARCHAR2(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column APPROVED is VARCHAR2(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column BEGINDATE is DATE
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column ENDDATE is DATE
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column CREATEDATE is DATE
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column EVENTTYPE_ID is NUMBER(19,0)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column DETAIL is CLOB(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column DATELABEL is VARCHAR2(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column DURATIONLABEL is VARCHAR2(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column LOCATION is VARCHAR2(4000)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| # of columns: 13
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| # of primary key columns specified: 1
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| WARNING:Assuming group name as the table name for [CORPEVENT].
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column CORPEVENT_ID is NUMBER
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column AUDIENCE_ID is NUMBER
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL datatype for column CREATEDATE is DATE
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| # of columns: 3
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| # of primary key columns specified: 2
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| WARNING:Assuming group name as the table name for [CORPEVENT_AUDIENCE].
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| # of groups defined in <dbschema> element: 2
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| [Mon May 02 11:03:53 MDT 2005] Begin executing ts-to-db
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Area VPath:/iwmnt/washington/main/engine/STAGING
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Setting up TDbSchemaAgent.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Validating cached connection...
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQLExceptionNo more data to read from socket
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| url : jdbc Smiley Surprised

racle:thin:@uslcdb01.ut.regence.com:1521:d116
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| login : mxp
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| login timeout=3
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Connecting to the database...
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Try connecting using jdbc Smiley Surprised

racle:thin:@uslcdb01.ut.regence.com:1521:d116...
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Connected to jdbc Smiley Surprised

racle:thin:@uslcdb01.ut.regence.com:1521:d116
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Driver Oracle JDBC driver
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Version 9.0.1.0.0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Connected to [uslcdb01.ut.regence.com:1521:d116]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SELECT * FROM USER_TABLES WHERE TABLE_NAME='CORPEVENT'
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Table [CORPEVENT] exists.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SELECT * FROM USER_TABLES WHERE TABLE_NAME='CORPEVENT_AUDIENCE'
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Table [CORPEVENT_AUDIENCE] exists.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Running deployment [ts-to-db]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| extraction type=full
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| tuple mode=wide
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| area=/iwmnt/washington/main/engine/STAGING
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| filelist=[/iw-home/TeamSite/tmp/deploy_fileList_9870.log]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| /iwmnt/washington/main/engine/STAGING/templatedata/events/member/data/test8.xml
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Generate DirectoryContents start:Mon May 02 11:03:53 MDT 2005
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Generate DirectoryContents end :Mon May 02 11:03:53 MDT 2005
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Generate TDCRTupleProducer start:Mon May 02 11:03:53 MDT 2005
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Generate TDCRTupleProducer end :Mon May 02 11:03:53 MDT 2005
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Building replicant order column information.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Building replicant order column information... Done.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Field : Audience/0/Audience Value: 101
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| TUPLE={location=Event Location , TeamSite/Templating/DCR/Type=events/member, createDate=2005-04-30, synopsis=copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| , state=Original, beginDate=2005-04-30, Audience/0=, approved=1, eventType/0/eventType=122, dateLabel=2005-04-29, path=templatedata/events/member/data/test8.xml, eventType/0=, Audience/0/Audience=101, imageURL=/templatedata/events/member/images/HealthWellness.Nutrition.gif, endDate=2005-04-30, corpEventId=3263, detail=copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| , eventTitle=Member Event 1, IWOV_PROC_FLAG=true, durationLabel=Event Description , FileName=/templatedata/events/member/data/test8.xml}
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| TDbSchemaGroupCfg:RowsExistForTuple Smiley Frustrated

ELECT COUNT(*) FROM CORPEVENT WHERE CORPEVENT_ID IN ( ? )
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| TTableSchemaHelper object for [CORPEVENT] found in cache.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| TTableSchemaHelper object for [CORPEVENT] found in cache.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| INSERT:INSERT INTO CORPEVENT(CORPEVENT_ID,TITLE,SYNOPSIS,PICTUREURL,APPROVED,BEGINDATE,ENDDATE,CREATEDATE,EVENTTYPE_ID,DETAIL,DATELABEL,DURATIONLABEL,LOCATION) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: CORPEVENT_ID, field: corpEventId, Index: 1,Converting '3263' to DECIMAL
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: TITLE, field: eventTitle, Index: 2,Converting 'Member Event 1' to VARCHAR
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: SYNOPSIS, field: synopsis, Index: 3,Converting 'copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| copy copy copy copy
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| ' to VARCHAR
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: PICTUREURL, field: imageURL, Index: 4,Converting '/templatedata/events/member/images/HealthWellness.Nutrition.gif' to VARCHAR
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: APPROVED, field: approved, Index: 5,Converting '1' to DECIMAL
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: BEGINDATE, field: beginDate, Index: 6,Converting '2005-04-30' to TIMESTAMP
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: ENDDATE, field: endDate, Index: 7,Converting '2005-04-30' to TIMESTAMP
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: CREATEDATE, field: createDate, Index: 8,Converting '2005-04-30' to TIMESTAMP
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Column: EVENTTYPE_ID, field: eventType/0/eventType, Index: 9,Converting '122' to DECIMAL
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| length of CLOB/LONG data = 111
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQLException occured in TableSchema:Exists()
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Exception Message: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Vendor Error Code: 17002
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL state: null
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******STACK TRACE*************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| java.sql.SQLException: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:496)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:619)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:513)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:103)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.CreateViaSql(TableSchema.java:274)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4411)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.GetClobLocator(TDbAgent.java:4388)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.convertAndSetParameter(TDbAgent.java:4208)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1264)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1151)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1063)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:333)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:962)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:520)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:165)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:49)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at java.lang.Thread.run(Thread.java:479)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQLException occured in TableSchema:Exists()
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Exception Message: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Vendor Error Code: 17002
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL state: null
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******STACK TRACE*************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| java.sql.SQLException: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:496)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:619)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:513)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:103)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.CreateViaSql(TableSchema.java:274)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4411)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4437)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.GetClobLocator(TDbAgent.java:4388)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.convertAndSetParameter(TDbAgent.java:4208)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1264)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1151)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1063)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:333)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:962)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:520)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:165)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:49)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at java.lang.Thread.run(Thread.java:479)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQLException occured in TableSchema:Exists()
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Exception Message: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Vendor Error Code: 17002
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL state: null
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******STACK TRACE*************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| java.sql.SQLException: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:496)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:619)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:513)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:103)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.CreateViaSql(TableSchema.java:274)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4411)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4437)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4437)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.GetClobLocator(TDbAgent.java:4388)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.convertAndSetParameter(TDbAgent.java:4208)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1264)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1151)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1063)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:333)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:962)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:520)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:165)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:49)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at java.lang.Thread.run(Thread.java:479)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQLException occured in TDbSchemaGroupCfg
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Exception Message: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Vendor Error Code: 17002
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| SQL state: null
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| *******STACK TRACE*************
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| java.sql.SQLException: Io exception: Broken pipe
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:496)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:511)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:209)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:192)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:778)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:634)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4416)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4437)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4437)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.GetClobLocator(TDbAgent.java:4388)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.convertAndSetParameter(TDbAgent.java:4208)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1264)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1151)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1063)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:333)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:962)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:520)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:165)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:49)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| at java.lang.Thread.run(Thread.java:479)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| ERROR Smiley Very Happy

oInsert() failed for group [CORPEVENT].
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| -- Failed
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| ERROR:WriteTuple failure to consumer[0]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| ERROR:Unable to process TeamSite source templatedata/events/member/data/test8.xml, obtained from filelist=/iw-home/TeamSite/tmp/deploy_fileList_9870.log
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Filelist walk done
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| ERROR:deployment [ts-to-db] FAILED
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Error occured in area outside TDbAgent consumer (explicit rollback initiated)
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Stat for group [CORPEVENT]:
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| -----------------------------------
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows inserted : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows updated : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows deleted : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows failed : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows rolled back : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows skipped : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| -----------------------------------
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Stat for group [CORPEVENT_AUDIENCE]:
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| -----------------------------------
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows inserted : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows updated : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows deleted : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows failed : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows rolled back : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rows skipped : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| -----------------------------------
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Rollback database [uslcdb01.ut.regence.com:1521:d116]...
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| DepUUID = 299cd740-bb2c-11d9-8dd0-a571e82cecb8 LegLabel= database
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Topic Session not established. Event msg will not published.
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Deployment[ts-to-db]
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| -----------------------------------
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| DCRs inserted : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| DCRs updated : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| DCRs deleted : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| DCRs failed : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| DCRs rolled back : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| DCRs skipped : 0
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| -----------------------------------
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Started : Mon May 02 11:03:53 MDT 2005
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| Finished: Mon May 02 11:03:54 MDT 2005
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| ### IWDataDeploy FAILED ###
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD| ### Sending result ###
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 DD|
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 <<< Concatenated database deployment log >>>

ENG: 2005-05-02 11:03:54 MDT GMT-06:00 Job ID=m1521 Deployment leg=database Elapsed Time=1091 ms <<<
ENG: 2005-05-02 11:03:54 MDT GMT-06:00 End logfile [/iw-home/OpenDeployNG/log/src.dd_mxp_dev_mevnt_config.ts-to-db.uslcweb03.to.database.log]

Find more posts tagged with

Comments

aputnam

I believe there is a patch that solves this issue:
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=54128

Migrateduser

Thank you:

I had done several searches for CLOB issues but did not see this article. We will try it, and thank you again for calling it to my attention.

- christine

Migrateduser

Hi,
Can you check to see if "IWTMP_LOB" table is created.
If it is then drop that table, restart you OD server and try your deployment again.
Your exception stack trace seems to indicate the failure is related to the creation of the IWTMP_LOB table.

Could you also post the sample DCR that you are workign on.

If you are not too far into development on 6.0.0....OD 6.0.2 has some bug fixes related to LOB's.

thanks
srini