topic ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:00 in SAS Data Management

ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:00

Gweeks — Mon, 18 Jan 2021 12:13:17 GMT

Hello everyone,

I am trying to replicate a SAP table into SAS using the Data Transfer transformation in SAS DI Studio, I've already registered the SAP table into SAS. When running the job, I get an error of that states that dialog_rowlimit has been exceed. Please help, I've tried using Bulkload and OBS=, it states that the options are invalid when used there

@Community_Help

Thank you.

Gweeks

Re: ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:00

LinusH — Tue, 26 Jan 2021 09:38:58 GMT

So you have the table registered in SAS, which lead me to belive that you have access to this data using a Libref, right?

In that case, Data Transfer is not the right transformation for you. That transformation is used for copying data between SAS servers.

If you want to work with these tables, refer to them directly in your jobs by using appropriate transfomations directly, e.g. Extract.

Re: ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:00

Gweeks — Tue, 26 Jan 2021 11:56:30 GMT

Hi LinusH,

I've registered the tables into SAS, yes. I've also tried using the extract transformation which just give an error message of "there are no unused destinations" for both the libraries it's reading from and pushing the data to. I've tried the table loader as well, the data contains about a million or more rows.