DataLoader [NSN-AC]

 

#!/bin/bash

 

NEType=$1

NEIns=$2

mrfTemplate=$3

startdate=$4

duration=$5

dimension=$6

rowsPerday=$7

hourCn=$8

randomFlag=$9

 

pipeDir=/var/opt/nokia/oss/osscore/iscirp/pmupld_osscore

WORK_DIR=`dirname $0`

WORK_DIR=`cd $WORK_DIR && pwd`

startTime=`date '+%Y-%m-%d_%H:%M:%S'`

logBatchNo=`date '+%m%d-%H%M%S'`

 

mrfTemplate=$WORK_DIR"/"$mrfTemplate

RESULT_DIR=`cd $WORK_DIR && cd ..&& pwd`

RESULT_DIR=$RESULT_DIR"/mrf_dir/"$1-$2"_"$logBatchNo

log_file=$WORK_DIR"/mrf_dir/"$1-$2"_"$logBatchNo.log

 

test ! -d $RESULT_DIR && mkdir -p $RESULT_DIR

 

echo "************** DATA LOADER RUNTIME LOG **************" > $log_file

echo "Original command: $0 $1 $2 $3 $4 $5 $6 $7 $8 $9

Begin at $startTime

 

Parameter list:

NE type      = $NEType

NE instance  = $NEIns

mrf Template = $mrfTemplate

Start Date   = $startdate

Duration     = $duration

Dimension Th = $dimension

Rows per day = $rowsPerday

Distinct hour= $hourCn

randomFlag   = $randomFlag

" |tee -a $log_file

 

gid=`sqlplus -S omc/omc <<EOF

set head off

select lower(trim(to_char(uco.co_gid,'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))) hex_str

from uma.utp_common_objects uco

where uco.co_dn like '%$NEType-$NEIns%'; 

EOF

`

echo "GID="$gid |tee -a $log_file 

 

$WORK_DIR/ETLOMeSGenmx.pl -NEtype $NEType -NEIns $NEIns -NEGid $gid -tem $mrfTemplate -date $startdate -dur $duration -dim $dimension  -rows $rowsPerday -hourCount $hourCn -outputDir $RESULT_DIR -maxLines 5000 -random $randomFlag |tee -a $log_file 

 

x=$?

if [ $x = 1 ]; then

  echo "Exception happened when parse xml file (ETLOMeSGenmx.pl). Abort!"|tee -a $log_file

  exit 1

fi;

 

 

echo "

xml file generation complete! Copy them to PM pipe dir...

" |tee -a $log_file

 

test -d $pipeDir

x=$?

if [ $x = 1 ]; then

  echo "PM pipe dir  $pipeDir not exist! Abort! "|tee -a $log_file

  exit 1

fi

 

cp $RESULT_DIR/*.xml $pipeDir

 

 

echo "************** Data loader complete **************" |tee -a $log_file