Index: trunk/MagicSoft/Mars/datacenter/macros/getdolist.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/getdolist.C	(revision 7480)
+++ trunk/MagicSoft/Mars/datacenter/macros/getdolist.C	(revision 7482)
@@ -130,5 +130,5 @@
                     rc.GetValue(table+".TimerTable", ""),
                     rc.GetValue(table+".Primary", ""));
-    query+=Form(" WHERE ISNULL(%s) AND ISNULL(fFailedCode) AND ISNULL(fFailedComment) AND ISNULL(fStartTime) AND ISNULL(fFailedTime) ", column.Data());
+    query+=Form(" WHERE ISNULL(%s) AND ISNULL(fReturnCode) AND ISNULL(fFailedCode) AND ISNULL(fFailedCodeAdd) AND ISNULL(fStartTime) AND ISNULL(fFailedTime) ", column.Data());
 
     TIter Next(&l);
Index: trunk/MagicSoft/Mars/datacenter/macros/setstatus.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/setstatus.C	(revision 7480)
+++ trunk/MagicSoft/Mars/datacenter/macros/setstatus.C	(revision 7482)
@@ -116,14 +116,14 @@
 }
 
-Int_t SetInfluences(MSQLServer &serv, TEnv &rc, TString primary, TString table, TString column, TString statustime, TString failedcode, TString failedcomment, TString starttime, TString failedtime, Bool_t resetall)
+Int_t SetInfluences(MSQLServer &serv, TEnv &rc, TString primary, TString table, TString column, TString statustime, TString returncode, TString failedcode, TString failedcodeadd, TString starttime, TString failedtime, Bool_t resetall)
 {
-    cout << "set influenes for " << table << "." << column << endl;
+    cout << "set influences for " << table << "." << column << endl;
 
     //build query and set step and influences for the step
     TString influences  = rc.GetValue(table+"."+column+".Influences", "");
 
-    TString query(Form("UPDATE %s SET %s=%s, fFailedCode=%s, fFailedComment=%s, fFailedTime=%s ",
-                       table.Data(), column.Data(), statustime.Data(), failedcode.Data(),
-                       failedcomment.Data(), failedtime.Data()));
+    TString query(Form("UPDATE %s SET %s=%s, fReturnCode=%s, fFailedCode=%s, fFailedCodeAdd=%s, fFailedTime=%s ",
+                       table.Data(), column.Data(), statustime.Data(), returncode.Data(), failedcode.Data(),
+                       failedcodeadd.Data(), failedtime.Data()));
     if (starttime.CompareTo("noreset"))
         query += Form(", fStartTime=%s", starttime.Data());
@@ -163,5 +163,5 @@
 }
 
-int setstatus(TString primary, TString table, TString column, TString statustime, TString failedcode, TString failedcomment, TString starttime, TString failedtime, Bool_t resetall=kTRUE)
+int setstatus(TString primary, TString table, TString column, TString statustime, TString returncode, TString failedcode, TString failedcodeadd, TString starttime, TString failedtime, Bool_t resetall=kTRUE)
 {
     TEnv env("sql.rc");
@@ -182,5 +182,5 @@
 
     //if reset is needed and/or can be done, set new values
-    return !CheckReset(rc, table, column, statustime) ? 0 : SetInfluences(serv, rc, primary, table, column, statustime, failedcode, failedcomment, starttime, failedtime, resetall);
+    return !CheckReset(rc, table, column, statustime) ? 0 : SetInfluences(serv, rc, primary, table, column, statustime, returncode, failedcode, failedcodeadd, starttime, failedtime, resetall);
 
 }
Index: trunk/MagicSoft/Mars/datacenter/macros/setupdb.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7480)
+++ trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 7482)
@@ -606,5 +606,6 @@
          "  fFailedTime       DATETIME             NULL,"
          "  fFailedCode       SMALLINT UNSIGNED    NULL,"
-         "  fFailedComment    VARCHAR(255)         NULL"
+         "  fReturnCode       SMALLINT UNSIGNED    NULL,"
+         "  fFailedCodeAdd    INT      UNSIGNED    NULL"
          ")";
 
@@ -618,5 +619,6 @@
          "  fFailedTime            DATETIME             NULL,"
          "  fFailedCode            SMALLINT UNSIGNED    NULL,"
-         "  fFailedComment         VARCHAR(255)         NULL"
+         "  fReturnCode            SMALLINT UNSIGNED    NULL,"
+         "  fFailedCodeAdd         INT      UNSIGNED    NULL"
          ")";
 
@@ -636,5 +638,6 @@
          "  fFailedTime            DATETIME             NULL,"
          "  fFailedCode            SMALLINT UNSIGNED    NULL,"
-         "  fFailedComment         VARCHAR(255)         NULL"
+         "  fReturnCode            SMALLINT UNSIGNED    NULL,"
+         "  fFailedCodeAdd         INT      UNSIGNED    NULL"
          ")";
 
@@ -651,5 +654,6 @@
          "  fFailedTime            DATETIME             NULL,"
          "  fFailedCode            SMALLINT UNSIGNED    NULL,"
-         "  fFailedComment         VARCHAR(255)         NULL"
+         "  fReturnCode            SMALLINT UNSIGNED    NULL,"
+         "  fFailedCodeAdd         INT      UNSIGNED    NULL"
          ")";