The following is a list of issues, including those attributed to third-party products, known to exist at the time of release.
Table 1: Known issues with installation, upgrade, migration
Known Issue | Issue ID |
---|---|
Installation of Toad Intelligence Central will fail for a Windows user with administrator permissions if User Account Control Settings is set to Never notify. Workaround: Set User Account Control Settings to default or above. To open User Account Control Settings, click Start | Control Panel and in the search box type uac. |
TIC-4858 |
The Toad Intelligence Central server runs as three services that start automatically when Windows starts. On installation, services run under the Local System account. Changing the user of any of the services can cause a license failure. Workaround: Re-enter the license to Toad Intelligence Central following the Product Licensing instructions. |
TIC-2306 |
Table 2: Known issues with log in, users and groups
Known Issue | Issue ID |
---|---|
On adding users to Intelligence Central from Active Directory and two of those users have the same username (different domain) then only one user will be added to Intelligence Central. Each username on Toad Intelligence Central must be unique. |
1922 |
In some instances, Intelligence Central may not release some connections after the user disconnects. A user may encounter a "number of connections exceeded" message when attempting to connect after the maximum number of connections has been reached. This release of Toad Intelligence Central now allows up to 1024 connections (sessions). Workaround: If a new connection cannot be opened because the maximum number of connections has been reached, restart the Toad Intelligence Central server. |
N/A |
If the machine hosting Toad Intelligence Central is not part of a domain then it will not be able to validate an Active Directory user log in from the Web Server, the Admin Console, or a client application (Toad Data Point). | 3253 |
Web Server: When the Administrator resets the password for an Intelligence Central user or enables an Intelligence Central user from a computer that does not have an email client installed, there may be problems if the Administrator chooses to email the new password to the user. | 4087 |
Web Server: You may experience a failure to log in to a web browser from Windows Server 2008 (64 bit) using Internet Explorer.
Workaround: Disable Internet Explorer Enhanced Security Configuration. See also Microsoft Technet: https://technet.microsoft.com/en-us/library/dd883248(v=ws.10).aspx
|
2977 |
Web Server: Failure to connect to a web browser from Windows Server 2012 using Internet Explorer. Workaround: From Internet Explorer click Tools | Internet Options | Security. Add the Web Server as a trusted site to the Internet Explorer Enhanced Security Configuration. |
3943 |
Connections from Toad Data Point to Toad Intelligence Central: Failure to connect to Toad Intelligence Central via a proxy server. Workaround: Ensure your Proxy Server is able to connect to the remote host where the Toad Intelligence Central server is running and supports HTTPS traffic. |
2086 |
Toad Data Point 3.8: The Administrator role functionality is not recognized when editing and deleting Intelligence Central groups. An Intelligence Central group can be deleted by the owner of the group and root Administrator only. Workaround: Users with the Administrator role can use the Web interface (Web server) to edit and delete Intelligence Central groups. |
QAT-6929 |
Table 3: Known issues working with objects published to Intelligence Central
Known Issue | Issue ID |
---|---|
When your configuration of Toad Intelligence Central services has been set to run under a Windows account other than "Local System" there is a problem where on upgrade Automation Scripts no longer run. The error is a Licensing Error: License of Toad Data Point instance on the Intelligence Central server is not valid. Workaround: There are three steps to the workaround.
|
2306 |
Table 4: known issues with objects from data sources
Known Issue | Issue ID |
---|---|
Snapshots can be stuck in a permanent 'Running' state following an unexpected event, for example if Toad Intelligence Central stops unexpectedly. While the snapshot is permanently 'Running' the snapshot data cannot be refreshed. Workaround: Restart the Toad Intelligence Central server. Instructions are provided in the Toad Intelligence Central Deployment Guide. |
4598 |
Table 5: Known issues - data source specific
Known Issue | Issue ID |
---|---|
Generic ODBC: Cannot map to a Generic ODBC data source if the DSN contains spaces. | 2965 |
Google Analytics: Mapping tables with start_date and end_date on a where clause have the following requirements:
Note that if optimizations are skipped then the start_date and end_date won't take affect. |
795 |
Oracle BI Enterprise Systems: Unknown error occurred while processing the query. The Oracle BI Enterprise Systems data source has timed out on the query. Workaround: Rewrite your query to return smaller datasets then join the results. For example you may want to query data one quarter at a time rather than for a whole year. |
2099 |
Apache Cassandra™: Mapping tables using the CQL (Cassandra Query Language) protocol some columns are not accessible. Background: There are issues around declaring a single column 'statically' in the CREATE COLUMN FAMILY statement, then adding other columns 'dynamically', as discussed in the Mixing static and dynamic section of http://www.datastax.com/dev/blog/thrift-to-cql3: “the upgrade to CQL3 will be less straightforward than in the case of pure static or pure dynamic column families. Namely, CQL3 still consider the column family static because the definition of [ADDRESS is static]. But since the [other] columns themselves are not declared … you will not be able to access them for CQL3” |
3024 |
Apache Cassandra: Attempting to connect from Windows machine with IPv6 enabled (which includes, for instance, Windows 7 by default) to an Apache Cassandra server on the same machine using the host name "localhost" fails with the message "Could not connect client socket: Already open". Workaround: Connect with the equivalent IPv4 address instead, for example "127.0.0.1". |
12763 |
Apache Cassandra: Databases must be configured to use an Order Preserving Partitioner in order to support range queries on the identifier column. | 11518 |
Apache Cassandra: Mapping tables with dynamic super columns whose names contain dynamic column names is not supported. | 11506 |
Apache Cassandra: Toad Intelligence Central does not support column-oriented tables. Toad Intelligence Central is only able to discover tables in the key-value model. |
|
MongoDB: For a MongoDB 3.0 (or later) connection, the user must have Read/Write privileges in the MongoDB database in order to view sub-tables (MongoDB embedded documents). | 5520 |
MySQL: Character data not encoded in UTF-8 is truncated at the first non-ASCII character. For example the word Protegé from a column encoded in latin1 is truncated to Proteg. |
12668 |
Toad Data Point 4.0 - SAP ASE: In an SAP ASE time type column, fractional seconds might be unexpectedly trimmed from data. This issue was encountered in a data object (snapshot) published from an SAP ASE data source using Toad Data Point 4.0 (or earlier). |
QAT-7839 |
Table 6: Known issues using third party connections to Toad Intelligence Central
Known Issue | Issue ID |
---|---|
Third Party Connections require default-character-set=utf8 | 2048 |
Before installing Toad Intelligence Central 6.1, ensure that your system meets the following minimum hardware and software requirements.
Ensure your hardware is appropriate for the expected usage.
Table 7: Hardware requirements of the Toad Intelligence Central server host
Configuration |
Connected Users1 |
Active Users2 |
Logical Processors3 |
Memory |
ProgramData\Quest Software\Toad Intelligence Central\4 |
Network Capacity |
---|---|---|---|---|---|---|
Desktop | 20 | 1 - 5 | 2 | 8 GB | 500 GB |
100 Mbit/s |
Small Server | 50 | 6 - 15 | 4 | 32 GB |
2 TB dedicated data disk or striped over 2-3 spindles |
200 Mbit/s |
Large Server | 100 | 16 - 30 | 8 | 64 GB | 4 TB striped over 3-4 spindles | 400 Mbit/s |
|
Notes:
|
|
TIP: For higher numbers of Active Users, disk performance (on ProgramData\Quest Software\Toad Intelligence Central\) will improve significantly if the data is striped across multiple spindles to enable concurrent I/O operations. This is especially true when Intelligence Central snapshots or datasets are heavily used. |
Table 8: Software requirements of the Toad Intelligence Central server host
Operating System |
Windows 8.1 (64-bit) Windows 10 (64-bit) Windows Server 2012 (64-bit) Windows Server 2016 (64-bit) Windows Server 2019 (64-bit) | ||||||||||||||||||||
.NET Framework |
.NET 4.7.2 or later is required. | ||||||||||||||||||||
Additional Software | Update for Universal C Runtime in Windows. See KB2999226 or Visual C++ Redistributable for VS 2015 for more information. | ||||||||||||||||||||
ODBC Drivers |
To connect to ODBC data sources, supporting ODBC drivers and necessary client files must be installed on the Toad Intelligence Central server host computer.
| ||||||||||||||||||||
Working with Toad Data Point |
Install Toad Data Point on the Toad Intelligence Central server host computer. Toad Data Point is automatically installed when your use the Toad Intelligence Central Installer to install the Intelligence Central server. This ensures compatibility of features and drivers for objects published through Toad Data Point and is required in order for Toad Data Point automation scripts to execute on Intelligence Central. Following installation of Toad Data Point on the Toad Intelligence Central host computer, start the Toad Data Point application and add your Toad Data Point Professional license key. Adding your license key to Toad Data Point is required, however Toad Data Point installed via the Toad Intelligence Central installer is not counted in the Toad Data Point license count. Automation scripts—If executing Automation scripts on the Toad Intelligence Central server, review the following:
| ||||||||||||||||||||
Security |
|
The Toad Intelligence Central installer installs the Toad Intelligence Central Web Server on the same host computer as Toad Intelligence Central. The minimum requirements of the Toad Intelligence Central Web Server are as follows.
Port |
Port 80 is reserved for the web port. During installation, you can change this if required. It is not advisable to install other web servers on the Toad Intelligence Central server host. Ensure the port is open for TCP inbound connection. Ensure the Windows firewall and any other firewalls affecting the Toad Intelligence Central server host allow access to the Web Server. |
Web Browser |
Access Toad Intelligence Central from any of the following Web browsers:
|
A valid data connectivity license supports the following data sources.
Business Intelligence |
Google Analytics Oracle Business Intelligence Enterprise Edition 10g, 11g and 12c SAP Business Objects Query as a Web Service (QAAWS) XI 3.0, 3.1 and 4.1 Salesforce SharePoint Lists using Data Services over SharePoint Server 2013 via OData. Also, SharePoint Online. Hive versions 0.10 (CDH 4.2), 0.13, 1.1 (CDH 5.12), 2.1.0. HiveServer2 is supported. SQL Server Analysis Services 2016 OData - Generic for any OData service versions 1, 2, 3 and 4. |
Relational | ODBC-compliant databases. See above section on ODBC drivers for details. |
Cloud |
Azure Table Services Apache Cassandra™ versions 1.0.5, 1.2.3, 2.0.9, 2.1.7, 3.0.5, 3.4, and 3.11.0 Apache HBase™ versions 0.89, 0.90.3, 0.98.6, and 1.2.6 MongoDB™ versions 2.0.1, 2.6, 2.6.5, 3.0, 3.2.4, 3.4.6, and 4.0.0 Amazon DynamoDB Cloudera Impala 2.9.0 SimpleDB |
Toad Intelligence Central is shipped with a trial key that enables a 90 day open trial license to Toad Intelligence Central. Use this key to evaluate Toad Intelligence Central without restriction.
At the end of the 90 day trial, if a Data Connectivity license has not been entered, your access to Toad Intelligence Central will be limited to Toad Intelligence Central Community Edition. Entry of a Data Connectivity license is required to use Toad Intelligence Central with Data Connectivity. Any Toad Intelligence Central license from a prior release can serve as a Data Connectivity license for this release.
Any user can enter a license. Administrator credentials are required to remove a license.
To activate a license
To upgrade, run the Toad Intelligence Central installer (which will launch the Toad Intelligence Central Upgrade Wizard) and follow the instructions.
This release of Toad Intelligence Central has been tested with and supports an upgrade from either of the two previous versions. For example, an upgrade to Intelligence Central 5.0 from either version 4.3 or version 3.3 has been tested and is supported.
|
Notes:
|
To find additional information, read product documentation, and connect with the community, see the following:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center