Completed with errors

Hi All,

I am trying to deploy the files to the target server and encountering the following error. Could you tell me where I am going wrong? The files are not getting published. I am invoking the OD script through the WF.

Thanks!
Jenni

[html]

\iw-home\opendeploy\OpenDeployNG\bin\iwodcmd start PLC\Documents_dd.xml -k iwdd=dcr_to_db -k area=\default\main\sha\internet\marylandroads\Projects\PG618_21\WORKAREA\workarea\ -k filename=templatedata\Project_Templates\Documents\data\Documents -k project=123 -k need-result=yes--------------------------------------------

OUTPUT:
Locating OpenDeploy service.
Got OpenDeploy service
>>>>>-- Start deployment PLC\Documents_dd.
iwodstart running in default synchronous mode.
Need to wait for deployment to complete.
>>>>>-- Deployment PLC\Documents_dd finished:
ID: m3 Start time: Thu Feb 07 09:07:56 EST 2008
Status: Completed with error

[/html]

Find more posts tagged with

Comments

nipper

We need a lot more information than that.

You need to get the DD logs off of the OD sender.

Andy

Jenni

We need a lot more information than that.

You need to get the DD logs off of the OD sender.

Andy

Hi Andy,

Here is the portion of the log...

Thanks!
Jenni

[html]
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: ORA-00001: unique constraint (PLCDBA.PK_PROJECT_DOCUMENT) violated

DBD: Vendor Error Code: 1
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-00001: unique constraint (PLCDBA.PK_PROJECT_DOCUMENT) violated

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:675)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:601)
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:570)
at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:763)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3422)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1284)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.InsertReplSameLevel(TDbSchemaGroupCfg.java:1621)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformReplicantInsert(TDbSchemaGroupCfg.java:1351)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1135)
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: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.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.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: ERROR Smiley Very Happy

oInsert() failed for group [Purpose and Need].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata\Project_Templates\Documents\data\Documents
DBD: ERROR:deployment [dcr_to_db] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
[/html]

nipper

Well this is something you will need to debug, there is some information in the log before the part you posted. However you are putting invalid data into a field that needs to be unique(it is the primary key I assume):

unique constraint (PLCDBA.PK_PROJECT_DOCUMENT) violated

Look in the file again and see what value you are placing in that field.

jagadesh

Hi,
Please check the dcr is having two values for
PK_PROJECT_DOCUMENT or not. In Schema you mentioned as primary key. So it needs unique value.

sumitk

This error could be if you are trying to insert an already existing value into a column defined unique.

Jenni

Hi Guys,

Thanks for the replies. Yes the issue was with the dupilcate row in the table.

Thanks!
Jenni