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.||
The following is a list of issues known to exist at the time of this release.
|Feature||Known Issue||Defect ID|
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|
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: 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:
|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.
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.
The Toad release package contains the following products:
See the Toad® for SAP® Solutions Installation Guide for more information.