Category
Topic
Subtopic
Book
Get error " ORA-01841 (full) year must be between -4713 and +9999, and not be 0 " running a query in Toad for Oracle (4378454)
The ORA-01841 error indicates an invalid year value in a date operation. ... Attempting to use a year outside this range will result in this error. ... Several factors can lead to the ORA-01841 error:
Get the message "Internet connection is required to continue" (4375439)
Clicking with the right button on the mouse on the Software Shortcut and select the "Run as Administrator" option in the menu. ... <br><br>2. ... Check that IPv6 is disabled in the Network card which is being used.<br><br>The Toad Subscription software should bring back the login screen.
Troubleshooting Scheduled Automation Scripts (4262080)
How can one troubleshoot, identify and localize to and correct any problems? ... In addition, how can one learn how to troubleshoot script scheduling and execution issues? ... How can one use the Job Manager to troubleshoot issues with scheduled Automation scripts?
Get the error "ORA-00600 [Internal Error Codes]". (4336954)
It indicates the process has encountered a low-level unexpected condition, which typically means you’ve encountered an Oracle Database bug.<br><br>The impact can vary from just being an annoyance that shows up in your logs once in a while, to something major that brings the database down.<br><br>When an ORA-00600 error is logged it includes a list of arguments in square brackets.
Get error " ADM14000E The database manager is unable to open diagnostic log file " in Windows Event Viewer Application log (4377657)
Toad for DB2 or Toad Data Point suddenly quits without sending any error message when connecting to the database or changing parameters in Toad options. ... When reviewing the Windows Event Viewer Application log, multiple entries with this text are found.
Does Toad Data Point support Azure active Directory - Universal with MFA ? (4377611)
Starting from Toad Data Point 6.0 release enables you to create a more secure type of connection to Microsoft SQL Azure by using Azure AD Universal with Multi-factor authentication. ... It adds another layer of security in the form of an additional verification step.
The top portion of the automation script window is all a light green color, making it look like it is disabled (4364319)
In an automation script, after disabling some of the activities, the whole top portion of the automation script becomes a light green color, making it look like the whole script is disabled.<br><br>See the picture.<br><br><img alt="2024-06-10_14-03-56.png" src="https://questsoftware.file.force.com/servlet/rtaImage?eid=ka06R000001MP2P&feoid=00N6R00000J0qH7&refid=0EM6R000006A5eK"></img> The design window was selected when disabling one of the activities. Follow these steps to solve it.<br><br>1. Select the design window and one of the activities.<br><br><img alt="2024-06-10_14-08-32.png" src="https://questsoftware.file.force.com/servlet/rtaImage?eid=ka06R000001MP2P&feoid=00N6R00000J0qH8&refid=0EM6R000006A5eP"></img><br>2. Right-click on the activity and select Enabled.<br><br><img alt="2024-06-10_14-11-20.png" src="https://questsoftware.file.force.com/servlet/rtaImage?eid=ka06R000001MP2P&feoid=00N6R00000J0qH8&refid=0EM6R000006A5eU"></img><br><br>3. The top portion of the automation script window will back to normal.<br><br><img alt="2024-06-10_14-14-14.png" src="https://questsoftware.file.force.com/servlet/rtaImage?eid=ka06R000001MP2P&feoid=00N6R00000J0qH8&refid=0EM6R000006A5eZ"></img><br><br>
Are Snowflake databases supported? (4362422)
Are Snowflake databases supported by Toad Data Point? <p>Snowflake databases are supported by Toad Data Point, starting from v5.6.<br><br>Please check the release notes <a href="https://support.quest.com/technical-documents/toad-data-point/5.6/release-notes#TOPIC-1732734" target="_blank">here</a> </p>
[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.
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.
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.
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.
What's New in Toad Data Point Subscription 6.3? (4376752)
What's New in Toad Data Point Subscription 6.3? Toad Data Point Subscription/Toad Workbook Subscription 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><li>Auto-Update service for upgrading Toad Data Point Subscription</li></ul>
What is the new AI Ask preview feature in Toad Workbook and how to use it? (4376298)
AI Ask is a new preview feature in Toad Workbook designed to make your workflow more efficient and data querying more intuitive. ... It leverages advanced AI to enhance your analysis experience, transforming how you interact with data.
How to change the email password at once in all automated tasks? (4371000)
Is it possible to change the email password in the sending email activity for several automation tasks at once? ... Toad Data Point doesn't have any functionality that can change part of the several automation scripts at the same time.
The Object Explorer Treelist view not display items alphabetically when connected to Snowflake. (4376470)
I am currently using the Snowflake connector, and when using the Object Explorer window pane, while using the Treelist view, I am a little frustrated by the default loading of objects not being alphabetical nor being able to sort them in any other way.
Connection, Loses session and TDP tries and reconnect without password causes login lockout (4364236)
Is there a method not to have the application try and reconnect after disconnection? ... In an environment, where the users are suspended after a finite number of attempts, it would be advantageous to keep Toad Data Point from reconnecting without full credentials.
Unable to 'save' the retain compare option 'Treat empty value as null' (4336258)
Unable to 'save' the retain compare option 'Treat empty value as null' Defect QAT-17375 QAT-17375
Get the message "You need to install Microsoft Active Directory Authentication Library (adalsql.msi) to connect to Azure SQL Database using Active Directory Password Authentication" (4362425)
Get the message "You need to install Microsot Active Directory Authentication Library (adalsql.msi) to connect to Azure SQL Database using Active Direcory Password Authentication" in Toad Data Point <p>The Microsot Active Directory Authentication Library should be installed.</p>
Attempting to install MSI Quest Installer on a PC and getting the error message Failed to configure per-machine MSI package (4362428)
Attempting to install MSI Quest Installer on a PC and getting the error message Failed to configure per-machine MSI package Possible Windows configuration issue. ... <p>Check the Windows Event Viewer and see if you have the following error.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All