I'm able to connect to the DB. Now the script is not executing . It is not showing any errors as well.
In my script "do.sql" is returning the count. However the script is not reading further down " if [[ ${fail_cnt} -ge 1 ]] ". Script and Debug output below.
...Now the script is not executing . It is not showing any errors as well.
In my script "do.sql" is returning the count. However the script is not reading further down " if [[ ${fail_cnt} -ge 1 ]] ". Script and Debug output below.
It does not show any errors because ${fail_cnt} which is '' is not greater than or equal to 1, and the control does not go inside the if branch. There is nothing erroneous about that.
You'll have to investigate your "do.tmp" file.
Maybe the file is empty?
Or maybe it is not empty but it does not have the text "MSG_fail", due to which awk does not report anything?
This User Gave Thanks to durden_tyler For This Post: