ERROR: Error terminating Netezza load: NOTICE: Rowset limit of 100000000 applied : ERROR: found b

Citrine10 — Thu, 16 Jul 2020 13:55:39 GMT

ERROR: Error terminating Netezza load: NOTICE:  Rowset limit of 100000000 applied  : ERROR:  found binary 0 in a data field, 
       specify escapeChar '\' option in the external table definition

Getting this error when trying to join a dataset and library dataset as follows:

proc sql;
create table ConsolidatedCust as
select *
from Will t
left join ghom.customers c /*this is the library*/
on t.Cin = c.cin
;quit;

Re: ERROR: Error terminating Netezza load: NOTICE: Rowset limit of 100000000 applied : ERROR: fou

ballardw — Thu, 16 Jul 2020 14:46:54 GMT

I would say that sounds like a Netezza setting, possibly by the admins to keep accidentally large requests from processing.

Talk to the DB admins and see if this is the case and what settings you may need to have set for your access.

Also, it is good idea to include the entire text of the Errors and better to include the code that generated them. Copy the text with code, errors, notes, and messages for the problem call. Paste into a code box opened on the forum with the </> icon to preserve formatting. Errors often include diagnostic characters but the message windows on this forum will reformat text resulting in the characters appearing in the wrong place.

topic ERROR: Error terminating Netezza load: NOTICE: Rowset limit of 100000000 applied : ERROR: found b in SAS Procedures

ERROR: Error terminating Netezza load: NOTICE: Rowset limit of 100000000 applied : ERROR: found b

Re: ERROR: Error terminating Netezza load: NOTICE: Rowset limit of 100000000 applied : ERROR: fou