topic Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default? in Administration and Deployment

OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

miguelcalzada — Mon, 17 Feb 2020 15:43:27 GMT

Hello there,

After installing and configuring SAS 9.4 M6 in a RedHat 7.7 environment, users start to use the platform, but they weren't receiving any observations from their programming.

When we checked the options, we saw that OBS was set to 0, and REPLACE set to NOREPLACE.

However, other environments we installed with the same depot and plan, had those to the correct defaults (OBS=max and REPLACE).

We have fixed it with a workaround, adding the line "options obs=max REPLACE;" to $SASCONFIG/Lev1/SASApp/WorkspaceServer/autoexec_usermods.sas. However, I'd like to know how this default has been able to change only in this environment (past and posterior environments installed with the same depot and plan have everything right) and how to change it back to the default without having to add a new line to the configuration files.

Any idea?

Thank you in advanced.

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

AnandVyas — Mon, 17 Feb 2020 16:01:04 GMT

By any chance does the environment has different encoding set for SAS Foundation?

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

miguelcalzada — Mon, 17 Feb 2020 16:16:06 GMT

No, I'm afraid the environment has the same enconding as the rest of the environments built with the same depot and plan.

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

Ksharp — Tue, 18 Feb 2020 05:57:42 GMT

Change these option in config file SASV9.CFG

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

Kurt_Bremser — Tue, 18 Feb 2020 07:28:39 GMT

Study the logs in $SASCONFIG/Lev1/SASApp/WorkspaceServer/Logs, or (if you use Enterprise Guide) right-click on the server, select Properties - Software - View Initialization Log.

You may have something in a preceding autoexec file (SASApp/appserver_autoexec.sas, SASApp/appserver_autoexec_usermods.sas, SASApp/WorkspaceServer/autoexec.sas) that causes an ERROR.

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

miguelcalzada — Tue, 18 Feb 2020 08:54:44 GMT

Thank you both for your answers, however:

@Ksharp I've looked at every sasv9.cfg file in the server, and no one of them have the options OBS or REPLACE.

@Kurt_Bremser I don't have any file in that log folder. When I look at the inicialization log ni EGuide, I get what you can found as an attachment, not founding anything related to the OBS and REPLACE problem. I have also look at all the autoexec files on the server, and apart from the line I've added that I speak of on the initial post, there's nothing strange.

Thank you again. If you have any more ideas to solve it, would be great.

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

AnandVyas — Tue, 18 Feb 2020 08:58:51 GMT

Does the SAS tiers span across multiple servers? If yes, can you invoke SAS Foundation session from another server (Metadata server should be ok as well) in the same environment and see what are the default options for OBS and REPLACE?

This is just to verify if the same problem is across the servers in the environment.

You can launch SAS Session by running the following command from terminal - /sashome/SASFoundation/9.4/sas -nodms

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

Kurt_Bremser — Tue, 18 Feb 2020 09:16:11 GMT

As I suspected, you have an ERROR:

9          %macro checkfmt;
10         %if %UPCASE(%sysfunc(getoption(fmtsearch))) eq (WORK LIBRARY) %then
11         	OPTIONS FMTSEARCH=(WORK LIBRARY EGTASK SASUSER);
12         %mend checkfmt;
WARNING: Apparent symbolic reference ORIG_FMT_LIBRARIES not resolved.
WARNING: Apparent symbolic reference ORIG_FMT_LIBRARIES not resolved.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 
       %UPCASE(%sysfunc(getoption(fmtsearch))) eq (WORK LIBRARY) 
ERROR: The macro CHECKFMT will stop executing.

You seem to have added a macro variable in your original fmtsearch definition when the workspace server starts, either in the autoexec or in one of the configuration files, or maybe even on the command line.

Look for the usage of &ORIG_FMT_LIBRARIES somewhere in there.

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

miguelcalzada — Fri, 21 Feb 2020 08:55:05 GMT

Thank you everyone, we have finally find the problem.

The developers added an autoexec.sas made by them that was included in the default autoexec_usermod so they could have some variables for their scripting, and we have an ENVIRONMENT variable defined differently in all of the environments. However, only in this particular environment, we had an ENVIRONMENT variable with a hyphen (PRE-PRODUCTION). That resulted in the added autoexec not recognizing it properly, which in turn modified the default OBS and REPLACE options (Don't know why, it just did).

We modified that new autoexec to recognize the hyphen in the ENVIRONMENT variable, and removed the line I added (explained at the start of the post), and the default options come as expected again without modifying them.

Thank you all for your answers and help, and I hope this post helps to anyone with the same problem (not probable, but who knows ).

Thank you!!

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

Kurt_Bremser — Mon, 24 Feb 2020 09:47:17 GMT

An ERROR will cause SAS to set these options, to prevent further damage to data.

Re: OBS option set to 0 and REPLACE to NOREPLACE by default. Reset to correct default?

miguelcalzada — Mon, 24 Feb 2020 16:55:41 GMT

That actually makes sense.

Thank you very much!