BookmarkSubscribeRSS Feed
KarthikC036
Calcite | Level 5

I'm getting below error while executing Stored processes.

Just performed patching and server reboot last week and all of a sudden below error is showing up.


2022-02-02T03:10:48,285 INFO [00003071] :rampsrv - New out call client connection (27) for user XXXX. Encryption level is Credentials using encryp
tion algorithm SASPROPRIETARY. Peer IP address and port are [10.16.53.182]:8561.
2022-02-02T03:10:48,295 INFO [00003071] :XXXXX - New client connection (26) accepted from server port 8629 for SAS token user XXXXXX. Encryption
level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are [XXXXXX]:52598.
2022-02-02T03:10:48,386 INFO [00003087] 26:XXXXXX - STP: 12: Creating New Context, sessionID=
2022-02-02T03:10:48,397 INFO [00003087] 26:XXXXXX - STP: Sending cost=101 to Load Balancer. Context Cost=100 STP Session Cost=1
2022-02-02T03:10:48,519 INFO [00003168] 26:XXXXXX - STP: 12: Executing SASEnvironment/SASMacro/apm_request_init.sas
2022-02-02T03:10:48,738 ERROR [00003168] 26:XXXXXX - STP_ERR: Requested Stored Process SASEnvironment/SASMacro/apm_request_init.sas does not exist.
2022-02-02T03:10:48,777 INFO [00003202] 26:XXXXX - STP: 12: Context Close
2022-02-02T03:10:48,855 INFO [00003202] 26:XXXXXX - STP: Sending cost=1 to Load Balancer. Context Cost=0 STP Session Cost=1
2022-02-02T03:10:48,910 INFO [00003215] 26:rampsrv - Client connection 26 for user XXXXXX closed.
2022-02-02T03:10:48,917 INFO [00003215] 26:rampsrv - Client connection 27 for user XXXXX closed.

 

I have already gone through below article but don't actually want to change the configureAPM.groovy file as I want to understand why system is unable to get the relative path for SASEnvironment/SASMacros path.

 

https://support.sas.com/kb/61/325.html

3 REPLIES 3
SASKiwi
PROC Star

So I assume apm_request_init.sas does exist in SASEnvironment/SASMacro? It's probably the SASAUTOS option that's need checking.

KarthikC036
Calcite | Level 5

Yes @SASKiwi the files apm_request_*.sas files does exist in SASEnvironment/SASMacros path. When it comes to SASAUTOS, it hasn't been modified at all. 

gwootton
SAS Super FREQ
This can happen if something changes the working directory of the server out of the SASApp/ path, so the relative path is no longer accurate.
--
Greg Wootton | Principal Systems Technical Support Engineer

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 724 views
  • 0 likes
  • 3 in conversation