Hi,

We are using our corporate scheduling tool to call a webfocus procedure. When i try to run the edastart -x command on the command line, it works fine. However when i try the same inside a shell script i was thrown error due to enviorment variables not set properly.


Command line (Working fine) :

/opt/ibi/srv77/wfs/bin/edastart -x "EX commission_statement/mainfex_pilot &PARAM1=4"



Shell Script (Not Working): Content of the shell script


#!/usr/bin/ksh
/opt/ibi/srv77/wfs/bin/edastart -x "EX commission_statement/mainfex_pilot &PARAM1=4"


Error:

(FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLORA. MODULE NAME : OR8PS10
(FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED :
(FOC1260) libclntsh.so.10.1: cannot open shared object file: No such file or
directory
(FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLORA ARE :
(FOC1260) ORACLE_SID : orac
(FOC1260) NLS_LANG : AMERICAN
(FOC1260) ORACLE_HOME : /opt/oracle/product/10.2.0/client_1
(FOC1260) LD_LIBRARY_PATH : /opt/ibi/srv77/home/bin
(FOC1260) /home/marasigana/installs/jdk1.6.0_17/jre/lib/i386/client
(FOC1260) /home/marasigana/installs/jdk1.6.0_17/jre/bin
(FOC1260) /opt/oracle/product/10.2.0/client_1/lib
(FOC1260) /opt/jdk1.6.0_22/jre/lib
(FOC1260) /opt/jdk1.6.0_22/lib
(FOC1260) /opt/jdk1.6.0_22/jre/lib/i386/server
(FOC1260) /opt/jdk1.6.0_22/jre/lib/i386/native_threads
(FOC1260) /opt/jdk1.6.0_22/jre/lib/i386
(FOC1260) /lib
(FOC1260) /usr/lib
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED
(FOC1479) ERROR CONNECTING TO SQL DATABASE

This message has been edited. Last edited by: Kerry,

Sorry everyone. It was a small mistake i made in my script. I had set my $ORACLE_HOME incorrectly. I changed it and it is working fine.

Saravanan,

Thanks for the update.

So often there is no feed back, so you never know the solution.

You fixed this yourself, It's the telling how that is important.