BookmarkSubscribeRSS Feed
Chethandeepak
Calcite | Level 5

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.

1 REPLY 1

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 677 views
  • 0 likes
  • 2 in conversation