Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 27794)
+++ trunk/ippTools/share/Makefile.am	(revision 27795)
@@ -114,5 +114,6 @@
      difftool_pendingcleanupskyfile.sql \
      difftool_revertdiffskyfile_delete.sql \
-     difftool_revertdiffskyfile_update.sql \
+     difftool_revertdiffskyfile_updated.sql \
+     difftool_setskyfiletoupdate.sql \
      difftool_skyfile.sql \
      difftool_todiffskyfile.sql \
@@ -223,4 +224,5 @@
      pstamptool_completedreq.sql \
      pstamptool_datastore.sql \
+     pstamptool_getdependent.sql \
      pstamptool_listjob.sql \
      pstamptool_pendingdependent.sql \
Index: trunk/ippTools/share/pstamptool_getdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_getdependent.sql	(revision 27795)
+++ trunk/ippTools/share/pstamptool_getdependent.sql	(revision 27795)
@@ -0,0 +1,5 @@
+SELECT DISTINCT pstampDependent.*
+FROM pstampDependent
+JOIN pstampJob USING(dep_id)
+JOIN pstampRequest USING(req_id)
+WHERE pstampDependent.state = 'new'
Index: trunk/ippTools/share/pstamptool_pendingdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27794)
+++ trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27795)
@@ -4,3 +4,5 @@
 JOIN pstampRequest USING(req_id)
 WHERE pstampDependent.state = 'new'
+    AND pstampDependent.fault = 0
     AND pstampJob.state = 'run'
+    AND pstampRequest.state = 'run'
Index: trunk/ippTools/share/pstamptool_revertdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_revertdependent.sql	(revision 27794)
+++ trunk/ippTools/share/pstamptool_revertdependent.sql	(revision 27795)
@@ -3,2 +3,3 @@
     JOIN pstampRequest USING(req_id)
 SET pstampDependent.fault = 0
+WHERE pstampDependent.state = 'new'
Index: trunk/ippTools/src/pstamptool.c
===================================================================
--- trunk/ippTools/src/pstamptool.c	(revision 27794)
+++ trunk/ippTools/src/pstamptool.c	(revision 27795)
@@ -530,5 +530,5 @@
 
     PXOPT_COPY_S64(config->args, where, "-req_id", "req_id", "==");
-    PXOPT_COPY_S64(config->args, where, "-fault", "req_id", "==");
+    PXOPT_COPY_S64(config->args, where, "-fault", "fault", "==");
     PXOPT_COPY_STR(config->args, where, "-state", "pstampRequest.state", "==");
     pxAddLabelSearchArgs(config, where, "-label", "pstampRequest.label", "LIKE");
@@ -967,5 +967,5 @@
     PXOPT_LOOKUP_STR(component,   config->args, "-component",  true, false);
     PXOPT_LOOKUP_STR(imagedb,     config->args, "-imagedb",  true, false);
-    PXOPT_LOOKUP_STR(rlabel,      config->args, "-rlabel",  false, false);
+    PXOPT_LOOKUP_STR(rlabel,      config->args, "-rlabel",  true, false);
     PXOPT_LOOKUP_BOOL(need_magic, config->args, "-need_magic", false);
     PXOPT_LOOKUP_BOOL(no_create,  config->args, "-no_create", false);
@@ -983,5 +983,5 @@
     }
 
-    psString query = pxDataGet("pstamptool_pendingdependent.sql");
+    psString query = pxDataGet("pstamptool_getdependent.sql");
     if (!query) {
         psError(PXTOOLS_ERR_SYS, false, "failed to retreive SQL statement");
@@ -1186,5 +1186,5 @@
 
     psMetadata *where = psMetadataAlloc();
-    PXOPT_COPY_S64(config->args, where, "-fault", "req_id", "==");
+    PXOPT_COPY_S64(config->args, where, "-fault", "pstampDependent.fault", "==");
     PXOPT_COPY_S64(config->args, where, "-dep_id", "dep_id", "==");
     pxAddLabelSearchArgs(config, where, "-label", "pstampRequest.label", "==");
@@ -1201,6 +1201,6 @@
     }
 
-    psString whereClause = psDBGenerateWhereSQL(where, NULL);
-    psStringAppend(&query, " %s", whereClause);
+    psString whereClause = psDBGenerateWhereConditionSQL(where, NULL);
+    psStringAppend(&query, " AND %s", whereClause);
     psFree(whereClause);
     psFree(where);
Index: trunk/ippTools/src/pstamptoolConfig.c
===================================================================
--- trunk/ippTools/src/pstamptoolConfig.c	(revision 27794)
+++ trunk/ippTools/src/pstamptoolConfig.c	(revision 27795)
@@ -177,5 +177,6 @@
     psMetadata *revertdependentArgs = psMetadataAlloc();
     psMetadataAddS64(revertdependentArgs, PS_LIST_TAIL, "-dep_id", 0, "define id for dependent", 0);
-    psMetadataAddS16(revertdependentArgs, PS_LIST_TAIL, "-fault",  0,   "new value for fault", 0);
+    psMetadataAddStr(revertdependentArgs, PS_LIST_TAIL, "-label", PS_META_DUPLICATE_OK,   "define label for dependent ", NULL);
+    psMetadataAddS16(revertdependentArgs, PS_LIST_TAIL, "-fault",  0,   "define fault", 0);
 
     // -pendingdependent