Loading & unloading data using sas environment manager

SatishR — Sat, 13 Apr 2024 10:46:54 GMT

Hello,

I am working with SAS Viya 3.5, in that i have existing created job

Sample: Unload cas-shared-default Public data

Sample: load cas-shared-default Public data

to configure this job first load unload data on daily basis i have some doubt as below.

First lets discuss about unloading the data,

as per the steps, we have to make changes in the Argument, so once click on argument tab following screen appears,

in server name, we selected Cas Server, Further data is in public library so incaslib selected, where to assign the table name which we have to unload from public library. what is use of filter tab.

I configured below manner,

and I am getting below log,

--------------------------------------------------

----------JOB INFORMATION----------

Job Created: 2024-04-13T10:11.121Z
Job ID: e8e07de8-a900-4fb2-85b8-3dbfb73f2c89
Heartbeat interval: PT0.3S
Job expires after: PT168H
Running as: Sas
Log file: /files/files/d44a07ee-74bb-4ee8-a90d-3aa1ff556094 [ 2024-04-13T10:11.121Z-results.log ]
Arguments:

Options:
{
"enabled" : true,
"type" : "UNLOAD",
"settings" : {
"unloadAccessThreshold" : "PT45S",
"successJobId" : ""
},
"selectors" : [ {
"serverName" : "cas-shared-default",
"inputCaslib" : "test123",
"outputCaslib" : null,
"filter" : "eq(name,’SAMPLE_DATA_PREP’)",
"settings" : { }
} ]
}

--------------------------------------------------

Created session cas-shared-default: e6c0f370-32c7-8640-bc0e-fdd312b7d189 (CAS Manager:Sat Apr 13 15:41:16 2024)
Using session e6c0f370-32c7-8640-bc0e-fdd312b7d189
Server: cas-shared-default
Input caslib: test123
Effective Settings:
{
"successJobId" : "",
"unloadAccessThreshold" : "PT45S"
}
----------UNLOAD STARTING----------

----------UNLOAD COMPLETE----------

----------SUMMARY----------

0 TABLES PROCESSED

----------CLEANUP STARTING----------

Session deleted: cas-shared-default: e6c0f370-32c7-8640-bc0e-fdd312b7d189
----------CLEANUP COMPLETE----------

Final Job State: completed
Log file:/files/files/d44a07ee-74bb-4ee8-a90d-3aa1ff556094

Similarly I want clarity regarding Loading the data. Please anyone could help to resolve the same.

Thanks in advance.

Re: Loading & unloading data using sas environment manager

gwootton — Mon, 15 Apr 2024 13:53:40 GMT

From the looks of your output you are telling the job to unload an in-memory table called "SAMPLE_DATA_PREP" in the CASLIB test123 if it hasn't been accessed in the last 45 seconds.

It looks like it did not find any tables that met those conditions.

Documentation on these Sample jobs can be found here:

CAS Table State Management
https://go.documentation.sas.com/doc/en/calcdc/3.5/caldatamgmtcas/n150v9svjp42ron1hn9r496xj49m.htm

Re: Loading & unloading data using sas environment manager

SatishR — Tue, 16 Apr 2024 05:21:57 GMT

@gwootton Same document I have referred, even I tried case sensitive manner table name in filter but getting same output.

Re: Loading & unloading data using sas environment manager

gwootton — Tue, 16 Apr 2024 12:54:41 GMT

Is the table currently loaded in memory? You may wish to engage SAS Technical Support to review your configuration and table state.

Re: Loading & unloading data using sas environment manager

SatishR — Fri, 19 Apr 2024 09:33:15 GMT

Yes Table loaded currently...

topic Re: Loading & unloading data using sas environment manager in SAS Viya

Loading & unloading data using sas environment manager

Re: Loading & unloading data using sas environment manager

Re: Loading & unloading data using sas environment manager

Re: Loading & unloading data using sas environment manager

Re: Loading & unloading data using sas environment manager