67200 - CAS Table State Management scheduled jobs begin to fail due to a problem with the CASMANAGER

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

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 Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Viya	Linux for x64	3.5	3.5	Viya	Viya

* 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.

Type:	Problem Note
Priority:	high

Date Modified:	2021-01-22 15:36:56
Date Created:	2021-01-11 10:46:07

Support

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

Operating System and Release Information