BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sathya66
Barite | Level 11

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

1 ACCEPTED SOLUTION

Accepted Solutions
sathya66
Barite | Level 11
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

View solution in original post

14 REPLIES 14
dpage
SAS Employee

/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?

 

 

 

sathya66
Barite | Level 11

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

dpage
SAS Employee

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

 

https://go.documentation.sas.com/?cdcId=fscdc&cdcVersion=15.1&docsetId=fsag&docsetTarget=n0gizfk7ahi...

 

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

https://go.documentation.sas.com/?docsetId=bimtag&docsetTarget=n0s325xuzaji9tn16zvgq128dvb5.htm&docs...

 

 

sathya66
Barite | Level 11
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
JuanS_OCS
Amethyst | Level 16

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...

 

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=e... 

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.

sathya66
Barite | Level 11
thanks,
Yes, forecast studio Client (desktop) is working fine except FSLOGIN macro from SAS EG or from DI
sathya66
Barite | Level 11
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"
JuanS_OCS
Amethyst | Level 16

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-up...

 

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.

 

 

sathya66
Barite | Level 11
Yes, I rebuilt and redeployed all the web apps. Everything is working fine except this FSLOGIN
dpage
SAS Employee

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

sathya66
Barite | Level 11

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

sathya66
Barite | Level 11
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"
sathya66
Barite | Level 11
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
JuanS_OCS
Amethyst | Level 16

Many thanks for sharing your solution, @sathya66 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 14 replies
  • 2372 views
  • 14 likes
  • 3 in conversation