This unix job failed with : "No such file or directory"
We are facing problem while executin below script,
Code:
cat $PIPE_FILE | imscp - "${LRX_FILE_LOC}" 2>&1 | tee "${LIST_DIR}/${IMSCP_OUT_FILE}" &
sqlplus -s ${REPORTING_CONNECT} <<EOF
whenever sqlerror exit 1 rollback
spool ${PIPE_FILE}
start ${LRX_EXEC_SQL} ${LRX_MDL_RUN_DATE}
spool off
exit
EOF
+ sqlplus -s /@plr03.prod
+ cat /tmp/11072.pipe
+ tee /production/lrx/listings/lrxwp001d_sup_job/
+ imscp - /fs932.1/production/lrx/data06/lrx_data_supplier_0812010.dat
+ 2>& 1
+ 0<<
whenever sqlerror exit 1 rollback
spool /tmp/11072.pipe
start /production/lrx/sql/lrx_supp_pharmetrics.sql 06-AUG-10
spool off
exit
tee: cannot open /production/lrx/listings/lrxwp001d_sup_job/
if [[ $? -ne 0 ]]
then
print An error occurred while executing sql for the extracting the data
print Check ${LRX_FILE_LOC} for errors
Finish 1 "Error occurred while executing sql for the extracting the data"
fi
+ [[ 0 -ne 0 ]]
# -----------------------------------------------------------------------------
# Zip the file and ftp to remote system
# -----------------------------------------------------------------------------
gzip -f ${LRX_FILE_LOC}
+ gzip -f /fs932.1/production/lrx/data06/lrx_data_supplier_0812010.dat
gzip: /fs932.1/production/lrx/data06/lrx_data_supplier_0812010.dat: No such file or directory
if [ $? -ne 0 ]
then
Finish 1 " Unable to compress the file ${LRX_DST_FILE_NM} "
fi
-----------------------------------------------------------------------
1. The above unix script, failed with "No such file or directory". but while executing this job, file is there in correct path only at that time(failure time). The file name is "/fs932.1/production/lrx/data06/lrx_data_supplier_0812010.dat". but is's saying like "unable to compress the file".
2. when a restart 2nd time failed with same reason without any changes.
3. when a restart 3rd time, it ran successfully without failed. but how??
----------------------------------------------------------------- We tested below code in development database(successful):
Code:
tlr01:lrxdusr:/development/lrx/temp> sh supp_ssig.ksh
rm /development/lrx/temp/supp_issue.pipe
+ rm /development/lrx/temp/supp_issue.pipe
mkfifo /development/lrx/temp/supp_issue.pipe
+ mkfifo /development/lrx/temp/supp_issue.pipe
cat /development/lrx/temp/supp_issue.pipe | imscp - /development/lrx/temp/lrx_data_supplier_0812010.dat 2>&1 | tee /development/lrx/temp/lrxwp001d_sup_job &
sqlplus / <<EOF
whenever sqlerror exit 1 rollback
spool /development/lrx/temp/supp_issue.pipe
start /development/lrx/temp/supp_issue.sql
spool off
exit
EOF
+ sqlplus /
+ cat /development/lrx/temp/supp_issue.pipe
+ imscp - /development/lrx/temp/lrx_data_supplier_0812010.dat
+ tee /development/lrx/temp/lrxwp001d_sup_job
+ 0< /var/tmp/sh10940.1
+ 2>& 1
tee: cannot open /development/lrx/temp/lrxwp001d_sup_job
IMS_filefopen: 07:03:21 - 2.09h For UX-11.00 Tue Aug 10 07:03:21 2010 /usr/local/bin/imssvr209h
IMS_filefopen: list of target filesystem(s) with file mask /development/lrx/temp/lrx_data_supplier_0812010.dat bufsize=51500
IMS_filefopen: /development/lrx/temp/ 50489 Kbytes available
IMS_internal_open: 07:03:21 - /development/lrx/temp/lrx_data_supplier_0812010.dat for write mode: w
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 10 07:03:21 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
IMS_internal_fclose: 07:03:21 - /development/lrx/temp/lrx_data_supplier_0812010.dat tot_bytes_io = 58
IMS_fclose: 07:03:21 - /development/lrx/temp/lrx_data_supplier_0812010.dat file_tot_bytes_io = 58
IMSCP: copy completed - 58 bytes
if [[ $? -ne 0 ]]
then
exit 1
fi
+ [[ 0 -ne 0 ]]
gzip -f /development/lrx/temp/lrx_data_supplier_0812010.dat
+ gzip -f /development/lrx/temp/lrx_data_supplier_0812010.dat
if [[ $? -ne 0 ]]
then
exit 1
fi
+ [[ 0 -ne 0 ]]
tlr01:lrxdusr:/development/lrx/temp> ll lrx_data_supplier_0812010.dat*
-rw-r--r-- 1 lrxdusr lrxdevl 108 Aug 10 07:03 lrx_data_supplier_0812010.dat.gz
Please refer my attachment. Please help me as soon as possible?
Thanks & Regards,
Saminathan.
Last edited by pludi; 08-11-2010 at 03:29 AM..
Reason: code tags, please...
Please use a more descriptive subject text. "Need clarification" won't tell anybody whether or not they can help you, or even what it's about
Please be careful with your formatting. For listings, there are [CODE][/CODE] tags. For everything else it isn't necessary to apply the format to each consecutive line separately.
Please describe what your program should do, what it does, and how it differs from the expected behaviour, instead of posting 2 listings and a screenshot. Most people don't own working crystal balls, and might discard your question without thinking about it. (See this).
Both of those scripts are extremely incomplete. PIPE_FILE is never defined anywhere, for instance. And most of those lines shouldn't be doing anything at all, with those pluses in front of everything.
I don't think you've got a script at all, there, you've got part of a diff file meant to be applied to a script.
---------- Post updated at 11:54 AM ---------- Previous update was at 11:52 AM ----------
[/COLOR]
Quote:
Originally Posted by Corona688
Both of those scripts are extremely incomplete. PIPE_FILE is never defined anywhere, for instance. And most of those lines shouldn't be doing anything at all, with those pluses in front of everything.
I don't think you've got a script at all, there, you've got part of a diff file meant to be applied to a script.
----------------------------------------------------------------------- Hi Corona,
The PIPE_FILE is defined already, that is not problem. but many path is defined previous lines. and this script is more 1000 lines. but i have posted half of the script where we face the problem.
Hi,
I want to use the "SU" command in script it is asking me to enter the password manually.
pleas the say the syntax of su command in single line that includes username/password. :) (3 Replies)
Hi All,
I have a file cleanlogs_imgp01_files which has the contents as follows,
cold_log|/opt/elf/cold_spool
get_orion_log|/opt/elf/logs
get_coldFiles_log|/opt/elf/logs
get_coldFiles_TuesToSat_log|/opt/elf/logs
get_coldFiles_MonToSat_log|/opt/elf/logs
And when i execute this, I get the... (1 Reply)
crw-rw-rw- 1 root root 1, 5 May 6 1998 /dev/zero
brw----rw- 1 root floppy 2, 28 May 6 1998 /dev/fd0H1440
In the above permission what is above C and B indicates?
Thanks (1 Reply)
Hi,
I am creating two shell scripts for Database backup and the output has to be routed to nohup.out file.
We will also be running the scripts in the background as
nohup.out <script_name> &
Do I manually need to create a nohup.out file in the directory from where the scripts are going... (1 Reply)
Hi, I have a file which contains below info :
$ cat test_file
kenny
denny
kite
I want to get all th file names which starts with k. Hence i used below command but the result was not up to the mark :
$ grep 'k*' test_file
kenny
denny
kite
Can someone please explain me why this is... (1 Reply)
:confused:
Hi All,
i am new to unix....so i am not sure whether i am asking the related question with our forum..
My question .....Can anyone explain me about the CGI script
is it something related to Unix or Linux or some other language.
Thanks in advance
Sha (1 Reply)
I just now read the doc in https://www.unix.com/tips-tutorials/35535-understanding-unix-timekeeping.html
Need clarification that half of the files in any directory is shown in below pattern in which time stamp pattern is highlighted
And half of the files are shown in different pattern... (2 Replies)
Hi ,
I need your help to know the exact operation of this following code ..
cat file1 | ux2dos | tr -d ''>>file2
file1 contains only one line : "DTS-PO\SPECTRUM WO 56"
the data contains a META CHAR "\" .. look at the above line.
But , The file2 output contains :... (7 Replies)
Hi All,
I am using Korn Shell HP UNIX and i am writing my scripts with filename extension as ksh or sh ..
I want to know what is the difference if i am giving ksh and sh
Other thing when we execute the shell script either we make it as executable and run directly else we give '.' or 'sh'... (2 Replies)