Hi Guys,
I was trying to deploy metadata of a file but not able to deploy. It throws following exception. I checked IW documents but I didnt get any article or help regarding this exception. Can some one help me in this.
*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-01401: inserted value too large for column
Vendor Error Code: 1401
SQL state: 23000
*******************************************************
*******STACK TRACE*************
java.sql.SQLException: ORA-01401: inserted value too large for column
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1273)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1151)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1063)
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:472)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:331)
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:962)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:487)
at com.interwoven.dd100.dd.IWDataDeploy.runDeploy(IWDataDeploy.java:527)
at com.interwoven.dd100.dd.IWDataDeploy.main(IWDataDeploy.java:508)
ERROR
oInsert() failed for group [TS_CWS_METADATA].
-- Failed
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source guideme/345wide.jsp, obtained from filelist=/opt/app/iw-home/tmp/hubclean/
deploy_EMEA_main_Intranet_Inside_hub_test5_unit_EDITION.txt
Filelist walk done
ERROR:deployment [teamsite_metadata_fl] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Stat for group [TS_CWS_METADATA]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [153.88.144.144:1521:cwsopacc]...
Deployment[teamsite_metadata_fl]
-----------------------------------
Files with EAs inserted : 0
Files with EAs updated : 0
Files with EAs deleted : 0
Files with EAs failed : 0
Files with EAs rolled back : 0
Files with EAs skipped : 0
-----------------------------------
Started : Wed Mar 23 06:47:31 CET 2005
Finished: Wed Mar 23 06:47:33 CET 2005
Regards
-Amar
