Known Issues
The following is a list of issues known to exist at the time of this release.
| Feature | Known Issue | Defect ID |
|---|---|---|
| Query Builder |
In SAP Sybase IQ and SAP Sybase SQL Anywhere, queries with a varchar datatype that contain single quotation marks do not function correctly when generating the query plan. Workaround: Replace single quotation marks with double single quotation marks when generating the explain plan. Note: This fix only affects the explain plan code for IQ and SQL Anywhere. |
ST92945 |
| Debugger | An ASE exception occurs when stepping into or over a function during procedure debugging. |
ST94273 |
| Schema Compare | Schema Compare add-in that generates DLL does not currently work from all objects context menus. | TSY-524 |
|
An error "Object reference not set to an instance of an object" displays when some snapshots are opened directly in Toad. |
2305673-1/TSY-236 | |
| Monitor | The monitor is enabled by default after Tools | Monitor | Process Browser is started but the tooltip still reads ‘Enable Monitor’. | TSY-523 |
| SQL Monitor will take several seconds to load in case of large SQL text data. | 2289371-1/TSY-160 | |
| Object Editor | In some cases Toad generates DROP and CREATE OR REPLACE at the same time for functions. | TSY-1942 |
|
Currently, it is not possible to Grant some of the roles for SAP HANA, incl. sap.hana.admin.roles::Monitoring or sap.hana.admin.roles::Administrator. Workaround: Assign the roles using the procedure from _SYS_REPO: GRANT_ACTIVATED_ROLE. |
TSY-1495 | |
| Queries | It is not possible to cancel some queries running in the background. | TSY-486 |
| QP5 | Items are not aligned properly when "Commas in lists" are configured "Leading with space" in Options | Editor | Formatter. | TSY-260 |
Third Party Known Issues
The following is a list of third party issues known to exist at the time of release of Toad for SAP Solutions 4.2.
| Feature | Known Issue | Defect ID |
|---|---|---|
| Connection Manager | An error "System.ArgumentOutOfRangeException 'count' must be non-negative. Parameter name: count" using SAP IQ client 16 was fixed. | TSY-1589/ 2912320-1 |
| Excel | If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662. | ST42486 |
| Export Wizard/ One Click Export |
To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations: 2003 PIAs: 2007 PIAs: |
N/A |
| ADO.Net Driver | Debugger does not allow you to step into or out of procedures. | N/A |
| Debugger |
Debugger support has been discontinued since SAP IQ 16. See SAP IQ Documentation for more information. |
TSY-1356 |
| SQL Editor |
System procedure sa_get_user_status throws error on IQ 16 due to a new column user_dn_cached_at, which has incorrect timestamp values set. This will be fixed in future updates of SAP IQ. The KBA reference is 2174162. Workaround: Write your own procedure or a view and select only the correct columns (exclude user_dn_cached_at column) or change the incorrect column datatype to varchar instead of timestamp. |
TSY-1060 |
Getting Started
Contents of the Release Package
The Toad release package contains the following products:
- Toad for SAP Solutions 4.2
- Product Documentation, including:
- Installation Guide
- Online Help
- Release Notes
Installation Instructions
See the Toad for SAP Solutions Installation Guide for more information.
Toad for SAP Solutions Editions
Toad for SAP Solutions Editions
Each Toad for SAP Solutions is packaged with additional Quest products to expand your SAP Solutions experience. The following products may be part of your Toad for SAP Solutions Edition:
The following Toad for SAP Solutions editions are available:
| Edition | Licensed |
| Toad for SAP Solutions Base Edition |
Toad for SAP Solutions Base |
| Toad for SAP Solutions Xpert Edition |
Toad for SAP Solutions Xpert SQL Optimizer for SAP ASE |
| Toad for SAP Solutions Developer Edition |
Toad for SAP Solutions Xpert SQL Optimizer for SAP ASE Benchmark Factory |
| Toad for SAP Solutions DBA Edition |
Toad for SAP Solutions Xpert Benchmark Factory for Databases Spotlight on SAP ASE Toad Data Modeler |
| Toad for SAP Solutions DB Admin Module |
DB Admin Module |
|
|
NOTE: The DB Admin Module Add-on can be added to any edition of Toad. |
|
|
IMPORTANT: Your license key determines the edition and will enable Toad for SAP Solutions functionality accordingly. In many cases, if functionality is disabled within Toad, you may not have an appropriate license to use it. When Toad is running, you can see which components are licensed by selecting Help | About. |
