topic ERROR: Error while using RFC to SAP. in SAS Data Management

ERROR: Error while using RFC to SAP.

Filipvdr — Thu, 07 Nov 2019 15:14:44 GMT

options sastrace=',,d,d' sastraceloc=saslog nostsuffix ;
LIBNAME sap_src SASIOSR3  trace=1  BatchMode=1  language=EN  Client=100  TRANSERRORCOMPATMODE=Y  r3name=DA1  group=DA1dialog  mshost="da1cs.al.ndis.be"  USER=SASRFC  PASSWORD="{SAS002}A15F8F56266BD0E83706CF0C04E43F23364802EA" ;

proc sql;
create table temp as select *
from sap_src."/1CPMB/BSTD8PSB"n where monotonic()<10;
quit;
options sastrace=off ;

Hello, i'm trying to read data from SAP using the data surveyor. I'm able to connect to SAP but when reading data i'm getting an error.

My logfile is in attachment, any idea's?

Filip

Re: ERROR: Error while using RFC to SAP.

Patrick — Fri, 08 Nov 2019 03:28:22 GMT

Could this be the reason?

Also: Don't use monotonic(). This is an undocumented and unsupported function which can return unexpected results when used with a database. If you want to reduce volumes for testing rather use Proc SQL options INOBS and OUTOBS like

Proc SQL inobs=10;

....

Re: ERROR: Error while using RFC to SAP.

Filipvdr — Fri, 08 Nov 2019 08:29:14 GMT

hi Patrick, we found the same support link and checked with our SAP support team but they could not fix the issue. You think it's SAP related or we're missing a setup within the SAS configuration. As we are able to connect to SAP i'm thinking it's more SAP related?