iwodcmd does not return -1 when deployment fails

Hi,

We are running OD/DD Version: 6.0.2.1.0.

When running the iwodcmd command to execute data deploy, if the deployment fails the command does not return a -1.

Below I have the command I am running followed by the datadeploy log that shows the deployment failed.

Thanks,
Nick

-----------------------------
Here's the command we are running:

/opt/Opendeploy/OpenDeployNG/bin/iwodcmd start xmlToDbPassDBTC2.cfg -inst WWWquark -k iwdd=xmltodb -k mytempcontent=_tc -k myenv=WWW -k mybox=quark -k xmlfile=/export/home/opendeploy/Projects/label/Atg72Tem-www-06-09-10-27/metadata_delta_template.xml -k currentTime=05/09/06 -k clearTable=no -k myuser=1234 -k mypass=acb -k mydb=web_meta -k myserver=zoot:3372
-----------------------------

Here's the datadeploy log that shows the exception, followed by the rollback, followed by the -1 return code. The command is not returning this -1. The command appears to return nothing at all.

DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: Attempt to insert duplicate key row in object 'MD_MASTER_WWW_NEELIX' with unique index 'MD_MASTER_WWW_NEELIX_key'

DBD: Vendor Error Code: 2601
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
com.sybase.jdbc2.jdbc.SybSQLException: Attempt to insert duplicate key row in object 'MD_MASTER_WWW_NEELIX' with unique index 'MD_MASTER_WWW_NEELIX_key'

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2535)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1916)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1540)
at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1523)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:89)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.InsertOneRow(TDbSchemaUpdateHelper.java:1133)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUpdate(TDbSchemaUpdateHelper.java:733)
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.DoOneXmlSource(TAgentClient.java:362)
at com.interwoven.dd100.dd.TAgentClient.DoXmlSource(TAgentClient.java:291)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:265)
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.IWDataDeploy.run(IWDataDeploy.java:568)
at java.lang.Thread.run(Thread.java:534)

DBD: ERROR Smiley Very Happy

oUpdate() failed for group [Master].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:deployment [xmltodb] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [Master]:
DBD: -----------------------------------
DBD: Rows inserted : 2
DBD: Rows updated : 705
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Stat for group [page_element]:
DBD: -----------------------------------
DBD: Rows inserted : 315
DBD: Rows updated : 0
DBD: Rows deleted : 315
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Rows inserted : 782
DBD: Rows updated : 0
DBD: Rows deleted : 775
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Stat for group [metadata1]:
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: Stat for group [metadata2]:
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: Stat for group [metadata3]:
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: Stat for group [metadata4]:
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: Stat for group [metadata5]:
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: Stat for group [metadata6]:
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: Stat for group [metadata7]:
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: Stat for group [metadata8]:
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: Stat for group [metadata9]:
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: Stat for group [metadata10]:
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 [zoot:3372/web_meta?charset=iso_1]...
DBD: Deployment[xmltodb]
DBD: Started : Thu Jun 08 14:53:52 MDT 2006
DBD: Finished: Thu Jun 08 14:57:10 MDT 2006
ENG: 2006-06-08 14:57:10 MDT GMT-06:00 nullDD Home : /opt/Opendeploy/OpenDeployNG
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[0]:currentTime=05/08/06
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[1]:myuser=abc
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[2]:iwdd=xmltodb
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[3]:mybox=sew
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[4]:myserver=rew
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[5]:myenv=WWW
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[6]:xmlfile=/export/home/opendeploy/Projects/label/Atg72Con-www-06-08-14-23/metadata_delta.xml
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[7]:clearTable=no
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[8]:mypass=****
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[9]:mydb=meta
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[10]:cfg=/opt/Opendeploy/OpenDeployNG/conf/xmlToDbPassDB.cfg.xml
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[11]:need-result=yes
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[12]:depuuid=e39589d0-f730-11da-85b8-c53df5d3a9d6
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[13]:leglabel=database
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[14]:svrlogfile=/opt/Opendeploy/OpenDeployNG/log/src.xmlToDbPassDB.cfgWWWneelix.xmltodb.phil.to.database.log
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 args[15]:execProcess=yes
DBD: 2006-06-08 14:53:52 MDT GMT+01:00 numArgs=16
Database Deployment error state: false

ENG: 2006-06-08 14:57:10 MDT GMT-06:00 Database deployment execution returned -1

ENG: 2006-06-08 14:57:10 MDT GMT-06:00 <<< Completed database deployment Invocation>>>

ENG: 2006-06-08 14:57:10 MDT GMT-06:00 Job ID=m466 Deployment leg=database Elapsed Time=199556 ms <<<
ENG: 2006-06-08 14:57:10 MDT GMT-06:00 End logfile [/opt/Opendeploy/OpenDeployNG/log/src.xmlToDbPassDB.cfgWWWneelix.xmltodb.phil.to.database.log]

Find more posts tagged with

Comments

Bill Klish

From the looks of the log you have the following set in odbase.xml. In the standalone element of the databaseDeployment section do you have execProcess="yes"?

You might try switching this to no or removing it. When we switched it to yes with version 6.0.2.1 we had weird results with return codes as well.

jed

Hi,

We are running OD/DD Version: 6.0.2.1.0.

When running the iwodcmd command to execute data deploy, if the deployment fails the command does not return a -1.

Yea. When I wrote a health check script I experienced weirdness with error codes based upon how/why OD failed. I ended up doing this...



        # save the output to a file
        my ($fhSTDERR, $errorSTDERR) = tempfile();
        my ($fhSTDOUT, $errorSTDOUT) = tempfile();
        # output outputs to STDERR
        open STDERR, ">$errorSTDERR";
        my $out=`$process > $errorSTDOUT`;
        my $outputSTDERR=slurp($errorSTDERR);
        my $outputSTDOUT=slurp($errorSTDOUT);
        unlink $errorSTDERR;
        unlink $errorSTDOUT;

        # OD has **** error reporting via STDERR and STDOUT
        # Look for these strings to produce a failure
        if($outputSTDERR =~ m/ERROR|error|Error|Unable/ ||
           $outputSTDOUT =~ m/ERROR|error|Error|Unable/){
[...]

So far this has worked...

RJEmy

You may wish to try this :-

my $odcmd = "Yor od command" ;

my $odResult;
eval
{
$odResult = `$odcmd >&1`;
};

my $error =$@;
if ($error ne "")
{
Log the error
}

if ($odResult == 0)
{
$task->CallBack(0, "Deployed files to Staging");
}
else
{
$task->CallBack(1, "OpenDeploy Failed");
}

Parag

Hi Nick,
I am having the same problem.
How did you overcome by this problem?
Were u able to get the correct return status of iwodcmd command? How?

It would be great help if u suggest something.
Thanks'
-Parag