topic Re: how many sessions in the stored process in Developers

how many sessions in the stored process

tony_sas — Tue, 21 Aug 2007 06:17:55 GMT

HI, all
I am a newlearner of sas stored process server.My situation is :
1.There is one stored process server in one host;
2. I connect the server from different machine through IE;
3. If I connect the server at almost the same time, how many sessions in the stroed process server. If different client has different session , how can I get the sessionID. Can you give some document to learn about such issues.
4. when I investigated the sas document of stroed process ,there are reserved macro variables ,such as _SESSIONID, but this macro variable is created only if a session has been explicitly created. I do not want to create a new session ervery time .
5.When I use the macro variable in a sas stored process , the value of _RMTADDR is different during every time I connect the server through different IE.How can the server realize this?

Thanks in advance!

Message was edited by: tony@sas Message was edited by: tony@sas

Re: how many sessions in the stored process

Cynthia_sas — Tue, 21 Aug 2007 16:38:11 GMT

Hi:
The answer to this question is very installation specific. For an overview of one company's experience with installing and configuring the Enterprise Intelligence Platform, this SAS Global Forum paper gives you a good idea of what your SAS Administrator had to know to set things up at your installation.
http://www2.sas.com/proceedings/forum2007/202-2007.pdf

Generally, the person writing stored processes does not worry about how many sessions are available or how the servers are handling requests. This falls under the category of tasks taken care of by the SAS Administrator for an installation.

All of these questions fall under the general category of "Platform Administration" and the person who installed the Enterprise Intelligence Platform should have a set of manuals available that go over the WHOLE installation process, including setting up the stored process server and using sessions.

We have a set of classes under the Platform Administration category:
http://support.sas.com/training/us/paths/pa.html

and a self-paced learning class (that I've heard takes about 13-15 hours to complete):
http://support.sas.com/training/us/crs/adbi.html

So as you can see, this is not a quick question. If you have an urgent or immediate need for help, you might consider contacting SAS Technical Support.

cynthia

Re: how many sessions in the stored process

tony_sas — Wed, 22 Aug 2007 02:08:53 GMT

Hi, Cynthia,
Thanks a lot for your so quick response!

I have readed the log of the store process, I find that every time I connect the stored process server, the sas.portal.sessionid and the sas.stp.sessionid are different . But during every connection ,these two variable are unique. The every connection is every time I login from the same machine or different host.During once login, these two variable are unique.

Now , my question is how can I get the value of these two variables?

I can get the value of the macro variable, such as _RMTADDR .But these two variables are not the macro.

The log is listed below, and the sas.portal.sessionid and the sas.stp.sessionid have been marked by black fonts.

Thanks in advance!

NOTE: %INCLUDE (level 1) ending.
=============== STP Context 36 Log End ===============
20070821:16.28.07.11: 00002659: 35:sasadm: STP: Releasing Lock on Session 1391CA6F-2EDB-48C6-9D61-449A609D99BE
20070821:16.28.07.11: 00002659: 35:sasadm: STP: 36: Not Saving session 1391CA6F-2EDB-48C6-9D61-449A609D99BE
20070821:16.28.07.11: 00002708: 35:sasadm: STP: 36: Context Close
20070821:16.28.07.13: 00002708: 35:sasadm: STP: Session Deleted 1391CA6F-2EDB-48C6-9D61-449A609D99BE
20070821:16.28.07.13: 00002708: 35:sasadm: STP: Sending cost=0 to Load Balancer. tkStat=0
20070821:16.28.07.13: 00002712:ERROR: The tcpSockRead call failed. The system error is 'The connection was reset by a peer.'.
20070821:16.28.07.13: 00002712:NOTE: Bridge protocol engine socket access method failed to read from socket, error 10054 (The
connection was reset by a peer.).
20070821:16.28.07.13: 00002708: Client connection (35) closed.
20070821:16.28.07.42: 00002714: New client connection (36) accepted from server port 8631 for user sasadm@CRDIT012TONY.
Encryption level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are 172.26.46.185:1740.
20070821:16.28.07.42: 00002675: 36:sasadm: STP: Creating New Context: Data\misdata\proccode\spo testSession2.sas, sessionID=
20070821:16.28.07.51: 00002675: 36:sasadm: STP: CreateContext: Context ID: 37, Address=0x1dd7c80
20070821:16.28.07.51: 00002675: 36:sasadm: STP: Sending cost=101 to Load Balancer. tkStat=0
20070821:16.28.07.64: 00002717: 36:sasadm: STP: Setting Lock on Session 3CE1EF5E-2414-4508-A179-EEC4DDEFAB65
20070821:16.28.07.66: 00002717: 36:sasadm: STP: 37: Executing Data\misdata\proccode\spo testSession2.sas
20070821:16.28.07.72: 00002717: 36:sasadm: STP: 37: Execution Complete. Status=0
=============== STP Context 37 Log ===============
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)

94 The SAS System 15:19 Tuesday, August 21, 2007

Licensed to Employee SID, Site 0047162208.
NOTE: This session is executing on the NET_SRV platform.
NOTE: SAS 9.1.3 Service Pack 4
WARNING: Only Base procedures and SAS/STAT procedures have been tested for use with VALIDVARNAME=ANY. Other use of this option is
considered experimental and may cause undetected errors.
NOTE: SAS Initialization used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

>>> SAS Macro Variables:
_HTCOOK=__utma=234506268.847354230.1182939212.1187674321.1187677512.12;
__utmz=234506268.1185257397.9.3.utmccn=(organic)|utmcsr=google|utmctr=sas%2Fshare|utmcmd=organic; sasitvid=2942428441.856029;
sas.portal.sessionid=GL02jGY7FwLvZVSbPnkLQvNKdMznH0qVcmVkKNGxWMvW5xKTWr32!494598364; sas.stp.sessionid=GL0GpfV2ZFtM5z5PK0v4TpTPKBBrL4WQvXrbqFpMFwgV1vz6GrRB!494598364
_SRVNAME=crdit012tony.apac.sas.com
_DOMAIN=DefaultAuth
_RESULT=STREAM

_APSLIST=_srvport,_metauser,_htcook,_grafloc,_srvname,_reqmeth,_htua,_domain,_url,_result,_version,_rmthost,_program,_metaperson,_us
ername,_rmtaddr,_repository
_URL=/SASStoredProcess/do
_METAUSER=sasadm
_REPLAY="&_URL?_sessionid=3CE1EF5E-2414-4508-A179-EEC4DDEFAB65&_program=replay&_entry=&_TMPCAT.."
_HTUA=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
_SRVPORT=7001
_VERSION=Version 9.1.3 (Build 348)
_PROGRAM=SBIP://Foundation/MIS/spo/testSession2
_RMTHOST=172.26.46.174
_METAPERSON=SAS Administrator
_REQMETH=POST
_USERNAME=sasadm
_GRAFLOC=/sasweb/graph
_RMTADDR=172.26.46.174
_REPOSITORY=Foundation
_TMPCAT=APSWORK.TCAT0025
1 options nosource source2 center notes nodate nonumber ls=195 formchar='|----|+|---+=|-/\<>*' pagesize=40 noovp nomprint
nomlogic nosymbolgen; title; footnote;

Re: how many sessions in the stored process

Cynthia_sas — Wed, 22 Aug 2007 03:18:06 GMT

Hi:

Depending on how you're running the stored process, this documentation may help you:
http://support.sas.com/documentation/configuration/biwaag.pdf

Your best bet for help with this question is to contact Technical Support.

cynthia

Re: how many sessions in the stored process

tony_sas — Thu, 23 Aug 2007 06:09:00 GMT

Thanks a lot!