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;
... View more