- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-26-2021 02:24 AM
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
Solved! Go to Solution.
- 2,268 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2021 04:33 PM
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:
- Go to the scheduled script 'Timeout For VA Chats Suspended on NLU Prediction'
- Click the Conditional Check box and the Condition window will be displayed.
- Enter the condition: new GlidePluginManager().isActive('com.glide.nlu.proxy') && gs.tableExists('open_nlu_predict_state_tracking');
- Save the change
If all else fails after this would probably suggest you log your own support case with NOW Support.
Kind Regards,
Shane
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-28-2021 08:41 PM
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2021 04:33 PM
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:
- Go to the scheduled script 'Timeout For VA Chats Suspended on NLU Prediction'
- Click the Conditional Check box and the Condition window will be displayed.
- Enter the condition: new GlidePluginManager().isActive('com.glide.nlu.proxy') && gs.tableExists('open_nlu_predict_state_tracking');
- Save the change
If all else fails after this would probably suggest you log your own support case with NOW Support.
Kind Regards,
Shane
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-13-2021 07:55 AM
Thanks for this one Shane!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-17-2021 08:29 PM
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.