topic Re: Error in DIS JOb executed in shell script in SAS Data Management

Error in DIS JOb executed in shell script

deh_asma — Thu, 31 May 2012 13:44:34 GMT

Hi,

I executed a DIS job under SAS DATA INTEGRATION and it works well. But when i deployed the same job, i had the bellow error when i executed the sas program in shell script

"ERROR 22-7: Invalid option name DBM" in libname statement of etlstmp in SCD step.

I used SCD type 2 in this job.

thank you

Re: Error in DIS JOb executed in shell script

shivas — Fri, 01 Jun 2012 04:39:55 GMT

Hi,

Check this SAS notes.Hope it helps...

http://support.sas.com/kb/42/242.html

http://support.sas.com/kb/36/253.html

Thanks,

Shiva

Re: Error in DIS JOb executed in shell script

deh_asma — Fri, 01 Jun 2012 14:44:55 GMT

Hi,

I executed this libname in SAS server:

LIBNAME etlstmp ORACLE DBINDEX=YES DBSLICEPARM=(THREADED_APPS,6) READBUFF=1000 INSERTBUFF=1000 UPDATEBUFF=1000 PATH=CAMPAIN_PROD CONNECTION=GLOBAL SCHEMA=SASMARTMA USER=SASMARTMA PASSWORD="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" DBMSTEMP=YES;

I had the bellow error:

3589? LIBNAME etlstmp ORACLE DBINDEX=YES DBSLICEPARM=(THREADED_APPS,6) READBUFF=1000 INSERTBUFF=1000 UPDATEBUFF=1000 PATH=CAMPAIN_PROD CONNECTION=GLOBAL SCHEMA=SASMARTMA USER=SASMARTMA PASSWORD="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" DBMSTEMP=YES;

3590?

3589 LIBNAME etlstmp ORACLE DBINDEX=YES DBSLICEPARM=(THREADED_APPS,6)

3589! READBUFF=1000 INSERTBUFF=1000 UPDATEBUFF=1000 PATH=CAMPAIN_PROD

3589! CONNECTION=GLOBAL SCHEMA=SASMARTMA USER=SASMARTMA

3589! PASSWORD="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" DBMSTE

------

ERROR 22-7: Invalid option name DBMSTE.

3590 MP=YES;

ERROR 22-7: Invalid option name MP.

But when i deleted some options in this libname "READBUFF=1000 INSERTBUFF=1000 UPDATEBUFF=1000" i didn't have any error.

there is a restriction in the length of SAS libname?

Thank you

Re: Error in DIS JOb executed in shell script

LinusH — Mon, 04 Jun 2012 09:16:27 GMT

Strange, seems like you could open a track to tech support.

Is this code generated from a libname definition, or have you entered it by yourself?

Re: Error in DIS JOb executed in shell script

Patrick — Mon, 04 Jun 2012 12:47:38 GMT

Is this an encoded passwort you're using?

I'm just guessing but may be the passwort contains a character which messes up things. You could try to %quote() it.

Is this just a deployd job which throws the error (and works when running directly in DIS) - or did you somehow copy the code; eventually even to another machine with a different code page?

If it's just a deployed job causing the issue then it's definitely a case for our friends from SAS Tech Support.

Re: Error in DIS JOb executed in shell script

deh_asma — Tue, 05 Jun 2012 11:33:11 GMT

Hi,

Thank you.

This code is generated from a libname definition. This problem was resolve after that we changed the database password to reduce the length of libname statement.