there should be a RemoteServices.log ans _wrapper.log under config/Lev1/web/logs. They will have further details on why RS didn't start. ... View more

Hi, It would have been useful to post the log here too What details are stored in Metadata for RS? Check in SMC -> Foundation Services Manager -> Remote Services -> Core -> Platform Service Registry Under TCPIp Connection, what host name is specificed. Does this match your machine? is it local host? 127.0.0.1? Also check the Event Broker Service -> Service Configuration -> Configuration ->Connections -> Edit, and check machine name. Check that the entry in here exists in your hosts file and try to start RS. If it was me, I would have localhost, on the assumption that Jboss is running on the same PC. Any anti virus differences between Network PC and Not? perhaps multicast is being blocked? Cheers. ... View more

Hi Pramod, You need to send the macros to your Grid session using a %syslput of the macro var after your signon.... If this is from EG, the pre/post code should have statements to send all your macro vars to the Grid session. Cheers. Message was edited by: mgst170 ... View more

Hi, Instead of using the libid to find the library in Metadata, try using the libref defined in Metadata instead. Libname B6RPAR META library='B6RPAR'; So, assuming your library names are consistent between Dev/Test/Prod, this should work after promotion. Cheers. ... View more

Hi, You'll need more than the location if you want to find out the values in the format. Try something like: proc format lib=???? cntlout=work.andy; select @lang ; run; fmtsearch lists your search path for formats. Replace ???? with the library where your fomat catalog lives. This will create a dataset with all the values within the lang format you are after. Hope this helps. Cheers ... View more

Hi, Solution is to modify the stored process. From the "SAS Code" window when editing a STP, click the "Include Code For" button. Deselect the option "Stored process macros". Should work fine after that, and yes, it will still run as a stored proc without these macros. Cheers. ... View more

Alternatively, if you are using 9.1.3, setting your SAS libraries to "Pre-Assigned" via the Management console, and setting invocation option "metaautoinit" for your workspace server will asign all your libraires on start up of E-Guide. ... View more

Just thinking out loud..... but how do you use a Stored Process to restart the Object spawner? The minute you issue the restart command to the spawner, it will kill your stored process, and you will never get any results back to check whether your command was successful. Or are you intending to kill the actual PID's that relate to the Stored Process Server but leave the spawner running? For what it's worth, if you have SAS connect, you could in theory have an STP that calls a signon to your server but uses the SAS User credentials. Once that connect session is established, you could then execute the call to the object spawner to restart it as you will be now running under the SAS user account. When I have done this in the past, it has typically been through the use of another 3rd party tool - sudo, upm etc. Cheers. ... View more

Depending on your infrastructure (9.1 onwards), this sounds like an prime example of using SAS Stored Processes. These would be generally be generated through Enterprise guide, and executed by users from there. Access to execution of the STP's can be controlled from the SAS Metadata Server using SAS Management console, including the connection information to your Oracle DB's. This authentication can be controlled/limited to certain users and/or groups. Cheers. ... View more

You can run pipe and x commands through EG. There are a number of ways in which this can be done, but as you are running local EG, here is the solution you need: Go to Start and type regedit Navigate to HKEY_CLASSES_ROOT\CLSID\{440196D4-90F0-11D0-9F41-00A024BB830C}\LocalServer32 Here you will see the sas command used to start your local workspace server session. In this command, replace the -noxcmd with -xcmd. Restart EG. Easiest way to check is to run proc options and check xcmd is now set. Cheers. ... View more