SAS Miner won't run anything: exception.server.nompconnect

BenDSW — Mon, 25 Aug 2014 08:55:36 GMT

Dear SAS folks,

I am trying to get accustomed to the SAS Miner (12.1) program and followed the instructions of the 'Getting started'-tutorial, which uses the 'Donor_raw_data' file. I managed to get to the point of running the StatExplore node, which leads to a note 'Running...' showing up in the bottom indefinitely, no error messages, no results ("Node execution was stopped on request.") and a log that is not very informative.

The log only reports the following interesting part:

-----

filename _wipxml '***\Lev1\***\Prc2\DiagramGetReportMetadata.xml' encoding="UTF-8" NOBOM;

WARNING: End of file.

%let SYSCC=0;

%let SYSRC=0;

%let EMEXCEPTIONSTRING=;

%let SYSMSG=;

%em_diagram(action=getreportsmeta, projpath=%nrstr(***\Lev1\SASTest\testit), projname=%nrstr(testit), dgmId=EMWS3, nodeid=Stat, outfile=DiagramGetReportMetadata.xml);

NOTE: Fileref _DGMFRF has been deassigned.

WIP_ACTION: GETREPORTSMETA

DGMID: EMWS3

LOCKFILE: ***\Lev1\SASTest\testit\testit\Workspaces\EMWS3\System\wsopen.lck

data _null_;

set EMWS3.EM_NODEID;

where upcase(NODEID)=upcase("Stat");

call symput('_EMCLASS', CLASS);

run;

NOTE: There were 1 observations read from the data set EMWS3.EM_NODEID.

WHERE UPCASE(NODEID)='STAT';

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

filename _wipxml '***\Lev1\***\Prc2\DiagramGetReportMetadata.xml' encoding="UTF-8" NOBOM;

-----

And in the DiagramGetReportMetadata.xml file I find the following:

-----

<?xml version="1.0" encoding="UTF-8" ?><_ROOT_ EMVERSION="12.1" >

<LAYOUT ORIENTATION="HORIZONTAL" NOTES="***\Lev1\SASTest\testit\testit\Workspaces\EMWS3\EMNOTES.txt"

<NODE CLASS="SASHELP.EMSAMP.IDS.CLASS" COMPONENT="DataSource" ID="Ids" X="324" Y="260"

DESCRIPTION="DONOR_RAW_DATA" DIAGRAMID="_ROOT_" PARENTID="">

<PROPERTIES DataSource="donorrawdata" Scope="LOCAL" Role="RAW" Library="***" Table="DONOR_RAW_DATA"

NCols="50" NObs="19372" NBytes="." Segment="" DataSourceRole="RAW" OutputType="VIEW"

ForceRun="N" ComputeStatistics="N" DataSelection="DATASOURCE" NewTable="" MetaAdvisor="BASIC"

ApplyIntervalLevelLowerLimit="Y" IntervalLowerLimit="20" ApplyMaxPercentMissing="Y"

MaxPercentMissing="50" ApplyMaxClassLevels="Y" MaxClassLevels="20" IdentifyEmptyColumns="Y"

VariableValidation="STRICT" NewVariableRole="REJECT" DropMapVariables="Y" DsId="donorrawdata"

DsSampleName="" DsSampleSizeType="" DsSampleSize="" DsCreatedBy="***" DsCreateDate="***"

DsModifiedBy="***" DsModifyDate="***" DsScope="LOCAL" Sample="D" SampleSizeType="PERCENT"

SampleSizePercent="20" SampleSizeObs="10000" DBPassThrough="Y" RunAction="Train"

Component="DataSource" RawCreateTime="***" CreateTime="***"

Description="" Data="***.DONOR_RAW_DATA" CMeta="***" LastRunMessage="exception.server.NOMPCONNECT"

Run="Y" LastRunStatus="FAIL" NeedRun="Y" NeedUpdate="N" ComputeHost="" NotesFile="***\Lev1\SASTest\testit\testit\Workspaces\EMWS3\Ids\EMNOTES.txt"

</PROPERTIES>

</Port>

</ImportPorts>

</Port>

</ExportPorts>

</NODE>

<NODE CLASS="SASHELP.EMEXPL.STATEXPLORE.CLASS" COMPONENT="StatExplore" ID="Stat" X="566"

Y="263" DESCRIPTION="StatExplore" DIAGRAMID="_ROOT_" PARENTID="">

<PROPERTIES BySegment="N" Correlation="Y" Spearman="N" Pearson="Y" ChiSquare="Y" ChiSquareInterval="Y"

ChiSquareIntervalNBins="5" MaximumVars="1000" HideVariable="Y" DropRejected="Y" UseValidate="N"

UseTest="N" UseScore="N" NObs="100000" IntervalDistribution="Y" ClassDistribution="Y"

LevelSummary="Y" ForceRun="N" RunAction="Train" Component="StatExplore" RawCreateTime="***"

CreateTime="***" LastRunMessage="" Run="Y" LastRunStatus="KILL" NeedRun="Y"

NeedUpdate="N" ComputeHost="" NotesFile="***\Lev1\SASTest\testit\testit\Workspaces\EMWS3\Stat\EMNOTES.txt"

<FileProperties ><![CDATA[

CROSSTAB

]]>

</FileProperties></PROPERTIES>

</Port>

</Port>

</Port>

</Port>

</ImportPorts>

</Port>

</Port>

</Port>

</Port>

</ExportPorts>

</NODE>

</NODES>

</CONNECTIONS>

<RUNSTATUS LASTSTATUS="FAILED" STATUS="COMPLETED" FAILEDERROR="exception.server.NOMPCONNECT"

FAILEDNODE="Ids" LAST_ALIVE="0">

</FAILED>

</CANCELLED>

</RUNSTATUS>

</LAYOUT>

</_ROOT_>

-----

The *** in the above lines replaces confidential info.

As far as I can guess.. the exception nompconnect, means that there is no multi-process connection. Another possibility is that the java version is not compatible (as far as I can tell from issues reported by others). Hopefully, someone could point out whether the configuration is incorrect and how this issue can be solved.

Thanks in advance,

Ben

Re: SAS Miner won't run anything: exception.server.nompconnect

jakarman — Mon, 25 Aug 2014 09:22:44 GMT

There is something to be checked/verified. The MPconnect error I have seen before with Eminer.

Some nodes of Eminer are able to use the MPconnect facility as described with SAS/Connect SAS/CONNECT(R) 9.3 User's Guide

It starts an other sas session on the same machine using the signon command. Mpconnect using that way only makes sense with asynchronous processing that is set by the sas system option noconnectwait.
The maximum number of parallel sessions can be set at the SAS metadatalevel where a dedicated Enterpriser miner items are created at the moment of a start of the rmi interface (using the configured unrestricted sasadmin with psw).

Do you wan to use EGuide and Mpconnect it is logical to set the system option default tot noconnectwait. You can try the functionality MPconnect manual with some code.
When this works with sas basic coding (In my case it did) than the question is why it would not wit Eminer,

During opening of a Eminer project al lot of code is activated by including that from some locations. The code for using mp-connect is hidden there somewhere.
It uses a signon statement for mp-connect but is/was expecting a synchronous mode setting. When this is not the case all checks will fail resulting in a mpconnect error message.
If this is the same in your case, you can reset this by adding a option connectwait in your eminer startupcode.

Re: SAS Miner won't run anything: exception.server.nompconnect

BenDSW — Fri, 05 Sep 2014 08:26:42 GMT

Fortunately, I came into contacts with some experts that managed to address the problem. I am not quite sure about the details of the solution, but I believe it came down to a workaround that involved increasing the number of threads available for SAS Miner.

Re: SAS Miner won't run anything: exception.server.nompconnect

jakarman — Fri, 05 Sep 2014 08:58:55 GMT

Ben,

That setting is found back using the SMC as part of the EM solution. A real platform admin is knowing that.

When the RMI-server is started it will logon to the sasmetadata (unrestricted admin) and set some special attribute for EMiner fo each WS server process.
Some settings are:

- The standard root location of your physical path of a EM-project.
- The path location in the SAS metadata where things are getting registered.
- The number of maximum nodes of parallel processing (MP-connect) allowed for each WS server.

As you are possible seen as some kind of jerk by IT people they are putting a lot of limitations on you.
No shell or ftp, no parallel processing etc. You probably find someone opening up some limitations.

I would think on a advice having a good collaboration and some communication with a technical SAS guru as being standard in your organization.

http://blogs.sas.com/content/corneroffice/2014/06/25/4-tips-for-modern-cios/

topic Re: SAS Miner won't run anything: exception.server.nompconnect in SAS Data Science

SAS Miner won't run anything: exception.server.nompconnect

Re: SAS Miner won't run anything: exception.server.nompconnect

Re: SAS Miner won't run anything: exception.server.nompconnect

Re: SAS Miner won't run anything: exception.server.nompconnect