Index: branches/eam_branches/ipp-20121219/ippToPsps/jython/detectionbatch.py
===================================================================
--- branches/eam_branches/ipp-20121219/ippToPsps/jython/detectionbatch.py	(revision 34857)
+++ branches/eam_branches/ipp-20121219/ippToPsps/jython/detectionbatch.py	(revision 34902)
@@ -766,5 +766,5 @@
                 self.populateSkinnyObjectTable(ota)
                 #self.logger.info("updated skinnyobject")
-                self.populateObjectCalColorTable(ota)
+                #self.populateObjectCalColorTable(ota)
                 #self.logger.info("updated objectcalcolor")
                 self.populateDetectionCalibTable(ota)
@@ -775,5 +775,5 @@
                 self.tablesToExport.append("Detection_" + ota)
                 self.tablesToExport.append("SkinnyObject_" + ota)
-                self.tablesToExport.append("ObjectCalColor_" + ota)
+                #self.tablesToExport.append("ObjectCalColor_" + ota)
                 self.tablesToExport.append("DetectionCalib_" + ota)
                 tables.append("Detection_" + ota)
Index: branches/eam_branches/ipp-20121219/ippToPsps/jython/gpc1db.py
===================================================================
--- branches/eam_branches/ipp-20121219/ippToPsps/jython/gpc1db.py	(revision 34857)
+++ branches/eam_branches/ipp-20121219/ippToPsps/jython/gpc1db.py	(revision 34902)
@@ -61,8 +61,10 @@
                    JOIN rawExp USING (exp_id) \
                    JOIN mergedvodbRun using (minidvodb_id) \
+                   JOIN mergedvodbProcessed using (merge_id) \
                    WHERE mergedvodbRun.mergedvodb = '" + dvoDb + "' \
                    AND minidvodbRun.state = 'merged' \
                    AND mergedvodbRun.state = 'full' \
                    AND minidvodbProcessed.fault = 0 \
+                   AND mergedvodbProcessed.fault = 0 \
                    AND addRun.stage = '" + stage + "' \
                    AND addRun.state = 'full' \
@@ -77,13 +79,17 @@
                    JOIN minidvodbRun USING(minidvodb_name) \
                    JOIN minidvodbProcessed USING(minidvodb_id) \
+                   JOIN mergedvodbRun USING(minidvodb_id) \
+                   JOIN mergedvodbProcessed USING (merge_id) \
                    JOIN  stackRun USING(stack_id) JOIN skycell USING(skycell_id) \
-                   WHERE minidvodbRun.minidvodb_group = '" + dvoDb + "' \
+                   WHERE mergedvodbRun.mergedvodb = '" + dvoDb + "' \
                    AND minidvodbRun.state = 'merged' \
                    AND minidvodbProcessed.fault = 0 \
+                   AND mergedvodbRun.state = 'full' \
+                   AND mergedvodbProcessed.fault = 0 \
                    AND addRun.stage = '" + stage + "' \
                    AND addRun.state = 'full' \
                    AND decdeg BETWEEN " + str(minDec) + " AND " + str(maxDec) + " \
                    AND radeg BETWEEN " + str(minRA) + " AND " + str(maxRA) 
-
+            
         try:
             rs = self.executeQuery(sql)
Index: branches/eam_branches/ipp-20121219/ippToPsps/jython/stackbatch.py
===================================================================
--- branches/eam_branches/ipp-20121219/ippToPsps/jython/stackbatch.py	(revision 34857)
+++ branches/eam_branches/ipp-20121219/ippToPsps/jython/stackbatch.py	(revision 34902)
@@ -93,5 +93,5 @@
        self.scratchDb.dropTable("StackToImage")
        self.scratchDb.dropTable("SkinnyObject")
-       self.scratchDb.dropTable("ObjectCalColor")
+       #self.scratchDb.dropTable("ObjectCalColor")
        self.scratchDb.dropTable("StackDetectionCalib")
 
@@ -828,5 +828,5 @@
         self.populateSkinnyObject()
         #self.logger.infoPair("populating","ObjectCalColor") 
-        self.populateObjectCalColor()
+        #self.populateObjectCalColor()
         #self.logger.infoPair("populating","StackDetectionCalib") 
         self.populateStackDetectionCalib()