# error code 137 and error code 35072

**URL:** <https://community.unix.com/t/error-code-137-and-error-code-35072/267848>\
**Category:** Shell Programming and Scripting\
**Created:** [June 17, 2010, 10:39am UTC](https://community.unix.com/t/error-code-137-and-error-code-35072/267848 "2010-06-17T10:39:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![laxmi131](https://community.unix.com/letter_avatar/laxmi131/32/6_449c533f586939b6e5f246632a46421f.png) [@laxmi131](https://community.unix.com/u/laxmi131)\
**Post date:** [June 17, 2010, 10:39am UTC](https://community.unix.com/t/error-code-137-and-error-code-35072/267848/1 "2010-06-17T10:39:02Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dips\_ag](https://community.unix.com/letter_avatar/dips_ag/32/6_449c533f586939b6e5f246632a46421f.png) [@dips\_ag](https://community.unix.com/u/dips_ag)\
**Post date:** [June 18, 2010, 12:46am UTC](https://community.unix.com/t/error-code-137-and-error-code-35072/267848/2 "2010-06-18T00:46:03Z")

</div>

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

> [@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

```plaintext
echo $ORACLE_HOME
/u00/app/oracle/product/11.2.0

```

It should return you the path.

-dips
