Chat now with support
Chat with Support

Toad for SAP Solutions 4.2 - Release Notes

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.


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.

Debugger An ASE exception occurs when stepping into or over a function during procedure debugging.


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.

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.

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: 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:

ADO.Net Driver Debugger does not allow you to step into or out of procedures. N/A

Debugger support has been discontinued since SAP IQ 16.

See SAP IQ Documentation for more information.

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.


Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad for SAP Solutions 4.2
  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:

Toad for SAP Solutions

Benchmark Factory

SQL Optimizer for SAP ASE

Spotlight on SAP ASE

Toad Data Modeler

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating