SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 67200: CAS Table State Management scheduled jobs begin to fail due to a problem with the CASMANAGER_META table

DetailsHotfixAboutRate It

In rare cases, the table.update action leaves a table in an unusable state. This issue has been observed with the CASMANAGER_META table, which is used by CAS Table State Management jobs. Indicators of this problem include scheduled job failures and repeating messages in the CAS server logs similar to the following:

INFO  [00000007] 49491 username 175833 [tkcasaimp.c:4448] - ++ action table.update / table={name='CASMANAGER_META', caslib='ReferenceData', where='serverName="cas-shared-default"and caslibName="Example Caslib"and tableName="example_table"and sourceTableName="example_table.sas7bdat"'}, set={{var='accessTimeUnloaded', value='0'}};
INFO  [00000007] 49491 username 175833 [tkcasaimp.c:4446] - [2] ++ action table.loadTable / path='CASMANAGER_META', readAhead=true, resident=false, caslib='ReferenceData', casOut={caslib='ReferenceData'}, singlePass=false, where='serverName="cas-shared-default"and caslibName="Example Caslib"and tableName="example_table"and sourceTableName="example_table.sas7bdat"', returnWhereInfo=true, cmpProgram=true;
ERROR [00000007] 49491 username 175833 [tkcastabd.c:1202] - Failed to access file (80BFE801): /opt/sas/viya/config/data/cas/default/referenceData/CASMANAGER_META.

In this example, the table.update action triggers a table.loadTable action because the CASMANAGER_META table is not found in memory. Also, the table.loadTable action fails because the CASMANAGER_META table does not have a source file that can be loaded because it is created in memory when needed. So, the scenario in these log messages indicates that the CASMANAGER_META table is in a bad state.

The only way to circumvent the error is to restart the CAS server, which drops all tables from memory.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS ViyaLinux for x643.53.5ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.