Index: trunk/ippToPsps/jython/stackbatch.py
===================================================================
--- trunk/ippToPsps/jython/stackbatch.py	(revision 37246)
+++ trunk/ippToPsps/jython/stackbatch.py	(revision 37433)
@@ -284,4 +284,6 @@
         self.selectDvoObjIDs()
 
+        self.generateRandomIDs()
+
         # add indexes StackObjectThin
         self.scratchDb.createIndex("StackObjectThin", "objID")
@@ -932,4 +934,12 @@
         return True
 
+    def generateRandomIDs(self):
+        sql = "UPDATE StackObjectThin set randomStackObjID = FLOOR(RAND()*9223372036854775807)";
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.errorPair('failed sql',sql)
+            return
+
+
     '''
     select objID (psps object ID) from dvo restricted to this set of imageIDs. also insert
@@ -951,5 +961,5 @@
         sqlLine.group("skyCellID",        "'" + str(self.skycellID) + "'")
         sqlLine.group("dataRelease",      "'" + str(self.skychunk.dataRelease) + "'")
-        sqlLine.group("randomStackObjID", "FLOOR(RAND()*9223372036854775807)")
+   #     sqlLine.group("randomStackObjID", "FLOOR(RAND()*9223372036854775807)")
 
         whereClause = " WHERE ("