Hi,
Our deployment is converting a valid tuple into null when updating the database. As we have PKeys, we get a SQL Exception. Please help. I am posting all the relevant information here..
We are using:
OD - 6.0.2 SP1
DD - 6.0.2
IW - 6.5.0
Windows 2k3
-----Log File-----
ENG: 2006-03-17 01:10:49 PST GMT-08:00 Proceed to execute the database deployment
ENG: 2006-03-17 01:10:49 PST GMT-08:00 Exec'ing [cmd.exe /E:1900 /C
\PROGRA~1\INTERW~2\OPENDE~1\lib\iwddexec iwdd="Deployment1" cfg=D:\PROGRA~1\INTERW~2\OPENDE~1\conf\DD_Liftoff\liftoff_dd.xml need-result=yes depuuid=ecf896c0-b595-11da-82c1-cbb9db3510b6 leglabel=database svrlogfile=D:\PROGRA~1\INTERW~2\OPENDE~1\log\DD_Liftoff\src.liftoff_dd.Deployment1.USLAXCMSDEV.to.database.log doEvtrpt=yes execProcess=yes]
DBD: Server log file
\PROGRA~1\INTERW~2\OPENDE~1\log\DD_Liftoff\src.liftoff_dd.Deployment1.USLAXCMSDEV.to.database.log
DBD: DD module version: 6.0.2.1.0 Build 52162 Interwoven 20050921
DBD: In Thread: Thread[OpenDeploy Main,5,main]
DBD: Run in Thread: Thread[DDThread,5,main]
DBD: Database Vendor set to ORACLE
DBD: SQL datatype for column Path is varchar(255)
DBD: SQL datatype for column IW_State is varchar(255)
DBD: SQL datatype for column eventDate is DATE
DBD: SQL datatype for column endDate is DATE
DBD: SQL datatype for column eventName is VARCHAR(100)
DBD: SQL datatype for column customerName is VARCHAR(100)
DBD: SQL datatype for column quote is VARCHAR(100)
DBD: # of columns: 7
DBD: # of primary key columns specified: 1
DBD: # of groups defined in element: 1
DBD: [Fri Mar 17 01:10:49 PST 2006] Begin executing Deployment1
DBD: Begin Set up the publisher thread
DBD: End Set up the publisher thread
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: 4
DBD: # view mappings: 0
DBD: # constraint mappings: 0
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='HERBALIFE'
DBD: Table [HERBALIFE] exists.
DBD: Running deployment [Deployment1]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/US/Web/Liftoff/English/WORKAREA/Content_Contributor
DBD: /default/main/US/Web/Liftoff/English/WORKAREA/Content_Contributor/templatedata/xml/liftoff/data
DBD: Generate TCustomDCRTupleProducer start:Fri Mar 17 01:10:50 PST 2006
DBD: Generate TCustomDCRTupleProducer end :Fri Mar 17 01:10:50 PST 2006
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={liftoff/0/gallery/0/imageCaption/0=Terrible, liftoff/0=, liftoff/0/testimonials/0=, TeamSite/Templating/DCR/Type=xml/liftoff, liftoff/0/gallery/0=, state=Original, liftoff/0/testimonials/0/customerName/0=Joodhi, liftoff/0/testimonials/0/customerImage/0=/cms/media/liftoff_testimonial5.swf, liftoff/0/events/0/eventDescription/0=This is Terrible 123, liftoff/0/gallery/0/fullImage/0=/cms/media/event_08.jpg, liftoff/0/testimonials/0/testimony/0=asdfsdfgdfghfghjghjk, liftoff/0/gallery/0/thumbnailOver/0=/cms/media/event_05.jpg, liftoff/0/events/0/eventImage/0=/cms/media/event_01.jpg, liftoff/0/events/0/eventDate/0=2006/10/10, liftoff/0/events/0/endDate/0=2006/10/10, liftoff/0/gallery/0/thumbnail/0=/cms/media/event_02.jpg, path=templatedata\xml\liftoff\data\were11, liftoff/0/events/0/eventName/0=Terrible, liftoff/0/events/0=, IWOV_PROC_FLAG=true, liftoff/0/testimonials/0/quote/0=Kid1}
DBD: TTableSchemaHelper not found in cache for [HERBALIFE]. Creating new.
DBD: RowsExistForPath
ELECT COUNT(*) FROM HERBALIFE WHERE Path = ?
DBD: INSERT:INSERT INTO HERBALIFE(Path,IW_State,eventDate,endDate,eventName,customerName,quote) VALUES (?,?,?,?,?,?,?)
DBD: Column: Path, field: path, Index: 1,Converting 'templatedata\xml\liftoff\data\were11' to VARCHAR
DBD: Column: IW_State, field: state, Index: 2,Converting 'Original' to VARCHAR
DBD: Column: eventDate, field: liftoff/0/events/0/eventDate, Index: 3,null
DBD: Column: endDate, field: liftoff/0/events/0/endDate, Index: 4,null
DBD: Column: eventName, field: liftoff/0/events/0/eventName, Index: 5,null
DBD: Column: customerName, field: liftoff/0/testimonials/0/customerName, Index: 6,null
DBD: Column: quote, field: liftoff/0/testimonials/0/quote, Index: 7,null
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: ORA-01400: cannot insert NULL into ("SCOTT"."HERBALIFE"."EVENTDATE")
DBD: Vendor Error Code: 1400
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-01400: cannot insert NULL into ("SCOTT"."HERBALIFE"."EVENTDATE")
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1284)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1160)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1072)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:475)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:334)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:974)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:261)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:194)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:542)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:568)
at java.lang.Thread.run(Thread.java:534)
Deployment file attached.
I am not sure as to why the fields are getting manipulated like this. I have checked the compatibility charts and our configuration seems to be a valid one.
TIA,
Rajat
