Index: trunk/MagicSoft/Mars/datacenter/scripts/condorstatistics
===================================================================
--- trunk/MagicSoft/Mars/datacenter/scripts/condorstatistics	(revision 9099)
+++ trunk/MagicSoft/Mars/datacenter/scripts/condorstatistics	(revision 9100)
@@ -64,5 +64,5 @@
    case $check0 in 
       1)   echo " check0=$check0 -> everything ok -> move files" >> $scriptlog 2>&1
-           printprocesslog "INFO plots successfully produced"
+           printprocesslog "INFO condor statistic filled succesfully"
            day=`basename $date`
            cd `dirname $date`
@@ -79,6 +79,6 @@
            cd $mars
            ;;
-      *)   echo " check0=$check0 -> ERROR -> couldn't create plots -> exit" >> $scriptlog 2>&1
-           printprocesslog "ERROR producing plots failed"
+      *)   echo " check0=$check0 -> ERROR -> couldn't fill condor statistic to DB -> exit" >> $scriptlog 2>&1
+           printprocesslog "ERROR filling condor statistic to DB failed"
            finish >> $scriptlog 2>&1
            ;;
Index: trunk/MagicSoft/Mars/datacenter/scripts/dbchk
===================================================================
--- trunk/MagicSoft/Mars/datacenter/scripts/dbchk	(revision 9099)
+++ trunk/MagicSoft/Mars/datacenter/scripts/dbchk	(revision 9100)
@@ -163,5 +163,5 @@
 
 # CHECK 3
-echo "Checking if all sequences from Sequences exists RunData" >> $scriptlog 2>&1
+echo "Checking if all sequences from Sequences exist RunData" >> $scriptlog 2>&1
 sequences=`echo SELECT fSequenceFirst FROM Sequences GROUP BY fSequenceFirst | mymysql`
 for sequence in $sequences
@@ -177,5 +177,5 @@
 
 # CHECK 4
-echo "Checking if all sequences from RunData exists in Sequences" >> $scriptlog 2>&1
+echo "Checking if all sequences from RunData exist in Sequences" >> $scriptlog 2>&1
 sequences=`echo SELECT fSequenceFirst FROM RunData WHERE not fSequenceFirst=0 GROUP BY fSequenceFirst | mymysql`
 for sequence in $sequences
@@ -190,3 +190,17 @@
 done
 
+# CHECK 5
+echo "Checking if all sequences from RunData exist in SequenceProcessStatus" >> $scriptlog 2>&1
+sequences=`echo SELECT fSequenceFirst FROM RunData WHERE not fSequenceFirst=0 GROUP BY fSequenceFirst | mymysql`
+for sequence in $sequences
+do
+   var=`echo SELECT fSequenceFirst FROM SequenceProcessStatus WHERE fSequenceFirst=$sequence | mymysql`
+   if ! [ "$sequence" = "$var" ]
+   then
+      echo "Sequence $sequence exists in RunData but not in SequenceProcessStatus." >> $scriptlog 2>&1
+      printprocesslog "Sequence $sequence exists in RunData but not in SequenceProcessStatus (DB)." 
+      continue
+   fi
+done
+
 finish >> $scriptlog 2>&1