Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Need clarification

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Need clarification
# 1  
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...
# 2  
Old 08-10-2010
  1. 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
  2. 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.
  3. 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).
This User Gave Thanks to pludi For This Post:
samiks14
# 3  
Old 08-10-2010
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.
This User Gave Thanks to Corona688 For This Post:
samiks14
# 4  
Old 08-11-2010
Java
---------- 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.
# 5  
Old 08-12-2010
You have posted diffs without posting any original of that section. I can't untangle the original, or indeed the problem from that mess.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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
Login or Register to Ask a Question