Categoria
Versione prodotto
Argomento
Argomento secondario
[TDP] "[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 1:" error is encountered when executing Common Table Expressions (CTEs) (4344808)
If a query using a Common Table Expression (CTE) is run using an ODBC connection to an IMPALA Data source, it will produce an error related to the Syntax. ... If the query is run without using a CTE, it will run fine.
Are there tutorials for Toad Data Point (formerly Toad for Data Analysts)? (4225971)
Are there tutorials or getting started guides for Toad Data Point (formerly Toad for Data Analysts)? ... Web-based training is available here. ... A list of informative videos about different topics and features can be found here.
Can Toad Data Point version control support Bitbucket (Git)? (4336255)
<br><br>Click <a href="https://support.quest.com/technical-documents/toad-data-point/6.2/installation-guide/13#TOPIC-2137114" target="_blank">here</a> ... to access Toad Data Point's latest installation manual page for more reference.
How to change the tool invoked in the in the Group Document defaults (4364248)
Is there a way that I can change what view is displayed when I click the "1 Understand", "2 Query", etc. buttons? ... I didn't see any option for this when browsing through the Tools -> Options. ... What I'd like to do is make these changes:
Error in License Portal: "License type is not supported for the product." received when adding a license (4371068)
Error in License Portal: "License type is not supported for the product." received when adding a license The license entered belongs to an unsupported product or a different edition of the product.
MS Azure SQL DB partitioned table and PK index DDL show up incorrectly in table Script tab (4344794)
Specifically, the partitioning scheme info is not shown, and the ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS have incorrect values (they say OFF, which is not the default, whereas they should say ON). ... The impact of this issue is that the DDL pulled from Toad produces the incorrect result.
How to access "Options" on Toad Workbook (4376993)
To get to “Options” in Toad Data Point traditionally go to “Tools > Options”, how do we get it on Toad Workbooks since it doesn't have the Tools menu? Follow these steps to access "Options" in Toad Workbook.<br>
Query Tab is missing in the Query Builder (4239291)
It only has a Diagram and Results tab. ... Corrupt QueryBuilder.xml file. ... 1) Close Toad
Data shows as EXCLUDED in the data grid (4233807)
When running a query on a table that has a text data type column, the records for the text column show as "excluded" in the data grid. ... Clicking on the cell prompts that I must resubmit query to see the information.
Failed to connect to Microsoft SQL Server with Encrypted Connection Enabled (4370303)
When attempting to connect to a Microsoft SQL Server instance with encrypted connection enabled, an error “The certificate chain was issued by an authority that is not trusted” results and unable to connect.
The initial Excel connection does not change when trying to use another Excel connection in an existing Workbook, the name of the connection and results are from the initial Excel connection (4346933)
The initial Excel connection does not change when trying to use another Excel connection in an existing Workbook, the name of the connection and results are from the initial Excel connection Defect Id: QAT-17523 Workaround: Use a new workflow for each excel connection QAT-17523
How to change connection info in the scheduled Toad for Data Point task files (4363065)
How do I change connection info in the scheduled Toad for Data Point task files? ... 3. Use the ellipse box next to your current connection to change the database
How to disable auto-startup for a database if Toad is crashing. (4345004)
How to disable auto-startup for a database if Toad is crashing. ... <div> </div> ... <div>3. ... Find the folder that corresponds to your Toad Data Point for example if you are using Toad Data Point version 5.1, you will find a 5.1 folder</div>
Cannot export to excel instance "Object does not match target type. Export is cancelled" (4361342)
Cannot export to excel instance "Object does not match target type. ... Close all the Microsoft applications (Outlook, Excel, Word, Etc) and also Toad Application</div>
What's New in Toad Data Point 6.3? (4376724)
What's New in Toad Data Point 6.3? Toad Data Point 6.3 introduces these items:<br> ... <ul><li>The Visual Query Builder now allows for more control over compound Where conditions with horizontal grouping</li><li>Data can now be exported to JSON format</li><li>Enhancement to the pivot grid</li><li>Additional filter options were added to the Data Compare wizard</li></ul>
In Toad Data Point, every SQL table I’d open up would give a count of records (4376251)
In the old Toad, every SQL table I’d open up would give a count of records in the lower right, like so: But opening the same table in 6.2, and it’s just blank: What’s especially weird is that I do get the Record count like normally if I’m viewing a query I built, but not in any of the Tables or Views.
Compare Data Sync Script Oracle to PostgreSQL incorrect (4332760)
When trying to compare data between Oracle and PostgreSQL the generated script is incorrect and wont run unless modified. ... Steps to reproduce the issue: ... Run this script in Oracle ... CREATE TABLE HR.TestCompare
User with limited DB access can not open saved WB - "Cannot restore the results. To restore the results please re-execute the query". (4361157)
When a user with limited DB access tries to open saved WB, TDP 5.4 and forward, denies it and throws an error "Cannot restore the results. ... To restore the results please re-execute the query".<br>If you try to change the connection from full access user to the limited access user while having that same WB open, TDP throws an error "Failed to change connection"<br>This issue has been regressing from TDP 5.2 to TDP 5.4 and forward, while in the previous version limited access user can open that same WB but as a "read-only" user and every time that same user tries to edit something he receives an error message &
Import_1 - rows failed in Prescan step. (4361329)
Mismatch of datatype Verify that the data coming from the source database is the same datatype as the target database.
Executing JavaScript MongoDB in the editor (native code) (4361364)
Toad Data Point does not supports executing JavaScript MongoDB in the editor (native code) Enhancement Request:QAT-16555 Workaround: None QAT-16555
Cannot connect to MySQL when using SSL and turning off "Allow unsecure connections" in Google cloud platform. (4343121)
Toad Data Point fails to connect and returns "Access denied for user 'root'@'localhost' (using password: YES)". ... <p><img src="https://prod-support-images-cfm.s3.amazonaws.com/KB_kA06R0000007CrfSAE_1.png"></img></p>
Problems editing templates in the export wizard activity (4329764)
The Export wizard uses a template which is populated with a Query file.<br>At some point we want to change the file that populates this template and we do this by following the steps below:<br>1.
Does Toad Intelligence Central(TIC) support Chinesse characters? (4257467)
Publish snapshots that named with Chinese characters will fail with an error, as screenshot below shows:</p> ... <p><img src="https://prod-support-images-cfm.s3.amazonaws.com/KB_kA06R0000006jHGSAY_1.png"></img></p>
When an import/export template is created (.tim file), the Server name for Microsoft Azure SQL Server is saved with additional characters attached to it, causing a connection error in the automation script (4329370)
Steps to reproduce the isssue: ... 2. Go to Automations ... 3. Create an Import or Export template ... 4. Save the automation script and run it ... Expected result: The automation script runs successfully
Getting error "System.UriFormatException" after installig MySQL (4334612)
It keeps throwing the following errors: ... System.UriFormatException: ... Reinstall MySQL. ... Make sure the MySQL version is a supported version by Toad Data Point. ... To see the list of supported versions go here, click on the Release Notes, and go to the System Requirements section.
Associazione di nuovi prodotti
- Strumenti self-service
- Knowledge Base
- Notifiche e avvisi
- Supporto prodotti
- Download di software
- Documentazione tecnica
- Forum utente
- Esercitazioni video
- Feed RSS
- Contatti
- Supporto tecnico
- Visualizza tutto