Date:         Fri, 19 Sep 2008 10:13:02 -0300
Reply-To:     Paulo Rodrigo <rodrigo.paulo.sp@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paulo Rodrigo <rodrigo.paulo.sp@GMAIL.COM>
Subject:      Re: error with saspora
Comments: To: Aamodt <vicente.bruno@gmail.com>
In-Reply-To:  <929dbacf-3e22-4404-9668-e570244bc560@m73g2000hsh.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

I guess that this error is with the Oracle client and S.O variables. Which
are the contents of LD_LIBRARY_PATH ? Coult you compare this with the same
user used in "D.I Studio" ? Did you have access to Metalink ?

Att: Paulo R. Herculano
SAS Consultant
+55-11-9226 6618
Skål Thunar!!

On Fri, Sep 19, 2008 at 6:35 AM, Aamodt <vicente.bruno@gmail.com> wrote:

> Hi, when I try to run this .bat
>
> DATA_ACTUAL=`date '+%Y%m%d'`
> /usr/local/sas9/SAS_9.1/sas -autoexec '/home/sasadm3/sasadm/
> WebReportsPPHist/Source/autoexec_sasapli.sas9' -config '/home/sasadm3/
> sasadm/WebReportsPPHist/Source/sasv9.cfg' -log '/home/sasadm3/sasadm/
> WebReportsPPHist/Source/logs_paralelos/
> SIG20_SAS9_p8a_ind_preventivos_dc_'${DATA_ACTUAL}'.log' -sysin '/home/
> sasadm3/sasadm/WebReportsPPHist/Source/Scripts_ETL/
> Sinistros_Preventivos_DC/_MASTERJOB_.SAS9'
>
> I get this error messages:
>
> MPRINT(ETLS_SETDEBUG):   OPTIONS MPRINT;
> Could not load /usr/local/sas9/SAS_9.1/sasexe/sasora (49 images
> loaded)
> Error: Could not load module /usr/local/sas9/SAS_9.1/sasexe/sasora.
>        Dependent module
> /axadbs01/app/oracle/product/9.2.0/lib32/libclntsh.a(shr.o) could not
> be loaded.
>        The module has an invalid magic number.
> Could not
> load module /usr/local/sas9/SAS_9.1/sasexe/sasora.
>        Dependent module /usr/local/sas9/SAS_9.1/sasexe/sasora could not be
> loaded.
> ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR:
> Image SASORA   found but not loadable.
> ERROR: Error in the LIBNAME statement.
>
> If I try to run the job via DI Studio it rus withou error. Any idea on
> why?
>



--