SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 69757: Stored processes intermittently fail to execute in SAS® Pooled Workspace servers and might return the "No such name was found..." error

DetailsHotfixAboutRate It

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]

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Integration TechnologiesSolaris for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Linux for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
HP-UX IPF9.4_M69.4_M89.4 TS1M69.4 TS1M8
64-bit Enabled Solaris9.4_M69.4_M89.4 TS1M69.4 TS1M8
64-bit Enabled AIX9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Ultimate x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Ultimate 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Professional x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Professional 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Home Premium x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Home Premium 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Enterprise 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 20169.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 20199.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 Std9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 R2 Std9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 R2 Datacenter9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 Datacenter9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2008 for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2008 R29.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 20089.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 109.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Pro x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Pro 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Enterprise 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Pro x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Pro 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Enterprise 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft® Windows® for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
z/OS9.4_M69.4_M89.4 TS1M69.4 TS1M8
SAS SystemSAS Customer Intelligence 360N/A
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.