@AnandVyas    Thanks for the reply.   Yes, the user can connect to oracle via SQL developer. I will connect to DBA for the same.   Is this possible we can troubleshoot this error at sas end? ... View more

You cannot get that error message from that code.  In that code ABCD is referencing a dataset in the WORK library and not a format catalog. Can you show the lines from the SAS log?   Format catalogs are not transferable across versions or operating systems. But SAS datasets normally are. So if you really do have a SAS dataset with the format definitions you can use PROC FORMAT to create a NEW catalog that will work with your current SAS session.   So to make the catalog MYNAME in the library that the MYLIB libref points to from the dataset name DATASET_NAME you would use this code. proc format lib=mylib.myname cntlin=dataset_name ; run; ... View more

You need to make sure your Oracle library has ReadMetadata and Read permissions granted to SASUSERS - those SAS users who are registered in the Metadata. ... View more

No. Memory is allocated before SAS is started, so you have to do this in the .config file.    So your two options are:   1. Get access to the .config file.   2. Reduce the memory footprint of the hash object. Please be more specific about how you use the hash object if you want help with this ... View more

To narrow down the problem a bit: Do you get in the SAS log some information why it fails? Do you have some SAS and/or Oracle error code and message? And: Does it fail because you don't get a connection to Oracle or does it hang once an connection has been established? Are there other jobs connecting to Oracle and ideally the same schema/tables with such issues?   Eventually pick one of the failed processes and ask the DBA if there has been something happening on the Oracle time during this time - and also if the query is visible on the Oracle side for this execution of the SAS job.   ... View more

To narrow down the problem a bit: Do you get in the SAS log some information why it fails? Do you have some SAS and/or Oracle error code and message? And: Does it fail because you don't get a connection to Oracle or does it hang once an connection has been established? Are there other jobs connecting to Oracle and ideally the same schema/tables with such issues?   Eventually pick one of the failed processes and ask the DBA if there has been something happening on the Oracle time during this time - and also if the query is visible on the Oracle side for this execution of the SAS job.   ... View more

PS when I installed our current 9.4 on AIX, I created the depot from the media on my desktop PC, then used WinSCP to copy the whole thing (binary mode!) to the server (using the SAS install user account), then did the chmod. Worked like a charm. ... View more

Hi All,     Please advise?   SASServer2_1 is not up during configuration.    SAS Web App Server SASServer1_1 is UP SAS Web App Server SASServer12_1 is UP SAS Web App Server SASServer2_1 is NOT up   config logs [appserverTarget] 2017-07-11 15:08:44,844 [main] INFO com.sas.appserver.utils.AntProcessInvoker - Environment Variables: [appserverTarget] 2017-07-11 15:08:44,844 [main] INFO com.sas.appserver.utils.AntProcessInvoker - Working Directory: /opt/sas/config/Lev1/Web/WebAppServer/SASServer2_1/bin [appserverTarget] 2017-07-11 15:08:44,844 [main] INFO com.sas.appserver.utils.AntProcessInvoker - Executable: /opt/sas/config/Lev1/Web/WebAppServer/SASServer2_1/bin/tcruntime-ctl.sh [appserverTarget] 2017-07-11 15:08:44,844 [main] INFO com.sas.appserver.utils.AntProcessInvoker - Arguments: [appserverTarget] 2017-07-11 15:08:44,844 [main] INFO com.sas.appserver.utils.AntProcessInvoker - start [appserverTarget] 2017-07-11 15:08:44,845 [main] INFO com.sas.appserver.utils.AntProcessInvoker - spawning process [appserverTarget] 2017-07-11 15:08:44,847 [main] INFO com.sas.appserver.vfabrictcsvr.Server - server.name SASServer2 using http on port 8180 [appserverTarget] 2017-07-11 15:08:54,848 [main] INFO com.sas.appserver.utils.PortUtils - isPortAvailable(server.name,8180) >>> [appserverTarget] 2017-07-11 15:08:54,849 [main] INFO com.sas.appserver.utils.PortUtils - Connection refused [appserverTarget] 2017-07-11 15:08:54,849 [main] INFO com.sas.appserver.utils.PortUtils - isAvailable=true [appserverTarget] 2017-07-11 15:08:54,849 [main] INFO com.sas.appserver.utils.PortUtils - isPortAvailable() <<<       ... View more

Yes, I am able to login to smc with sastrust user and I have used sasadm userid password.   Can I change the password of below user during sas upgrade? Is there any impact if we change these passwords?   sasadm@saspw sastrust@saspw sasevs@saspw vatadm vdbadms   During initial installation we have selected the Reducing the Number of Password Prompts option. ... View more

Do you want to take your lat/long coordinates, and plot dots (or markers) on a map at those locations, and have the colors of the dots represent the data? (for this you could use Proc Gmap, and annotate the points)   Or, do you want to figure out which region the lat/long points are in, and then aggregate (average, etc) the values within each region, so you can produce a map showing the regions, with the region area colored by the aggregate (average, etc) values? (for this, you could use Proc Ginside to determine which region the lat/long points are in)     ... View more