Notifications

126 views

Description

During running Cloud Resource Discovery on a Madrid Instance, the following error message is thrown in system logs:

Warning org.mozilla.javascript.EvaluatorException: GlideRecord.query() - invalid table name: cloud_resources_service_type_map

Steps to Reproduce

  1. Run Cloud Resource Discovery on a ServiceNow Madrid Instance.
  2. Check the System Logs.
  3. The following error messages will be found and they are thrown because of 'Initialize Cloud Resources Count' business rule: 
    Warning org.mozilla.javascript.EvaluatorException: GlideRecord.query() - invalid table name: cloud_resources_service_type_map (sys_script.094122a46773130022646c706785ef13.script; line 8)
    EvaluatorException(JavaScript evaluation error on:
    (function executeRule(current, previous) {

    var scheduleSysID = current.getValue('dscheduler');
    var statusSysID = current.getUniqueValue();

    //Iterating through all CIs of Source table to "Discovery Cloud Results" table and Initializing their counts to 0
    var resourcesGR = new GlideRecord('cloud_resources_service_type_map');
    resourcesGR.query();
    while (resourcesGR.next()) {
    var initializeCountGR = new GlideRecord('discovery_cloud_results');
    initializeCountGR.initialize();
    initializeCountGR.setValue('status', statusSysID);
    initializeCountGR.setValue('cloud_resource_name', resourcesGR.getValue('cloud_resource'));
    initializeCountGR.setValue('resource_service_type', resourcesGR.getValue('service_type'));
    initializeCountGR.setValue('cloud_resource_count', 0);
    if (scheduleSysID)
    initializeCountGR.setValue('schedule', scheduleSysID);
    initializeCountGR.insert();
    }

    })(current, previous);
    )

Workaround

This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this form to be notified when more information will become available.

 

As a workaround, you may delete 'Initialize Cloud Resources Count' business rule on the affected Madrid instances:

https://<instance_name>.service-now.com/sys_script.do?sys_id=094122a46773130022646c706785ef13


Related Problem: PRB1373710

Seen In

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - ITOM - Discovery and Service Mapping - 201908

Fixed In

Madrid Patch 10

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-02-27 09:44:54
Published:2019-11-26