topic Re: SAS forecast server code error in EG in SAS Forecasting and Econometrics

SAS forecast server code error in EG

sathya66 — Thu, 30 Jan 2020 10:17:01 GMT

Hi All,

tried to run the code in Dev but when run the specific macro, it seems to be pointing to prod mid tier rather than DEV.

Here is the code that we are trying to run.

%FSLOGIN(USER=test_user, PASSWORD=XXXXX,
     SASENVIRONMENT=dev);

getting the below error.

ERROR: Exception caught in FSLOGIN.

ERROR: ENVIRONMENT_LOAD_FAILED

01-29 13:11:58,084 [Thread-4][FATAL XmlEnvironmentManager] - Unable to properly initialize EnvironmentManager (IOException) using

the provided URL (https://prodmid:8343/sas/sas-environment.xml)

java.net.ConnectException: Connection timed out (Connection timed out)

If I run the same code in prod , it works fine as the sas-environment.xml is correct.

but why it is picking up the wrong sas environment file in dev?

I have checked the sas-environment.xml we have Dev info in the sas-environment.xml in dev

Thanks,

Re: SAS forecast server code error in EG

rajib_nath — Thu, 30 Jan 2020 12:52:06 GMT

Hi @sathya66,

You should check the content inside "sassw.config" file which is located at SAS Home (typically "C:\program files\SASHome").

Look for the value of SASENVIRONMENTSURL= property and check if it is pointing to the right middle tier host.

Hope this helps, Regards,

Re: SAS forecast server code error in EG

sathya66 — Thu, 30 Jan 2020 13:03:01 GMT

Thanks,

Yes, it is pointing to the right mid tier host.

Re: SAS forecast server code error in EG

rajib_nath — Thu, 30 Jan 2020 18:12:40 GMT

Ok.

In EG, you need to connect to a Workspace Server using a connection profile. The Workspace Server can be a remote or a local one.

Can you please check the Workspace Server information in the profile?

If you are connected to a remote host A, then the SASENVIRONMENT= property will be read from host A. If you are connected to a local workspace server, then this property will be read from the local machine. Can you please check?

Re: SAS forecast server code error in EG

sathya66 — Tue, 04 Feb 2020 13:52:06 GMT

Hi,

I am sure I connected to remote access , because it is trying to connect to prod from DEV remote host "https://prodmid:8343/sas/sas-environment.xml".

how can I check the workspace server information in the profile?

Thanks,

Re: SAS forecast server code error in EG

rajib_nath — Tue, 04 Feb 2020 17:31:03 GMT

HI @sathya66,

In EG, there is an icon at the bottom right corner to view the current profile, I am attaching two images for illustration.

Once you have clicked on that icon, a dialog will open up and display the details of the workspace server. You can also create a new profile to connect to another remote and local workspace. The user has to be a valid OS account authorized to that SAS Workspace.

Re: SAS forecast server code error in EG

sathya66 — Wed, 05 Feb 2020 10:56:34 GMT

Thanks @rajib_nath ,

I connected to remote host. below screen shot is a connection profile to connect to a server right , it will connect to Metadata and then SASAPP and then workspace /pooled workspace .

above code is working in Prod but when we run the same code in Dev , it is trying to connect PROD environment variable.

I have checked the environment variable file in Mid DEV ,it has correct mid /sas-environment.xml.

Thanks,

Re: SAS forecast server code error in EG

rajib_nath — Wed, 05 Feb 2020 14:04:02 GMT

@sathya66,

You need to check the "sassw.config" file in the Workspace Server machine of DEV host. I am guessing the server hosting workspace server and / or metadata server is different from Mid DEV. Can you please check that?

Re: SAS forecast server code error in EG

sathya66 — Wed, 05 Feb 2020 15:15:56 GMT

Thanks @rajib_nath ,

it is pointing to wrong(prod) env instead of dev.

Thanks,