SAS 数据集成：SAP 表提取错误

Question

这是错误代码：

Line 115: ERROR: RFC_ERROR_SYSTEM_FAILURE Error in module RSQL of the database interface.    NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. `

错误日志：

NOTE: Libref SAPENG was successfully assigned as follows: 
  Engine:        R3 
  Physical Name: PRORELOC
101        %rcSet(&syslibrc);
102        
103        %let etls_recnt = 0;
104        %macro etls_recordCheck;
105           %let etls_recCheckExist = %eval(%sysfunc(exist(SAPEng.CDPOS, DATA)) or
106                 %sysfunc(exist(SAPEng.CDPOS, VIEW)));
107        
108           %if (&etls_recCheckExist) %then
109           %do;
110              proc sql noprint;
111                 select count(*) into :etls_recnt from SAPEng.CDPOS;
112              quit;
113           %end;
114        %mend etls_recordCheck;
115        %etls_recordCheck;
MPRINT(ETLS_RECORDCHECK):   proc sql noprint;
MPRINT(ETLS_RECORDCHECK):   select count(*) into :etls_recnt from SAPEng.CDPOS;
ERROR: RFC_ERROR_SYSTEM_FAILURE
Error in module RSQL of the database interface.

知道为什么会发生这种情况吗？ 我尝试提取的表称为 CDPOS。其他SAP表没有错误

Answer 1

RFC_ERROR_SYSTEM_FAILURE 表示 RFC 调用出错，通常会生成短转储（事务 ST22）和/或系统日志条目（SM21）。检查这些日志以找出到底出了什么问题。