Known issues and limitations for Data Virtualization
The following known issues and limitations apply to Data Virtualization.
For additional solutions to problems that you might encounter with Data Virtualization, see the troubleshooting topic Troubleshooting the Data Virtualization service.
- General issues
- The following general issue impacts Data Virtualization users.
- Audit issues
- The following issues and limitations apply to audit issues in Data Virtualization.
- Data source and connection issues and limitations
- For information about limitations and known issues that apply to data sources and connections, see Limitations and known issues for data sources in Data Virtualization.
- Installation and upgrade issues
- The following issue applies to installing and upgrading Data Virtualization. For more information, see Installing Data Virtualization and Upgrading Data Virtualization.
- Data virtualization issues
- The following issues and limitations apply to virtualization in Data
Virtualization.
- The List view on the Virtualize page does not consistently display tables or views
- Querying an object that uses double quotation marks (") in its name fails with an external authorizer error
- Publishing an object that uses double quotation marks in its name (") fails with SQL0010N error
- The virtualization status might be stuck in the Virtualize data page even after virtualization is complete
- Data Virtualization jobs that start at 1PM UTC fail
- Previewing Cloud Object Storage (COS) data might cause a "This flat file is invalid" error
- Some protected objects might intermittently not display a lock icon in the web client
- Recreating virtualized tables after using the DROP NICKNAME SQL statement results in object already exists error
- Data that is virtualized with double-byte coded character sets and special characters might appear truncated
- You cannot use special characters such as semicolons in schema names when you virtualize a table in MongoDB on Cloud
- Virtualizing a table with many columns or long column names might fail
- User and group management issues
- The following issues and limitations apply to user and group management in Data Virtualization. For more information about user and group management, see Virtualizing data.
- Data governance issues
- The following issues and limitations apply to data governance in Data
Virtualization.
- Limited governance support for object or schema names that contain the slash (/), backslash (\) or both characters
- RCAC data protection rules are not applied to a view if both Deny access and masking IBM Knowledge Catalog rules are applied to the table referenced by the view
- You cannot apply business terms when you virtualize files in data sources on the Files tab
- You cannot see business term assignments or grouped tables in the Explore view
- Cannot see list of available tables in the strict virtualization mode
- A virtualized object cannot be used in Cognos Dashboards without credentials and an appropriate role
- Caching issues
- The following issues and limitations apply to caching in Data Virtualization.
- File issues
- The following issues and limitations apply to files in Data Virtualization.
General issues
- Users cannot log out from the Data virtualization interface
-
Applies to: 5.1.0 and later
Audit issues
- Audit log entries might not be forwarded to the zen-audit service
-
Applies to: 5.1.0 and later
- SQL statement text is not logged
-
Applies to: 5.1.0 and later
Data source and connection issues
- For information about limitations and known issues that apply to data sources and connections, see Limitations and known issues for data sources in Data Virtualization.
Data virtualization issues
- The List view on the Virtualize page does not consistently display tables or views
- Querying an object that uses double quotation marks (") in its name fails with an external authorizer error
- Applies to: 5.1.2
- Publishing an object that uses double quotation marks in its name (") fails with SQL0010N error
-
Applies to: 5.1.0 and later
- The virtualization status might be stuck in the Virtualize data page even after virtualization is complete
-
Applies to: 5.1.0 and later
When you navigate to the Virtualize page and then virtualize an object in the Files tab, the virtualization status for that object on the Virtualized data page might be stuck in
Started
even after the process completes.Workaround: Refresh the Virtualized data page.
- Data Virtualization jobs that start at 1PM UTC fail
-
Applies to: 5.1.2
- Previewing Cloud Object Storage (COS) data might cause a "This flat file is invalid" error
- Some protected objects might intermittently not display a lock icon in the web client
- Recreating virtualized tables after using the DROP NICKNAME SQL statement
results in
object already exists
error
- Data that is virtualized with double-byte coded character sets and special characters might appear truncated
-
Applies to: 5.1.0 and later
- You cannot use special characters such as semicolons in schema names when you virtualize a table in MongoDB on Cloud
-
Applies to: 5.1.0
- Virtualizing a table with many columns or long column names might fail
-
Applies to: 5.1.0 and later
Installation and upgrade issues
- Alert monitor is unable to detect the data policy service (DPS) during instance upgrade to IBM Cloud Pak® for Data 5.1.2
- Applies to: 5.1.2 and later
- Pre-backup phase fails when upgrading Data Virtualization from IBM Cloud Pak for Data 4.8.x to 5.1.2
- Applies to: 5.1.2 and later
- Data Virtualization instance is unavailable and the web client is disabled after you upgrade from IBM Cloud Pak for Data 4.8.8 to IBM Software Hub 5.1.1
- Applies to: 5.1.1
- Upgrading existing Cloud data source connections to Data Virtualization on Cloud Pak for Data version 5.1.0 causes certificate errors
- Upgrading remote connectors to IBM Cloud Pak for Data version 5.1.0
results in an
Unable to initialise GaianNode data (aborting)
error -
Applies to: 5.1.0 and later
- Db2REST pod in
CrashLoopBackOff
state -
Applies to: 5.1.0 and later
User and group management issues
- Privileges and authorities that are granted to user groups are not considered when you create views
-
Applies to: 5.1.0 and later
Data governance issues
- Limited governance support for object or schema names that contain the slash (/), backslash (\) or both characters
- RCAC data protection rules are not applied to a view if both Deny access and masking IBM Knowledge Catalog rules are applied to the table referenced by the view
- You cannot apply business terms when you virtualize files in data sources on the Files tab
-
Applies to: 5.1.0
- You cannot see business term assignments or grouped tables in the Explore view
-
Applies to: 5.1.0
- Cannot see list of available tables in the strict virtualization mode
-
Applies to: 5.1.0
- A virtualized object cannot be used in Cognos Dashboards without credentials and an appropriate role
-
Applies to: 5.1.0
Caching issues
- Online backup of Data Virtualization can affect cache refreshes
-
Applies to: 5.1.0
File issues
- You cannot preview long string values in headings in CSV, TSV, or Excel files
-
Applies to: 5.1.0 and later
- You might encounter errors when you virtualize large Excel files
-
Applies to: 5.1.0 and later
- Encoding detection override for files data with Japanese characters
-
Applies to: 5.1.0 and later