%fsload - Project not able to load

[amitbjambhulkar]

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

);

[yabwon]

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 ?

[amitbjambhulkar]

Yes its available. Getting below error.

[yabwon]

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

[amitbjambhulkar]

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

[yabwon]

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

[yabwon]

Does the Note form documentation apply to you? 

[amitbjambhulkar]

note from log file?

[yabwon]

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

[amitbjambhulkar]

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

[rajib_nath]

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.

[amitbjambhulkar]

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

[rajib_nath · Accepted solution]

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.

[amitbjambhulkar]

Thanks for help 🙂 Issue resolved.

[rajib_nath]

Great to hear you are able to proceed. 👍