Shell Programming and Scripting

2010-10-10 22:25:42
[Error: 43059] Init block 'UA Deployment Date': Dynamic refresh of repository scope variables has failed.
[Error: 16024] The ODBC function has returned an error. The database may not be available, or the network may be down.
2010-12-10 22:25:42
[Error: 43059] Init block 'Current Usage Accelerator Refresh Date': Dynamic refresh of repository scope variables has failed.
[Error: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down.
2010-12-11 22:25:42
[Error: 43059] Init block 'New Activity Interval for Asset': Dynamic refresh of repository scope variables has failed.
[Error: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down.
2010-12-11 22:25:42
[Error: 43059] Init block 'New Activity Interval for Account': Dynamic refresh of repository scope variables has failed.
[Error: 16024] The ODBC function has returned an error. The database may not be available, or the network may be down.
2010-12-13 22:25:42
[Error: 43059] Init block 'New Activity Interval for Opportunity': Dynamic refresh of repository scope variables has failed.
[Error: 16024] The ODBC function has returned an error. The database may not be available, or the network may be down.

tail -f $logfile |
   while read LINE; do
    if echo $LINE | grep ^20..'-'..'-'.. >/dev/null; then
        logdate=$LINE
    echo " the log date is: ========== $logdate ============="
        if ['$logdate'<'$lastdate']; then
            if echo $LINE | grep '16024' >/dev/null; then
               echo " ========= I find the error   =================================: $LINE"
            
            #    echo $LINE | cut -d "|" -f > $tempfile
            fi
        fi
#    if echo $LINE | date >/dev/null; then
#        lastrun=$LINE
#        echo " ========= Last run date is=================================: $lastrun"
#        if [$lastrun < $lastdate ]; then
#           echo " Last run date is less than last date"
#               if echo $LINE | grep ^20..'-'..'-'.. >/dev/null; then
#                linecount=$(($linecount + 1))
#                echo " I find the line: $LINE"
#                      echo $LINE | cut -d "|" -f > $tempfile
#                         breakdown=$(echo $LINE | cut -d "]" -f 1)
#                 echo "$LINE" >> $tempfile
#                    echo "The break down is:   $breakdown" 
#            fi
        else
            echo " Last run date is larger than last date"
        fi
#    fi
exit 0
done<$logfile

 awk -v l="$lastdate" '/^....-..-../&&$0>l{d=$0}d&&/Error: 1602[34]/{print d,$0}' file1

awk -v l="$lastdate" '($0==l){n=1}(n==1)&&(/Error: 1602[34]/||/^....-/)' input

inserter=`sqlplus -s <<EOF $USERID/$PASSW@$DB
set heading off
set pagesize 0
set tab off
INSERT INTO DB.ERROR(ERR_DATE, ERR_MSG)
VALUES
($logdate,$errormsg);
exit
EOF`

awk -v l="$lastdate" '/^....-..-../&&$0>l{d=$0}d&&/Error: 1602[34]/{print d,$0}' $logfile

while read LINE; do
DATE=`echo $LINE | awk -v l="$lastdate" '/^....-..-../&&$0>l{d=$0}d&&/Error: 1602[34]/{print d}'`
MSG=`echo $LINE | awk -v l="$lastdate" '/^....-..-../&&$0>l{d=$0}d&&/Error: 1602[34]/{print $0}'`
#here i will call sql plus and insert above variables into database
done<$logfile

$ export lastdate='2010-12-11 22:25:42'
$ export fmt="INSERT INTO DB.ERROR(ERR_DATE, ERR_MSG) \nVALUES \n('%s','%s');\n"
$ awk -v l="$lastdate" -v f="$fmt" '/^....-..-../&&$0>l{d=$0}d&&/Error: 1602[34]/{printf(f,d,$0)}' file1
INSERT INTO DB.ERROR(ERR_DATE, ERR_MSG)
VALUES
('2010-12-13 22:25:42','[Error: 16024] The ODBC function has returned an error. The database may not be available, or the network may be down.');
$