need your expertise to help troubleshoot a certain problem i'm having. I crated a shell script which will ftp get 1 crash log from multiple servers (listed in a text file). Each log will then be parsed by calling an awk script. The problem is, for certain log its parsing perfectly, and for some, its not parsing at all.
I have checked the input file, they are FTPed without any error into desired input directory. Disk space is also not a problem. However the AWK is throwing out below errors :
Code:
$ awk -f crash.awk /home/icpapp/scripts/crash/input/crash.OM5 /home/icpapp/scripts/crash/output/crash.OM5
awk: Cannot find or open file /home/icpapp/scripts/crash/output/crash.OM5.
The input line number is 42440. The file is /home/icpapp/scripts/crash/output/crash.OM5.
The source line number is 1.
below is my shell script :
Code:
#!/bin/sh
APPHOME=$HOME/scripts/crash
for lines in `cat $APPHOME/crash.servers`
do
#echo $lines
SERVER=`echo $lines | cut -f1 -d=`
IP=`echo $lines | cut -f2 -d=`
#echo $IP
cd $APPHOME
echo "Getting crash log from : "$SERVER
$APPHOME/ftp.sh "$IP"
mv crash.txt $APPHOME/input/crash.$SERVER
echo "Input file : "$APPHOME/input/crash.$SERVER
echo "Output file : "$APPHOME/output/crash.$SERVER
awk -f crash.awk $APPHOME/input/crash.$SERVER $APPHOME/output/crash.$SERVER
if [ $? -eq 0 ]; then
echo "Exit status : Success"
else
echo "Exit Status : Error"
fi
echo "----------------------------------------"
done
exit 0
And below is my awk script :
Code:
BEGIN {
scope=0
crashinfo=""
pidtid=""
FS=" "
}
{
if ($0 == "-")
{
scope++
}
if ($1 == "Process")
{
scope++
}
if ($1 == "PROCESS")
{
scope++
}
if (substr($0,0,5) == " /app")
{
if (scope == 4)
{
crashinfo=$0
scope++
}
}
if ($1 == "Itanium" && $2 == "Register" && $3 == "dump" && $4 == "for")
{
if (scope == 5)
{
pidtid=$5" "$6" "$7" "$8
print pidtid"|"crashinfo >> ARGV[2]
scope=0
}
}
}
END {
}
I'm not sure if i should put in my put my input file in here as it is VERY huge. However, it would look like something like this :
hi guys,
i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB
MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
this the file raw format:
Number of... (6 Replies)
Hi,
I would like to parse the next output of an lvdisplay -v using awk:
--- Logical volumes ---
LV Name /dev/vg01/lvol3
VG Name /dev/vg01
LV Permission read/write
LV Status available/syncd
Mirror copies ... (2 Replies)
I am trying to parse two files and get data that does not match in one of the columns ( column 3 in my case )
Data for two files are as follows
A.txt
=====
abc 10 5 0 1 16
xyz 16 1 1 0 18
efg 30 8 0 2 40
ijk 22 2 0 1 25
B.txt
=====
abc... (6 Replies)
I'm converting some code from ksh on my macbook (Version M 1993-12-28 s+) to an older solaris machine with ksh 88.
I can't seem to figure out this line, it worked on the new shell version.
set -A combo -- $(for x in ${ImageIDs};
do
nawk -v s=$x 'if($2 == s) getline ; getline if ($1 ==... (2 Replies)
Hi Experts,
I am trying to parse the following file;
FILEA
a|b|c|c|c|c
a|b|d|d|d|d
e|f|a|a|a|a
e|f|b|b|b|boutput expected:
a<TAB>b
<TAB><TAB>c<TAB>c<TAB>c<TAB>c<TAB>
<TAB><TAB>d<TAB>d<TAB>d<TAB>d<TAB>
e<TAB>f
<TAB><TAB>a<TAB>a<TAB>a<TAB>a<TAB>
<TAB><TAB>b<TAB>b<TAB>b<TAB>b<TAB>*... (7 Replies)
Hello All,
I have a situation as below:
(1) Read a source file (a single file of 1.2 million rows in it )
(2) Read Destination files one by one and replace the content ( few fields in it ) with the corresponding matching field from source file.
I tried as below: ( please note I am not... (4 Replies)
Hi all, I have a file that contains a good hundred of these job definitions below:
Job Name Last Start Last End ST Run Pri/Xit
________________________________________________________________ ____________________... (7 Replies)
This is really frustrating because I can't figure it out.
I'm running a health check script. One of the items I'm checking is the amount of memory on a server. I use the free command, which outputs something like this (excerpt)
Mem: 100 100 100 100
Swap: 100 100 100 100
In my debugging... (5 Replies)
Hello:
I am working parsing a large input file which will be broken down into multiples based on the second field in the file, in this case: STORE.
The idea is to create each file with the corresponding store number, for example: Report_$STORENUM_$DATETIMESTAMP , and obtaining the... (7 Replies)
I have two files that I am going to use diff to find the differences but need to parse them before I do that. I have include the format of each file1 and file2 with the desired output of each (the first 5 fields in each file). The first file has a "chr" before the # that needs to be removed. I... (1 Reply)
09-26-2011
