RFC Exception: NOT_AUTHORIZED

Former Member — Thu, 13 Nov 2008 08:40:51 GMT

Hi all.

I get the above error when extracting data from SAP to another system.

Pls. see code executed below and notice that one table is ok but the second is not.

8 libname mylib r3 user="SASACCESS" password=XXXXXXX client=410 language=EN

9 ashost=srv133 sysnr=00

10 host=localhost port=6999;

NOTE: Libref MYLIB was successfully assigned as follows:

Engine: R3

Physical Name: srv133

11 options obs=max;

12 run;

13 data zcrm_md_ean;;

14 set mylib.zcrm_md_ean;

15 run;

NOTE: There were 1343 observations read from the data set MYLIB.zcrm_md_ean.

NOTE: The data set WORK.ZCRM_MD_EAN has 1343 observations and 10 variables.

NOTE: DATA statement used (Total process time):

real time 0.51 seconds

cpu time 0.01 seconds

16 data zcrm_bpextend;

17 set mylib.zcrm_bpextend;

ERROR: RFC Exception: NOT_AUTHORIZED

18 run;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.ZCRM_BPEXTEND may be incomplete. When this step was stopped there

were 0 observations and 0 variables.

NOTE: DATA statement used (Total process time):

real time 0.12 seconds

cpu time 0.01 seconds

Regards

Tonni Berggren

Re: RFC Exception: NOT_AUTHORIZED

shivhare — Thu, 13 Nov 2008 11:01:38 GMT

Go to user profile and check authorization object related to RFC and give full authorization to all object

Thanks

Amit