カテゴリ
製品バージョン
トピック
サブトピック
Profiling not detecting duplicated data (4329195)
After running a query that has duplicates in IDs, I go to "Profiling" tab to check "Duplicates" but the value is 0 The "Profiling options" are set to First 1000 rows and there are not duplicates in this set of data <p> </p>
Can I append data to an existing Excel file when exporting data if I do not know the number of rows of the first select beforehand? (4333337)
Can I append data to an existing Excel file when exporting data if I do not know the number of rows of the first select beforehand? ... For the second select it is possible to specify which row of the Excel you want to start the export in, but when the number of rows the first select returns is unknown, it is hard to guess where to start the export.
Crosss-connection query betwen to Oracle databases fails when using case statement (4368982)
The Unknown column error is encountered in cross-connection query with case statements using two oracle data sources<br><br> ... <p><img src="https://prod-support-images-cfm.s3.amazonaws.com/KB_kA06R0000007PemSAE_1.png"></img></p> WORKAROUND<br><br>None<br><br>STATUS<br><br>Waiting for fix in a future release of Toad Data Point<br> QAT-17881
Double click Toad file does not open workbook fully (4278268)
Double-click the file while Toad is closed does not open the workbook windows completely. ... <p>Open Toad Workbook and then open the file via Open | File menu.</p>
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.
It is possible to migrate scheduling tasks manually if they were not migrated upon initial launch? (4332916)
It is possible to migrate scheduling tasks manually if they were not migrated upon initial launch? <p>RESOLUTION</p> ... <p>1.Select Tools | Administer | Job Manager.<br>2.Click on the Job Manager toolbar.<br>3.Select the scheduled tasks to migrate and click on the "Migrate scheduled tasks from other versions" </p>
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.
How to create the Support Bundle file in Toad (4323349)
How to create the Support Bundle file for the following programs: ... Support Bundle: Can be found in Toad menu| Help | Support bundle >> Then click on the Support Bundle Tab and save this text file file in the Desktop.
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.
Upgrade from 6.2.0.23226 to 6.2.3.25681 (4376407)
When trying to upgrade from 6.2.0.23226 to 6.2.3.25681, the installer asks me first to remove the previous version.<br>Is that correct? ... Will the settings be preserved even though I remove the previous version?<br> Yes, that is correct.<br>Uninstall version 6.2.0.23226 and proceed to install version 6.2.3.25681<br>Toad Data Point does not remove the settings when uninstalling and this upgrade will take over the previous one.<br>Anyway, you can make a backup of the folder containing your settings just to have it.
Missing tabs in the query builder (4346949)
The query builder has only two tabs rather than three. ... How do I get it back ? <div>Please do the following:</div> ... <div> </div> ... <div>3. ... Create a new folder inside this path and name it BACKUP</div>
How do I get back1-2-3-4 tool bar the sits under the main tool bar? (4364571)
I'm missing the 1-2-3-4 tool bar that sits under the main tool bar. ... 1. Go to Tools | Configuration Wizard.
MongoDB data source native connection does not allow more than one database per single connection (4361363)
MongoDB data source native connection does not allow more than one database per single connection Toad Data Point only allows one database per single connection <p>Workaround: None</p>
Variable Issue in Workbook 5.6 (4344812)
We are noticing issues with variables in Workbook, Variables do not pop up correctly and errors out when using them. ... Saving the workbook and reopening breaks it. ... I am attaching the workbook screen where you can see 3 variables in the query, and if you see on the bottom left corner, the variables sections doesn't match with what we named the variables in the query.
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
Unable to open workbook from shared directory (4367296)
When a user with limited DB access tries to open saved WB, Toad Data Point denies it and throws an error "Cannot restore the results. ... <div> </div> <p>WORKAROUND: None</p>
SAP Hana Database Error (4376274)
SAP Hana Database Error: sql syntax error: incorrect syntax near..." error message encountered when executing block statement with a Temp table, using SAP Hana connection<br><br>Repro Steps - <br><br>Start TDP and establish SAP Hana connection<br><br>Open SQL Editor and paste following statement: <br><br> “DO BEGIN<br> TESTTABLE=SELECT 'HELLO WORLD!' FROM DUMMY;<br> SELECT * FROM :TESTTABLE; -- this line creates a syntax error<br> END;”<br><br>Execute statement and for Value in “Bind variables” form, type “address“. Click “OK”<br><br>“SAP Hana Database error” is shown below - <br>
Value cannot be an empty collection. Parameter name: columnReaders” error appears when running a query with Oracle standard_hash function (4346971)
Value cannot be an empty collection.
Getting Missing MySQL ODBC Driver error message, but driver is installed (4344810)
Just today upgraded to TDP 5.5 and TIC 5.5 When creating a cross-connect query involving tables from SQL Server, Excel, and TIC, receiving this error message: "Missing MYSQL ODBC Driver" However, the 5.5 installs did create such ODBC drivers and I can see them in the ODBC administrator.
Error when connecting to Oracle database using sub-schema when the Direct connection is used (4361236)
When connecting to an Oracle database using sub-schema via Direct connection the following error message appears ORA-01017: invalid username/password; logon denied ... Using the Oracle Client connection the problem doesn't appear.
Query builder description's field when using bind variables can not be modified (4367297)
Run a query ... The Bind Variable dialog appears ... In the Description field, a value cannot be added ... **The same issue appears in Toad Workbook ... STATUS
Snowflake Fill in functionality not working properly in Toad Data Point 5.6 (4344816)
I am getting mixed results with the snowflake connector with regards to quotes on fill in values. ... We use database/schema/table for our names. ... If I start to type the database, toad recognizes the viable options but when I hit tab to have it auto filled in, it just gives me empty double quotes (even erases what I already typed.
How to Disable/Stop Automation Task ? (4344984)
2. Find the Task you want to disable. ... 3. Right-click the task and click "Disable Task". ... 4. Once you have disabled the task, the automation task will turn color gray.
The cursor won't move to the line where is an error in SQL code - Oracle Client Connection (4344806)
On previous releases, if there was an error in my SQL code, TDP would move my cursor to the line with the problem -- which was very helpful when the error wasn't self-explanatory. ... On 5.4, TDP leaves my cursor at the same point as when I executed the query and doesn't show me where the error is located.
SQL Script Returning Errors - Invalid object name 'temp1' (4365230)
Invalid object name 'temp1' when running SQL Script in Automation using SQL To File or Export Wizard.<br>Toad Automation does not support GO keyword in the syntax The SQL Script has a GO keyword on the syntax.<br> Remove all the GO keywords from the syntax in the SQL Script.
製品の新しい関連付け
- セルフ・サービス・ツール
- ナレッジベース
- 通知および警告
- 製品別サポート
- ソフトウェアのダウンロード
- 技術文書
- ユーザーフォーラム
- ビデオチュートリアル
- RSSフィード
- お問い合わせ
- Technical Support
- すべて表示