topic Re: Unable to open parameter catalog in update mode in SAS Enterprise Guide

Unable to open parameter catalog in update mode

SAS_Doctor — Fri, 05 Nov 2010 15:59:26 GMT

I get this note when I run a program in EG that uses a dymaic parameter:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.

The parameter is called "Parent" and it uses a sas file to dynamically populate the parameter values that has a list of several names.

Here's the whole log:

1 The SAS System 09:43 Friday, November 5, 2010

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Export_by_Parent';
4 %LET _CLIENTPROJECTPATH='\\fl-sas03\SSC\SAS Source
4 ! Code\SSC_Op_Analysis_Dev\Lost_LIS\2010\Lost_LIS_2010.egp';
5 %LET _CLIENTPROJECTNAME='Lost_LIS_2010.egp';
6 %LET _SASPROGRAMFILE=;
7 %LET Parent = Arcadian;
8
9 ODS _ALL_ CLOSE;
10 OPTIONS DEV=ACTIVEX;
NOTE: Procedures may not support all options or statements for all devices. For details, see
the documentation for each procedure.
11 GOPTIONS XPIXELS=0 YPIXELS=0;
12 FILENAME EGSR TEMP;
13 ODS tagsets.sasreport12(ID=EGSR) FILE=EGSR STYLE=sasweb
13 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/SharedFiles/BIClientStyles/4.2/sasweb
13 ! .css") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");
NOTE: Writing TAGSETS.SASREPORT12(EGSR) Body file: EGSR
14
15 GOPTIONS ACCESSIBLE;
16 %global Parent Path Rpt_Year Run_Dt;
17
18 %Let Path=\\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011;
19 *\\fl-sas03\CMSDATA\csv files;
20 *\\fl-sas03\SSC\OperationsAnalysis;
21 *\\nas-fl\Shared_Files\SSC_Operations_Analysis\Lost_LIS_Detail_Rpts;
22
23
24 %Put _GLOBAL_;
GLOBAL SQLOBS 0
GLOBAL RPT_YR 10
GLOBAL SQLOOPS 10
GLOBAL _CLIENTAPP 'SAS Enterprise Guide'
GLOBAL _CLIENTPROJECTPATH '\\fl-sas03\SSC\SAS Source
Code\SSC_Op_Analysis_Dev\Lost_LIS\2010\Lost_LIS_2010.egp'
GLOBAL _CLIENTPROJECTNAME 'Lost_LIS_2010.egp'
GLOBAL PATH \\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011
GLOBAL RUN_DT 20101105T094330
GLOBAL SYS_SQL_IP_ALL 1
GLOBAL SYS_SQL_IP_STMT select distinct a."HNUM" from MMS.LOST_LIS_TRR a where (
a."TRR_FILE_LOAD" in ('201009', '201012') ) and ( a."HNUM" in ('S5741', 'S5966') ) order by
a."HNUM" asc NULLS FIRST
GLOBAL _CLIENTUSERID 'jbaillie'
GLOBAL _CLIENTUSERNAME 'James Baillie'
GLOBAL _SASSERVERNAME 'SASMain'
GLOBAL _CLIENTTASKLABEL 'Export_by_Parent'
GLOBAL _SASHOSTNAME 'FL-SAS03.sscincorporated.com'
GLOBAL _CLIENTVERSION '4.22.0.10173'
GLOBAL SQLXRC 0
GLOBAL SQLXMSG
GLOBAL SQLXOBS 0
GLOBAL SQLRC 0
2 The SAS System 09:43 Friday, November 5, 2010

GLOBAL PARENT Arcadian
GLOBAL SASWORKLOCATION "F:\SAS Temporary Files\_TD1504\Prc2/"
GLOBAL SQLEXITCODE 0
GLOBAL RPT_YEAR 2010
GLOBAL _SASSPLEVEL None
GLOBAL _CLIENTMACHINE 'FL-W990NZL1'
GLOBAL _SASPROGRAMFILE
25
26 Data _NULL_;
27 Run_Dt=compress(put(DateTime(),IS8601DT.),'-:');
28 call symput('Run_Dt',trim(Run_Dt));
29 run;

NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

30 %put NOTE: Runt_Dt ===>&Run_Dt.<===;
NOTE: Runt_Dt ===>20101105T113909<===
31
32 libname mmsdmart meta library="mmsdmart";
NOTE: Libref MMSDMART was successfully assigned as follows:
Engine: META
Physical Name: D:\MMSDMART
33
34 proc export
35 data=mmsdmart.LostLIS&Rpt_Year._DETAIL (where=(parentname="&Parent"))
36 outfile="&Path.\&Parent._LOSTLIS_DETAIL_&Run_Dt..tab"
37 dbms=TAB
38 ;
39 run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary
parameter values will be saved to WORK.PARMS.PARMS.SLIST.
40 /**********************************************************************
41 * PRODUCT: SAS
42 * VERSION: 9.2
43 * CREATOR: External File Interface
44 * DATE: 05NOV10
45 * DESC: Generated SAS Datastep Code
46 * TEMPLATE SOURCE: (None Specified.)
47 ***********************************************************************/
48 data _null_;
49 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
50 %let _EFIREC_ = 0; /* clear export record count macro variable */
51 file '\\nas-fl\IT\Data
51 ! Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101105T113909.tab
51 ! ' delimiter='09'x DSD DROPOVER lrecl=32767;
52 if _n_ = 1 then /* write column names or labels */
53 do;
54 put
55 "PLANNUMBER"
3 The SAS System 09:43 Friday, November 5, 2010

56 '09'x
57 "PLANNAME"
58 '09'x
59 "PARENTNAME"
60 '09'x
61 "ENTITYID"
62 '09'x
63 "HICN"
64 '09'x
65 "HICNUMBER"
66 '09'x
67 "MEMBERID"
68 '09'x
69 "MEMBERLASTNAME"
70 '09'x
71 "MEMBERFIRSTNAME"
72 '09'x
73 "LOSTLISMEMBERTYPE"
74 '09'x
75 "ACTIVESTATUS"
76 '09'x
77 "OUTREACHDATE"
78 '09'x
79 "AUTOCALLATTEMPT"
80 '09'x
81 "AUTOCALLDATE"
82 '09'x
83 "MAILFLAG"
84 '09'x
85 "MAILDATE"
86 '09'x
87 "BRCRETURNFLAG"
88 '09'x
89 "BRCRETURNDATE"
90 '09'x
91 "OUTBOUNDCALLATTEMPT"
92 '09'x
93 "LASTQUEUEPULLDATE"
94 '09'x
95 "LISAPPROVAL"
96 '09'x
97 "LOSTLISCASESTATUS"
98 '09'x
99 "LOSTLISOUTCOMERESULT"
100 '09'x
101 "LOSTLISTCASESTATUSDATE"
102 '09'x
103 "REENTRY_NUMBER"
104 '09'x
105 "MSPMEMBERTYPE"
106 '09'x
107 "MSPCASECYCLE"
108 '09'x
4 The SAS System 09:43 Friday, November 5, 2010

109 "CURRENTMSPSTATUS"
110 '09'x
111 "MSPCREATEDATE"
112 '09'x
113 "PreviouslyRPT"
114 '09'x
115 "PLAN_MEMBERID"
116 '09'x
117 "PBP_ID"
118 '09'x
119 "PLANINFO"
120 '09'x
121 "OUTREACHCYCLE"
122 ;
123 end;
124 set MMSDMART.LOSTLIS2010_DETAIL(where=(parentname="Arcadian")) end=EFIEOD;
125 format PLANNUMBER $5. ;
126 format PLANNAME $52. ;
127 format PARENTNAME $30. ;
128 format ENTITYID best12. ;
129 format HICN $12. ;
130 format HICNUMBER $12. ;
131 format MEMBERID $15. ;
132 format MEMBERLASTNAME $30. ;
133 format MEMBERFIRSTNAME $30. ;
134 format LOSTLISMEMBERTYPE $28. ;
135 format ACTIVESTATUS $1. ;
136 format OUTREACHDATE dtdate9. ;
137 format AUTOCALLATTEMPT $1. ;
138 format AUTOCALLDATE dtdate9. ;
139 format MAILFLAG $2. ;
140 format MAILDATE dtdate9. ;
141 format BRCRETURNFLAG $2. ;
142 format BRCRETURNDATE dtdate9. ;
143 format OUTBOUNDCALLATTEMPT $1. ;
144 format LASTQUEUEPULLDATE dtdate9. ;
145 format LISAPPROVAL best12. ;
146 format LOSTLISCASESTATUS $25. ;
147 format LOSTLISOUTCOMERESULT $23. ;
148 format LOSTLISTCASESTATUSDATE dtdate9. ;
149 format REENTRY_NUMBER $30. ;
150 format MSPMEMBERTYPE $34. ;
151 format MSPCASECYCLE 4. ;
152 format CURRENTMSPSTATUS $char38. ;
153 format MSPCREATEDATE dtdate9. ;
154 format PreviouslyRPT best12. ;
155 format PLAN_MEMBERID $15. ;
156 format PBP_ID $3. ;
157 format PLANINFO $93. ;
158 format OUTREACHCYCLE $19. ;
159 do;
160 EFIOUT + 1;
161 put PLANNUMBER $ @;
5 The SAS System 09:43 Friday, November 5, 2010

162 put PLANNAME $ @;
163 put PARENTNAME $ @;
164 put ENTITYID @;
165 put HICN $ @;
166 put HICNUMBER $ @;
167 put MEMBERID $ @;
168 put MEMBERLASTNAME $ @;
169 put MEMBERFIRSTNAME $ @;
170 put LOSTLISMEMBERTYPE $ @;
171 put ACTIVESTATUS $ @;
172 put OUTREACHDATE @;
173 put AUTOCALLATTEMPT $ @;
174 put AUTOCALLDATE @;
175 put MAILFLAG $ @;
176 put MAILDATE @;
177 put BRCRETURNFLAG $ @;
178 put BRCRETURNDATE @;
179 put OUTBOUNDCALLATTEMPT $ @;
180 put LASTQUEUEPULLDATE @;
181 put LISAPPROVAL @;
182 put LOSTLISCASESTATUS $ @;
183 put LOSTLISOUTCOMERESULT $ @;
184 put LOSTLISTCASESTATUSDATE @;
185 put REENTRY_NUMBER $ @;
186 put MSPMEMBERTYPE $ @;
187 put MSPCASECYCLE @;
188 put CURRENTMSPSTATUS $ @;
189 put MSPCREATEDATE @;
190 put PreviouslyRPT @;
191 put PLAN_MEMBERID $ @;
192 put PBP_ID $ @;
193 put PLANINFO $ @;
194 put OUTREACHCYCLE $ ;
195 ;
196 end;
197 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro
197 ! variable */
198 if EFIEOD then call symputx('_EFIREC_',EFIOUT);
199 run;

NOTE: The file '\\nas-fl\IT\Data
Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101105T113909.tab' is:

Filename=\\nas-fl\IT\Data
Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101105T113909.tab,
RECFM=V,LRECL=32767,File Size (bytes)=0,
Last Modified=05Nov2010:11:39:09,
Create Time=05Nov2010:11:39:09

NOTE: 993 records were written to the file '\\nas-fl\IT\Data
Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101105T113909.tab'.
The minimum record length was 252.
The maximum record length was 456.
6 The SAS System 09:43 Friday, November 5, 2010

NOTE: There were 992 observations read from the data set MMSDMART.LOSTLIS2010_DETAIL.
WHERE parentname='Arcadian';
NOTE: DATA statement used (Total process time):
real time 1.23 seconds
cpu time 0.03 seconds

992 records created in \\nas-fl\IT\Data
Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101105T113909.tab from
MMSDMART.LOSTLIS2010_DETAIL.

NOTE: "\\nas-fl\IT\Data
Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101105T113909.tab"
file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 1.40 seconds
cpu time 0.09 seconds

200 quit;
201
202 GOPTIONS NOACCESSIBLE;
203 %LET _CLIENTTASKLABEL=;
204 %LET _CLIENTPROJECTPATH=;
205 %LET _CLIENTPROJECTNAME=;
206 %LET _SASPROGRAMFILE=;
207
208 ;*';*";*/;quit;run;
209 ODS _ALL_ CLOSE;
210
211
212 QUIT; RUN;
213

Re: Unable to open parameter catalog in update mode

ChrisHemedinger — Sun, 07 Nov 2010 22:21:25 GMT

(Looks like the log is clipped here due to formatting...but that's okay.)

In a default BI environment, SASUSER is read-only (-RSASUSER option). I'm not sure which part of the program here is accessing the SLIST, but if it defaults to SASUSER and it's trying to update it, that's the cause of the NOTE.

Chris

Re: Unable to open parameter catalog in update mode

SAS_Doctor — Mon, 08 Nov 2010 22:56:57 GMT

Chris;

Thanks for looking at this. I am now getting an "ERROR: Undetermined I/O failure". I tried putting this same code into a program, so I could test my code. I definately have write access to this drive. And the "Program" version works were the "Stored Process" does not. So I put the Stored Process in a different project and that did not have any affect.

Here's the log:

1 The SAS System 17:40 Monday, November 8, 2010

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
Licensed to SOCIAL SERVICES COORDINATORS/MAINLINE INFO, Site 70067395.
NOTE: This session is executing on the X64_SRV08 platform.

NOTE: SAS Initialization used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: The autoexec file, C:\SAS\SASEBI\Lev1\SASMain\StoredProcessServer\autoexec.sas, was executed at server initialization. No server log was specified. Add the log option to the server startup command to see details of the autoexec execution (refer to
"Specifying Logging Options" under "Server Startup Command" in the Server Administrator's Guide).

>>> SAS Macro Variables:

PARENT=Arcadian
RPT_YEAR=2010
SYSDBMSG=
SYSDBRC=0
_APSLIST=RPT_YEAR,PARENT,_RESULT,_ODSSTYLE,_ENCODING,_CLIENTNAME,_ODSDEST,_ODSSTYLESHEET,_GOPT_DEVICE,_METAPERSON,_ODSOPTIONS,_METAFOLDER,_METAUSER,_PROGRAM,_CLIENT,_USERNAME,_SECUREUSERNAME
_CLIENT=SAS Enterprise Guide; CLR 2.0.50727.3615; Microsoft Windows NT 5.1.2600 Service Pack 3
_CLIENTNAME=SAS Enterprise Guide
_ENCODING=utf-8
_GOPT_DEVICE=ACTIVEX
_METAFOLDER=/SSC Analytics/Lost_LIS/
_METAPERSON=James Baillie
_METAUSER=jbaillie@SSC
_ODSDEST=HTML
_ODSOPTIONS=ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v92/sasgraph.exe#version=9,2")
_ODSSTYLE=sasweb
_ODSSTYLESHEET=(URL="file:///C:/Program%20Files/SAS/SharedFiles/BIClientStyles/4.2/sasweb.css")
_PROGRAM=/SSC Analytics/Lost_LIS/Export_Lost_LIS_Detail_sp
_REPLAY="&_URL?_sessionid=4F6978CD-9395-48FC-89FA-654678FF6D58&_program=replay&_entry=&_TMPCAT.."
_RESULT=STREAM
_SECUREUSERNAME=jbaillie
_TMPCAT=APSWORK.TCAT003A
_USERNAME=jbaillie

1 options nosource source2 center notes nodate nonumber ls=195 formchar='|----|+|---+=|-/\<>*' pagesize=40 noovp nomprint nomlogic nosymbolgen; title; footnote;
The SAS System

NOTE: %INCLUDE (level 1) file D:\SSC\SAS Source Code\SSC_Op_Analysis_Dev\Export_Lost_LIS_Detail_sp.sas is file D:\SSC\SAS Source Code\SSC_Op_Analysis_Dev\Export_Lost_LIS_Detail_sp.sas.
3 +* Begin EG generated code (do not edit this line);
4 +*
5 +* Stored process registered by
6 +* Enterprise Guide Stored Process Manager V4.2
7 +*
8 +* ====================================================================
9 +* Stored process name: Export_Lost_LIS_Detail_sp
10 +*
11 +* Keywords: Lost LIS, Export
12 +* ====================================================================
13 +*
14 +* Stored process prompt dictionary:
15 +* ____________________________________
16 +* PARENT
17 +* Type: Text
18 +* Label: Parent
19 +* Attr: Visible
20 +* ____________________________________
21 +* RPT_YEAR
22 +* Type: Numeric
23 +* Label: Rpt_Year
24 +* Attr: Visible, Required
25 +* Default: 2010
26 +* ____________________________________
27 +*;
28 +
29 +
30 +*ProcessBody;
31 +
32 +%global PARENT
33 + RPT_YEAR;
34 +
35 +OPTIONS VALIDVARNAME=ANY;
36 +* End EG generated code (do not edit this line);
37 +
38 +%STPBEGIN;
39 +
The SAS System

40 +%global Parent Path Rpt_Year Run_Dt;
41 +
42 +
43 +Data _NULL_;
44 + Run_Dt=compress(put(DateTime(),IS8601DT.),'-:');
45 + call symput('Run_Dt',trim(Run_Dt));
46 +run;

NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

47 +%put NOTE: Runt_Dt ===>&Run_Dt.<===;
NOTE: Runt_Dt ===>20101108T174033<===
48 +
49 +libname mmsdmart meta library="mmsdmart";
NOTE: Libref MMSDMART was successfully assigned as follows:
Engine: META
Physical Name: D:\MMSDMART
50 +
51 +%Let Path=\\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011;
52 +
53 +proc export
54 + data=mmsdmart.LostLIS&Rpt_Year._DETAIL (where=(parentname="&Parent"))
55 + outfile="&Path.\&Parent._LOSTLIS_DETAIL_&Run_Dt..tab"
56 + dbms=TAB
57 +;
58 +run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.

ERROR: Undetermined I/O failure.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set MMSDMART.LOSTLIS2010_DETAIL.
WHERE parentname='Arcadian';
NOTE: DATA statement used (Total process time):
real time 0.24 seconds
The SAS System

cpu time 0.01 seconds

0 records created in \\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101108T174033.tab from MMSDMART.LOSTLIS2010_DETAIL.

NOTE: "\\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101108T174033.tab" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.72 seconds
cpu time 0.07 seconds

219 +quit;
220 +
221 +%STPEND;
222 +
223 +* Begin EG generated code (do not edit this line);
224 +;*';*";*/;quit;
225 +
226 +* End EG generated code (do not edit this line);
NOTE: %INCLUDE (level 1) ending.

Re: Unable to open parameter catalog in update mode

ChrisHemedinger — Wed, 10 Nov 2010 21:17:52 GMT

The stored process server runs under a different account, and so might not have access to all of the paths that your personal user account has.

You should probably work with SAS Technical Support on this one to diagnose. They might recommend a smaller SAS program that attempts to write to the area your program writes to, and using that in a stored process to see if it can work.

Chris

Re: Unable to open parameter catalog in update mode

learning_sas — Tue, 26 Nov 2013 05:01:25 GMT

Chris Sir,

I am a student from India.... I am very new to SAS....

i) Kindly help me to create SAS Permanent Library in my Desktop..... I am using SAS EG Student version....

ii) Also I need one more help..... How to access the Permanent Dataset (which is stored in my Desktop) for writing Program....

Thank You.

Sankha DB

Re: Unable to open parameter catalog in update mode

ChrisHemedinger — Tue, 26 Nov 2013 12:46:32 GMT

Sankha,

Are you using the SAS OnDemand for Academics version? If so, most of your questions should be answered in these resources.

If you are using the commercial version of SAS Enterprise Guide, you can use the Tasks->Data->Download SAS Data Sets task (and the Upload task) to copy data sets from the SAS session to the local PC and back again.

If you're just getting started with SAS, you might want to watch this free SAS Talks webinar.

Chris