Problem Note 69757: Stored processes intermittently fail to execute in SAS® Pooled Workspace servers and might return the "No such name was found..." error
 |  |  |  |  |
Stored processes intermittently fail to execute and errors such as the following might appear in SAS Pooled Workspace server logs when debug logging is enabled:
yyyy-mm-ddThh:mm:ss,sss DEBUG [19443526] 4391:ciprem@saspw - IOM RETURN -1{compRef:7fcb84287ce0} ->StoredProcessContext2::WorkspaceSet(): text=<?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">No such name was found.</SASMessage></Exception></Exceptions>
yyyy-mm-ddThh:mm:ss,sss DEBUG [00000005] 4391:ciprem@saspw - IOM RETURN -1{compRef:7fcb60110140} ->StoredProcessContext2Proxy::WorkspaceSet(): text=<?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">No such name was found.</SASMessage></Exception></Exceptions>
yyyy-mm-ddThh:mm:ss,sss DEBUG [00000005] 4391:ciprem@saspw - IOM RETURN -1{compRef:7fcb7c109c60} ->Workspace::CreateSTPContextFromWorkspace(): text=<?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">No such name was found.</SASMessage></Exception></Exceptions>
When debug logging is not enabled for the SAS Pooled Workspace Server, there is no evidence of an issue in the SAS Pooled Workspace server log.
You are most likely to encounter this issue with a heavy stored process load on the SAS Pooled Workspace server, which can occur in SAS® Customer Intelligence 360 Engage: Direct. In SAS Customer Intelligence 360 Engage: Direct, an error similar to the following appears in your onprem_direct.log file:
yyyy-mm-dd hh:mm:ss,sss ERROR [CIExec-12] SID[] USER[] CC[] [] om.sas.services.storedprocess.Execution2 - Stored process
"OnPrem Direct - 2833fe5299b77f2b12eb3b14b0d71937" (eid: 3176) completed execution with the following exception(s):
yyyy-mm-dd hh:mm:ss,sss ERROR [CIExec-12] SID[] USER[] CC[] [] om.sas.services.storedprocess.Execution2 -
com.sas.services.storedprocess.SASServerException: A failure occurred accessing the execution server.
at com.sas.services.storedprocess.Execution2.extractConnectionAndGetStreams(Execution2.java:2536)
at com.sas.services.storedprocess.Execution2.executeStoredProcess(Execution2.java:2585)
at com.sas.services.storedprocess.Execution2.execute(Execution2.java:1370)
at com.sas.services.storedprocess.StoredProcess2.execute(StoredProcess2.java:1227)
at com.sas.analytics.crm.platformservices.storedprocess.ProcessRunner.doRun(ProcessRunner.java:151)
at com.sas.analytics.crm.platformservices.storedprocess.ProcessRunner.doRun(ProcessRunner.java:114)
at com.sas.analytics.crm.platformservices.storedprocess.ProcessRunner.run(ProcessRunner.java:86)
at com.sas.analytics.crm.custdata.storedprocess.StoredProcess.runStoredProcess(StoredProcess.java:198)
at com.sas.analytics.crm.custdata.storedprocess.StoredProcess.execute(StoredProcess.java:128)
at com.sas.analytics.crm.custdata.datapattern.MAQuery.doExecute(MAQuery.java:583)
at com.sas.analytics.crm.task.ejb.Task.execute(Task.java:154)
at com.sas.analytics.crm.custdata.datapattern.DataPatternManager.uploadDataFromTable(DataPatternManager.java:1247)
at com.sas.analytics.crm.rest.taskgen.impl.DataPatternAccessorImpl.uploadDataFromTable(DataPatternAccessorImpl.java:317)
at com.sas.analytics.crm.agent.service.DirectMarketingSegmentService.processSegmentUpload(DirectMarketingSegmentService.java:133)
at com.sas.analytics.crm.agent.service.DirectMarketingSegmentService.process(DirectMarketingSegmentService.java:62)
at com.sas.analytics.crm.agent.impl.CI360MAAgent$5.run(CI360MAAgent.java:706)
at com.sas.analytics.crm.agent.impl.CI360MAAgent$TaskRunnable.run(CI360MAAgent.java:620)
at com.sas.analytics.crm.custdata.datapattern.MAQuery.doExecute(MAQuery.java:635)
at com.sas.analytics.crm.task.ejb.Task.execute(Task.java:154)
at com.sas.analytics.crm.task.ejb.Task.executeFromTaskManagement(Task.java:122)
at com.sas.analytics.crm.task.ejb.Task.run(Task.java:448)
at com.sas.analytics.crm.task.ejb.TaskSequence$WrappedTask.run(TaskSequence.java:1306)
at com.sas.analytics.crm.task.queue.JobRunner.run(JobRunner.java:32)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.sas.analytics.crm.task.queue.EvenDistributionJobQueue$JobAdvice.invoke(EvenDistributionJobQueue.java:380)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy157.run(Unknown Source)
at com.sas.analytics.crm.task.ejb.ThreadPoolPriorityExecutorImpl$QueueExecuteHandler.run(ThreadPoolPriorityExecutorImpl.java:121)
at com.sas.analytics.crm.task.ejb.ClearedThreadLocalRunnable.run(ClearedThreadLocalRunnable.java:17)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748) Caused by: com.sas.iom.SASIOMDefs.GenericError: No such name was found.
at com.sas.iom.SASIOMDefs.GenericErrorHelper.read(GenericErrorHelper.java:22)
at com.sas.iom.SASIOMDefs.GenericErrorHelper.extract(GenericErrorHelper.java:47)
at com.sas.iom.SAS._portable_stub_IWorkspace_1_1.CreateSTPContextFromWorkspace(_portable_stub_IWorkspace_1_1.java:43)
at com.sas.services.storedprocess.Execution2.extractConnectionAndGetStreams(Execution2.java:2426)
... 37 more yyyy-mm-dd hh:mm:ss,sss ERROR [CIExec-12] SID[af104d7aa983dbed:7c553b7f:1826aada752:-79b8] USER[ciprem] CC[] []
crm.custdata.storedprocess.StoredProcess - TID[segmentUpload-44b1100d-8e6f-4be0-b10c-8c0fc3507ddd]
[no SAS log available]
"OnPrem Direct - 2833fe5299b77f2b12eb3b14b0d71937" (eid: 3176) completed execution with the following exception(s):
yyyy-mm-dd hh:mm:ss,sss ERROR [CIExec-12] SID[] USER[] CC[] [] om.sas.services.storedprocess.Execution2 -
com.sas.services.storedprocess.SASServerException: A failure occurred accessing the execution server.
at com.sas.services.storedprocess.Execution2.extractConnectionAndGetStreams(Execution2.java:2536)
at com.sas.services.storedprocess.Execution2.executeStoredProcess(Execution2.java:2585)
at com.sas.services.storedprocess.Execution2.execute(Execution2.java:1370)
at com.sas.services.storedprocess.StoredProcess2.execute(StoredProcess2.java:1227)
at com.sas.analytics.crm.platformservices.storedprocess.ProcessRunner.doRun(ProcessRunner.java:151)
at com.sas.analytics.crm.platformservices.storedprocess.ProcessRunner.doRun(ProcessRunner.java:114)
at com.sas.analytics.crm.platformservices.storedprocess.ProcessRunner.run(ProcessRunner.java:86)
at com.sas.analytics.crm.custdata.storedprocess.StoredProcess.runStoredProcess(StoredProcess.java:198)
at com.sas.analytics.crm.custdata.storedprocess.StoredProcess.execute(StoredProcess.java:128)
at com.sas.analytics.crm.custdata.datapattern.MAQuery.doExecute(MAQuery.java:583)
at com.sas.analytics.crm.task.ejb.Task.execute(Task.java:154)
at com.sas.analytics.crm.custdata.datapattern.DataPatternManager.uploadDataFromTable(DataPatternManager.java:1247)
at com.sas.analytics.crm.rest.taskgen.impl.DataPatternAccessorImpl.uploadDataFromTable(DataPatternAccessorImpl.java:317)
at com.sas.analytics.crm.agent.service.DirectMarketingSegmentService.processSegmentUpload(DirectMarketingSegmentService.java:133)
at com.sas.analytics.crm.agent.service.DirectMarketingSegmentService.process(DirectMarketingSegmentService.java:62)
at com.sas.analytics.crm.agent.impl.CI360MAAgent$5.run(CI360MAAgent.java:706)
at com.sas.analytics.crm.agent.impl.CI360MAAgent$TaskRunnable.run(CI360MAAgent.java:620)
at com.sas.analytics.crm.custdata.datapattern.MAQuery.doExecute(MAQuery.java:635)
at com.sas.analytics.crm.task.ejb.Task.execute(Task.java:154)
at com.sas.analytics.crm.task.ejb.Task.executeFromTaskManagement(Task.java:122)
at com.sas.analytics.crm.task.ejb.Task.run(Task.java:448)
at com.sas.analytics.crm.task.ejb.TaskSequence$WrappedTask.run(TaskSequence.java:1306)
at com.sas.analytics.crm.task.queue.JobRunner.run(JobRunner.java:32)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.sas.analytics.crm.task.queue.EvenDistributionJobQueue$JobAdvice.invoke(EvenDistributionJobQueue.java:380)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy157.run(Unknown Source)
at com.sas.analytics.crm.task.ejb.ThreadPoolPriorityExecutorImpl$QueueExecuteHandler.run(ThreadPoolPriorityExecutorImpl.java:121)
at com.sas.analytics.crm.task.ejb.ClearedThreadLocalRunnable.run(ClearedThreadLocalRunnable.java:17)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748) Caused by: com.sas.iom.SASIOMDefs.GenericError: No such name was found.
at com.sas.iom.SASIOMDefs.GenericErrorHelper.read(GenericErrorHelper.java:22)
at com.sas.iom.SASIOMDefs.GenericErrorHelper.extract(GenericErrorHelper.java:47)
at com.sas.iom.SAS._portable_stub_IWorkspace_1_1.CreateSTPContextFromWorkspace(_portable_stub_IWorkspace_1_1.java:43)
at com.sas.services.storedprocess.Execution2.extractConnectionAndGetStreams(Execution2.java:2426)
... 37 more yyyy-mm-dd hh:mm:ss,sss ERROR [CIExec-12] SID[af104d7aa983dbed:7c553b7f:1826aada752:-79b8] USER[ciprem] CC[] []
crm.custdata.storedprocess.StoredProcess - TID[segmentUpload-44b1100d-8e6f-4be0-b10c-8c0fc3507ddd]
[no SAS log available]
There is no workaround for this issue.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Integration Technologies | Solaris for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 |
| Linux for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Ultimate x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Ultimate 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Professional x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Professional 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Home Premium x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Home Premium 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Enterprise x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Enterprise 32 bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2016 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2019 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Std | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 R2 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 10 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft® Windows® for x64 | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| z/OS | 9.4_M6 | 9.4_M8 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| SAS System | SAS Customer Intelligence 360 | N/A | ||||
A fix for this issue for Base SAS 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9R.html#69757A fix for this issue for Base SAS 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D9T.html#69757| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-02-01 13:29:20 |
| Date Created: | 2022-12-12 14:02:54 |