cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Go
‎09-18-2023
  • 86 Posts
  • 19 Likes Given
  • 3 Solutions
  • 7 Likes Received

sas access to hadoop error

by Quartz | Level 8 in Administration and Deployment
‎04-20-2018 03:03 PM
‎04-20-2018 03:03 PM
Hi All,   We are trying to SAS/Access to hadoop with below libname and I get below error ? any thoughts? (hadoop jar/conf path looks all good)   libname hdp hadoop server='ixnbda1dm04.sce.com' port=10000 schema=default subprotocol=hive2;   ERROR: Error trying to establish connection: Could not open client transport with JDBC Uri:        jdbc:hive2://IYXCDBDA04.sce.com:10000/default: java.net.ConnectException: Connection refused (Connection refused) ERROR: Error in the LIBNAME statement. ... View more

Re: Creating a sas compressed dataset from a teradata table

by Quartz | Level 8 in SAS Programming
‎04-11-2018 07:51 PM
‎04-11-2018 07:51 PM
What are all the features of SPDS, I mean what are the best use cases to opt for SPD ? does it make proc sort faster ? ... View more

SPDS basic question

by Quartz | Level 8 in Administration and Deployment
‎04-11-2018 06:47 PM
1 Like
‎04-11-2018 06:47 PM
1 Like
 Hi,   Is SPDS is legacy ? if we have GRID environment , is it silly to opt for SPDS ?  ... View more

Re: Problem with PROC EXPORT

by Quartz | Level 8 in SAS Procedures
‎02-26-2018 04:10 PM
‎02-26-2018 04:10 PM
THIS WORKS..... the attach statement (conetnttype) is the key   PROC EXPORT DATA=sashelp.cars OUTFILE="/tmp/cars_test.xlsx" DBMS=XLSX REPLACE LABEL; SHEET=Sheet1; RUN; FILENAME Mailbox EMAIL 'nayakig@sce.com' Subject='Test Mail message' attach=("/tmp/cars_test.xlsx" content_type="application/xlsx"); DATA _NULL_; FILE Mailbox; PUT "Hello"; PUT "Attached is the report"; RUN; ... View more

Re: sasadm@saspw getting locked out frequently

by Quartz | Level 8 in SAS Visual Analytics
‎02-12-2018 08:52 PM
3 Likes
‎02-12-2018 08:52 PM
3 Likes
Wow... this conversation thread helped me big time ...__/\__ __/\__ __/\__ ... View more

sas energy forecasting error

by Quartz | Level 8 in Administration and Deployment
‎02-09-2018 03:30 PM
‎02-09-2018 03:30 PM
Hi All,   I am new to Energy Forecasting and we just deployed SAS energy forecasting component, we can launch the web application, but see below error, when ignore and try to load data from server, it gives error too...see screenshots 1 & 2(remove the .txt extension and open) , whats wrong ? ... View more

Re: Object spawner is getting big every day making sasconfig full

by Quartz | Level 8 in Administration and Deployment
‎02-05-2018 02:40 PM
‎02-05-2018 02:40 PM
we just cracked it, we checked the log and it has too many lines of below entry, and we realized it is because of a node going down in grid environment... thank you very much for the prompt response @alexalalexa, meybe they named it after you alexa... 🙂 🙂 The load balancing processor could not send update to peer (A5RZ7YZK.AY000003_@lexvpsas05.sce.com) ... View more

Re: Object spawner is getting big every day making sasconfig full

by Quartz | Level 8 in Administration and Deployment
‎02-05-2018 01:45 PM
‎02-05-2018 01:45 PM
Here is the file, we just got the big log file.... if you need i can attach the big 13gb file ... View more

Object spawner is getting big every day making sasconfig full

by Quartz | Level 8 in Administration and Deployment
‎01-30-2018 01:29 PM
‎01-30-2018 01:29 PM
Hi All,   we are running 5node grid and every day one of the objectspwnerlog is getting big(upto 40gb) and causing probs.... we are 99% sure only one node's objectspwner log is full (we deleted objectspwner_node4.log for last 2 days..not sure thats coincidence to happen for only node4)... we dont remember changing anything recently in log.config.xml or in SMC/loggers... help us so that we wont face same problem tomoro morning..!? ... View more

Re: Is there a way to find out when LASR server crashes ?

by Quartz | Level 8 in Administration and Deployment
‎01-29-2018 06:04 PM
‎01-29-2018 06:04 PM
@alexal,   I am sorry  thats my colleague and im his brand new team mate... didnt realize you work for SAS directly, so wanted see if sas community here has other ideas... thanks for your support... we will go with sas track from here....  ... View more

Re: Is there a way to find out when LASR server crashes ?

by Quartz | Level 8 in Administration and Deployment
‎01-26-2018 02:48 PM
‎01-26-2018 02:48 PM
Hi alexal,   Please see attached files...! ... View more

Re: Is there a way to find out when LASR server crashes ?

by Quartz | Level 8 in Administration and Deployment
‎01-23-2018 05:36 PM
1 Like
‎01-23-2018 05:36 PM
1 Like
@JuanS_OCS and @alexal ..   Thanks for the detailed reply, ours is distributed environment...! we are still trying to find out the cause/solution ... ... View more

Is there a way to find out when LASR server crashes ?

by Quartz | Level 8 in Administration and Deployment
‎01-16-2018 04:26 PM
1 Like
‎01-16-2018 04:26 PM
1 Like
Hi All,   You think I can schedule a simple unix script to send me an alert when LASR server crashes ?? ... View more

Re: AIX question

by Quartz | Level 8 in Administration and Deployment
‎08-11-2017 02:01 PM
‎08-11-2017 02:01 PM
Alexal, It worked, thank you very much... I tried ls -lXp before instead of ls -ll , but did not realize I could ues -X with ps -ef , thank you... ... View more

AIX question

by Quartz | Level 8 in Administration and Deployment
‎08-11-2017 10:49 AM
‎08-11-2017 10:49 AM
this is not a sas question at all, this is unix question, I could not find an answer to this, hope i find it here...   ps -ef in AIX gives "UID" in the first column, but the UID it displays only 8 characeters, I need entire uid , some of the uid's length is more than 8, how can i print whole uid ? please advise ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-18-2023 02:02 AM
Likes given to
Likes from
Quick links