Index: trunk/Mars/datacenter/scripts/writemcsequencefile
===================================================================
--- trunk/Mars/datacenter/scripts/writemcsequencefile	(revision 9627)
+++ trunk/Mars/datacenter/scripts/writemcsequencefile	(revision 10019)
@@ -65,10 +65,28 @@
    sequencefile=$sequencepath/sequence$no2.txt
    
+   # data runs
    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence
    datruns=`sendquery`
+   if [ "$datruns" = "" ]
+   then 
+      printprocesslog "ERROR data runs for sequence "$sequence" are missing in the database "
+      check=2
+   fi
+   # pedestal runs
    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence
    pedruns=`sendquery`
+   if [ "$pedruns" = "" ]
+   then 
+      printprocesslog "ERROR pedestal runs for sequence "$sequence" are missing in the database "
+      check=2
+   fi
+   # calibration runs
    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence
    calruns=`sendquery`
+   if [ "$calruns" = "" ] 
+   then 
+      printprocesslog "ERROR calibration runs for sequence "$sequence" are missing in the database "
+      check=2
+   fi
    
    printprocesslog "INFO writing sequencefile $sequencefile"