"invalid table name: open_nlu_predict_state_tracking" errors since upgrading to Quebec

Hans Peter
Tera Contributor

Hi,

Since we upgraded our instaces to Quebec, we're getting the following error around every minute (loglevel "Warning"):

org.mozilla.javascript.EvaluatorException: GlideRecord.addQuery() - invalid table name: open_nlu_predict_state_tracking (<refname>; line 7)
Line(7)
staleVAPredictionStateGR.addQuery('app', 'Virtual Agent');
evaluateString(JavaScript evaluation error on:
var VA_NLU_PREDICTION_TIMEOUT = parseInt(gs.getProperty('com.glide.cs.nlu.predict.timeout') || 30); // seconds

var timeoutThreshold = new GlideDateTime();
timeoutThreshold.add(-(VA_NLU_PREDICTION_TIMEOUT * 1000));

var staleVAPredictionStateGR = new GlideRecord('open_nlu_predict_state_tracking');
staleVAPredictionStateGR.addQuery('state', 'NOT IN', 'COMPLETED,CANCELLED,TIMED_OUT,SERVICE_ERROR,PREDICT_ERROR');
staleVAPredictionStateGR.addQuery('app', 'Virtual Agent');
staleVAPredictionStateGR.addQuery('app_document_table', 'sys_cs_conversation_task');
staleVAPredictionStateGR.addQuery('mode', 'ASYNC');
staleVAPredictionStateGR.addQuery('sent_on', '<=', timeoutThreshold);
staleVAPredictionStateGR.query();
var timeoutCandidates = [];
while (staleVAPredictionStateGR.next()) {
if ('suspended' == staleVAPredictionStateGR.app_document.getRefRecord().state) {
var stateTrackingSysId = '' + staleVAPredictionStateGR.getUniqueValue();
var convSysId = '' + staleVAPredictionStateGR.app_document.getRefRecord().conversation;
var csTaskSysId = '' + staleVAPredictionStateGR.app_document;
var userSysId = '' + staleVAPredictionStateGR.user_id;
sn_cs.VASystemObject.timeoutNLUPrediction(convSysId, csTaskSysId, stateTrackingSysId, userSysId);
}
}
)

 

I can't really find a business rule or script include that contains these lines of code, but it seems to be about Virtual Agent and NLU, which we're currently not using at all. 

It kind of looks like I'm missing a plugin or something, but I'm a little surprised since we're not using VA / NLU features at all, and I honestly don't even know our license situation in regards to those applications. Did anyone else have this problem after upgrading to Quebec?

Thanks in Advance for your help,

Hans

1 ACCEPTED SOLUTION

Hi Hans,

Quick follow up. I have logged a support case for this and have the following information back.

This is related to PRB1498255 - Timeout For VA Chats Suspended on NLU Prediction script cluttering logs. 

This scheduled script was installed during the Quebec upgrade which references a table installed by the "Proxy agent for connecting to Natural Language Understanding (NLU) providers" plugin.

The defect is permanently fixed in Rome release. The suggested fix is to modify the script to the Rome fixed version by adding a condition to the scheduled script:

Approach to modify the scheduled script in following steps:

  1. Go to the scheduled script 'Timeout For VA Chats Suspended on NLU Prediction'
  2. Click the Conditional Check box and the Condition window will be displayed.
  3. Enter the condition: new GlidePluginManager().isActive('com.glide.nlu.proxy') && gs.tableExists('open_nlu_predict_state_tracking');
  4. Save the change

If all else fails after this would probably suggest you log your own support case with NOW Support.

Kind Regards,
Shane

View solution in original post

6 REPLIES 6

Shane Butler
Tera Guru

Hi Hans,

We too have recently started seeing this in our logs too after upgrading to Quebec an we too are not using the NLU / Virtual Agent at this point in time. I do note that in Quebec that the filter for a table view now also shows the Natural Language filter too so wondering if this has something to do with this:

find_real_file.png

Hi Hans,

Quick follow up. I have logged a support case for this and have the following information back.

This is related to PRB1498255 - Timeout For VA Chats Suspended on NLU Prediction script cluttering logs. 

This scheduled script was installed during the Quebec upgrade which references a table installed by the "Proxy agent for connecting to Natural Language Understanding (NLU) providers" plugin.

The defect is permanently fixed in Rome release. The suggested fix is to modify the script to the Rome fixed version by adding a condition to the scheduled script:

Approach to modify the scheduled script in following steps:

  1. Go to the scheduled script 'Timeout For VA Chats Suspended on NLU Prediction'
  2. Click the Conditional Check box and the Condition window will be displayed.
  3. Enter the condition: new GlidePluginManager().isActive('com.glide.nlu.proxy') && gs.tableExists('open_nlu_predict_state_tracking');
  4. Save the change

If all else fails after this would probably suggest you log your own support case with NOW Support.

Kind Regards,
Shane

Thanks for this one Shane!

Hello.
Does this flaw only appear in the production instance?
In my environment, the above warning appears in the log for the production instance, but not for the It does not seem to appear in the development and validation instances.