Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

error code 137 and error code 35072

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting error code 137 and error code 35072
# 1  
Old 06-17-2010
error code 137 and error code 35072
Hi

while trying to run few scripts
/afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh
this script contains the below data
load_dir=/afs/ae.ge.com/informatica/ardw/dev/data
prog_dir=/afs/ae.ge.com/informatica/ardw/dev/bin
ctl_dir=/afs/ae.ge.com/informatica/ardw/dev/ctl
log_dir=/afs/ae.ge.com/informatica/ardw/dev/logs
sql_dir=/afs/ae.ge.com/informatica/ardw/dev/sql
sqlplus -s ops\$afnardw/ardw82bi@evnrdwd1 @$sql_dir/cdw_ar_update_recvbal.sql >> $log_dir/script.log

I am trying to execute this script through informatica

There i am getting ther error
1.shell command failed with exit code 137
for another instance i am geting an error
2.execution of command did not complete successfully with exit code 35072

when i am executing this in unix
$ sh /afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh
/afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh: sqlplus: not found

please let me know what is the issue

Thanks in advance
# 2  
Old 06-18-2010
Quote:
Originally Posted by laxmi131
Hi

I am trying to execute this script through informatica

There i am getting ther error
1.shell command failed with exit code 137
for another instance i am geting an error
2.execution of command did not complete successfully with exit code 35072
Informatica exit codes don't tell you real unix shell error.


Quote:
Originally Posted by laxmi131
when i am executing this in unix
$ sh /afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh
/afs/ae.ge.com/informatica/ardw/dev/bin/cdw_ar_update_recvbal.sh: sqlplus: not found
Check your .profile file if the $ORACLE_HOME variable is set or not.
When you type
Code:
echo $ORACLE_HOME
/u00/app/oracle/product/11.2.0

It should return you the path.

-dips
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

When I run the code yesterday I am getting output,when I run same code today I am getting error?

If run the below code today its creating all directory and getting output files,I f run same code tomorrow I am getting error. can any one give suggestion to sortout this error. OSError: no such file or directory : '062518'My code looks like this import paramiko import sys import os ... (8 Replies)
Discussion started by: haribabu2229
8 Replies

2. Shell Programming and Scripting

How to capture the error code a use it in error table?

Hello Everyone, I have written a file validation script in unix to compare the data and trigger file.My requirement is if the file validation fails,I need to upate the error details in a table ex:Below is the one of many validation checks i am doing if then echo "Actual count between... (3 Replies)
Discussion started by: karthik adiga
3 Replies

3. Shell Programming and Scripting

whats error in code ??

if `egrep -c "safe_mode" /usr/local/lib/php.ini` - gt 0 && " `egrep -c "safe_mode" /usr/local/lib/php.ini` = "On" " then echo " Good " exit else echo " Not Good "; fi and (4 Replies)
Discussion started by: x-zer0
4 Replies

4. AIX

lsmksysb: error 0511-119 & 0511-137 ?

I have 2 workstations that when I do the smitty lsmksysb to verify the tape created by the smitty mksysb, both fail on the same problem: restore: 0511-119 There is a missing header block. restore: 0511-137 Trying to find the next header. Data maybe lost. Starting again at file .... I... (3 Replies)
Discussion started by: Browser_ice
3 Replies

5. Shell Programming and Scripting

Help needed with error code..

Hi Guys, I have a script which is inserting records in the table. The insert query has 0 rows to be inserted. because of that a warning is being thrown. But the return code of the insert query is showing as 1. Is it like when a warning comes, the return code will be 1? However, the same... (1 Reply)
Discussion started by: mac4rfree
1 Replies

6. Filesystems, Disks and Memory

Exit code 137 on a backup

Can some one tell me what it means to get a exit code od 137 from a cron scheduled backup on HP-UX. Also if you know of a book that has the HP-UX codes that would be great. Thanks (4 Replies)
Discussion started by: twins
4 Replies

7. Shell Programming and Scripting

Error code checking

I'm trying to create a directory from my Perl script. Only if the there was an error I want to let the user know about it. So if the folder exists is ok. This is what I think should work: `mkdir log 2>/dev/null`; if($? == 0 || $? == errorCodeForFileExists) { everyting is fine } else {... (3 Replies)
Discussion started by: jepombar
3 Replies

8. UNIX for Advanced & Expert Users

FD0 error code 30

Hi I am new to this forum. Iam facing very strange problem in sco open server 5. when i try to mount the fd0 it just says "fd0 writeprotected, read only error code 30" I changed the floppy drive. even I check the /dev/fd0 permissions it is read and wirte. I changed the floppies also. but... (6 Replies)
Discussion started by: Pritpal singh
6 Replies

9. Solaris

Finding error code

Hi Guys, Can you tell me how to find error code generated by a command. Say i run a command and its generating an error how do i find out its error code ( i know its done using redirection operator.......but not sure how)? (2 Replies)
Discussion started by: nitinkgoud
2 Replies
Login or Register to Ask a Question