Hotfixes for Spotfire Data Virtualization are cumulative. A newer hotfix release completely supersedes previous hotfixes for the same major/minor version and contains all prior resolutions. These updates apply to the SDV Server, Studio, and Business Directory components.

Note: Hotfix updates for Spotfire Data Virtualization are distributed directly via Support links rather than the standard Spotfire major/minor release download portal. Please use the direct links provided in the sections below to obtain the required installation packages.

If you instead prefer to download hotfixes directly from the Support Portal, do the following:

1. Go to the Support Portal (https://support.tibco.com) and login.

2. Go to Downloads menu > Hotfixes > AvailableDownloads > Data Virtualization and locate the version/hotfix of interest.

Latest Cumulative Release: SDV 8.9.0 HF-004

• Direct Download Link: Download SDV 8.9.0 HF-004

Resolved Issues in HF-004

• CIS-120114: END TIME is now always reported for failed requests in request execution reports.

• CIS-120567: Introduced Incognito Mode for data sources (configured in Studio via Data Source > Advanced tab > set Incognito = True). Flags a data source as sensitive so SDV suppresses its query text and row data from every operator-visible surface by substituting ******** for real content (server debug logs, SYS_REQUESTS.QUERYPLAN, Studio "Show Query Plan", KPI events, and query-stats plan dumps). Designed for regulated PII/PHI stores and dynamic-credential lookups.

• CIS-120568:

  • JSON_TABLE permissive column binding: Missing keys return SQL NULL instead of failing the query, keys bind by name across out-of-order documents, and empty array/object paths produce zero rows without error.

  • COSTREAM ARRAYS: Sibling arrays of unequal length use max length with NULL-padding for shorter columns, scalar and array mixed rows align transparently, and null elements pass through as SQL NULL.

  • Opt-in exception suppression for JSON functions: Introduced server setting /server/sql/overrides/jsonFunction/suppressExceptions (default false) and per-query option SELECT { option "SUPPRESS_JSON_FUNCTION_EXCEPTIONS" = "true" } ... to return SQL NULL instead of raising exceptions for JSONPATH, JSON_EXTRACT, and JSON_EXTRACT_SCALAR.

  • Strict validation: Duplicate JSON field names within a single JSON_TABLE row are now rejected.

• CIS-120570:

  • JSON_TABLE: NULL input now returns an empty cursor instead of throwing an error, and bare [] / {} payloads (with or without leading whitespace) are correctly parsed as JSON containers.

  • JSON_OBJECT, JSON_OBJECTAGG, JSON_ARRAY, JSON_ARRAYAGG: Correctly compose interleaved scalar and JSON-typed arguments.

  • REST/JSON web-service responses: String fields are no longer double-quoted, and JSON-typed columns emit as JSON payloads rather than re-encoded string literals.

• CIS-120751: Fixed an issue where, after upgrading to 8.9.0, expanding certain metadata paths in Studio (e.g., <server> (/) > policy) failed with a serialization error, preventing the resource tree from loading.

• CIS-120827: Provided missing translations for untranslated tooltips in Flow Editor.

• CIS-120828: Fixed an exception in the JDBC driver when using an encrypted connection.

Previous Release: SDV 8.9.0 HF-003

(Note: All resolutions listed below are already included in the latest cumulative HF-004 package)

• Direct Download Link: Download SDV 8.9.0 HF-003

Resolved Issues in HF-003

• CIS-120188: Fixed an issue where System table annotations were intermittently missing or blank in non-English locales where translated files were unavailable. The server now gracefully falls back to English annotations, ensuring descriptions remain visible.

• CIS-120266: Updated the TOSTRING function to successfully accept TIMESTAMP and DATE arguments.

• CIS-120363: Resolved a Studio localization bug where the UI could remain stuck in the operating system language even after English was explicitly selected.

• CIS-120420: Fixed an issue where performing an in-place upgrade from SDV 8.8.1 to 8.9 left out the /lib/report and /metrics root directories from the repository. Both directories and their contents are now correctly created during upgrade routines.

• CIS-120421: Resolved an oversight where the monthly Deployment Report email could not be disabled without impacting the Global Server Email configuration. A new independent configuration property has been introduced: /server/processing/triggers/deploymentReportEnabledOnServerRestart. Setting this to false and restarting the server disables the trigger (/lib/report/GenerateDeploymentReportTrigger) cleanly.

• CIS-120486: Fixed a NullPointerException involving KPI metrics when data is flushed.

• CIS-120487: Resolved geospatial function mapping errors in jdbc.yaml by restoring the missing argument_in_order key to affected functions.

• CIS-120505: Addressed high data storage consumption caused by KPI Metrics persisting heavy query plans in the queryplan column of the metrics_requests table. To disable query plan persistence, navigate to: Server -> Runtime Processing Information -> Requests -> Query Plan in system table SYS_REQUESTS and KPI Metrics table metrics_requests.

Previous Release: SDV 8.9.0 HF-002

(Note: All resolutions listed below are already included in the latest cumulative HF-004 package)

• Direct Download Link: Download SDV 8.9.0 HF-002

Resolved Issues in HF-002

• CIS-119615: Fixed a 500 Internal Server Error triggered when REST, OData, or SOAP API URL paths contained Chinese (non-ASCII) characters.

• CIS-119850: Disabled access to the Spark Web UI console to patch a reported security vulnerability.

• CIS-120045: Enhanced Workload Management visibility; when a SQL request hits a Memory rule, the query plan will now explicitly output the rule's name and memory restrictions (e.g., Shared memory: 128850 (125.83 KB) workload memory rule: <rule_name>).

• CIS-120047: Introduced generic Geometry data type support at the CIS server layer to achieve uniform data handling across DST adapters.

Installation Instructions

• The downloaded .zip archive contains a comprehensive README text file. Please refer to it for step-by-step installation instructions, environment prerequisites, and component-specific deployment workflows.

This article provides a centralized tracking list for hotfixes released for Spotfire Data Virtualization (SDV) version 8.9.0.