About ScottBass

ScottBass · ‎08-05-2015

Hi, I think the answer is "No", but just checking... Is there a way to get EG to add the _method option to SQL queries? This is for an end user query, where they point and click rather than hand write code. I'm modifying an end users project to get it to run faster, and want to know if SQL is using an index in a left join. msglevel is set to "I". Regards, Scott

ScottBass · ‎07-30-2015

One last comment, perhaps as much to myself as anyone...but if you want to chime in please do so Hmmm...in thinking about this further, I wonder if generation data sets would work well here? It's been a billion years since I've used them. Time to revisit the doc! Edit: I do wish proc append would roll over the generation group. If we have a 10M row base table and are appending 1K rows from today's transactions, I don't want to run a full data step just to roll over the generation group. If there IS a way to roll over the generation group using proc append, let me know. Otherwise, the "manual" approach to creating a backup from the above post may be the way to go. proc datasets lib=work nowarn nolist kill; quit; * only need to specify the genmax option the first time ; data class (genmax=3 label="First"); set sashelp.class; run; * another data step ; data class (label="Second"); set class; run; * proc append (bummer...no work.Class#002) ; proc append base=class (label="Third") data=sashelp.class; run; * one more iteration, the first one will be deleted ; data class (label="Fourth"); set sashelp.class; run; Added edit about proc append and generation groups

ScottBass · ‎07-29-2015

Thanks Jack. The target cloned dataset needs to have a different name in the same library as the source dataset.

ScottBass · ‎07-29-2015

Thanks Linus, that helped. Perhaps it's better to see the code in context, so the full picture is evident. FWIW this approach is based on work from the programmer before me, although I've modified it a bit: *** Load the data *** ; %* The desired output is to: ; %* 1) A backup of yesterdays data named "_old" ; %* 2) Load todays data with the correct output name ; %* And to do so with optimal performance and recoverability ; %* The "flow" is: ; %* 1) Create an empty skeleton dataset (including indexes) based on the current "fact" dataset ; %* 2) Delete the "_old" dataset (day before yesterdays data) ; %* 3) Rename the current "fact" dataset to "_old" (now it is yesterdays data) ; %* 4) Load todays data into the "_tmp" dataset ; %* 5) Rename the "_tmp" dataset to the current "fact" dataset ; %* We could reverse #3 and #4 (rename then load directly) ; %* but that is more confusing if an error occurs during the load ; %* and we have to manually recover ; %macro load_data(type,lib,target); %let type=%lowcase(&type); %if (&type eq hospital) %then %let source=workspde.claimfact&type._epi_xfr; %else %if (&type eq medical) %then %let source=workspde.claimfact&type._epi; %* save current syscc value and reset to 0 ; %let syscc_temp=&syscc; %let syscc=0; proc datasets lib=&lib nolist nowarn; %if (&syscc eq 0) %then %do; * Create skeleton dataset including indexes for later use ; delete &target._tmp; %* In case it exists ; run; append base=&target._tmp data=&target (obs=0); run; %end; %if (&syscc eq 0) %then %do; * Delete the "_old" dataset (now the day before yesterdays data) ; delete &target._old; run; %end; %if (&syscc eq 0) %then %do; * Rename the current "fact" dataset to "_old" (now yesterdays data) ; change &target=&target._old; run; %end; %if (&syscc eq 0) %then %do; * Load todays data into the "_tmp" dataset ; append base=&target._tmp data=&source; run; %end; %if (&syscc eq 0) %then %do; * Rename the "_tmp" dataset to the current "fact" dataset (now todays data) ; change &target._tmp=&target; run; %end; quit; %let syscc=&syscc_temp; %bench(elapsed,data=elapsed,message=Load: Load &type data) %mend;

ScottBass · ‎07-27-2015

Hi, Is this the best approach to clone a dataset including indexes? The end result should be an empty dataset with all indexes in place from the source dataset. options obs=max; data class; set sashelp.class; run; data zipcode; set sashelp.zipcode; run; proc datasets lib=work nowarn nolist; modify class; index create name; index create sex; index create age; index create primary=(height weight); run; modify zipcode; index create statecode; index create statename; run; quit; libname temp spde "%sysfunc(pathname(work))" temp=yes; options obs=0; proc copy in=work out=temp clone; select class zipcode; run; options obs=max; proc datasets lib=temp nowarn nolist; change class=class2; change zipcode=zipcode2; quit; proc copy in=temp out=work; select class2 zipcode2; run; libname temp; I like the fact that the SPDE engine allows me to create a temporary library whose directory will be deleted by SAS when the library is freed. Which is why I'm using that approach. One thing to note is, on my system (Windows), the cloned dataset is "large", even though it's empty. This is due to the Data Set Page Size being different due to the two different engines being used. I read the doc on proc copy; to me it seemed that the clone option would create a dataset with the same internal structure as the source dataset (even across the two engines). My "real" code is SPDE to SPDE, so this won't be an issue. My real code also needs to clone two datasets. Now if only SAS supported: proc sql; create table work.class2 like sashelp.class including indexes; quit; or something like that. If the above code IS the current best approach, perhaps SAS could make this a bit easier in a future release? Regards, Scott

ScottBass · ‎07-08-2015

Hi All, Thanks all for your responses. , your comment "Usual protection in most apps is quoting or some form of "escaping" " inspired me to try the below, which works in my environment (Excel 2007, Australian Regional Settings, etc.). YMMV. /* create a new DateTime column from the date column */ data buy; date=date(); datetime=datetime(); * dates must be converted to datetime format ; datetime2=dhms(date,0,0,0); format date date9. datetime datetime2 datetime21.; run; /* Pre-9.2, the format/informat name was IS8601DT . That name is still */ /* allowed in 9.2, although we are */ /* now using the name E8601DT (E=Extended vs. B=Basic). */ /* set the format for the DateTime coming from SAS */ /* and set the Excel type and format so Excel knows what to do with it */ ods noresults; ods _all_ close; ods tagsets.excelxp file='c:\temp\temp.xml' style=analysis; proc print data=buy; format datetime datetime2 e8601dt.; var date; var datetime; var datetime2; var datetime2 / style(data)={tagattr='type:DateTime format:dd.mm.yyyy'}; * works ; var datetime2 / style(data)={tagattr='type:DateTime format:ddd-dd.mm.yyyy'}; * works ; var datetime2 / style(data)={tagattr='type:DateTime format:ddd-dd/mm/yyyy'}; * does not work ; var datetime2 / style(data)={tagattr='type:DateTime format:dd/mm/yyyy'}; * does not work ; var datetime2 / style(data)={tagattr='type:DateTime format:dd\/mm\/yyyy'}; * works, go figure ; run; ods tagsets.excelxp close; ods listing; Note the "escaped" slashes in the last example. I've tried to attach a screenshot of the results in my environment: * Advanced Editor, Attach Files (click Choose file button): Max Size: 1.0K, no file type allowed. * Insert Image (click the camera icon): Just times out when I try to insert a 97Kb png file into the message If someone can tell me how to attach screenshots to a message I'll edit the message later. Regards, Scott

ScottBass · ‎07-04-2015

I would think the format specification i.e. {tagattr='type:DateTime format:dd/mm/yyyy'} should match the format as listed in Excel, i.e. Home -> Number format dropdown -> Custom -> dd/mm/yyyy. As explained in the link above Adding a Custom Format to those Offered by Excel (Microsoft Excel), the issue is due to the fact that dd/mm/yyyy is not a date format shipped with Excel. I was hoping someone here would have a bright idea I haven't been able to think of.

ScottBass · ‎07-03-2015

Hi, I have the below code based on 38143 - Apply date formats with the ExcelXP destination: ods noresults; ods _all_ close; ods tagsets.excelxp file='c:\temp\temp.xml' style=analysis; /* create a new DateTime column from the date column */ data buy; date=date(); datetime=datetime(); * dates must be converted to datetime format ; datetime2=dhms(date,0,0,0); format date date9. datetime datetime2 datetime21.; run; /* Pre-9.2, the format/informat name was IS8601DT . That name is still */ /* allowed in 9.2, although we are */ /* now using the name E8601DT (E=Extended vs. B=Basic). */ /* set the format for the DateTime coming from SAS */ /* and set the Excel type and format so Excel knows what to do with it */ proc print data=buy; format datetime datetime2 e8601dt.; var date; var datetime; var datetime2; var datetime / style(data)={tagattr='type:DateTime format:yyyy-mm-dd'}; var datetime / style(data)={tagattr='type:DateTime format:mm-dd-yy'}; var datetime / style(data)={tagattr='type:DateTime format:yyyy-mm-dd:hh:mm:ss'}; var datetime / style(data)={tagattr='type:DateTime format:dd/mm/yyyy'}; * <<< not working in excel ; var datetime2 / style(data)={tagattr='type:DateTime format:yyyy-mm-dd'}; var datetime2 / style(data)={tagattr='type:DateTime format:mm-dd-yy'}; var datetime2 / style(data)={tagattr='type:DateTime format:yyyy-mm-dd:hh:mm:ss'}; var datetime2 / style(data)={tagattr='type:DateTime format:dd/mm/yyyy'}; * <<< not working in excel ; run; ods tagsets.excelxp close; ods listing; It "works" except for the dd/mm/yyyy format. I think the issue is due to Excel being poorly designed (sorry, I'm not a fan of Excel): http://excel.tips.net/T003096_Adding_a_Custom_Format_to_those_Offered_by_Excel.html I've tried creating the custom format in an autostart template, but that's not working, I think because the output is XML - it does work (the custom format is in place) if I just launch Excel without opening a saved workbook. Any bright ideas how I can 1) save the cell/column as a proper Excel date (i.e. not as '25/12/2015 string), and 2) have Excel format that as dd/mm/yyyy? BTW it's Excel 2007 with English (Australia) regional format. Changing the region settings on the end users computer is not an option. Thanks, Scott

ScottBass · ‎06-21-2015

Hi Jag, Thanks. It looked like an icon to me, so I'd always just clicked it. I never hovered long enough for the pop up to happen. Now that I do hover, I get the pop up, but some of the longer ones disappear before I've had a chance to read them. I do think a click icon/dialog window paradigm would have been more intuitive. Regards, Scott

ScottBass · ‎06-17-2015

(Wow...1K file size limit for attachments. Sorry I couldn't get my screenshot that small. Hopefully the message makes sense without the screenshot.)

ScottBass · ‎06-17-2015

Hi, Say I'm installing SAS Foundation + Clients on my local machine (Windows). So I launch setup.exe, select Install SAS Foundation and Related Software, and get something like the attached screenshot. So what exactly is the "Info" column meant to do? I click what appears to be an icon and...nothing. What "info" is the installation wizard meant to be providing? Is there a documentation link that actually gives me the info for each of these module choices? For example, what do I get (or don't get) with "Report Fonts for Clients" or "Standalone Formats"? Thanks, Scott

ScottBass · ‎04-14-2015

Thanks Paul, I've got this working thanks to the link you provided. For those that find this thread in the future, here's what I did: General: F: is a dedicated drive for the work and utility files. It is the "root" of the work and util files. We have F:\SASWork and F:\SASUtil to split out the work and utility files. These correspond to the -WORK and -UTILLOC invocation options. We have three SAS levels on the one machine, so we have F:\SASWork\Lev1 | Lev2 | Lev9 and F:\SASUtil\Lev1 | Lev2 | Lev9. All directories and files are owned by SYSTEM down to the directories created by SAS (i.e. _TD12345_<machinename>) The link Paul provided uses the "Everyone" principal. I used "Users" instead of "Everyone", since all SAS users will be authenticated. I tweaked some of the settings differently from the link Paul provided. I tested pretty heavily, and these settings appear to meet my needs. In general, I granted as little permission as possible but still work correctly. See details below. Option 1: F:\ SYSTEM and Administrators: Full Control ~ This folder, subfolders and files Machinename\Users: Traverse folder / execute file + List folder / read data ~ This folder, subfolders and files (This will display as "Special permissions") Inheritance is on F:\SASWork Everything is inherited F:\SASWork\Lev1 | Lev2 | Lev9 Everything is inherited Additional ACEs: Machinename\Users: Traverse folder / execute file + List folder / read data + Read attributes + Create folders / append data ~ This folder only. This allows the current SAS process to create the _TD12345_MachineName_ folder under F:\SASWork\Lev1. This directory, subfolders, and files are owned by the user who has launched the SAS process. Note that some of these permissions duplicate permissions from the Users principal inherited from F:\. CREATOR OWNER: Full Control ~ Subfolders and files only. This allows the current SAS process to read/write/delete files and subfolders under _TD12345_MachineName_ Under this scenario, another user can list the contents of someone else's user library, but cannot read the data. For example, I can execute libname foo "F:\SASWork\Lev1\_TD12345_MachineName", where that path is someone else's work folder. The DMS explorer will show the contents, i.e. SAS datasets, in that library, but I cannot open them or read their data. In the unlikely scenario where even the name of the contents in the other user's work library is sensitive: Option 2: Same as above, except: 1) Turn off inheritance on Lev1 | Lev2 | Lev9 2) Remove the inherited Machinename\Users principal (i.e. remove Traverse folder / execute file + List folder / read data from This folder, subfolders, and files) 3) Propagate the explicit permissions to the child objects (i.e. SYSTEM and Administrators) 4) So, the remaining Machinename\Users principal granting Traverse folder / execute file + List folder / read data + Read attributes + Create folders / append data only applies to This folder only. In this scenario, I cannot even list the contents of the other user's work library. libname foo "F:\SASWork\Lev1\_TD12345_MachineName", where that path is someone else's work folder, fails with Access denied. I went with Option 1, which meets my security needs. Thanks again for the help Paul, and I hope this may help someone else who finds this in the future. Regards, Scott Message was edited by: Scott Bass: Further testing showed that CREATOR OWNER needs Full Control, not just Modify

ScottBass · ‎04-13-2015

Hi, Windows Server 2012 R2 SAS 9.4 Apologies if this info is already in the SAS documentation. If so please point me in the right direction. Our server is using a common "root" for all SAS work and SAS util directories. That root is on its own disk drive. The details are F:\SASWork\Lev1 | Lev2 | Lev9\<sas work sub-dir, eg _TD<PID>_<MachineName>_ Assume that 1) our end users need X command capability from EG, and 2) some users may be working with sensitive data that only they should access. Question: what is the best practice/correct NTFS permissions to ensure that only the "owner" of the files gets access? I've set these NTFS permissions (which aren't correct): F:\ Owner = MachineName\Administrators Administrators: Full Control This folder, subfolders, and files SYSTEM: (Same as administrators) MachineName\Users: Read & Execute This folder, subfolders, and files (so that the SAS process can traverse the directory tree and create the sub-directory under F:\SASWork\Lev1\...) Inheritance is turned on F:\SASWork Owner = MachineName\Administrators Inherits from F:\ F:\SASWork\Lev1 Owner = MachineName\Administrators Inherits from F:\ Additional ACE: MachineName\Users Modify This folder, subfolders, and files (so that the SAS process can create the sub-directory under F:\SASWork\Lev1\...) If the user running EG is an administrator, the SAS work sub-directory i.e. _TD12345_MachineName_ is owned by MachineName\Administrators. If the user running EG is not an administrator, the SAS work sub-directory is owned by that user. It's fine if administrators can see anyone else's data, but non-administrators should not be able to access anyone else's data. Is there an NTFS principal I can use, such as CREATOR OWNER, such that only the owner of the SAS work directory/files can access the files, without locking down the NTFS permissions so tight that the creation of the SAS work directory itself fails? Thanks, Scott P.S.: This is pretty esoteric, and I don't suspect any problems from my end users. But assuming the end user will do the right thing isn't a good premise on which to base security! Appendix: Here is some sample code that a nefarious user could use to snoop on the work files (at least in my current environment...what about yours?) * get pathname to work library ; %let work=%sysfunc(pathname(work)); %put &=work; * get all directories under the work library parent folder ; * replace F:\SASWork\... with whatever is the parent folder for your work library ; * note that even without XCMD the user could just guess at PIDs and use PROC COPY ; filename dir pipe 'dir F:\SASWork\Lev1 /s /b /a:d' lrecl=1000; data workdirs; infile dir lrecl=1000; length file $1000; input; file=_infile_; run; * build a program to copy their data to my work library ; filename copy temp lrecl=1000; data _null_; set workdirs; file copy lrecl=1000; put "libname dummy '" file +(-1) "';"; put "proc copy in=dummy out=work memtype=data;"; put "run;"; put "libname dummy clear;"; run; * check the program ; data _null_; infile copy lrecl=1000; input; put _infile_; run; * execute the program ; %include copy; * check the work library ; proc datasets lib=work details; quit; /* alternative approach...runs faster but may not work 100% * build a program to copy their data to my work library ; filename copy "&work\copy.bat" lrecl=1000; data _null_; set workdirs; file copy lrecl=1000; put "copy " file " &work"; run; * check the program ; data _null_; infile copy lrecl=1000; input; put _infile_; run; * execute the program ; systask command "&work\copy.bat" wait; */

ScottBass · ‎03-15-2015

And here are the results when I use the BAT file in my Lev9 environment: cmd console output: E:\SAS\Config\Lev9\Web\SASEnvironmentManager\server-5.8.0-EE\bin>hq-server.bat start wrapper | Starting the SAS [Config-Lev9] SAS Environment Manager service... wrapper | SAS [Config-Lev9] SAS Environment Manager started. E:\SAS\Config\Lev9\Web\SASEnvironmentManager\server-5.8.0-EE\bin>hq-server.bat stop wrapper | Stopping the SAS [Config-Lev9] SAS Environment Manager service... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | Waiting to stop... wrapper | SAS [Config-Lev9] SAS Environment Manager stopped. wrapper.log: STATUS | wrapper | 2015/03/16 12:47:26 | Starting the SAS [Config-Lev9] SAS Environment Manager service... STATUS | wrapper | 2015/03/16 12:47:26 | --> Wrapper Started as Service STATUS | wrapper | 2015/03/16 12:47:26 | Java Service Wrapper Community Edition 32-bit 3.5.6 STATUS | wrapper | 2015/03/16 12:47:26 | Copyright (C) 1999-2010 Tanuki Software, Ltd. All Rights Reserved. STATUS | wrapper | 2015/03/16 12:47:26 | http://wrapper.tanukisoftware.com STATUS | wrapper | 2015/03/16 12:47:26 | STATUS | wrapper | 2015/03/16 12:47:26 | Launching a JVM... INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: Initializing... INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: WARNING - Unable to load the Wrapper's native library because none of the INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: following files: INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: wrapper-windows-x86-64.dll INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: wrapper.dll INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: could be located on the following java.library.path: INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: E:\SAS\Config\Lev9\Web\SASEnvironmentManager\server-5.8.0-EE\wrapper\sbin\%LD_LIBRARY_PATH% INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: E:\SAS\Config\Lev9\Web\SASEnvironmentManager\server-5.8.0-EE\wrapper\sbin\%LIBPATH% INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: E:\SAS\Config\Lev9\Web\SASEnvironmentManager\server-5.8.0-EE\wrapper\sbin\%SHLIB_PATH% INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: E:\SAS\Config\Lev9\Web\SASEnvironmentManager\server-5.8.0-EE\wrapper\sbin\..\..\wrapper\lib INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: E:\SAS\Config\Lev9\Web\SASEnvironmentManager\server-5.8.0-EE\wrapper\sbin\..\lib INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: Please see the documentation for the wrapper.java.library.path INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: configuration property. INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: System signals will not be handled correctly. INFO | jvm 1 | 2015/03/16 12:47:27 | WrapperManager: STATUS | wrapper | 2015/03/16 12:47:31 | SAS [Config-Lev9] SAS Environment Manager started. INFO | jvm 1 | 2015/03/16 12:47:34 | Mar 16, 2015 12:47:34 PM org.apache.tomcat.jdbc.pool.ConnectionPool init INFO | jvm 1 | 2015/03/16 12:47:34 | WARNING: maxIdle is larger than maxActive, setting maxIdle to: 100 STATUS | wrapper | 2015/03/16 12:48:35 | Stopping the SAS [Config-Lev9] SAS Environment Manager service... INFO | jvm 1 | 2015/03/16 12:48:35 | [HQServer.main(stop)]: Shutdown of type 'NormalStop' was request INFO | wrapper | 2015/03/16 12:48:40 | Waiting to stop... INFO | wrapper | 2015/03/16 12:48:45 | Waiting to stop... INFO | wrapper | 2015/03/16 12:48:50 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:02 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:07 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:12 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:22 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:27 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:33 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:38 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:43 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:48 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:53 | Waiting to stop... INFO | wrapper | 2015/03/16 12:49:58 | Waiting to stop... INFO | wrapper | 2015/03/16 12:50:03 | Waiting to stop... INFO | wrapper | 2015/03/16 12:50:08 | Waiting to stop... ERROR | wrapper | 2015/03/16 12:50:10 | Shutdown failed: Timed out waiting for signal from JVM. STATUS | wrapper | 2015/03/16 12:50:10 | Dumping JVM state. INFO | jvm 1 | 2015/03/16 12:50:10 | 2015-03-16 12:50:10 INFO | jvm 1 | 2015/03/16 12:50:10 | Full thread dump Java HotSpot(TM) 64-Bit Server VM (24.51-b03 mixed mode): INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "WrapperListener_stop_runner" prio=6 tid=0x000000000769a000 nid=0x63fc waiting on condition [0x000000000a91f000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: TIMED_WAITING (sleeping) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.sleep(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.tanukisoftware.wrapper.WrapperStartStopApp.stop(WrapperStartStopApp.java:466) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.tanukisoftware.wrapper.WrapperManager$13.run(WrapperManager.java:4214) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Thread-4" daemon prio=6 tid=0x0000000007695800 nid=0x82fc runnable [0x000000000a81f000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.FileInputStream.readBytes(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.FileInputStream.read(FileInputStream.java:243) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.util.exec.StreamPumper.run(StreamPumper.java:124) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.run(Thread.java:744) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Thread-3" daemon prio=6 tid=0x0000000007694000 nid=0x5144 runnable [0x000000000969f000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.FileInputStream.readBytes(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.FileInputStream.read(FileInputStream.java:272) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.BufferedInputStream.fill(BufferedInputStream.java:235) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.BufferedInputStream.read1(BufferedInputStream.java:275) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.BufferedInputStream.read(BufferedInputStream.java:334) INFO | jvm 1 | 2015/03/16 12:50:10 | - locked <0x00000000fd9c0418> (a java.io.BufferedInputStream) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.io.FilterInputStream.read(FilterInputStream.java:107) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.util.exec.StreamPumper.run(StreamPumper.java:124) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.run(Thread.java:744) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "[Pool-Cleaner]:Tomcat Connection Pool[1-1857196397]" daemon prio=6 tid=0x0000000007695000 nid=0x8a48 waiting on condition [0x000000000959f000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: TIMED_WAITING (sleeping) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.sleep(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.apache.tomcat.jdbc.pool.ConnectionPool$PoolCleaner.run(ConnectionPool.java:1172) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "WrapperStartStopAppMain" prio=6 tid=0x0000000007698000 nid=0x8ff8 runnable [0x00000000084ce000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.ProcessImpl.waitForInterruptibly(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.ProcessImpl.waitFor(ProcessImpl.java:448) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.util.exec.Execute.waitFor(Execute.java:362) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.util.exec.Execute.execute(Execute.java:333) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.bootstrap.ProcessManagerImpl.executeProcess(ProcessManagerImpl.java:110) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.bootstrap.ProcessManagerImpl.executeProcess(ProcessManagerImpl.java:84) INFO | jvm 1 | 2015/03/16 12:50:10 | at com.hyperic.bootstrap.TcServerEngineController.start(TcServerEngineController.java:90) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.bootstrap.HQServer.start(HQServer.java:152) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.hyperic.bootstrap.HQServer.main(HQServer.java:272) INFO | jvm 1 | 2015/03/16 12:50:10 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) INFO | jvm 1 | 2015/03/16 12:50:10 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.reflect.Method.invoke(Method.java:606) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:245) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.run(Thread.java:744) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "DestroyJavaVM" prio=6 tid=0x0000000007697000 nid=0x65a4 waiting on condition [0x0000000000000000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Wrapper-Connection" daemon prio=6 tid=0x0000000007693800 nid=0x7fa0 in Object.wait() [0x00000000082cf000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: WAITING (on object monitor) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Object.wait(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | - waiting on <0x00000000fd732560> (a org.tanukisoftware.wrapper.WrapperManager$13) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.join(Thread.java:1280) INFO | jvm 1 | 2015/03/16 12:50:10 | - locked <0x00000000fd732560> (a org.tanukisoftware.wrapper.WrapperManager$13) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.join(Thread.java:1354) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.tanukisoftware.wrapper.WrapperManager.privilegedStopInner(WrapperManager.java:4246) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.tanukisoftware.wrapper.WrapperManager.handleSocket(WrapperManager.java:4977) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.tanukisoftware.wrapper.WrapperManager.run(WrapperManager.java:5327) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.run(Thread.java:744) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Wrapper-Control-Event-Monitor" daemon prio=6 tid=0x0000000007696800 nid=0x5bc8 waiting on condition [0x00000000080cf000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: TIMED_WAITING (sleeping) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Thread.sleep(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | at org.tanukisoftware.wrapper.WrapperManager$3.run(WrapperManager.java:908) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Service Thread" daemon prio=6 tid=0x000000000578c800 nid=0x1c34 runnable [0x0000000000000000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "C2 CompilerThread1" daemon prio=10 tid=0x000000000578a800 nid=0x8e44 waiting on condition [0x0000000000000000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "C2 CompilerThread0" daemon prio=10 tid=0x0000000005787000 nid=0x83e4 waiting on condition [0x0000000000000000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Attach Listener" daemon prio=10 tid=0x0000000005786000 nid=0x143c runnable [0x0000000000000000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Signal Dispatcher" daemon prio=10 tid=0x0000000001a9b800 nid=0x8898 waiting on condition [0x0000000000000000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: RUNNABLE INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Finalizer" daemon prio=8 tid=0x0000000005764800 nid=0x760c in Object.wait() [0x0000000006aef000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: WAITING (on object monitor) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Object.wait(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | - waiting on <0x00000000ff608b40> (a java.lang.ref.ReferenceQueue$Lock) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135) INFO | jvm 1 | 2015/03/16 12:50:10 | - locked <0x00000000ff608b40> (a java.lang.ref.ReferenceQueue$Lock) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "Reference Handler" daemon prio=10 tid=0x0000000005763000 nid=0x8764 in Object.wait() [0x00000000069ee000] INFO | jvm 1 | 2015/03/16 12:50:10 | java.lang.Thread.State: WAITING (on object monitor) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Object.wait(Native Method) INFO | jvm 1 | 2015/03/16 12:50:10 | - waiting on <0x00000000ff608cc8> (a java.lang.ref.Reference$Lock) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.Object.wait(Object.java:503) INFO | jvm 1 | 2015/03/16 12:50:10 | at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:133) INFO | jvm 1 | 2015/03/16 12:50:10 | - locked <0x00000000ff608cc8> (a java.lang.ref.Reference$Lock) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "VM Thread" prio=10 tid=0x0000000005761000 nid=0x3324 runnable INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "GC task thread#0 (ParallelGC)" prio=6 tid=0x00000000019ba000 nid=0x4ad4 runnable INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "GC task thread#1 (ParallelGC)" prio=6 tid=0x00000000019bb800 nid=0x1e7c runnable INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "GC task thread#2 (ParallelGC)" prio=6 tid=0x00000000019bd000 nid=0x43e4 runnable INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "GC task thread#3 (ParallelGC)" prio=6 tid=0x00000000019bf000 nid=0x1a44 runnable INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | "VM Periodic Task Thread" prio=10 tid=0x00000000057d6000 nid=0x75fc waiting on condition INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | JNI global references: 216 INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | jvm 1 | 2015/03/16 12:50:10 | Heap INFO | jvm 1 | 2015/03/16 12:50:10 | PSYoungGen total 38912K, used 17716K [0x00000000fd500000, 0x0000000100000000, 0x0000000100000000) INFO | jvm 1 | 2015/03/16 12:50:10 | eden space 33792K, 37% used [0x00000000fd500000,0x00000000fe1540d8,0x00000000ff600000) INFO | jvm 1 | 2015/03/16 12:50:10 | from space 5120K, 99% used [0x00000000ff600000,0x00000000ffaf9208,0x00000000ffb00000) INFO | jvm 1 | 2015/03/16 12:50:10 | to space 5120K, 0% used [0x00000000ffb00000,0x00000000ffb00000,0x0000000100000000) INFO | jvm 1 | 2015/03/16 12:50:10 | ParOldGen total 87040K, used 1826K [0x00000000f8000000, 0x00000000fd500000, 0x00000000fd500000) INFO | jvm 1 | 2015/03/16 12:50:10 | object space 87040K, 2% used [0x00000000f8000000,0x00000000f81c8ad0,0x00000000fd500000) INFO | jvm 1 | 2015/03/16 12:50:10 | PSPermGen total 21504K, used 16941K [0x00000000f2e00000, 0x00000000f4300000, 0x00000000f8000000) INFO | jvm 1 | 2015/03/16 12:50:10 | object space 21504K, 78% used [0x00000000f2e00000,0x00000000f3e8b4e8,0x00000000f4300000) INFO | jvm 1 | 2015/03/16 12:50:10 | INFO | wrapper | 2015/03/16 12:50:13 | Waiting to stop... ERROR | wrapper | 2015/03/16 12:50:14 | JVM did not exit on request, terminated STATUS | wrapper | 2015/03/16 12:50:15 | <-- Wrapper Stopped STATUS | wrapper | 2015/03/16 12:50:17 | SAS [Config-Lev9] SAS Environment Manager stopped.

ScottBass · ‎03-15-2015

Thanks @SASKiwi, but that KB article is about the Environment Manager Agent, not the Environment Manager. And I don't get from that article where starting and stopping the service via the Services snapin (and by extension the Start-Service and Stop-Service Powershell cmdlets) are prohibited. It even states "3. Start the SAS Environment Manager agent how you normally start it".

Online Status	Offline
Date Last Visited	‎03-11-2021 01:34 AM

Re: How do I unsubscribe from a topic?

Re: How do I unsubscribe from a topic?

How do I unsubscribe from a topic?

Re: How to: Listing all the files in a folder

Re: How to: List all the files in a folder

Re: How to improve performance in Data step where clause

Re: Using SAS to find a streak of occurrences within any seven day win...

Re: Proc transpose error with same name variable and exceeds 32 length

Re: using rsubmit in a loop

Re: using rsubmit in a loop

Re: LOCF

Re: Programming Question

Re: Programming Question

Re: SAS query - Split data to different dataset

Re: SAS query - Split data to different dataset

Re: Why the result useing the catx have blanks

Re: Check numeric values in alphanumeric variables

Re: Read a Variable Value into a Macro Variable

Re: How to: List all the files in a folder

EG Custom Task to play a sound

How to create a working outline for SAS Global Forum

SAS Global Forum Presenter Mentoring Program

Is there a way to specify _method in an EG query?

Re: Clone a dataset including indexes

Re: Clone a dataset including indexes

Re: Clone a dataset including indexes

Clone a dataset including indexes

Re: Format Excel date as dd/mm/yyyy

Re: Format Excel date as dd/mm/yyyy

Format Excel date as dd/mm/yyyy

Re: SAS Deployment Wizard: Is the Info column mean to do anything?

Re: SAS Deployment Wizard: Is the Info column mean to do anything?

SAS Deployment Wizard: Is the Info column mean to do anything?

Re: Proper NTFS permissions for work directories under Windows

Proper NTFS permissions for work directories under Windows

Re: SAS Environment Manager does not properly shutdown

Re: SAS Environment Manager does not properly shutdown

SAS Global Forum 2020