23 déc. 2023 — CIS-98477. Doc content is missing for Custom Java Procedures (CJP), please refer to. TDV 8.3 User's Guide for more details on CJP. ... ation update to the ...
The TIBCO Data Virtualization (TDV) 8.5.6 release has three distribution types. One is for on-premises installations that utilize our platform specific ...
TIBCO® Data Virtualization Release Notes Version 8.5.6 | December 2023 Copyright © 2002-2023. Cloud Software Group, Inc. All Rights Reserved. 2 | Contents Contents Contents 2 New in 8.5.6 4 Upgrade Instructions 6 Applying the Service Pack to TDV Server, Studio, and Business Directory 6 To apply a service pack 6 Applying the Service Pack or Hotfix to Active Cluster 10 To Rollback and Downgrade a Service Pack 11 TDV and Business Directory 8.5.6 Fixed Issues 14 Known Issues 21 TDV and Business Directory 8.5.5 Fixed Issues 26 TDV and Business Directory 8.5.4 Fixed Issues 34 TDV and Business Directory 8.5.3 Fixed Issues 44 TDV and Business Directory 8.5.2 Fixed Issues 45 TDV and Business Directory 8.5.1 Fixed Issues 46 TDV and Business Directory 8.5 Fixed Issues 47 TDV and Business Directory 8.4 Fixed Issues 50 Spotfire® Advanced Data Services License Restrictions 54 Jaspersoft® Advanced Data Services License Restrictions 55 TIBCO Data Virtualization for TIBCO CloudTM Metadata - Metadata 56 TIBCO® Data Virtualization Release Notes 3 | Contents Harvesting Limited Edition License Restrictions TIBCO Data Virtualization for Spotfire® Data Science - Team Studio License restrictions 57 TIBCO(R) Data Virtualization AWS Infrastructure License Restrictions 58 AWS Infrastructure 58 Refund Policy 58 TIBCO Documentation and Support Services 59 Release Version Support 60 Legal and Third-Party Notices 62 TIBCO® Data Virtualization Release Notes 4 | New in 8.5.6 New in 8.5.6 The TIBCO® Data Virtualization (TDV) 8.5.6 release has three distribution types. One is for on-premises installations that utilize our platform specific installer binaries or patch archives. The second is for container and Kubernetes runtime environments that use our container distribution (i.e. Docker files and Helm charts). The container distribution can be used in private and public cloud environments (for example, Azure). The third is our AWS Marketplace offering for those that don't want to manage nor host a TDV installation. For more information on the products and components included in TDV, refer to the TDV Installation and Upgrade Guide. For more information on the products and components in Business Directory, refer to the TDV Business Directory Guide. TDV 8.5.6 includes features and enhancements in the following areas: Supported Platforms This release adds support for l Oracle Enterprise Linux 8 l Oracle Enterprise Linux 9 l Red Hat Enterprise Linux 8 l Red Hat Enterprise Linux 9 l Rocky Linux 8 l AlmaLinux 8 l IBM AIX 7.2 l Microsoft Windows Server 2022 Miscellaneous l Upgrade to Java 17 - This version of TDV uses Java 17 l A new field "Security Token" is added to the Salesforce.com Adapter. TIBCO® Data Virtualization Release Notes 5 | New in 8.5.6 l A new configuration option server/web services interface/Keep cursor column name when bare json is true has been added to control whether cursor column name should be printed. l A new option "Overwrite" is added in the Import Resource dialogue in TDV Studio. If selected, resources that have identical names and folder paths will be overwritten. Owner and user privileges are also overwritten. Use this option to guarantee that the new TDV workspace matches the folders and content present in the CAR file. This option clears target folders before copying the CAR file contents to them. l Added support to create and drop text index in Vertica driver. The source table on which the index is to be created must have a primary key and an associated projection. It must also be both sorted and segmented by the primary key TIBCO® Data Virtualization Release Notes 6 | Upgrade Instructions Upgrade Instructions Applying the Service Pack to TDV Server, Studio, and Business Directory Important bug fixes and additional functionality are added to TDV with each service pack. Service packs typically involve careful ordering of procedural steps to make sure appropriate scripts are generated and available, and backup files saved. Notes: l Customers using advanced data source adapters that require OAuth authentication, need to first run TDV as a stand-alone server (no Monitor Daemon), set up OAuth once, and then run TDV with the Monitor Daemon. l Sometimes when running Manager after a service pack install an error message pops up (Unable to finish loading...). You can safely ignore this message, close, and reopen Manager. To apply a service pack 1. Optionally, perform a full TDV and Business Directory backup. For details about backup export, see the TDV Administration Guide or the Business Directory Guide. 2. If installing on Windows, be sure to use Run as Administrator. 3. For Windows, make sure to close any open windows to the repository/jdk folder. 4. Stop all TDV processes, instances, and databases. 5. Download the following TDV 8.5.6 zip files from TIBCO edelivery to the TDV installation directories: l TIB_tdv_server_8.5.6_all.zip (download the server zip file to your server TIBCO® Data Virtualization Release Notes 7 | Upgrade Instructions installation folder.) l TIB_tdv_bd_8.5.6_all.zip (download the BD server zip file to your BD server installation folder.) l TIB_tdv_studio_8.5.6_all.zip (download the studio zip file to your studio installation folder.) Note: If you are upgrading from an earlier 8.3.x or 8.4.x versions of TDV, you do not need to upgrade to 8.5.0 before applying the 8.5.6 service pack. You can directly upgrade to this version of TDV (TDV 8.5.6). 6. Unzip the files. When asked whether to replace the existing files, reply Yes. If you are not asked whether to replace files, the service pack is being extracted to some directory other than <TDV_INSTALL_DIR>. The service pack must be extracted to the appropriate installation directory, and must overwrite files in that directory. 7. Run the following scripts to upgrade your product. Note: When running on a Linux/AIX environment, you will have to grant execute permission on the upgrade scripts. Run the following command to do this: chmod 755 *.sh 8. Enter the repo and cache passwords when prompted. Product TDV Studio TDV Server TDV Business Directory Directory bin bin bin Script studio_upgrade_patch.bat cis_upgrade_patch.<sh|bat> bd_upgrade_patch.<sh|bat> Note: On the windows platform only, if you are upgrading from a pre-8.5 TDV Server installation to TDV Server 8.5 or higher l You need to upgrade your TDV Studio to the same version you upgraded your TDV Server with. l You may encounter an error in the upgrade script when installing the VC_reldist.exe. TIBCO® Data Virtualization Release Notes 8 | Upgrade Instructions When this happens follow these manual steps: i) Open a cmd.exe with "Run as Administrator". ii) cd <TDV_INSTALL_DIR>. iii) Run the following command to delete the repository directory: rd /S /Q repository iv) Run the following command to copy the upgrade repository directory to the appropriate location in the <TDV_INSTALL_DIR>: copy install/<VERSION>/repository repository v)Run the following command to manually execute the VC_reldist.x64.exe file: .\bin\VC_redist.x64.exe vi) Fix any permissions issues or any issues that you might encounter while running step v). vii) Rerun the upgrade script (cis_upgrade_patch.bat) .\bin\cis_upgrade_patch.bat 9. Server and Business Directory only: Perform a monitor restart that is required after upgrading to 8.5.6 For example, composite.bat/sh monitor restart or bd.bat/sh monitor restart Note: Sometimes, the manual restart fails with below error. In this case we need to kill all java processes and start the monitor manually: 07:28:32.914 [main] ERROR com.compositesw.monitor.Monitor - Monitor is already running 07:28:32.940 [main] ERROR monitor.events - 2022-08-09 07:28:32.921 -0700 ERROR FAIL Composite Server Monitor fail 0 system composite 10002 6640221251692 6640221251692 10. (Optional) Follow this step only if you are using the default self signed TDV Server/Studio/Business Directory certificate files and you have upgraded from a TDV 8.3 or TDV 8.4 installation. Note : TDV installers provide default self signed certificates for SSL. We do not recommend using these for production TDV installations. TIBCO® Data Virtualization Release Notes 9 | Upgrade Instructions Now that you have upgraded your TDV Server/Business Directory/Studio to 8.5.6, the following steps will guide you on how to update your TDV self signed certs since you are using them. 1. Stop your TDV Server/Business Directory/Studio processes. Note: you do not need to stop the Postgresql repository (TDV Server/Business Directory) nor cache (TDV Server only) processes. 2. Backup your existing TDV certificates a) TDV Server - backup files under <TDV_INSTALL_ DIR>/conf/server/security/*.jks (cis_server_keystore.jks and cis_server_ truststore.jks) b) TDV Business Directory - backup files under <TDV_INSTALL_ DIR>/conf/server/security/*.jks (cis_server_keystore.jks and cis_server_ truststore.jks) c) TDV Studio - backup files under <TDV_INSTALL_ DIR>/conf/studio/security/*.jks (cis_studio_keystore.jks and cis_studio_ truststore.jks) 3. Replace your TDV certificate files with ones from the latest TDV Server/Business Directory/Studio patch. a) TDV Server - copy <TDV_INSTALL_ DIR>/conf/server/security/installcerts/cis_server_keystore.jks to <TDV_ INSTALL_DIR>/conf/server/security/cis_server_keystore.jks copy <TDV_INSTALL_DIR>/conf/server/security/installcerts/cis_ server_truststore.jks to <TDV_INSTALL_DIR>/conf/server/security/cis_server_ truststore.jks b) TDV Business Server - copy <TDV_INSTALL_ DIR>/conf/server/security/installcerts/cis_server_keystore.jks to <TDV_ INSTALL_DIR>/conf/server/security/cis_server_keystore.jks copy <TDV_INSTALL_DIR>/conf/server/security/installcerts/cis_ server_truststore.jks to <TDV_INSTALL_DIR>/conf/server/security/cis_server_ truststore.jks c) TDV Studio - copy <TDV_INSTALL_ DIR>/conf/studio/security/installcerts/cis_studio_keystore.jks to <TDV_ INSTALL_DIR>/conf/studio/security/cis_studio_keystore.jks copy <TDV_INSTALL_DIR>/conf/studio/security/installcerts/cis_ studio_truststore.jks to <TDV_INSTALL_DIR>/conf/studio/security/cis_studio_ truststore.jks 4. Restart TDV Server/Business Directory/Studio processes. TIBCO® Data Virtualization Release Notes 10 | Upgrade Instructions To rollback the service pack that you just applied, refer to To Rollback and Downgrade a Service Pack. Applying the Service Pack or Hotfix to Active Cluster When updating Active Cluster, it is critical that clusterid remain unchanged. Changing it can adversely affect cached data. These instructions are guidelines developed from testing with a two node Active Cluster environment. To upgrade with scheduled system downtime 1. Determine and note the clusterid, so that it can remain unchanged. 2. Make sure that the cluster is in sync. That is, make sure both nodes are in the cluster and are functional. 3. Disable any cache refreshes on both of the nodes. 4. Configure the load balancer to stop sending traffic to node 1. Shutting down node 1 would cause in-flight requests to fail. 5. Remove node 1 from the cluster. 6. If your TDV products are running, stop them, including all processes and databases used as repositories or caches. 7. Apply the service pack or hot fix to node1. 8. Start up node 1, and re-join the cluster. 9. Configure the load balancer to send traffic to node 1 instead of node 2. 10. Remove node 2 from the cluster. 11. If your TDV products are running, stop them including all processes and databases used as repositories or caches. 12. Apply the service pack or hot fix to node 2. 13. Startup node 2 and rejoin cluster. TIBCO® Data Virtualization Release Notes 11 | Upgrade Instructions 14. Enable cache refreshes on both of the nodes. 15. Verify the cluster status. To Rollback and Downgrade a Service Pack 1. If working on Windows, any open windows to the repository or jdk folder must be closed. 2. Make sure that the TDV Server is stopped. composite.<bat|sh> monitor stop Note: To check if the Monitor daemon has stopped completely, check for the "Bye" message in cs_server.log. 3. Start the TDV Server back up without the monitor, by running the following command: composite_server.<bat|sh> run 4. You will be unable to downgrade your TDV version directly to an 8.3.x or 8.4.x version . You have to downgrade the TDV repository first to the corresponding 8.x release and then apply the upgrade patches accordingly. To downgrade your TDV repository version to 8.3.x run the following command: bin/server_util.bat/sh -server localhost -port 9400 -user xyz_admin password <TDV ADMIN PASSWORD> -rollbackRepository -toVersion 8.3.0 To downgrade your TDV repository version to 8.4.x run the following command: bin/server_util.bat/sh -server localhost -port 9400 -user xyz_admin password <TDV ADMIN PASSWORD> -rollbackRepository -toVersion 8.4.0 5. Run the rollback script located in the following directories: Note: Stop all java processes if they are running. TDV Server: <TDV_INSTALL_DIR>/install/rollback_TIB_tdv_server_<product version>.<service pack number>_all.<bat|sh> TDV Studio: <TDV_INSTALL_DIR>/install/rollback_TIB_tdv_studio_<product version>.<service pack number>_all.bat Business Directory: TIBCO® Data Virtualization Release Notes 12 | Upgrade Instructions <TDV_INSTALL_DIR>/bd/install/rollback_TIB_tdv_bd_<product version>.<service pack number>_all.<bat|sh> 6. Run the downgrade script located in the following directories: TDV Server: <TDV_INSTALL_DIR>/bin/cis_downgrade_patch.sh\bat TDV Studio: <TDV_INSTALL_DIR>/bin/studio_downgrade_patch.bat) Business Directory: <TDV_INSTALL_DIR>/bin/bd_downgrade_patch.sh\bat 7. Navigate to <TDV_INSTALL_DIR> and reapply the last service pack. After rollback it is necessary to apply the previous version of service pack before starting the server. 8. (Optional) Only follow this step if you updated the default self signed TDV Server/Studio/Business Directory certificate files for your previous 8.X upgrade. Replace your existing TDV certificates with your previous backup of them. a) TDV Server - copy your backup jks files to <TDV_INSTALL_ DIR>/conf/server/security/ (For example, cis_server_keystore.jks and cis_server_ truststore.jks) b) TDV Business Directory - copy your backup jks files to <TDV_INSTALL_ DIR>/conf/server/security/ (For example, cis_server_keystore.jks and cis_server_ truststore.jks) c) TDV Studio - copy your backup jks files to <TDV_INSTALL_ DIR>/conf/studio/security/ (For example, cis_studio_keystore.jks and cis_studio_ truststore.jks) 9. Start the Monitor Daemon. For TDV: composite.<bat|sh> monitor start For BD: bd.<bat|sh> monitor start In the server.log, verify that the version is the target version you intended. Notes: a. In case the server doesnt start or server logging hasn't started after downgrade, you have to manually edit the following files: l conf/server/log4j2.properties(server) TIBCO® Data Virtualization Release Notes 13 | Upgrade Instructions l bd\conf\log4j2.properties(bd) and replace '/dv/dev/projects/CI_workspace/build" with your install directory path <TDV_INSTALL_ DIR>. b. While downgrading from 8.8.X to 8.6.X , doing the above steps still might not start the server. In that case, check if the file jettison-1.3.jar is missing in the folder apps/common/lib. If it is missing, you need to manually copy the file from an earlier TDV 8.5.5 install (or below in TDV 8.5.x) or an 8.6.x install. 10. Restart the Monitor Daemon. For TDV: composite.<bat|sh> monitor restart For BD: bd.<bat|sh> monitor restart TIBCO® Data Virtualization Release Notes 14 | TDV and Business Directory 8.5.6 Fixed Issues TDV and Business Directory 8.5.6 Fixed Issues The following issues are fixed in this version of TIBCO® Data Virtualization. Key CIS-92186 CIS-97608 CIS-99480 CIS-100753 CIS-101456 Summary Fixed driverConfig to avoided spurious checks that resulted in issues when calling -configDsn and -installDriver at the same time. Privileges of data source resources were getting modified when new tables were added using multi-table caching option. This causes the permissions on the cache database to be revoked. This issue has been fixed. A new check box Copy privileges from parent container has been added in the DDL dialog. If selected, privileges can be inherited from the parent container (data source or schema) under which the multi-table cache is created. Claim name containing "/" was not honored by the hasClaim and getClaim procedures. This has been fixed. Unable to manually update an existing CJP datasource Url or CLASSPATH. This has been fixed. Users can now use the browse button to fill the url. The Url cannot be manually edited anymore to avoid saving encoded characters such as space in the url string. TDV installs vcredist 2015-2019 that is required for postgres, if user already has it installed, it uses it to initialize postgres. An error occurs if user has 2015-2022 vcrdist installed and TDV tries to install 2015-2019. This has been fixed. TDV now checks if user has 2015-2019 or 2015-2022 and bypasses installation of vcredist and uses what is in the users machine to intialize postgres. When applying a patch, you must make sure that vcredist 2015-2022 is uninstalled before applying patch, otherwise there will be an error. TIBCO® Data Virtualization Release Notes 15 | TDV and Business Directory 8.5.6 Fixed Issues (Continued) Key CIS-103645 CIS-103871 CIS-104254 CIS-105859 CIS-106035 CIS-106047 CIS-106064 CIS106074/CIS107334 CIS-106078 CIS-106166 CIS-106178 Summary HTTP "Host" header injection security vulnerabiltiy is fixed in WebUI. Any malicious "Host" header manipulation is now detected by TDV server and the corresponding HTTP request is rejected with HTTP resonse "400 Bad Requset". To enable this feature TDV server should be configured with proper "Allowed Hosts" setting (Configuration -> Security -> Allowed Hosts). If there were any custom functions created by the user in their TDV environment, those custom functions were getting unchecked after performing an in-place upgrade. This has been fixed. Correct JSON responses will be generated when published resources with different data types are accessed from client tools. Introspection with Snowflake data source throws error "Comparison method violates its general contract". This has been fixed. Resource mappings were saved with empty strings in Deployment Manager. This caused unexpected behavior when opened again. This has been fixed. Postgres process in the server with an INSERT flag was running at 100% cpu usage in one of the nodes in the cluster. This has been fixed. UTF8 encoding has been fixed in TDV jdbc/odbc/ado.net drivers Correct JSON responses will be generated when published resources with different data types are accessed from client tools. Locale/Code Page parameter mentioned on the ODBC driver's configuration pagewas not visible. This has been fixed. SMTP email trigger failed when using port 25/587. This has been fixed. Version check logic has been updated in all TDV docker, docker_k8s and k8s scripts to handle newer versions of docker, kubectl and helm so that a later version of Helm (than 3.4) is honored. TIBCO® Data Virtualization Release Notes 16 | TDV and Business Directory 8.5.6 Fixed Issues (Continued) Key CIS-106218 CIS-106235 CIS-106262 CIS-106269 CIS-106325 CIS-106354 CIS-106356 CIS-106513 CIS-106514 Summary Using the TDV ODBC driver, when a Prepared statement is used to insert into a table with a primary key specified by connecting with ODBC Client, an error occurs when using SQLBindParameter. This has been fixed. Packaged query failed against the snowflake adapter when using the WHERE clause in it. This issues has be been fixed and a new Snowflake adapter is included with this release. The error messages for invalid login from server have been normalized. WebUI: Autocomplete has been set to off for user/password fields in Web UI. Note: If the brower honors it, then the user will not have the ability to auto fill the user/password fields. If the brower doesn't honor TDV settings, then the user could auto fill the user/password fields from the browser's stored passwords Syntax highlighting issues in TDV scratchpad has been fixed. Data Source Toolkit (DST) adapters, including CDATA adapters, can be replaced with another adapter version - i.e. be un-deployed and redeployed without having to restart the TDV server. Requests should not be run against data sources controlled by the adapter during the adapter replacement process. Unable to enter username with only numeral character in row-based security. This has been fixed. With an incorrect encryption password, the import failed with error, but data source jar files in the car file were still imported. This has been fixed. A configuration option server/web services interface/Keep cursor column name when bare json is true has been added to control whether cursor column name is printed when bare json is set as True. if the option is true and bare json is also set as True, then the table cursor will be printed with the column name in the format "column name : value, column name: value,.. " otherwise the table cursor will be printed without the column name in the TIBCO® Data Virtualization Release Notes 17 | TDV and Business Directory 8.5.6 Fixed Issues (Continued) Key CIS-106543 CIS-106596 CIS-106629 CIS-106631 CIS-106680 CIS-106682 CIS-106781 CIS-106785 CIS-106959 Summary format "column value, column value, ...". Syntax highlighting for keywords was not working as expected when used inside brackets. This has been fixed. Functionality has been added to handle special-case characters if they are present in the SAP data source table DD02T. The DATETIME data type returned from a Sybase data source was displayed as received without adjusting the precision. This is now fixed and the returned value is now trimmed to show only 3 numbers in nanoseconds for better user-friendly consumption. Removed unnecessary parameters that caused a connection exception in some Hive versions. "Unable to parse SQL script: Incorrect syntax" error displayed for functions SUBSTR, SUBSTRB, SUBSTRING, DECFLOAT and REPEAT. This has been fixed. A Write failed error is displayed when modifying a committed VCS GitHub resource and committing it again. This error message has been modified to provide more information that will be useful. The following error was displayed when using IsNumeric function and then CAST. This was due to the IsNumeric return true for empty value input and then the CAST being sent an empty value. Data conversion exception - invalid character value to cast '' as 'FLOAT'. [func-3953120] [Log ID: 1dda3b6d-8045-4fd580ba-fc27adc4f0a3]. This has been fixed. Web UI now uses the domain name configured within the TDV server instead of the domain name entered by the end-user in the login screen. This resolves a bug where CASE sensitive queries can cause errors within Web UI when domain name is not in a match CASE. Query execution in Amazon S3 data source was switched to classic engine, TIBCO® Data Virtualization Release Notes 18 | TDV and Business Directory 8.5.6 Fixed Issues (Continued) Key CIS-106974 CIS-107025 CIS-107078 CIS-107082 CIS-107127 CIS-107224 CIS-107292 Summary even though it was explicitly set to use the Parallel Processing engine. This has been fixed. Web UI: Some flows were not displayed in the 'Overview' tab and the 'Data Workbench' tab based on the 'case sensitive' settings. This has been fixed. WebUI: When Accessing TDV via HTTPS, an error was encountered and content was not displayed. This has been fixed. RapidSQL crashed while retrieving NULL data from the TDV server using the Windows ODBC driver. This has been fixed. Single quoted string literals were not recognized in Studio editor. This has been fixed. Fixed issue with JSON_TABLE sql operator. When re-introspection or statistics collection is scheduled through the UI panels in Studio, each execution (i.e. introspection or collection) will occur at only one node at a time in a TDV cluster - instead of running at the same time on all cluster nodes. Multiple executions over a period of time will be assigned across all cluster nodes in a round-robin fashion. After upgrading to TDV 8.4.1, if the Repository is dropped/recreated, TDV fails to start up due to Repository errors. This has been fixed. When performing a dropSchema repo util command to drop the schema, all data in the schema will be deleted. In a patch install, the dropSchema must be done with the current versioned composite_clean script. Restarting server (composite.sh monitor start) will re-create the 8.4.1 schema automatically. There is no need to manually run "createSchema" repo util command. For example, a customer who upgraded to 8.4.1 will run dropSchema as given below: ./bin/repo_util.sh -dropSchema -schemaDropScript conf/repository/postgresql/composite_clean080401001.sql TIBCO® Data Virtualization Release Notes 19 | TDV and Business Directory 8.5.6 Fixed Issues (Continued) Key CIS-107304 CIS-107334 CIS-107374 CIS-107417 CIS-107507 CIS-107613 CIS-107657 CIS-107816 CIS-108715 Summary The file composite_clean is suffixed with the latest version 841. Server needs to be up and running for invoking the dropSchema command. After this step, run composite.sh monitor restart This is required in order to restart the server that will automatically create the latest 841 schema. The file server_files.xml had incorrect path specified. This has been fixed. Correct JSON responses will be generated when published resources with different data types are accessed from client tools. Fixed the BufferedPipe thread leak issues that happen when join queries are interrupted in a cluster environment and the parent thread is terminated. Fixed JSON message encoding processor to handle values and their data types correctly when a published webservice response is obtained using a JSON url Unable to save the changes for SAP, SAP BW, SAP BW BEX adapter properties. This has been fixed. In an LDAP environment with several active user accounts, when a user executing long running queries against the KPI data source is deleted while KPI metrics are getting truncated, the rest of the users were blocked from logging into TDV server. This has been fixed. GoogleAds adapter update will now support API v14. In DB2 datasource, CHAR fields were introspected incorrectly to CHAR(255) irrespective of what the actual length of the field is. This has been fixed. If you encounter the following JVM error: TIBCO® Data Virtualization Release Notes 20 | TDV and Business Directory 8.5.6 Fixed Issues (Continued) Key CIS108938/CIS108960 Summary java.lang.NoClassDefFoundError: Could not initialize class sun.security.jca.ProviderConfig$ProviderLoader Add the JVM flag, by executing the command below: --add-opens java.base/com.sun.crypto.provider=ALLUNNAMED Fixed the ability to restore resource mappings from a DM backup car file. TIBCO® Data Virtualization Release Notes 21 | Known Issues Known Issues The following issues exist in this release of TIBCO® Data Virtualization. Key CIS-92933 CIS-93260 CIS-95625 CIS-96701 CIS-96737 Summary When you set the Studio configuration option "Cursor Fetch Limit" to over 4197 rows, there is a de-serialization error in Studio while saving the results to a .csv file At TDV Server startup, you may see an error such as "Cannot register URI http://www.w3.org/2007/05/xmldsig-more#ripemd160-rsa-MGF1 to class" in the server log. The error does not impact TDV functionality so it may be safely ignored. Column information is not available in TDV Studio grid, when a view is added using modeling unions. To workaround this issue: 1. Put the first table/view in the model before adding the UNION. 2. Switch to the Grid tab and pull down the column information. This only needs to be performed once while creating the view. The column information will be available in the resource grid views after adding other resources, and there will be no exceptions thrown. PostgresSQL adapter cannot identify that a cursor/record type is being returned as the executed function's result. As a result, it cannot return a table as one of the output parameters. SSL handshake between the Excel client (version 2016 and 2019) and TDV which uses a self signed certificate for secure end points (i.e. https) displays a connection error message: "couldn't establish the trust relationship for the SSL/TSL secure channel". TIBCO® Data Virtualization Release Notes 22 | Known Issues (Continued) Key CIS-98163 CIS-98364 CIS-98668 CIS-98477 CIS-98707 CIS-99672 Summary For any site being added in Deployment Manager, if any changes are made and saved, then those changes disappear when user navigates to a different target site and back to the original site. This issue happens only with the 'Containers' tab for any data source under 'Resource Mappings'. To workaround this and see the change made, simply refresh the browser/click on the refresh icon in the DM. When exporting the result dataset from Web UI to a file (csv), only partial data may be exported if the number of rows is greater than 100. When the number zero is entered as the Minimum/Maximum value in the statistics gathering table, "0" it does not displayed. Doc content is missing for Custom Java Procedures (CJP), please refer to TDV 8.3 User's Guide for more details on CJP. The Manual Cardinality Override settings value can only accept 2147483647 as the maximum. This may sometime need to be greater than this value depending on the data volume and currently this value cannot be changed. When using Deployment Manager, Migrate Resources Operation to deploy artifacts containing a cache to another site, choosing the option "Caches for Existing Objects: Re-Create Cache Tables" may throw the following exception: MESSAGE TYPE RuntimeError MESSAGE Cannot create target table(s) '/shared/examples/ds_ orders/tutorial/ViewSales_cache' for resource :'/shared/examples/ViewSales'. Detail Message: Unableto execute "CREATE TABLE "tutorial"."ViewSales_ cache" ( "cachekey" integer NOT NULL, "ProductID"numeric(32, 0), "ProductName" varchar (32768),"CategoryID" numeric(32, 0), "CategoryName" varchar(32768), "ProductDescription" varchar TIBCO® Data Virtualization Release Notes 23 | Known Issues (Continued) Key CIS-101378 CIS-102734 CIS-103395 CIS-103438 CIS-105247 CIS-106240 CIS-106448 CIS-106640 Summary (32768),"SerialNumber" varchar(32768), "UnitPrice" numeric(32, 6), "ReorderLevel" numeric(32, 0), "LeadTime"varchar(32768), "Status" varchar(50), "Discount"numeric(12, 2) )" in data source"/shared/examples/ds_orders". SQL State = 42P07 SQLError Code = 0 [data-3911071] - Cause: ERROR:relation "ViewSales_cache" already exists When explicit privileges are given to a group "testgroup" in source site on a view (testgroup does not exist in target), the export plan that contains resource bundle and principal bundle and principal mappings from source to target does not export the explicit privileges to target. When using /services/webservices/system/admin/user/operations/createGroup to add a new group to Active Directory, the new group takes upto 30 minutes to be added. Inconsistencies are seen in the model panel when using the PUT method on the View that was created and edited in SQL tab. The 'group' column in KPI metrics is not populated. Web UI will not display a table when the table name matches it's schema name. Workaround is to either change the table name or corresponding schema name in order for the the table to show in Web UI. Information about the Original owner of a resource is not stored in the system tables in TDV. Packaged query on a RedShift data source fails when attempting to execute the "Copy" command. Some URLs may or may not require a trailing slash ('/') depending on the oauth provider used. TIBCO® Data Virtualization Release Notes 24 | Known Issues (Continued) Key CIS-106840 CIS-106929 CIS-107057 CIS-107204 CIS-107219 CIS-107530 CIS-107649 CIS-107930 CIS-108423 CIS-108556 Summary LastModifedDate field is not updated in the ALL_RESOURCE_ PROPERTIES table. DROP TABLE DDL command fails because of case sensitivity issues. Due to changes in the Twitter API and the service itself, the current Twitter adapter is no longer functional. A future adapter fix will be required to address this. TDV restricts regular and multi-columln IN clause result set to 1000 rows when pushing to Oracle and Oracle does not have any such restrictions for multi-column IN. In a Cluster environment with 2 nodes, there are some limitations as noted below: 1. When you create a data source the second time , the binary files will be copied over to other nodes although that is unnecessary. 2. When you manually edit binary files/xml configuration files in one node, you have to manually copy the changes to other nodes. Using TDV Snowflake adapter v22.0.8626, you will be unable to use WITH clause that contains string comparison in where clause Published Views are not accessible in Web UI when there are over 10000 views. When multiple rules exist in Row based policies and when those policies are used in a group/claim RBS policy with "Row data must satisfy ALL policies listed above", the rule concatenation may be wrong and unexpected results may be obtained. SQLServerException of Catalog view 'fn_listextendedproperty' occurs when using MSSQL adapter to connect to Azure SQL Data Warehouse After installing services on linux using cis_install_services.sh TDV does not TIBCO® Data Virtualization Release Notes 25 | Known Issues (Continued) Key CIS-108844 CIS-108987 Summary read the environment variables (~/.bash_profile) when the services are started using scripts cis.cache.sh, cis.server.sh and cis.repository.sh. When using the docker.io package on Ubuntu Linux, you will encounter a problem when calling the build_tdv_image.sh script. Here is how to work around that issue. 1. Verify that you are using docker.io a) pt list --installed | grep docker.io WARNING: apt does not have a stable CLI interface. Use with caution in scripts. docker.io/jammy-security,now 20.10.21-0ubuntu1~22.04.3 amd64 [installed,upgradable to: 24.0.5-0ubuntu1~22.04.1] 2. To resolve the issue (2 ways to do so): a. Remove --progress BUILD_PROGRESS flag from build_tdv_image.sh script. b. Remove docker.io package and install docker from docker repositiory with this guidance [Install Docker Engine on Ubuntu | Docker Docs|https://docs.docker.com/engine/install/ubuntu/] When querying an Oracle datasource (using Oracle 12 driver specifically), you may get an exception due to missing class "oracle/xdb/XMLType". To workaround this issue, connect to your datasource using the Oracle 19 driver. TIBCO® Data Virtualization Release Notes 26 | TDV and Business Directory 8.5.5 Fixed Issues TDV and Business Directory 8.5.5 Fixed Issues The following issues are fixed in this Service Pack of TIBCO® Data Virtualization. Key CIS-96669 CIS-98751 CIS-99020 CIS-100675 CIS-100710 CIS-100797/CIS-101947 CIS-101095 Summary Fixed XML/SQL encoding and decoding issue when importing a car file from a version control repository (VCS) into TDV server. When creating a CJP datasource , the URL generated by clicking on Browse and choosing a path containing space characters must be edited to change all "%20" characters to " " (space characters) before creating the datasource. Accessing Swagger link for "Published REST Web Service" fails with the error: Fetch error Server Error http://localhost:9490/rest/webservice.json This has been fixed. There was a Memory leak noticed in TDV Studio when moving the columns up and down in the Grid tab of a view. This has been fixed. Capabilities changes have been applied to SybaseIQ data source. JDBC ODBC bridge adapter throws an exception " column label not found"" when connecting to/Introspecting PostgreSQL datasource. This has been fixed. "Client Warning" option has been disabled for the "Request Lifetime Limit" rule in Workload Management as it is not relevant. TIBCO® Data Virtualization Release Notes 27 | TDV and Business Directory 8.5.5 Fixed Issues (Continued) Key CIS-101674 CIS-101750 CIS-101809 CIS-101811 CIS-101928 CIS-102127/CIS-102262 CIS-102330 CIS-102388 CIS-102441 Summary Password could not be updated for an existing Azure Domain. This has bee fixed. Improvements to ADO.NET logger performance. In a Local File System data source, creating 2 tables with the same file name in different schemas throws an exception similar to "[Code: 1906510, SQL State: ] An exception occurred when executing the following query: "CREATE TABLE fileSchema."test1.parquet" (col1 VARCHAR, col2 INTEGER, col3 VARCHAR)". Cause: Table default.test1_46_parquet already exists. You need to drop it first. [Log ID: fd2945c2-ca22-4b80b698-1be8376dfa95] [jdbc-1906510] This has been fixed. Using a Cloud File System datasource, a file was created using the DDL statement CREATE. However it was not dropped when using the DROP statement. This has been fixed. Adapter properties gets printed in the log file as SET statements. This has been fixed. These unnecessary properties will not be displayed anymore in the log file if not explicitly set by the user in the adapter -> advanced tab -> "JDBC connection properties". Composite group User cannot 'Load Data' in Business Directory. This has been fixed. Upgraded Apache Commons Text to 1.10 for CVE-2022-42889. 401 Unauthorized error encountered when accessing an Azure Domain in the Web Manager on the Row-Based Security page when the user name contains '@' character. This has been fixed. Trying to get an Access Token using the Refresh Token using TDV REST adapter, fails with the following error - "OAuth Flow TIBCO® Data Virtualization Release Notes 28 | TDV and Business Directory 8.5.5 Fixed Issues (Continued) Key CIS-102482 CIS-102558 CIS-102600 CIS-102629 CIS-102635 CIS-102841 CIS-47928 CIS-72734 Summary failed. no parameter access_token found in response.". This has been fixed. After setting the memory limit on the workload management to a certain number the first time (Example: 25%), even after updating the percentage to a different number (Example: 70%) on the workload management page, the query is still being limited at the previous set percentage (Example: 25%). This is because the previous value is still cached and is limiting the query execution. This issue has been fixed. After publishing a web REST API using the POST method, the binding location is set as "Query" in the TDV generated swagger content, even though the input variables have been bound to "ENTITY". This is now fixed. When TDV Studio language is set to Japanese, the arguments displayed in the CAST function dialog was incorrect. This has been fixed. The Oracle jdk version has been upgraded to java version "11.0.17" 2022-10-18 LTS in the Windows and Linux environments and to openjdk version "11.0.16.1" 2022-08-12 in the AIX environment. Message body was garbled when an email containing Japanese strings in the subject and message body gets sent from a TDV trigger. This has been fixed. Updated TDV ODBC windows/linux drivers to use openssl 3.0.7 for CVE-2022-3786 and CVE-2022-3602. Enhancements to logger used by ADO.Net. After a drop & re-create of a TDV repository schema, the admin password does not get reset to the most recent password. This TIBCO® Data Virtualization Release Notes 29 | TDV and Business Directory 8.5.5 Fixed Issues (Continued) Key CIS-90072 CIS-91335 CIS-96850 CIS-98010 CIS-98062 CIS-98111 CIS-98320 CIS-98324 Summary has been fixed. In TDV Studio's old Text Editor, when characters were typed in or deleted, the action was not carried out at the cursor position and the user had to change the "display scale and layout" setting to 100%. This has been fixed. The Text Editor has been improved. Some of the key features of this new Text Editor are described in the section New Text Editor for TDV Studio. Unable to connect MS Access using the DSN. This has been fixed. Fixed issue with accessing network files for TDV file data sources. The updateResources API now supports subtype NONE for type DATA_SOURCE. Fixed raw literal value processing issue for SAP data source. It is now possible to use the 'Pass-through login' credentials (if customers need to do so) while using Teradata's 'Enable Fast Load/Fast Export for large table' option when the source and target datasources are different. This makes sure that the insertion operation also occurs with the provided user credentials (pass-through) and not using the default DS credentials when using this specific set of configurations. More concise error message provided for invalid date format. ODBC Windows driver closes the connection when returning CLOB values that exceed 16000 characters. This has been fixed. TIBCO® Data Virtualization Release Notes 30 | TDV and Business Directory 8.5.5 Fixed Issues (Continued) Key CIS-98437 CIS-98439 CIS-98510 CIS-98463 CIS-98705 CIS-98706 CIS-98742 CIS-98745 CIS-98772 CIS-98779 CIS-98830 Summary MongoDB data source was not failing over to other nodes in replica set. This has been fixed in MongoDB version 21.0.7947 and up. Please get new Snowflake adapter from 8.4 or above TDV_adapter_<version>_all.zip hotfix. Resolved duplicate records being inserted into Snowflake tables in Snowflake adapter 21.0.7963. After a deployment using Deployment Manager, the keystore in the Advanced panel on the SOAP data source at the source side would disappear. This has been fixed. Updated Snowflake JDBC driver to version 3.13.5 in Snowflake adapter 21.0.7963.0. Queries from Informatica using ODBC could get stuck in READY state intermittently. This has been fixed. Google BigQuery, Snowflake, and others containing oauthrefreshtoken and oauthverifier token values would get duplicated when the data source was exported, causing the connection to fail. This could cause the car file to bloat when done many times. This issue has been fixed. Fixed NPE during logging to log file. Fixed issue with aggregate function JSON_OBJECTAGG Fixed issue when using PIVOT or UNPIVOT inside a sql script. Fixed: Google BigQuery requests would intermittently return the error "HTTP/2.0 404 Not Found" While refreshing the cache the following error was encountered: "The multi-part identifier "aggrExpr3109.c3117" could not be bound". TIBCO® Data Virtualization Release Notes 31 | TDV and Business Directory 8.5.5 Fixed Issues (Continued) Key CIS-98847 CIS-98869 CIS-93190 CIS-99020 CIS-99024 CIS-99146 CIS-100158 CIS-100372 CIS-100549 CIS-101357 CIS-101570 Summary This has been fixed. Fixed memory leak when running queries. LDAPS users got dropped when "Auto-synchronization" feature is enabled due to a case-sensitive mismatch issue. This has been fixed. TDV would cast a cell that contained the characters "m", "d", "y", "h", or "s" as a Date or Time data type. This has been fixed and these cells will now retain their original Excel data type. Accessing Swagger link for "Published REST Web Service" failed with the error: Fetch error Server Error http://localhost:9490/rest/webservice.json. This has been fixed. Fixed issue related to sso Token exchange process (affected windows driver only). This has been fixed. Support for Connection KeepAlive functionality has been included to the JDBC driver. Support out-of-order data from SAP in wide table queries. Upgraded postgresql JDBC driver to 42.2.26. Improvement to error message generated in ODBC driver when an invalid hostname is used. Improved the error message displayed when the introspection of a datasource fails due to bad host name. Flow names containing emojis resulted in errors while loading data in applications such as Spitfire. This has been fixed. TIBCO® Data Virtualization Release Notes 32 | TDV and Business Directory 8.5.5 Fixed Issues (Continued) Key CIS-101607 CIS-101624 CIS-101686 CIS-101726 CIS-101799 CIS-102252 CIS-102268 CIS-102521 Summary When the result of the EPOCH function was greater than 2147483647 or less than -2147483648 (for example, if the date was greater than 2040-01-01 or less than 1900-01-01), the following exception was encountered "com.compositesw.cdms.webapi.WebapiException: The integer value -62,135,596,800 cannot be cast because it is outside the required range of -2,147,483,648 to 2,147,483,647.". This has been fixed. In a Salesforce SSO adapter, user is unable to introspect resources when the table contains a foreign key. This has been fixed. A new SELECT option "EXPLAIN_TEXT_WIDTH" has been introduced to avoid query result mismatch issues. Any value set in this option will override the server configuration setting explainWidth which is set to 100 characters by default. Unable to introspect Postgresql resource names containing leading/trailing spaces. This has been fixed. Introspecting for resources in Snowflake adapter skipped the Stored Procedures that needs to be added to TDV. This has been fixed. A System exception occurred on the Cloud File System datasource when running DDLs in the specific order CREATE, INSERT, AND DROP. This has been fixed. Query WITH clause not efficiently reused during query execution. A query WITH clause becomes inefficient after subsequent executions. TIBCO® Data Virtualization Release Notes 33 | TDV and Business Directory 8.5.5 Fixed Issues - TIBCO® Data Virtualization Release Notes 34 | TDV and Business Directory 8.5.4 Fixed Issues TDV and Business Directory 8.5.4 Fixed Issues The following issues are fixed in this Service Pack of TIBCO® Data Virtualization. Key Summary CIS-91768 Upgrade TDV ODBC Drivers (Windows/Linux) to use OpenSSL 3.0.5 Upgrade TDV ODBC Driver (AIX) to use OpenSSL 1.1.1q CIS-91810 Fixed the Oracle EBS datasource introspection issues. CIS-92349 NumberFormatException was thrown for published XQuery that has "xs:boolean" data type in REST/JSON response. This is fixed. CIS-95146 Fixed the maximum SQL length alias issue across all data sources that caused unexpected results while pushing the query to the underlying data source. CIS-96671 Added new optional property usable in Connection String Property Name: EnableKeepAlive Property Type: Boolean Default Value: false In DSN Editor UI(ODBC) this property is located under 'connection' tab. When set to true, the driver enables TCP-KeepAlive for the connection. CIS-96849 Fix to the Keystore attached to SOAP datasource which got corrupted intermittently. CIS-97750 A new setting is added to the Snowflake properties YAML which allows literalonly comparisons. TIBCO® Data Virtualization Release Notes 35 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary CIS-97755 In Studio, the Client Secret was not obfuscated in the OAuth 2.0 tab for REST, SOAP, and WSDL data sources. This has been fixed. CIS-97913 Oracle Synonyms w/DB Link were not introspecting for Data Source. This has been fixed. CIS-97937 Snowflake adapter has been updated to include new capability for CurrentDate() support. CIS-97991 Support has been added for $count with $filter in the Odata call. CIS-97994 Fixed Null pointer exception when executing Any to Any transformation. CIS-98139 When connecting to a SOAP data source, use the alias specified in the Advanced > Certificates section if it exists to allow SSL connections. CIS-98411 Introspection for CFS data sources (Amazon S3, Azure Data Lake and Local File Storage) could skip tables whose name contained special characters. This has been fixed. CIS-98455 An 'OAuthGrantType' property has been added to the Salesforce adapter that allows you to set it to 'PASSWORD'. CIS-98456 Support has been added for OAuth via a SharePoint app. This is made available via the 'SharePointOAuth' AuthScheme. You will also need to set OAuthGrantType to 'Client'. Required Connection Properties: AuthScheme=SharePointOAuth InitiateOAuth=GETANDREFRESH OAuthGrantType=CLIENT OAuthClientId OAuthClientSecret CIS-98459 Calling a procedure through the TDV ADO .Net Data provider failed. This has been fixed. TIBCO® Data Virtualization Release Notes 36 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary CIS-98499 An issue causing contention and progressive slowness when many quick requests are sent to TDV has been fixed. CIS-98508 Updated sharepoint adapter to version 21.0.7985.0. CIS-98539 When defining a Column-Based Security with a "Partial String Mask" rule, the suffix value got replaced with "XXX-'," after saving. This is fixed. CIS-98543 TDV Power BI driver has been updated to version 21.0.7942.0 CIS-98576 Column Description in SQL Server is not set as Annotation in TDV. This is fixed. CIS-98592 Using the Redshift adapter under "packages", queries returning large amounts of data may cause memory in TDV to run high and CPU usage to increase. Using settings in the "Other" category in the adapter panel can restrict memory and CPU usage if needed. Below are the recommended settings, but these may be altered depending on your situation. MaxConnectionBuffers=50;FlushSessionBuffersPool=True;CancelPendingStatemen t=True Actions CIS-98709 Fixed the inconsistent behavior of procedures created and published with OData V4. CIS-98716 ADO.Net Data Provider version has been updated to 7997. CIS-98734 backup_export procedure failed with an xception "Given final block not properly padded. Such issues can arise if a bad key is used during decryption.". This has been fixed. CIS-98741 GIT resources disappeared from the repository after republishing. Thi is fixed. CIS-98776 Users without READ privileges on published table were able to retrieve data from that table. This has been fixed. CIS-98787 hasClaim/getClaim procedures return an error when a non existing claim is passed. This specifically happens when the JSON is nested. This has been fixed. TIBCO® Data Virtualization Release Notes 37 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary CIS-98830 While refreshing the cache the following error was encountered: "The multi-part identifier "aggrExpr3109.c3117" could not be bound". This has been fixed. CIS-98836 Fixed alias and position errors caused by SELECT over JOIN and function arguments in aggregate functions. CIS-98912 Fixed "NLS data type mismatch" issues encountered in RBS policy. CIS-98932, Issues with using the built-in procedures hasClaim and getClaim in a nested CIS-98787 JSON has been fixed. CIS-98948 Updated TDV to use log4j 2.17.1. CIS-99036 TDV Oracle adapter has been modified to handle special character column size scenarios. CIS-99040 Attempting to add a new domain in TDV web manager throws "ServerError: Cannot create domain "LdapLocal".external domain information is invalid. [security-1900204]" error. This has been fixed. CIS-99042 TO_DATE and PARSE_DATE functions with format option is not throwing an error when an invalid date is provided as an input. Instead it returns an invalid date such as '2021-02-31'. This has been fixed. CIS-99056 When querying data in Microsoft Excel, the following exception was thrown. "Unable to execute native SQL fetch to create Dataset because it is not able to create java.sql.Statement object. [data-2913120] Cause: Could not find a valid license for using JDBC-ODBC Bridge 2018 on this system." This has been fixed in the JDBCODBC adapter version 21.0.8037.0 and above. CIS-99062 Cached views were not being applied with PIVOT and UNPIVOT operators. You may see this error. "Unable to load data source with id "0" from repository. [datasrc-2940000]" This issue has been fixed. CIS-99105 Fixed Null Pointer Exception in PushableFunctionSplitter when creating execution plan. TIBCO® Data Virtualization Release Notes 38 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary CIS-99209 Fixed encryption error in fast cluster join. CIS-99130 Scalar subquery not initialized in UPDATE statement if target table is a composite view . This has been fixed. CIS-99142 VARCHAR datatypes were not getting properly interpreted in TDV. VARCHAR(16) should be interpreted as VARCHAR with 16 characters. This has been fixed. CIS-99164 Fixed the java.lang.ClassCastException error encountered when creating an execution plan. CIS-99165 Fixed the Null Pointer Exception encountered when executing query with UnionPreggregator. CIS-99194 Fixed issues encountered while generating DEBUG logging for the advanced adapters after enabling the DEBUG property in log4j2 file. CIS-99209 Encryption failures were encountered on the joined node after the sync. This has bee fixed to properly communicate between nodes. CIS99210 The quotes separating the schema name from the index name are missing when a table is created with an index for an Oracle data source when setting up multitable caching. This has been fixed. CIS-99213 Fixed MongoDB adapter to include options "x509" authentication type in the Auth Scheme drop-down list. CIS-99262 AGGREGATE Functions were not being pushed down to MySQL when two functions were used in the same SELECT query. This has been fixed. CIS-99263 If TDV 8.5 ODBC Driver is used to connect to a TDV Server using python as the end client, the client ends the connection with a segmentation fault. This has been fixed. CIS-99332 Fixed the error "Unknown where node type" encountered in Oracle DB when the "WHERE EXISTS" clause in the DELETE statement is from a view. TIBCO® Data Virtualization Release Notes 39 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary CIS-99342 VCS can not be enabled in TDV 8.5 or higher if there has been an in-place upgrade of just the TDV Sever from TDV 8.x to TDV 8.5.0. On the windows platform only, if you are upgrading from a pre-8.5 TDV Server installation to TDV Server 8.5 or higher, you need to upgrade your TDV Studio to the same version you upgraded your TDV Server with. CIS-99376 Functions with large input counts can block if the capability file does not support the function. This has been fixed. CIS-99392 Fixed the missing alias in Fetch node when using $expand in OData V4. CIS-99396 Limit for sql projection aliases has been set to 256 characters for the sql projections that do not have a valid alias. CIS-99403 The TDV ODBC Client throws "Unable to query text" when "Max Text Column Size" parameter is set. This has been fixed. CIS-99404 A new Snowflake adapter is provided to address the "JWT token invalid" error received when authenticating the adapter. CIS-99406 Fixed Role Based Access Control (RBAC) violation in TDV Server for CBS policies. CIS-99429 When the execution plan is generated for a query that contains a function, you may get an error similar to "ERROR: missing FROM-clause entry for table "tExpr6451"". This has been fixed. CIS-99481 Fixed the Query Engine optimization issue. CIS-99490 Columns that returned 0 in the earlier TDV versions were returning NULL in TDV 8.5. This has been fixed. CIS-99554 The users were dropped while enabling "Auto-Sync" in LDAP domain. This has been fixed. CIS-99588 Using a UNIQUEIDENTIFIER in INSERT or UPDATE in Microsoft SQL Server is now supported. This restriction has been removed when using TDV's Data Ship TIBCO® Data Virtualization Release Notes 40 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary functionality. CIS-99640 Fixed GoogleBigQuery adapter timestamp parsing error. CIS-99694 Cannot update the password for the existing LDAP domain if the password contains special characters. CIS-99772 An "Invalid Login attempt" error encountered while changing the login name for the LDAP domain when the password of the user is different. This has been fixed. CIS-99773 If the TDV WebUI Data Catalog consists of an incorrect flow created by one user, then the All Flows section of the Web UI gives a blank screen when used by a different user. This issue has been fixed. CIS-99803 Alias resolution for a query was resulting in the error "missing FROM-clause entry for table". This has been fixed. CIS-99810 CREATE table failed on Amazon Redshift data source due to Double precision column type. This has been fixed. CIS-99840 ClassCastException occured when trying to take a full server backup. This has been fixed. CIS-99841 Query against SAP fails with the error "An error has occurred while parsing a dynamic entry" when the query contains a WHERE clause using characters. This has been fixed. CIS-99871 Functions FIRST and LAST were not working as expected. This has been fixed. CIS-99993 Column and View data are unavailable using authentication type OAuth when using Dynamics CRM adapter. This has been fixed. CIS100034 In a query involving two different SQL servers, a SEMI JOIN caused duplicate rows in the result set. This has been fixed. CIS- Function FIRST VALUE IGNORE NULLS returned incorrect results. This has been TIBCO® Data Virtualization Release Notes 41 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary 100217 fixed. CIS100268 The $filter condition with null values in a OData query failed. This has been fixed. CIS100332 Using the client drivers (JDBC, ODBC and ADO.Net, queries with concurrent calls to server gets hung. This has been fixed. CIS100510 Fixed the exception thrown when using ODBC driver with SQL Server "Linked Services". CIS100593 Upgrade TDV Server, BD and Studio to use Java 11.0.15. Windows - java version "11.0.15" 2022-04-19 LTS Linux - java version "11.0.15" 2022-04-19 LTS AIX - openjdk version "11.0.15" 2022-04-19 CIS100609 Update CosmosDB driver to 21.0.8180.0. CIS100610 Importing a car file failed to re-analyze dependencies and hook the links again, because of a few exceptions encountered in the ImpactApi. This has been fixed. CIS100669 Active Directory adapter has been updated to version 21.0.8133.0. CIS100674 API call cbsGetPolicy failed with an error "value may not null". This has been fixed. CIS100703 Fixed the infinite loop issues in PreparedParser that was caused due to inefficiencies with LEFT parenthesis. CIS100720 Prevented storing any Cross-Site Scripting created while adding rule into the policy of Row-Based-Security in Web Manager. TIBCO® Data Virtualization Release Notes 42 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary CIS100736 Studio's sql editor's "Save To File" option saved incorrect results in the file. This has been fixed. CIS100808 Query containing WITH clause failied with error "The request has been closed. No operations can be performed using it". CIS100811 Fixed issue where cancelling of a query request can take abnormally long. CIS100812 When user.dir is not set and DEBUG is enabled, Deployment Manager throws an exception. CIS100817 When running a request to Google Spread Sheets, you may encounter the exception "User Rate Limit Exceeded. Rate of requests for user exceed configured project quota.". This has been fixed in GoogleSheets adapter version v21.0.8137.0 and later. CIS100886 WITH clause was not pushed down in MySQL datasource. This has been fixed. CIS100999 The Divide operator in TDV did not return the fractional part of the result and returned only the integer part. For Oracle, Hive data sources, this was contrary to the native behavior. This has been fixed. CIS101029 Fixed use case involving non standard identifiers belonging to a WITH clause. Identifiers normally follow the following regular expression: a-zA-Z0-9_$# CIS101094 In Deployment Manager, when a Principal Bundle is deployed, the "all" group is not replicated to the Target. This causes users to lose privileges on resources located under "/services". This has been fixed. CIS101157 The value of Write Timeout Window server configuration setting does not get updated on the node that was joined. This has been fixed. CIS- Queries that ran successfully in a previous release of TDV failed with an error TIBCO® Data Virtualization Release Notes 43 | TDV and Business Directory 8.5.4 Fixed Issues (Continued) Key Summary 101170 "The request has been closed. No operations can be performed using it". This has been fixed. CIS101201 Cassandra adapter has been updated to version 21.0.8160. CIS101227 When using the DATE_TRUNC function in TDV against Oracle, a "Failed query" error was encountered. This has been fixed. CIS101229 Web Manager unable to change the language to japanese even if the browser and localisation is set to Japan. This has been fixed. CIS101237 Exporting a Full Server Backup failed with an decryption error: This has been fixed. CIS101244 Amazon Redshift adapter has been updated to version 21.0.8180. CIS101352 Fixed VCS issue with commit folder names having umlaut characters. CIS101440 The AWS govcloud end points were not listed in the Amazon S3 adapter endpoints list. CIS101546 Upgrading from TDV 8.3 to 8.5.0 failed with CREATE INDEX error "string too long". This has been fixed. TIBCO® Data Virtualization Release Notes 44 | TDV and Business Directory 8.5.3 Fixed Issues TDV and Business Directory 8.5.3 Fixed Issues The following issues are fixed in this Service Pack of TIBCO® Data Virtualization. Key CIS-99406 CIS-99542 CIS-100985 Summary Fixed Role Based Access Control (RBAC) violation in TDV Server for CBS policies. Fixed TDV windows only installer (uninstaller.exe) issues CVE-202122037 and CVE-2021-22038. FastJson was removed from the TDV distribution in 8.5.3. It was a required component in older versions of TIBCO Streaming adapter, but was removed in the newest version. Note: The FastJson library has a known vulnerability CVE-2022-25845, which is fairly severe, but neither TDV nor the Streaming adapter has been vulnerable due to the use of "safe mode" when handling the FastJson library. TIBCO® Data Virtualization Release Notes 45 | TDV and Business Directory 8.5.2 Fixed Issues TDV and Business Directory 8.5.2 Fixed Issues The following issues are fixed in this Service Pack of TIBCO® Data Virtualization. Key CIS-98948 CIS-99023 CIS-99059 CIS-99162 CIS-99238 Summary Updated TDV to use log4j 2.17.1. Removed slf4j-log4j12 dependency for ComputeDB and TibcoStreaming adapters Fixed missing log4j class issue in TDV adapter (cis_ds_distributed). Updated logback software to logback 1.2.10. Added tdv namespace label to tdv.yaml configmap. TIBCO® Data Virtualization Release Notes 46 | TDV and Business Directory 8.5.1 Fixed Issues TDV and Business Directory 8.5.1 Fixed Issues The following issues are fixed in this Service Pack of TIBCO® Data Virtualization. Key CIS-98476 CIS-98743 Summary A new server configuration is added. Set the following configuration value to True if you want to run Custom Java Procedures: Administration -> Configuration -> Data Sources -> CJP -> Enable the ability to run Custom Java Procedures By default this is set to False. This is a change in behavior from the earlier versions of TDV server. If you set this to True, make sure you fully trust the JAR files used for Custom Java Procedures. Note: The Custom Java Procedure JAR file must exist within the directory specified in the Custom Jar Import Directory server configuration (Administration -> Configuration -> Server -> Configuration -> Files -> Custom Jar Import Directory) and must have a .jar extension in the file name. Because of this, it is important to note that once a customer upgrades to 8.3.1, 8.4.1, or 8.5.1, it will be impossible for Custom Java Procedure data sources to have their URLs pointing to a location other than within the Custom Jar Import Directory. To mitigate CVE-2021-44228 ("Log4Shell" zero-day exploit), all bundled log4j2 jar dependencies have been upgraded to log4j 2.17. TIBCO® Data Virtualization Release Notes 47 | TDV and Business Directory 8.5 Fixed Issues TDV and Business Directory 8.5 Fixed Issues The following issues are fixed in the 8.5 release of TIBCO® Data Virtualization. Key CIS-66502 CIS-90344 CIS-91652 CIS-92723 CIS-94227 CIS-94498 CIS-94530 CIS-94531 Summary TDV now supports Oauth2 for published web services (REST, OData) and drivers (JDBC, ODBC and ADO.Net). Couchbase adapter now supports query-passthrough option. Fix to the Studio UI to improve readability when large data is appended in OAuth tab of the data source. The internal PostgreSQL database has been upgraded to PostgreSQL 12.8. On-premises (installers): TDV 8.5 Server and Business Directory now use PostgreSQL 12.8. Docker and Kubernetes: TDV 8.5 Server now uses Postgresql 12.8. Future 12.X updates will automatically be updated for this distribution when the TDV images are rebuilt. Fix for the following issue encoutered while connecting through the ODBC driver, which prevents users from executing queries using DBLINK: ORA-28562: Heterogeneous Services data truncation error Ability to control the max size of the log files (cs_monitor.log and cs_ monitor.out) has been added to the composite.sh/bat files in the linux/windows environments. Support for Binary Literals have been added to TDV 8.5. Fix for not saving the empty PASSWORD_STRING in the new Data TIBCO® Data Virtualization Release Notes 48 | TDV and Business Directory 8.5 Fixed Issues (Continued) Key Summary Source window with asterisks. CIS-94570 Documentation update for the isBlocking parameter set in executeProcudure, executeNativeSql, executeSql, executeSqlScript and executePreparedSql APIs. CIS-94763 TDV now allows customers to disable group synchronization during the login. A built-in procedure is available that can be invoked to manually sync the groups in the Web Manager or create a trigger to sync the groups. CIS-95268 Fix to remove Spike Triggers from the list of system event triggers. CIS-95437 Fix to make HTTP/S Jetty settings (Max/Min Threads, Accept Queue, Max Idle Time) configurable and clean up unused settings CIS-95846 Fix to the monitor service process which failed to start on non-English Windows Operating Systems in TDV Business Directory version 8.4. CIS-95913 Documentation update to clarify the MPP Engine functionality in a cluster environment. CIS-96184/CIS-95834 TDV now supports Table Column Aliases (SQL-92). CIS-96550 Fix for annotation details to not be truncated when using the ODBC driver. CIS-96558 Fix to the functions DATEADD, DATEDIFF and DATEPART to remove mandatory quotes requirement for the first parameter. CIS-96670 Fix for issues encountered while executing UPDATE statements on a Vertica data source with Table alias specified. CIS-96695 Fix to improve Studio login delay when user is part of the Ldap domain group. TIBCO® Data Virtualization Release Notes 49 | TDV and Business Directory 8.5 Fixed Issues (Continued) Key Summary CIS-96742/CIS-97539 Fix for an intermittent ADO.NET connection failure. CIS-96915 Fix for retaining the double quotes around the datasource path in the opt file. CIS-96955 Fix to address a change in the published procedure type with an OUT parameter in TDV 8.3 which created functions instead of procedures in Cognos client. CIS-97178 Fix for the permission issues seen in the shell script files when applying hotfix. CIS-97269 Documentation fix with updated links to retrieve the driver for Oracle adapter. CIS-97544 Fix to the site refresh operation in Business Directory. CIS-97577 Fix for loading special characters from UTF-8 file when using Informatica data source. CIS-97624 Fix to not default the ClientSystemUserID to "SYSTEM". CIS-97663 Fix for performance issues while using nested loops. CIS-98157 Fix to support ISNUMERIC() function like the SQL Server implementation CIS-98290 Fix for a data corruption issue when a correlated scalar subquery is within a CASE expression. TIBCO® Data Virtualization Release Notes 50 | TDV and Business Directory 8.4 Fixed Issues TDV and Business Directory 8.4 Fixed Issues The table below lists the issues fixed in TDV 8.4 release. 8.4 Fixed Issue CIS-72933 CIS-88735 CIS-90204 CIS-91980 CIS-92135 CIS-92354 CIS-92402 CIS-92597 CIS-92732 Summary Fix to display a descriptive database error from the underlying TDV drivers to the end user. Fix to enable SSL Mutual authentication login. Support For DDL clauses for Vertica and Teradata Drill temp directory now shares TDV temp directory. Fix to enable creation of Column Based Security rules on a group containing users from two different domains (for example, Composite and LDAP). Documentation update for the "FORCE_ESTIMATION" option in Reference Guide > TDV Query Engine Options Fix for the alternateSecurityCredentials property map that is used to pass down the OAuthAccessTokenProperty to be processed accurately using the PowerBI data connector. Documentation update to the pkg_import command line utility specification about partially introspecting a view from a CAR file. Fix for Thai language supported fonts not displaying correctly in Studio. Follow these steps to add the selected fonts to the Studio properties: 1. Set the font to Tahoma or a Thai-language supported font in Studio > Edit > Options > Default Font 2. Set the font to Tahoma or a Thai-language supported font in Studio > TIBCO® Data Virtualization Release Notes 51 | TDV and Business Directory 8.4 Fixed Issues (Continued) 8.4 Fixed Issue CIS-92783 CIS-92903 CIS-92905 CIS-92959 CIS-92992 CIS-93006 CIS-93087 CIS-93088 CIS-93089 CIS-93098 CIS-93173 CIS-93199 Summary Edit > Editors > Font 3. Restart Studio. Fix for the error encountered while running SOAP Transformation into Relational Data TDV pkg_import.sh when using options file throwing the error "Cannot set an attribute "path" on resource" Support for Boolean and BIT data types in CBS Policy assignments. Fix for Power BI driver failure for user with password that contains special characters Fix for the Odata $expand function failure. Fix for issues encountered while importing external tables from Amazon Redshift into TDV. Fix for issues encountered when trying to make an OData call with one master entity to 2 child entities having the same column names. Fix for issues encountered in response data when we using $expand=* for the entities that have 2 foreign keys. Fix for the Odata $expand function incorrect behavior. Fix for error encountered when executing plan using Curl from Deployment Manager. Fix for issues encountered while rendering a multi-level expand containing a 1-to-many relationship. Fix for issues encountered with the OData expand functionality while using filters on nested/expanded entities, which causes invalid results. TIBCO® Data Virtualization Release Notes 52 | TDV and Business Directory 8.4 Fixed Issues (Continued) 8.4 Fixed Issue CIS-93431 CIS-93439 CIS-93496 CIS-93556 CIS-93893 CIS-94103 CIS-94187 CIS-94202 CIS-94310 CIS-94508 CIS-94580 Summary Fix for the error message "unknown operator: $query" while fetching data from Azure CosmosDB 3.6 using MongoDB adapter in TDV. Documentation update for the missing content of the Advanced Tab field columns. Fix for issues encountered while generating alias in SQL Server query. Fix for issues encountered while connecting to TDV 8.3 ODBC using the unixODBC driver manager. Fix for issues encountered when importing CAR files containing columns with NULL/no names. Fix for issues seen in GoogleBigQuery Adapter returning NULL records with certain WHERE clauses or with force_parallel option when data is large. Fix for issues seen when using TDV SQL Reserved Keywords as column names in views published via OData. Implemented performance settings for certain frequently updated repository tables such as security_privileges and metadata_attributes tables. Power BI related performance improvements for a TDV published resource. Fix for the XML parser decrypting character code as character (_x003a_ to ":") in table name using updateSqlTable API In some situations, you may get an exception when using MAX/MIN/ SUM (literal) aggregates. The exception may be similar to this: "The integer value 1,121 cannot be cast because it is outside the required range of 0 to 0" TIBCO® Data Virtualization Release Notes 53 | TDV and Business Directory 8.4 Fixed Issues (Continued) 8.4 Fixed Issue CIS-94588 CIS-94765 CIS-95031 CIS-95095 CIS-95442 CIS-95846 CIS-95899 Summary This issue has been fixed. In an XSLT Transformation, if the schema of the source contains a "choice" element, the XSL code for the XSLT resource may be incorrect, resulting in empty or missing elements in the result set. This has been fixed. Doc update: Transaction Isolation appears be incorrectly described as a proxy-based firewall setting Fix for exception handling while executing SQL Script procedures. Doc update: Column-Level restrictions set in TDV has the same behavior when a resource is accessed through a client interface, whether the selected resource is a table or a view. In TDV Server version 8.4, the monitor service process failed to start on non-English Windows Operating Systems. This has been fixed. In TDV Business Directory version 8.4, the monitor service process failed to start on non-English Windows Operating Systems. This has been fixed. The server_values.xml has incorrect path and causes the Business Directory 8.4 installation to fail. This has been fixed. TIBCO® Data Virtualization Release Notes 54 | Spotfire® Advanced Data Services License Restrictions Spotfire® Advanced Data Services License Restrictions If you are licensing TIBCO® Data Virtualization as Spotfire® Advanced Data Services (formerly known as TIBCO Spotfire® Advanced Data Services), you can publish views from all supported data sources to Spotfire® via JDBC, ODBC and ADO.NET except the following which are sold as separate license add-ons · Oracle E-Business Suite · Salesforce.com · SAP Business Warehouse · SAP ERP · Siebel eBusiness Applications Use of the business directory or clustering requires a full license to TIBCO Data Virtualization. A full TIBCO Data Virtualization license is also required for publishing views as web services or to clients that are not Spotfire® clients. TIBCO® Data Virtualization Release Notes 55 | Jaspersoft® Advanced Data Services License Restrictions Jaspersoft® Advanced Data Services License Restrictions If you are licensing TIBCO Data Virtualization as Jaspersoft Advanced Data Services (formerly known as TIBCO Jaspersoft® Advanced Data Services), you can publish views from all supported data sources to Jaspersoft via JDBC, ODBC and ADO.NET. Use of the business directory or clustering requires a full license to TIBCO Data Virtualization. A full TIBCO Data Virtualization license is also required for publishing views as web services or to clients that are not Jaspersoft. TIBCO® Data Virtualization Release Notes 56 | TIBCO Data Virtualization for TIBCO CloudTM Metadata - Metadata Harvesting Limited Edition License Restrictions TIBCO Data Virtualization for TIBCO CloudTM Metadata - Metadata Harvesting Limited Edition License Restrictions If you are licensing TIBCO Data Virtualization as TIBCO Data Virtualization for TIBCO CloudTM Metadata - Metadata Harvesting Limited Edition, you can (re)introspect all supported data sources to retrieve metadata and provide them to TIBCO CloudTM Metadata via Web services. A full TIBCO Data Virtualization license is required for use of the business directory, clustering or provisioning data as well as publishing views as web services or publishing to any destination other than TIBCO Cloud Metadata. If you want to upgrade from TIBCO Data Virtualization for TIBCO Cloud Metadata Metadata Harvesting Limited Edition to a full TIBCO Data Virtualization license, you need to license TIBCO Data Virtualization for TIBCO Cloud Metadata - Upgrade to TIBCO Data Virtualization. TIBCO® Data Virtualization Release Notes 57 | TIBCO Data Virtualization for Spotfire® Data Science - Team Studio License restrictions TIBCO Data Virtualization for Spotfire® Data Science - Team Studio License restrictions When licensed as part of Spotfire Data Science - Team Studio (formerly known as TIBCO Spotfire® Data Science - Team Studio), TIBCO Data Virtualization access is only allowed from the Spotfire Data Science - Team Studio Server. A full TIBCO Data Virtualization license is required for use of the Business Directory, clustering or provisioning data as well as publishing views as web services, or publishing to any destination other than Spotfire Data Science - Team Studio. TIBCO® Data Virtualization Release Notes 58 | TIBCO(R) Data Virtualization AWS Infrastructure License Restrictions TIBCO(R) Data Virtualization AWS Infrastructure License Restrictions Following are the TDV offerings in the AWS Marketplace: l TIBCO Data Virtualization for Windows (Hourly) l TIBCO Data Virtualization for Windows (BYOL) l TIBCO Data Virtualization for Red Hat Linux (BYOL) l TIBCO Data Virtualization for Red Hat Linux (Hourly) TIBCO Software provides 24x7, award-winning support services along with uninterrupted access to TIBCO Data Virtualization updates. This requires purchase of a support contract or a software subscription that includes support. Please refer to your maintenance terms for further details. https://www.tibco.com/resources/terms-and-policies/tibco-maintenanceterms AWS Infrastructure AWS Support is a one-on-one support channel that is staffed 24x7x365 with experienced support engineers. AWS Support offers four support plans: Basic, Developer, Business, and Enterprise. The Basic plan is free of charge and offers support for account and billing questions and service limit increases. The other plans offer an unlimited number of technical support cases with pay-by-the-month pricing and no long term contracts, providing the level of support that meets your needs. Learn more Refund Policy Refunds are not provided, but you can cancel at any time by terminating your instance and canceling the subscription on the Marketplace Portal. TIBCO® Data Virtualization Release Notes 59 | TIBCO Documentation and Support Services TIBCO Documentation and Support Services For information about this product, you can read the documentation, contact TIBCO Support, and join TIBCO Community. How to Access TIBCO Documentation Documentation for TIBCO products is available on the Product Documentation website, mainly in HTML and PDF formats. The Product Documentation website is updated frequently and is more current than any other documentation included with the product. Product-Specific Documentation Documentation for TIBCO® Data Virtualization is available on the TIBCO® Data Virtualization Product Documentation page. The following documents for this product can be found in the TIBCO Documentation site: Users TDV Getting Started Guide TDV User Guide TDV Client Interfaces Guide TDV Tutorial Guide TDV Northbay Example Administration TDV Installation and Upgrade Guide TDV Administration Guide TDV Active Cluster Guide TDV Security Features Guide Data Sources TIBCO® Data Virtualization Release Notes 60 | TIBCO Documentation and Support Services TDV Adapter Guides TDV Data Source Toolkit Guide (Formerly Extensibility Guide) References TDV Reference Guide TDV Application Programming Interface Guide Other TDV Business Directory Guide TDV Discovery Guide TIBCO TDV and Business Directory Release Notes - Read the release notes for a list of new and changed features. This document also contains lists of known issues and closed issues for this release. Release Version Support TDV 8.5 is designated as a Long Term Support (LTS) version. Some release versions of TIBCO Data Virtualization products are selected to be long-term support (LTS) versions. Defect corrections will typically be delivered in a new release version and as hotfixes or service packs to one or more LTS versions. See also TIBCO Data Virtualization Long-Term Support (LTS) Releases. How to Contact Support for TIBCO Products You can contact the Support team in the following ways: l To access the Support Knowledge Base and getting personalized content about products you are interested in, visit our product Support website. l To create a Support case, you must have a valid maintenance or support contract with a Cloud Software Group entity. You also need a username and password to log in to the our product Support website. If you do not have a username, you can request one by clicking Register on the website. TIBCO® Data Virtualization Release Notes 61 | TIBCO Documentation and Support Services How to Join TIBCO Community TIBCO Community is the official channel for TIBCO customers, partners, and employee subject matter experts to share and access their collective experience. TIBCO Community offers access to Q&A forums, product wikis, and best practices. It also offers access to extensions, adapters, solution accelerators, and tools that extend and enable customers to gain full value from TIBCO products. In addition, users can submit and vote on feature requests from within the TIBCO Ideas Portal. For a free registration, go to TIBCO Community. TIBCO® Data Virtualization Release Notes 62 | Legal and Third-Party Notices Legal and Third-Party Notices SOME CLOUD SOFTWARE GROUP, INC. ("CLOUD SG") SOFTWARE AND CLOUD SERVICES EMBED, BUNDLE, OR OTHERWISE INCLUDE OTHER SOFTWARE, INCLUDING OTHER CLOUD SG SOFTWARE (COLLECTIVELY, "INCLUDED SOFTWARE"). USE OF INCLUDED SOFTWARE IS SOLELY TO ENABLE THE FUNCTIONALITY (OR PROVIDE LIMITED ADD-ON FUNCTIONALITY) OF THE LICENSED CLOUD SG SOFTWARE AND/OR CLOUD SERVICES. THE INCLUDED SOFTWARE IS NOT LICENSED TO BE USED OR ACCESSED BY ANY OTHER CLOUD SG SOFTWARE AND/OR CLOUD SERVICES OR FOR ANY OTHER PURPOSE. USE OF CLOUD SG SOFTWARE AND CLOUD SERVICES IS SUBJECT TO THE TERMS AND CONDITIONS OF AN AGREEMENT FOUND IN EITHER A SEPARATELY EXECUTED AGREEMENT, OR, IF THERE IS NO SUCH SEPARATE AGREEMENT, THE CLICKWRAP END USER AGREEMENT WHICH IS DISPLAYED WHEN ACCESSING, DOWNLOADING, OR INSTALLING THE SOFTWARE OR CLOUD SERVICES (AND WHICH IS DUPLICATED IN THE LICENSE FILE) OR IF THERE IS NO SUCH LICENSE AGREEMENT OR CLICKWRAP END USER AGREEMENT, THE LICENSE(S) LOCATED IN THE "LICENSE" FILE(S) OF THE SOFTWARE. USE OF THIS DOCUMENT IS SUBJECT TO THOSE SAME TERMS AND CONDITIONS, AND YOUR USE HEREOF SHALL CONSTITUTE ACCEPTANCE OF AND AN AGREEMENT TO BE BOUND BY THE SAME. This document is subject to U.S. and international copyright laws and treaties. No part of this document may be reproduced in any form without the written authorization of Cloud Software Group, Inc. TIBCO, the TIBCO logo, the TIBCO O logo, ActiveSpaces, Enterprise Messaging Service, Spotfire, TERR, S-PLUS, and S+ are either registered trademarks or trademarks of Cloud Software Group, Inc. and/or its subsidiaries in the United States and/or other countries. Java and all Java based trademarks and logos are trademarks or registered trademarks of Oracle Corporation and/or its affiliates. All other product and company names and marks mentioned in this document are the property of their respective owners and are mentioned for identification purposes only. You acknowledge that all rights to these third party marks are the exclusive property of their respective owners. Please refer to Cloud SG's Third Party Trademark Notices (https://www.cloud.com/legal) for more information. This document includes fonts that are licensed under the SIL Open Font License, Version 1.1, which is available at: https://scripts.sil.org/OFL Copyright (c) Paul D. Hunt, with Reserved Font Name Source Sans Pro and Source Code Pro. Cloud SG software may be available on multiple operating systems. However, not all operating system platforms for a specific software version are released at the same time. See the "readme" file TIBCO® Data Virtualization Release Notes 63 | Legal and Third-Party Notices for the availability of a specific version of Cloud SG software on a specific operating system platform. THIS DOCUMENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. THIS DOCUMENT COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN; THESE CHANGES WILL BE INCORPORATED IN NEW EDITIONS OF THIS DOCUMENT. CLOUD SG MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S), THE PROGRAM(S), AND/OR THE SERVICES DESCRIBED IN THIS DOCUMENT AT ANY TIME WITHOUT NOTICE. THE CONTENTS OF THIS DOCUMENT MAY BE MODIFIED AND/OR QUALIFIED, DIRECTLY OR INDIRECTLY, BY OTHER DOCUMENTATION WHICH ACCOMPANIES THIS SOFTWARE, INCLUDING BUT NOT LIMITED TO ANY RELEASE NOTES AND "README" FILES. This and other products of Cloud SG may be covered by registered patents. For details, please refer to the Virtual Patent Marking document located at https://www.tibco.com/patents. Copyright © 2002-2023. Cloud Software Group, Inc. All Rights Reserved. TIBCO® Data Virtualization Release Notesmadbuild