Java heap space error while running program in studio in viya 4

Chethandeepak — Mon, 21 Oct 2024 12:46:55 GMT

Hi ,

while im running code getting java heap space out of memory error.

libname dbms spark platform=databricks
schema="xxxxxxxx"
server="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" port=443
user=token pwd=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
httpPath="xxxxxxxxxxxxxxxxxxxxxxx"
properties="catalog=xxxxxxx;DefaultColumnSize=255;ConnectRetryWaitTime=30" ;
NOTE: Libref dbms was successfully assigned as follows:
Engine: SPARK
Physical Name:
jdbc:cdata:databricks:Server=xxxxxxxxxxxxxxx;Database=xxxxx:HTTPPath=xxxxxxxxxxxxxx
2e8;QueryPassthrough=true;UseCloudFetch=true;catalog=xxxxxxx;DefaultColumnSize=255;ConnectRetryWaitTime=30
86
87 data chk_deploy;
88 set dbms.schema_account_name;
89 where latest_flag='Y';
90 run;
ERROR: Fetch error: java.lang.OutOfMemoryError: Java heap spaceUnable to read from pipe.Unable to read from pipe.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.

where i need to increase java heap space -xms and -xmx value in SAS in viya 4

Regards ,
Ravi.

Re: Java heap space error while running program in studio in viya 4

ChrisNZ — Sat, 26 Oct 2024 14:19:36 GMT

You should contact SAS tech support support@sas.com

topic Java heap space error while running program in studio in viya 4 in SAS Programming

Java heap space error while running program in studio in viya 4

Re: Java heap space error while running program in studio in viya 4