Hi,
we are getting following error for our "xml-to-db" deployment
[php]
DBD: Parameter Index: 7, Value: templatedata/learning/event/data/us000523, Converting 'templatedata/learning/event/data/us000523' to VARCHAR
DBD: Column: EventID, field: EventID, Index: 7,Converting 'templatedata/learning/event/data/us000523' to VARCHAR
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbAgent
reparedUpdate()
DBD: Exception Message: [TDS Driver]Empty Parameter:3
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [TDS Driver]Empty Parameter:3
at com.inet.tds.g.a(Unknown Source)
at com.inet.tds.g.for(Unknown Source)
at com.inet.tds.b.new(Unknown Source)
at com.inet.tds.b.executeUpdate(Unknown Source)
at com.interwoven.dd100.dd.TDbAgent.PreparedUpdate(TDbAgent.java:2046)
at com.interwoven.dd100.dd.TDbAgent.Update(TDbAgent.java:2951)
at com.interwoven.dd100.dd.TDbAgent.NarrowInsertUpdate(TDbAgent.java:2205)
at com.interwoven.dd100.dd.TDbAgent.WriteTuple(TDbAgent.java:3643)
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.DoOneXmlSource(TAgentClient.java:390)
at com.interwoven.dd100.dd.TAgentClient.DoXmlSource(TAgentClient.java:319)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:293)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: Error occured in TDbAgent:
reparedUpdate()
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:deployment [xml-to-db] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Rollback database [10.28.1.136:1433?database=prod_publicsite]...
DBD: Deployment[xml-to-db] Table[EVENT1]
DBD: -----------------------------------
DBD: Tuples inserted : 0
DBD: Tuples updated : 0
DBD: Tuples deleted : 0
DBD: Tuples failed : 0
DBD: Tuples rolled back : 0
DBD: Tuples skipped : 0
DBD: -----------------------------------
DBD: Started : Tue Oct 20 07:25:18 CDT 2009
DBD: Shutting down DDD PublisherThread
DBD: Finished: Tue Oct 20 07:25:57 CDT 2009
DBD:
### IWDataDeploy FAILED ###
DBD:
### Sending result ###
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 Database deployment execution returned 1
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 <<< Completed database deployment Invocation>>>
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 Manifest path is E:/Interwoven/OpenDeployNG/log/db/iwovdev/src.iwovdev-eventsfinal.xml-to-db.USCEDWS04.to.database.log.mf
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@f50ac8
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 fHasFailedItems is set to true
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 Published leg event depUuid=[a11ffb50-bd73-11de-89b1-c10e57057d42] legLabel=[database] nextUuid=[null] nextDep=[null]
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 Job ID=m834 Deployment leg=database Elapsed Time=38468 ms <<<
ENG: 2009-10-20 07:25:57 CDT GMT-05:00 End logfile [E:\Interwoven\OpenDeployNG\log\db/iwovdev\src.iwovdev-eventsfinal.xml-to-db.USCEDWS04.to.database.log]
[/php]
untill some hours ago,this deployment was successfull ,the dcr "us000523" was also getting deployed ,actually it is already in DB ,some HTML tags like "p" have added through text editor in this DCR and now it is failing ,
looking forward for some guidance from experts,
regards,
mav
