Index: /trunk/ippToPsps/jython/gpc1db.py
===================================================================
--- /trunk/ippToPsps/jython/gpc1db.py	(revision 35184)
+++ /trunk/ippToPsps/jython/gpc1db.py	(revision 35185)
@@ -61,7 +61,9 @@
             sql = "SELECT DISTINCT stage_id, DEGREES(ra), DEGREES(decl) \
                    FROM addRun \
+                   JOIN addProcessedExp USING (add_id) \
                    JOIN minidvodbRun USING(minidvodb_name) \
                    JOIN minidvodbProcessed USING(minidvodb_id) \
                    JOIN camRun ON (stage_id = cam_id) \
+                   JOIN camProcessedExp USING(cam_id) \
                    JOIN chipRun USING (chip_id) \
                    JOIN rawExp USING (exp_id) \
@@ -73,4 +75,6 @@
                    AND minidvodbProcessed.fault = 0 \
                    AND mergedvodbProcessed.fault = 0 \
+                   AND camProcessedExp.fault = 0 \
+                   AND addProcessedExp.fault = 0 \
                    AND addRun.stage = '" + stage + "' \
                    AND addRun.state = 'full' \
Index: /trunk/ippToPsps/jython/ipptopspsdb.py
===================================================================
--- /trunk/ippToPsps/jython/ipptopspsdb.py	(revision 35184)
+++ /trunk/ippToPsps/jython/ipptopspsdb.py	(revision 35185)
@@ -1099,4 +1099,7 @@
             return 0
 
+        if value is None:
+            return 0
+
         print "box ingested host ", value, " does not match db host ", host
         raise
Index: /trunk/ippToPsps/jython/loader.py
===================================================================
--- /trunk/ippToPsps/jython/loader.py	(revision 35184)
+++ /trunk/ippToPsps/jython/loader.py	(revision 35185)
@@ -118,4 +118,5 @@
 
         numAttempts = 0
+        abort = False
         while True:
 
@@ -138,5 +139,4 @@
                 self.logger.infoPair("client status", "ok")
 
-                abort = False
                 for batchType in self.skychunk.batchTypes:
 
