ERROR: DIALOG_ROWLIMIT_EXCEEDED Number:00

[Gweeks]

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

[LinusH]

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.

[Gweeks]

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.