Notifications

949 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 - 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 - Platform - Performance Analytics Content Pack for Guided Tours - v1.0.1
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 - Configuration Compliance - 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

Fixed In

New York Patch 3
Orlando

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-07-29 02:59:12
Published:2019-11-13