Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need clarification
Top Forums UNIX for Advanced & Expert Users Need clarification Post 302443851 by samiks14 on Tuesday 10th of August 2010 08:24:32 AM
Old 08-10-2010
Java 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.
Need clarification-unix_failure-success-codejpg
Last edited by pludi; 08-11-2010 at 03:29 AM.. Reason: code tags, please...
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need clarification

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)
Discussion started by: ravi.sadani19
2 Replies

2. Shell Programming and Scripting

need clarification about tr -d command ?

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)
Discussion started by: vparunkumar
7 Replies

3. Shell Programming and Scripting

TimeStamp clarification

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)
Discussion started by: Sreejith_VK
2 Replies

4. Web Development

Clarification

: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)
Discussion started by: Shahul
1 Replies

5. AIX

grep -- clarification

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)
Discussion started by: merajh
1 Replies

6. UNIX for Dummies Questions & Answers

Clarification regarding nohup.out

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)
Discussion started by: narayanv
1 Replies

7. Shell Programming and Scripting

permission clarification

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)
Discussion started by: thelakbe
1 Replies

8. UNIX for Advanced & Expert Users

Need Clarification

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)
Discussion started by: DevM
1 Replies

9. HP-UX

su command clarification

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)
Discussion started by: vigneshwaran007
3 Replies
All times are GMT -4. The time now is 06:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy