Notifications

41 views

Description

Symptoms


After upgrading to London, high volume of errors in the syslog seen as following, when loading a form.

2018-10-08 11:55:54 (771) Default-thread-5 FCD78A19DBC1E7002F10147A3A961990 txid=e35ac6d9dbc1 WARNING *** WARNING *** GlideRecord invalid table name: ts_c_10_0
2018-10-08 11:55:54 (772) Default-thread-5 FCD78A19DBC1E7002F10147A3A961990 txid=e35ac6d9dbc1 WARNING *** WARNING *** GlideRecord invalid table name: ts_c_10_1
2018-10-08 11:55:54 (772) Default-thread-5 FCD78A19DBC1E7002F10147A3A961990 txid=e35ac6d9dbc1 WARNING *** WARNING *** GlideRecord invalid table name: ts_c_10_2
2018-10-08 11:55:54 (773) Default-thread-5 FCD78A19DBC1E7002F10147A3A961990 txid=e35ac6d9dbc1 WARNING *** WARNING *** GlideRecord invalid table name: ts_c_10_3

Release


London

Environment


All

Cause


PRB1308973 , PRB1308349

Due to existence of invalid text search tables and the NullPointerError that can occur in London. 

Resolution


Please run following script to "clean up invalid text search tables", in affected instance as MAINT user.

 

+++++++++++++++++++++++++++++++++++++++

checkForInvalidTSCTables();
function checkForInvalidTSCTables() {
var arrayIterator =
GlideCacheManager.getPrivateUnsortedKeys("syscache_tabledescriptor");
while(arrayIterator.hasNext()) {
var table = arrayIterator.next()
if (!table.startsWith("ts_c"))
continue;

var gr = new GlideRecord(table);
if (gr.isValid())
continue;

var sys_db_object = new GlideRecord('sys_db_object');
sys_db_object.setWorkflow(false);
var success_sys_db_object = sys_db_object.get('name',table);

var sys_dictionary = new GlideRecord('sys_dictionary');
sys_dictionary.setWorkflow(false);
var success_sys_dictionary = sys_dictionary.get('name',table);

if (success_sys_db_object || success_sys_dictionary) {
gs.print("Cleaning Up Invalid Table = '" + table + "'. Contains sys_db_object records '"
+ success_sys_db_object + "'. Contains sys_dictionary records '" +
success_sys_dictionary + "'.");
GlideSystemUtilDB._dropTable(table);
}
}
}

++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

Article Information

Last Updated:2019-08-26 17:38:48
Published:2019-02-14