Shell Programming and Scripting

 Rejected - Error on table TableA, column ColA.
Error String 1.
 Rejected - Error on table TableA, column ColB.
Error String 2.
 Rejected - Error on table TableA, column ColB.
Error String 2.
 Rejected - Error on table TableA, column ColA.
Error String 1.
 Rejected - Error on table TableA, column ColA.
Error String 1.

 Rejected - Error on table TableA, column ColA.
Error String 1.                                                   3 Rows
 Rejected - Error on table TableA, column ColB.
Error String 2.                                                   2 Rows

awk '{x=$0; getline; x=x"\n"$0; a[x]++}END{for (i in a){print i, a[i], "rows"}}' file

awk '{x=$0;            ###### Taking complete line into a variable named x
getline;               ###### getline is an awk keyword to move the cursor to next line.
x=x"\n"$0;             ###### taking value of variable named x with it's previous value and then new line and then complete line($0).
a[x]++}                ###### Here creating an array named a whose index is x and incrementing it's each occurances too.
END{                   ###### starting END section here.
for (i in a){          ###### starting a for loop in array named a
print i, a[i], "rows"} ###### here once we get into array a then printing the value of vafriable i, value of array a as a[i](which is nothing but count of rows) and string rows then. 
}' file                ###### calling Input_file here.

grep -A 1 "Rejected - Error" $FILE_NAME | cut -d':' -f2

awk '/^ Rejected/ {x=$0; getline; x=x"\n"$0; a[x]++}END{for (i in a){print i, a[i], "rows"}}' file
 Rejected - Error on table TableA, column ColB.
Error String 2. 2 rows
 Rejected - Error on table TableA, column ColA.
Error String 1. 3 rows

perl -nle 'if($id){$save{"$id\n$_"}++}; ($id)=/^( Rejected.*$)/; END{for(keys %save){print "$_ $save{$_} rows"}}' deekhari.log

 Rejected - Error on table TableA, column ColB.
Error String 2. 2 rows
 Rejected - Error on table TableA, column ColA.
Error String 1. 3 rows