Notifications

730 views

Description

If an instance has a record in the [sys_db_object] table with an empty name and following an upgrade to New York Patch 2, tables might not be created properly. This can be observed when a table is created during the installation of an Application, the activation of a plugin, an import set creation, the commit of an Update Set.

When creating a table manually:

  • The creation of the Collection record in [sys_dictionary] is not captured in the Customer Update table [sys_update_xml] and therefore not captured in an Update Set.
  • If fields are added to the table on the [sys_db_object] form BEFORE the form is submitted then the [sys_dictionary] records are created for the fields, BUT all [sys_documentation] for the table and fields are missing and therefore not captured in Update Set.
  • If fields are added to the table AFTER it has been created, then it works fine and everything is captured in an Update Set.

Other related [sys_update_xml] records such as application menu, module, role, access controls, and access role records are captured.

 

A NullPointerException is thrown from the Usage Analytics code base:

2019-11-07 05:08:30 (400) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 SEVERE *** ERROR *** sys_db_object has nil/empty name, skipping in DBObjectManager.load: a35a646e6f1522001f6cb03f5d3ee466
2019-11-07 05:08:30 (418) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 DBTable.create() for: u_qualys_vuln_list
2019-11-07 05:08:30 (650) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 Replication is not enabled on table: u_qualys_vuln_list, not queueing replication table create special db event
2019-11-07 05:08:31 (063) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 ColumnMetadataCache: Removing u_qualys_vuln_list
2019-11-07 05:08:31 (068) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 CachingStorageMetadataEntry: Flushing u_qualys_vuln_list
2019-11-07 05:08:31 (130) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 *** Script: Begin ResourceSupport.buildTableResources(u_qualys_vuln_list, undefined)
2019-11-07 05:08:31 (132) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 *** Script: End ResourceSupport.buildTableResources
2019-11-07 05:08:31 (234) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 LicensingTableCreateListener: Initializing licensing attrs for table u_qualys_vuln_list
2019-11-07 05:08:31 (240) Default-thread-8 3AC547941B0100101ECBA8233A4BCB66 txid=65d643d41b01 WARNING *** WARNING *** Evaluator: java.lang.NullPointerException
Caused by error in sys_script.d49ab227bf1320001875647fcf0739c4.script at line 2
com.glide.usageanalytics.license.UALicArtifactStore.loadEntitledCustomTableList(UALicArtifactStore.java:223)
com.glide.usageanalytics.license.UALicArtifactMgr.reloadEntitledCustomTbls(UALicArtifactMgr.java:116)
com.glide.usageanalytics.lef.UAPlatLicUtils.handleTableInsert(UAPlatLicUtils.java:52)
com.glide.usageanalytics.lef.LicensingTableCreateListener.onTableCreate(LicensingTableCreateListener.java:28)
com.glide.db.ddl.DBTable.create(DBTable.java:156)
com.glide.db.table.TableCreate.createTable(TableCreate.java:127)
com.glide.db.table.TableCreate.process(TableCreate.java:56)
com.glide.db.impex.Bootstrap.createTable(Bootstrap.java:223)
com.glide.db.impex.Bootstrap.upgradeTables(Bootstrap.java:202)
com.glide.db.impex.Bootstrap.upgradeTables(Bootstrap.java:165)
com.glide.db.impex.Bootstrap.upgradeTables(Bootstrap.java:112)
com.glide.db.impex.Bootstrap.bootstrap(Bootstrap.java:89)
com.glide.update.loader.schema.TableSchemaLoader.buildBootstrapXMLAndCreateTable(TableSchemaLoader.java:123)
com.glide.update.loader.schema.TableSchemaLoader.loadTable(TableSchemaLoader.java:88)
com.snc.apps.api.TableEditor.jsStaticFunction_tableCreate(TableEditor.java:109)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138)
org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:670)
org.mozilla.javascript.FunctionObject.call(FunctionObject.java:614)
org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2582)
org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
org.mozilla.javascript.gen.sys_script_d49ab227bf1320001875647fcf0739c4_script_1060._c_script_0(sys_script.d49ab227bf1320001875647fcf0739c4.script:2)
org.mozilla.javascript.gen.sys_script_d49ab227bf1320001875647fcf0739c4_script_1060.call(sys_script.d49ab227bf1320001875647fcf0739c4.script)
org.mozilla.javascript.gen.sys_script_d49ab227bf1320001875647fcf0739c4_script_1060.exec(sys_script.d49ab227bf1320001875647fcf0739c4.script)
com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:279)
etc....

Steps to Reproduce

You can identify the null object in the [sys_db_object] table by running this query:

https://<instance-name>/sys_db_object_list.do?sysparm_query=nameISEMPTY&sysparm_first_row=1

Or look for nameISEMPTY in the [sys_db_object] table.

Workaround

This problem has been fixed. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.

If you are unable to upgrade to a fixed version, the workaround is to remove the [sys_db_object] with the nil name. DO NOT delete it from the UI. Instead, contact ServiceNow Technical Support who will remove the bad record from the backend.


Related Problem: PRB1367576

Seen In

New York Patch 1
SR - IntegrationHub - Docker Integration v1.0.2
SR - IntegrationHub - JIRA Service Desk Integration r2 - v2.0.0
SR - IntegrationHub - JIRA Service Desk Integration r2 - v2.0.7
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - Audit Management PA Content - Madrid 2019 Q1
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - NIST RMF - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Policy and Compliance PA Content - Madrid 2019 Q1
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - Risk Management PA Content - Madrid 2019 Q1
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITBM - Agile 2.0 Dashboards v1.0
SR - ITBM - Scrum Dashboards Common v1.0
SR - ITBM - Scrum Dashboards Common v1.0.2
SR - ITOM - CMDB CI Class Models - 201907
SR - ITOM - CMDB CI Class Models - 201908
SR - ITOM - CMDB CI Class Models - 201909
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - ITOM - Fundamentals Istanbul Jakarta Kingston r1 - v5.99.6
SR - PAR - Performance Analytics Content Pack for Guided Tours - v1.0.1
SR - SecOps - Configuration Compliance - New York 2019 Q3
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - CarbonBlack Integration - New York 2019 Q3
SR - SIR - RecordedFuture Integration - New York 2019 Q3
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response Flow Designer Content - Madrid 2019 Q2
SR - SIR - Security Incident Response Mobile - New York 2019 Q3 2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Security Incident Response UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - SIR - Threat intelligence - New York 2019 Q3
SR - SIR - VirusTotal Integration - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Rapid7 - London 2019 Q2 v.6.2.1
SR - VR - Shodan Exploit - New York 2019 Q3
SR - VR - Solution Management Madrid Q2
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response Mobile - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Intended Fix Version

Orlando

Fixed In

New York Patch 3

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-02-28 08:02:27
Published:2019-11-13