we need to revert to provious edition of team site.
A) we used teamsite area base data deplyemnt (ext attrbute+Tamsite record) to update the some DB tables. when we deploy to exsiting tabel to revert to a prevouse version expected the below behaviour is not working,
1) inserted record need to be deleted
2) changed data should be revereted for the existing record.
Note:
However if you delete the all the records in the table and then if you do a arae base DD deployment this inserts the record correctly.
Can some one help how to reolve this issue
below is error thet we are geting when we try to update
*******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: ORA-01400: cannot insert NULL into ("CMS_CONTENT"."IWTEMP_998D6EA"."FILE_EXTENSTION")
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 ("CMS_CONTENT"."IWTEMP_998D6EA"."FILE_EXTENSTION")
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.executeFetch(TTC7Protocol.java:955)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2053)
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.TDbSchemaRowSort.InsertRows(TDbSchemaRowSort.java:268)
at com.interwoven.dd100.dd.TDbSchemaRowSort.PerformSort(TDbSchemaRowSort.java:79)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.PerformSort(TDbSchemaUpdateHelper.java:137)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired(TDbSchemaUpdateHelper.java:157)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:823)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdateWithGroupTree(TDbSchemaCfg.java:953)
at com.interwoven.dd100.dd.TDbSchemaCfg.RealUpdate(TDbSchemaCfg.java:933)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:441)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TPredicateEvaluator.WriteTuple(TPredicateEvaluator.java:116)
at com.interwoven.dd100.dd.TTupleSubstitutor.WriteTuple(TTupleSubstitutor.java:113)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1008)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:502)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.DoMultiDeployment(TAgentClient.java:206)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:169)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:608)
at java.lang.Thread.run(Thread.java:534)
DBD: ERROR
oRealUpdate() failed for group [CPL_PRICING].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/page/cpl/data/
DBD: ERROR
eployment [cpl] FAILED
DBD: ERROR:multi-deployment [all] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
