About japsas100

japsas100 · ‎03-29-2017

Thanks.... Same script also runing into prod env. I am very sure there is no issue with script.

japsas100 · ‎03-29-2017

Hello, I am getting below error when i submit the pass through code on sas EG. We have recently installed the sas 9.4 env. ERROR: 23 proc sql; 24 connect to odbc as redshift (datasrc='Redshift' USER=xxxxx PASSWORd=xxxxxxxxxxxxxxxxx); 25 create table work.xxxxxx as 26 select * 27 from connection to redshift (select top 200 * from prod.xxxxxxxxx); ERROR: CLI prepare error: [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: syntax error at or near "敳敬瑣琠灯㈠〰⨠映潲⁭牰摯献扩敢摟汥癩牥y"LINE 1: 敳敬瑣琠灯㈠〰⨠映潲⁭牰摯献扩敢摟汥癩牥y ^ SQL statement: select top 200 * from prod.xxxxxxxxxxxxxx. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 28 disconnect from redshift; NOTE: Statement not executed due to NOEXEC option. When I submit the libname statement only (below line)its execuated sucesfully without error. 23 LIBNAME redshift ODBC DATAsrc=Redshift SCHEMA=xxxx USER=xxxxxxxx PASSWORD=XXXXXXXXXXXXXXXXX ; NOTE: Libref REDSHIFT was successfully assigned as follows: Engine: ODBC Physical Name: Redshift Please advise.

japsas100 · ‎03-28-2017

Thanks Anja, When I load data into Lasr server its sucessfully loaded and I can see some are copied under root note(VA Signature files) but cant see any data on worker node. But When I login to EM and see there is some error under Resource tab. This resource is turned off or has not been configured properly. The problem is: Error contacting resource: Can't connect to MBeanServer url [ptql:State.Name.eq=java,Args.*.eq=org.apache.hadoop.hdfs.server.datanode.DataNode] port [null] username [null]: java.io.IOException: State.Name.eq=java,Args.*.eq=org.apache.hadoop.hdfs.server.datanode.DataNode java.io.IOException: Operation not permitted Please turn on the server, or fix its Configuration Properties. Please advise?

japsas100 · ‎03-28-2017

Thanks JuanS_OCS, Just want to check if we load data into Lasr server where physically store the data on root and workers nodes?

japsas100 · ‎03-28-2017

Hi, We have recently done with Installation and configration of SAS 9.4 M3 including SAS VA 7.3 distributed on Linux env. Could you please advise how we can validate and testing our new environment before handover to users. I Can load the data into Lasr server with any error but I can see it save some files into VA_Singnature path on root node and I cant see any data saved on other 3 worker nodes. Please Advise!!!

japsas100 · ‎03-27-2017

Thanks Timmy2383 Issued has been fixed. Acutually use not have the appropriate access right thats why its throwing error. When I assigned all the required access through smc then I am able to connect with oracle without any error. Thanks You soo much for your help.

japsas100 · ‎03-27-2017

Thanks for reply. Still getting the same error.

japsas100 · ‎03-27-2017

yes we have licened for oracle client. but know know how we can whether it is installed or not? oracle client version 11.2 installed on Linux env. on below path : /usr/lib/oracle/11.2./client64 Oracle database version : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

japsas100 · ‎03-27-2017

We are not using sas connect. I am getting the error agin . 28 data _null_; 29 if sysexist('LD_LIBRARY_PATH') then do; 30 put "Exists"; 31 LD_LIBRARY_PATH = sysget('LD_LIBRARY_PATH'); 32 put LD_LIBRARY_PATH = ; 33 end; 34 else put "Not exists"; 35 run; Exists LD_LIBRARY_PATH=/opt/sas/sashome/Secure/sasexe:/opt/sas/sashome/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/Driver:/ opt/sas/sashome/SASPrivateJavaRuntimeEnvironment/9.4/jre/lib/amd64/server:/opt/sas/s NOTE: DATA statement used (Total process time): Is this env resolved coreclty? oracle error: ERROR: Could not load /opt/sas/sashome/SASFoundation/9.4/sasexe/sasora (105 images loaded) ERROR: libclntsh.so.11.1: cannot open shared object file: No such file or directory 24 25 LIBNAME abc ORACLE PATH=prod USER=sas_r PASSWORD=XXXXXXXXXXX; ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable.. Please make sure Oracle environment is set correctly. Look in the install/Config doc for additional info for your platform. Other possible reasons - incomplete Oracle client install, 32/64-bit mismatch between Oracle client & SAS, incorrect Oracle client version(Oracle client must match the version picked during post-install process), incompatible sasora for your OS or its attribs don't permit SAS to load it. ERROR: Error in the LIBNAME statement.

japsas100 · ‎03-27-2017

I have added these variable in both these files but still getting the same error. I noticed when i execuate below prog its showing Oracle_Home not exit during signon? data _null_; if sysexist('$ORACLE_HOME') then do; put "Exists"; Oracle_Home = sysget('$ORACLE_HOME'); put Oracle_Home = ; end; else put "Not exists"; run;

japsas100 · ‎03-27-2017

done...Again I am getting the same error: ERROR: Unable to connect to Oracle-Oracle environment is either not set or set incorrectly! ERROR: Error in the LIBNAME statement.

japsas100 · ‎03-27-2017

Hello Everyone Could you please advise what steps are required to setup sas oracle configration on Linux. We alredy installed oracle client 11.2 version on sas9.4. Oracle installed : /usr/lib/oracle/11.2./client64 TNS File Path : /etc/opt/oracle I am getting below error from SAS EG: - ERROR: Unable to connect to Oracle-Oracle environment is either not set or set incorrectly! ERROR: Error in the LIBNAME statement.

japsas100 · ‎03-22-2017

Hi , We have recently installed and configured sas va 7.3 distributed environment with HPA. We are not able to start services and get below error.... -------------- Task Summary -------------- SUCCESS (SASJob PreCode) SUCCESS (Set Grid Node Count) ERRORS (Start Server) ---------------------------------------------- ERROR: Failed to enumerate available compute nodes in the distributed computing environment. ERROR: Failed to open TKGrid library. ERROR: The bridge for SAS High-Performance Analytics encountered an internal error. ----------------------------------------------

japsas100 · ‎03-21-2017

Please advise.....When I start HDFS services (without Kerberos) its throw below error. Iam installation hadoop on linux env. [hdfs@sastest01 ~]$ $HADOOP_HOME/sbin/start-dfs.sh 17/03/21 16:48:30 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable Starting namenodes on [sastest01.s.xxxx.xx] sastest01.s.xxxx.xx: starting namenode, logging to /opt/sas/hadoop/hadoop-2.4.0/logs/hdfs/hadoop-hdfs-namenode-sastest01.s.xxxx.xx.out sastest04.s.xxxx.xx: starting datanode, logging to /opt/sas/hadoop/hadoop-2.4.0/logs/hdfs/hadoop-hdfs-datanode-sastest04.s.xxxx.xx.out sastest02.s.xxxx.xx: starting datanode, logging to /opt/sas/hadoop/hadoop-2.4.0/logs/hdfs/hadoop-hdfs-datanode-sastest02.s.xxxx.xx.out sastest03.s.xxxx.xx: starting datanode, logging to /opt/sas/hadoop/hadoop-2.4.0/logs/hdfs/hadoop-hdfs-datanode-sastest03.s.xxxx.xx.out Starting secondary namenodes [0.0.0.0] 0.0.0.0: starting secondarynamenode, logging to /opt/sas/hadoop/hadoop-2.4.0/logs/hdfs/hadoop-hdfs-secondarynamenode-sastest01.s.xxxx.xx.out 17/03/21 16:48:49 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

japsas100 · ‎03-20-2017

Thank you So much.

Online Status	Offline
Date Last Visited	‎11-23-2022 10:52 AM

Re: Proc HTTP Error

Sas Internal account password including special characters

Re: Error on login in SAS-AML system

Re: Proc HTTP Error

Re: Proc HTTP Error

Proc HTTP Error

Re: SAS EG 8.2 ERROR

SAS EG 8.2 ERROR

Re: Network Error

Network Error

Re: Network Error

Re: How to Check Authentication method in SAS

Re: SAS 9.4 High Performance Suite

SAS EG Data Import Error with XLSX format

SAS CyberArk Integration

Unlock sastrust@saspw Account

Re: SAS Share Error

Change SAS/SHARE server password

Re: SAS ODBC ERROR

SAS ODBC ERROR

Re: SAS VA 7.3 Distribute ---Testing and Validation

Re: SAS VA 7.3 Distribute ---Testing and Validation

SAS VA 7.3 Distribute ---Testing and Validation

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: SAS Oracle Configration

Re: SAS Oracle Configration

SAS Oracle Configration

LASR SERVER START ERROR

SAS-Hadoop Installation Error

Re: SAS EG ERROR