topic Re: %fsload - Project not able to load in SAS Forecasting and Econometrics

%fsload - Project not able to load

amitbjambhulkar — Tue, 09 Apr 2024 11:18:12 GMT

Hi,

I have created project "CC_DCC_gic_prod" in dev "/ie01/dev/UTF_ForecastStudio/Projects".

I am trying to run the project from SAS EG using below code but getting ERROR: Project CC_DCC_gic_prod does not exist. Do I need to define or add "CC_DCC_gic_prod" project name in anywhere in Server so it will automatically pick? Please let me know looking forward for help & suggestions from experts.

%let project_name=CC_DCC_gic_prod;

%fsload(PROJECTNAME=&project_name,

ENVIRONMENT=&env

);

Re: %fsload - Project not able to load

yabwon — Tue, 09 Apr 2024 12:06:04 GMT

Is the project file name: "CC_DCC_gic_prod"? maybe it is "cc_dcc_gic_prod "?

did you looked into the "/ie01/dev/UTF_ForecastStudio/Projects" and checked if the project really exist there ?

Re: %fsload - Project not able to load

amitbjambhulkar — Tue, 09 Apr 2024 12:14:49 GMT

Yes its available. Getting below error.

Re: %fsload - Project not able to load

yabwon — Tue, 09 Apr 2024 12:16:12 GMT

Could you show more log? use the </> icon to paste it.

Re: %fsload - Project not able to load

yabwon — Tue, 09 Apr 2024 12:18:32 GMT

Does the Note form documentation apply to you?

Re: %fsload - Project not able to load

amitbjambhulkar — Tue, 09 Apr 2024 12:22:59 GMT

34 %let project_name=CC_DCC_gic_prod;
35 %fslogin(user=&userid, password=&pwd);

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: 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.
NOTE: DATA statement used (Total process time):
real time 5.26 seconds
cpu time 0.00 seconds

NOTE: Session created on remote middle tier fsmain.
36
37 /* Load FS Project Macro Variables */
38
39 /*%fsload(PROJECTNAME=&project_name,
3 The SAS System Tuesday, April 9, 2024 05:51:14 PM

40 USER=&userid,
41 PASSWORD=&pwd,
42 HOST=&hostname,
43 ENVIRONMENT=&env
44 );*/
45 %let project_name=CC_DCC_gic_prod;
46
47 %fsload(PROJECTNAME=&project_name,
48 ENVIRONMENT=&env
49 );
NOTE: Resolved midtier=fsmain

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
49:69
ERROR: Project CC_DCC_gic_prod does not exist.
NOTE: DATA statement used (Total process time):
real time 2.30 seconds
cpu time 0.01 seconds

NOTE: Stopping FSLOAD due to errors.
50
51 %put fsload=&fsload;
fsload=ERROR

Re: %fsload - Project not able to load

amitbjambhulkar — Tue, 09 Apr 2024 12:29:57 GMT

note from log file?

Re: %fsload - Project not able to load

yabwon — Tue, 09 Apr 2024 12:33:12 GMT

no from log but from the documentation: https://documentation.sas.com/doc/en/fscdc/15.1/fsag/p0uny1o1va75ngn1n0n9oelx8jhg.htm

Re: %fsload - Project not able to load

yabwon — Tue, 09 Apr 2024 12:41:10 GMT

1) what is the value of "&env"?

2) could you add "options mprint;" before executing the macro? That note about "Numeric values have been converted to character" looks strange.

Bart

Re: %fsload - Project not able to load

amitbjambhulkar — Tue, 09 Apr 2024 12:47:44 GMT

I read the documentation but not able to resolve the issue.

Re: %fsload - Project not able to load

amitbjambhulkar — Wed, 10 Apr 2024 06:56:12 GMT

Please let me know if anyone know how to resolve this issue?

Re: %fsload - Project not able to load

rajib_nath — Wed, 10 Apr 2024 08:55:55 GMT

Hi,

Here is a quick test you can perform to see if the project exists:

Program used:

%FSLOGIN (USER=&user, PASSWORD=&pass)
%FSGETENV ( PRINT = YES )
%FSGETPRJ ( PRINT = YES, ENVIRONMENT = default )
%FSLOGOUT

Explanation of above code:

Line-1. Login

Line-2. Get all the FS environments available in the system. You should see output like the one below:

Line-3. Get all projects inside an environment e.g. "Default". It should be run for all such available environments.

If you run Step-3 against all configured environments, that should list all projects from all environments. You should be able to check if the project of interest "CC_DCC_gic_prod" is present in one of the environments.

Line-4. Log out

The call to %FSLOAD () supports "ENVIRONMENT = option". If not supplied, "ENVIRONMENT = Default" is used. You need to specify the environment where that project is found.

Hope this helps to resolve the issue.

Re: %fsload - Project not able to load

amitbjambhulkar — Thu, 11 Apr 2024 06:56:39 GMT

Hi,

Thanks for reply.

Now I can see the issue. Name is correct "DCL_gic_prod" but dataset is coming wrong "Wish_gic_prod_ts".

Also how to change dataset name to correct name as "DCL_gic_prod". If dataset name get change then I believe issue will get resolved.

Could you please let me know how to add new project name if some projects are missing?

Thanks,

Amit

Re: %fsload - Project not able to load

rajib_nath — Thu, 11 Apr 2024 07:38:28 GMT

Great to see the issue getting resolved.

To change data you can use the 'Change data source' option from the 'File' menu, inside a project.

You can also use the %FSSETDAT macro - https://go.documentation.sas.com/doc/en/fscdc/14.3/fsag/n0axo8su134oi0n19t5zmf7rptcr.htm

Hope this helps.

Re: %fsload - Project not able to load

amitbjambhulkar — Fri, 12 Apr 2024 06:58:25 GMT

Thanks for help 🙂 Issue resolved.

Re: %fsload - Project not able to load

rajib_nath — Fri, 12 Apr 2024 12:43:10 GMT

Great to hear you are able to proceed. 👍