Chat now with support
Chat with Support

Toad for SAP Solutions 3.2 - Release Notes

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad® for SAP® Solutions.

Feature Resolved Issue Defect ID
Connection Manager It is now possible to change the language when connecting to an ASE instance. QAT-10368/3243367-1
Debugger A time-out error when running Debugger was fixed. QAT-10678/4005766-1
General Toad now supports a maximum precision of 26 numbers for a decimal type for SAP ASE. QAT-10515/3984327-1
An arithmetic overflow error during queries of very large databases was fixed. QAT-10766/3984327-1
Object Editor (DOE) Creating indexes on SAP IQ does not throw errors anymore. TSY-2032/3498596-1
Object Explorer Inserting NULL values into some columns does not throw errors on SAP ASE anymore. TSY-2033/3496350-1
Query Builder error related to incorrect loading of table columns was fixed. TSY-2001/QAT-7518/3295055-1
Schema Compare and Sync Build Script now includes column(s) for Primary Key of Indexes.


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
Object Editor

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 3.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 3.2
  2. Product Documentation, including:
    • Installation Guide
    • Online Help
    • Release Notes

Installation Instructions

See the Toad® for SAP® Solutions Installation Guide for more information.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating