Changeset 33833 for trunk/ippToPsps/jython/scratchdb.py

Timestamp:

Apr 27, 2012, 1:37:43 PM (14 years ago)

Author:

rhenders

Message:

catching exception if table to drop is missing

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (1 diff)

trunk/ippToPsps/jython/scratchdb.py

@@ -408 +408 @@
                     self.logger.errorPair("Unable to delete " + fileType + " file from", self.dvoDoneTable)
 
-               sql = "DROP TABLE " + self.getDbFriendlyTableName(region + "." + fileType)
-               self.execute(sql)
+               tableName = self.getDbFriendlyTableName(region + "." + fileType) 
+               sql = "DROP TABLE " + tableName
+               try: self.execute(sql)
+               except:
+                    self.logger.errorPair("Unable to drop table", tableName)
+                    pass
 
         deletedDetectionCount = detectionCount - self.getRowCount(self.dvoDetectionTable)