topic Re: %FSLOGIN error in Administration and Deployment

%FSLOGIN error

sathya66 — Mon, 14 Sep 2020 19:15:17 GMT

All,

i am getting below erro, when I try to run FSLOGIN macro. see below

28 %FSLOGIN(USER=test, PASSWORD=XXXX,
29 SASENVIRONMENT=default);

NOTE: The data set WORK.FSKEYDAT has 1 observations and 3 variables.
NOTE: Compressing data set WORK.FSKEYDAT increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

NOTE: There were 1 observations read from the data set WORK.FSKEYDAT.
NOTE: The data set WORK.FSKEYDAT has 1 observations and 3 variables.
NOTE: Compressing data set WORK.FSKEYDAT increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: Assuming default middle-tier name based on login type: fsmain

NOTE: Could not load classloader fsmain. Using default classloader.
NOTE: Could not initialize classpath. Classpath variable is not set.
ERROR: Could not initialize classpath from picklist file.
NOTE: The DATA step has been abnormally terminated.
java.io.FileNotFoundException: /opt/sas/home/SASVersionedJarRepository/picklist/forecastbat/forecastbat.txt (Permission denied)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
2 The SAS System Monday, September 14, 2020 08:07:00 PM

at java.io.FileInputStream.<init>(FileInputStream.java:138)
at java.io.FileReader.<init>(FileReader.java:72)
NOTE: DATA statement used (Total process time):
real time 1.00 seconds
cpu time 0.00 seconds

Re: %FSLOGIN error

dpage — Mon, 14 Sep 2020 19:19:29 GMT

/opt/sas/home/SASVersionedJarRepository/picklist/forecastbat/forecastbat.txt (Permission denied)

Seems like the root cause - can you confirm the user executing the code (so your user, or the spawner identity for stored process / pooled workspace server) can see the contents of that file?

Re: %FSLOGIN error

sathya66 — Mon, 14 Sep 2020 19:58:47 GMT

Now I am getting diffrent ERROR

NOTE: Assuming default middle-tier name based on login type: fsmain

NOTE: Could not load classloader fsmain. Using default classloader.
NOTE: Could not initialize classpath. Classpath variable is not set.
ERROR: Exception caught in FSLOGIN.
ERROR: NO_ENVIRONMENTS
com.sas.analytics.forecasting.client.api.exceptions.ForecastingException: NO_ENVIRONMENTS
at
com.sas.analytics.forecasting.client.api.ForecastingSessionFactory.createForecastingSession(ForecastingSessionFactory.java:156)
2 The SAS System Monday, September 14, 2020 08:56:00 PM

at com.sas.analytics.forecasting.bridge.macros.ForecastStudioBridge.login(ForecastStudioBridge.java:3799)
Caused by: java.lang.IllegalStateException: NO_ENVIRONMENTS
... 2 more
NOTE: DATA statement used (Total process time):
real time 2.77 seconds
cpu time 0.00 seconds

Re: %FSLOGIN error

dpage — Mon, 14 Sep 2020 20:09:23 GMT

sounds like no sas-environment.xml was specified during the deployment.

https://go.documentation.sas.com/?cdcId=fscdc&cdcVersion=15.1&docsetId=fsag&docsetTarget=n0gizfk7ahih67n1ote6x4w6ontu.htm&locale=en

you can specify it after the fact in the sassw.config

https://go.documentation.sas.com/?docsetId=bimtag&docsetTarget=n0s325xuzaji9tn16zvgq128dvb5.htm&docsetVersion=9.4&locale=en

Re: %FSLOGIN error

sathya66 — Mon, 14 Sep 2020 20:38:40 GMT

Thanks,
I set it properly, when I tested that URL http://server-name:port/sas/sas-environment.xml
I can access that link too.
sassw.config in compute is also pointing to mid but no luck same error

Re: %FSLOGIN error

JuanS_OCS — Tue, 15 Sep 2020 10:42:26 GMT

Hello @sathya66 , @dpage ,

you folks probably won't need this as I see a lot progress here thanks to @dpage

The last error was queried in the communities in the past, it was resolved by SAS Tech Support, it seems a configuration issue indeed: https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/com-sas-analytics-forecasting-client-api-exceptions/td-p/474333

I would personally give a chance to this troubleshooting guide, at least in order to retrieve more information.

https://support.sas.com/kb/62/516.html

Is the Forecast Studio Client (web and desktop) working OK?

Edit/Update: did you notice this?

NOTE: Assuming default middle-tier name based on login type: fsmain

NOTE: Could not load classloader fsmain.

This made me thing about a couple of things I remember from the past.

1. https://documentation.sas.com/?docsetId=fsdskag&docsetTarget=fslogin.htm&docsetVersion=15.1&locale=en

Have you tried to override a custom value for the option MIDTIER=label ?

2. https://support.sas.com/kb/20/435.html

This is an note for another solution, not forecast, but it would be interesting to learn why cannot find the class fsmain or its loader. I wonder if you can re-apply this for fsmain. You might need to find first the location of this jar.

Re: %FSLOGIN error

sathya66 — Tue, 15 Sep 2020 11:44:56 GMT

thanks,
Yes, forecast studio Client (desktop) is working fine except FSLOGIN macro from SAS EG or from DI

Re: %FSLOGIN error

sathya66 — Tue, 15 Sep 2020 12:27:02 GMT

And
above macro was working fine before without any issues. It is happening only after applying latest sas security update on mid tier
https://tshf.sas.com/techsup/download/hotfix/HF2/SAS_Security_Updates.html
"SAS Security Update 2019-11 sas-security-update-2019-11-M6.zip"

Re: %FSLOGIN error

JuanS_OCS — Tue, 15 Sep 2020 12:39:06 GMT

Well, that is very relevant information, it would have been nice if reported in the beginning. But, as they say, better late than never! 😉

Did you have the chance to read and go through the instructions? https://tshf.sas.com/techsup/download/hotfix/HF2/security/sas-security-update-2020-08-M7/security-update-2020-08.pdf

It mentions a couple of things: install hotfixes, in order, once finished, rebuild and redeploy web applications, attention to horizontal and vertical clusters, etc.

In addition, and only in the case you actually did all of above, I wonder if some permissions are not in place or certificates (specially if you have SSL). But from the error it seems to me as the rebuild and redeploy is missing.

Re: %FSLOGIN error

sathya66 — Tue, 15 Sep 2020 14:19:53 GMT

Yes, I rebuilt and redeployed all the web apps. Everything is working fine except this FSLOGIN

Re: %FSLOGIN error

dpage — Tue, 15 Sep 2020 14:25:52 GMT

We've hit all the obvious things I think there are to check - a tech support track is the best next step.

Re: %FSLOGIN error

sathya66 — Wed, 16 Sep 2020 09:27:29 GMT

Thanks for this,
We have raised with SAS Tech.Keep you posted

Re: %FSLOGIN error

sathya66 — Wed, 16 Sep 2020 09:25:40 GMT

I found the issue is with picklist/forecastbat/forecastbat.txt file in Meta and compute. I think not with mid tier .
I tested in another environment.
Installed latest hot fixes in meta and compute only(including forecast server hotfixes).
I noticed it is over writing "forecastbat.txt".I replaced with original forecastbat.txt and FSlogin worked fine but When I upgraded metadata(one of the post install step ) then FSLOGIN is not working again.
getting diffrent error now "ERROR: Could not initialize classpath from picklist file, root java folder not found"

Re: %FSLOGIN error

sathya66 — Tue, 22 Sep 2020 09:03:51 GMT

We resolved this issue as there is a forecast server version difference between client and between servers.
We resolved it by putting version check=false in JREOPTIONS for now

Re: %FSLOGIN error

JuanS_OCS — Tue, 22 Sep 2020 09:45:34 GMT

Many thanks for sharing your solution, @sathya66