DataDeploy Fail but workflow ended.

jihan

Hi,

We're having an intermittent issue whereby data is not displayed in portal after deployment.

The flow is :

1) User upload document in TeamSite
2) Submit to workflow
3) Tag the document with all the Metadata values required
4) Deploy & View in portal

It's using filelist deployment. When I check the log (filelist..dd.log), I've found an error:

DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: ORA-06519: active autonomous transaction detected and rolled back
ORA-06512: at "CSKP.TG_CSKPMETADATA_MASTER_UPD", line 288
ORA-04088: error during execution of trigger 'CSKP.TG_CSKPMETADATA_MASTER_UPD'

DBD: Vendor Error Code: 6519
DBD: SQL state: 65000
DBD: *******************************************************
DBD: 
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-06519: active autonomous transaction detected and rolled back
ORA-06512: at "CSKP.TG_CSKPMETADATA_MASTER_UPD", line 288
ORA-04088: error during execution of trigger 'CSKP.TG_CSKPMETADATA_MASTER_UPD'

 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.TDbSchemaUpdateHelper.UpdateOneRow(TDbSchemaUpdateHelper.java:877)
 at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUpdate(TDbSchemaUpdateHelper.java:723)
 at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:827)
 at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:852)
 at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:448)
 at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
 at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:455)
 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.ProcessOneFileList(TAgentClient.java:581)
 at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:538)
 at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:483)
 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.TDASThread.ProcessItem(TDASThread.java:203)
 at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)


DBD: ERRORoUpdate() failed for group [cskpmetadata_master].
DBD:  -- Failed 
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source procedure_facado/whats_new/promotion/Current/DG Smart Plan Refresher.zip, obtained from filelist=/app/iw-home/tmp/filelist.1554406_2
DBD: Filelist walk done
DBD: ERROR:deployment [cskpmetadata] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [cskpmetadata_master]:
DBD: -----------------------------------
DBD:   Rows inserted      : 0
DBD:   Rows updated       : 0
DBD:   Rows deleted       : 0
DBD:   Rows failed        : 0
DBD:   Rows rolled back   : 0
DBD:   Rows skipped       : 0
DBD: -----------------------------------
DBD: Rollback database [192.100.100.161:1521:cskp]...
DBD: Deployment[cskpmetadata] 
DBD: -----------------------------------
DBD:   Files with EAs inserted      : 0
DBD:   Files with EAs updated       : 0
DBD:   Files with EAs deleted       : 0
DBD:   Files with EAs failed        : 0
DBD:   Files with EAs rolled back   : 0
DBD:   Files with EAs skipped       : 0
DBD: -----------------------------------
DBD: Started : Tue Aug 23 17:07:20 SGT 2011
DBD: Finished: Tue Aug 23 17:07:20 SGT 2011
DBD: 
### IWDataDeploy FAILED ###

What is it trying to do exactly when it returned the error "ORA-06519: active autonomous transaction detected and rolled back" ?

How should I solve this error?

Please help!

The environment is :
Interwoven TeamSite 6.5.0 Service Pack 2
running on Solaris box. DB is Oracle.

Thank you.

Rick Poulin

This is a problem with your DB trigger and not with DataDeploy. Judging from the error description http://ora-06519.ora-code.com/, your trigger is executing PL/SQL that is expecting an explicit 'commit' or 'rollback' and you haven't provided one.