topic Re: Getting error while read data from SAP in SAS Programming

Getting error while read data from SAP

AnandsinhSindha — Thu, 13 Jul 2023 11:06:32 GMT

Hi Team,

I tried to perform simple data step in SAS, Read data from SAP and write into SAS. Kindly refer below code,

Data WORK.SAMPLE_WRITE;
set SAP.READ_DATA;
run;

While run above code we get below error.

ERROR: DIALOG ROW LIMIT EXCEEDED Number:000

Kindly suggest solution for this, thanks in advance

Re: Getting error while read data from SAP

ballardw — Thu, 13 Jul 2023 15:30:28 GMT

You should probably show how you connect to SAP.

replace sensitive strings like passwords, if used, with XXXX or similar but the entire code of the connection is needed. Best is to include the code from the LOG along with all the messages that are generated.

Re: Getting error while read data from SAP

SASKiwi — Thu, 13 Jul 2023 23:07:31 GMT

I suggest you open a Tech Support track for this error. I searched SAS Support but was unable to find anything relevant.

Re: Getting error while read data from SAP

AnandsinhSindha — Fri, 14 Jul 2023 05:34:58 GMT

Issue was resolved after removing some character columns.