Geneva Patch 3 Hot Fix 6

Geneva Patch 3 Hot Fix 6 provides fixes for the Geneva release.

For Geneva Patch 3 Hot Fix 6:
Build date: 03-04-2016_2129
Build tag: glide-geneva-08-25-2015__patch3-hotfix6-03-02-2016

For more information about how to upgrade an instance, see Upgrade to Geneva.

For more information about the release cycle, see the ServiceNow Release Cycle. For a downloadable, sortable version of Geneva fixed problems, see KB0598265.

Note: This version is approved for FedRAMP.

Fixed problems in Geneva Patch 3 Hot Fix 6

Problem Short description Description Steps to reproduce
On Premise

PRB665363

Upgrading to Geneva Patch 3 or later with insufficient Oracle privileges leads to the instance being zbooted ServiceNow has identified an issue affecting customers with an Oracle database who upgrade to Geneva Patch 3 or later. When upgrading, if the Oracle user account that was used to execute the installation or upgrade is missing the "grant select on dba_users to snc" privilege, then the preflight check fails. The instance is unable to confirm the schema exists and a zboot is triggered. When executing an upgrade, this results in catastrophic data loss. Refer to the Known Error article (KB0564467) for details.
Persistence

PRB660232

Report on variables (of type Reference) on sc_req_item results in 'Syntax Error or Access Rule Violation detected by database (Not unique table/alias: 'sc_item_option2')' When defining a bar chart report on the sc_req_item table, grouped by Variables, and with a combination of 'Select Item' and 'Select Variable' (variables of type Reference), running the report results in the error 'Syntax Error or Access Rule Violation detected by database (Not unique table/alias: 'sc_item_option2')'. This issue is reproducible in Fuji Patch 11 and Geneva.
  1. Log into a Geneva Patch 1 OOB instance.
  2. Create a new report.
    • Table: sc_req_item (Requested Items)
    • Type: Bar
    • Group by: Variables
      • Select Item: "Password Reset"
      • Select Variable: "Whose password needs to be reset?"
    • Aggregation: Count
    • Number of Groups: System Default (12)
    • Show other: Checked
  3. Click Run.
  4. Observe the error message.
This issue is also reproducible in list reports.
  1. Log into a Geneva Patch 1 OOB instance.
  2. Create a new report.
    • Table: sq_req_item (Requested Items)
    • Type: List
    • Group by: None
    • Select Variable:
      • From the Available column, select Variables > Password Reset > Whose password needs to be reset?
      • Add this variable to the Selected column.
    • Click Run.
    • Observe the error message.

Fixes included with Geneva Patch 3 Hot Fix 6

* Unless any exceptions are noted, you can safely upgrade to this release version from any of the versions listed below. These prior versions contain PRB fixes that are also included with this release. Be sure to upgrade to the latest listed patch that includes all of the PRB fixes you are interested in.

Note:
  • The fixes for Geneva Patch 2 and Geneva Patch 3 were combined into one patch. ServiceNow documentation refers to this combined patch as Geneva Patch 3.
  • Geneva Patch 3 Hot Fix 4 does not exist.