2008 Nov 13 8:40 AM
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
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
2008 Nov 13 11:01 AM
Hi
Go to user profile and check authorization object related to RFC and give full authorization to all object
Thanks
Amit
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |