LH1026
Follow / 23 Jun 2016 at 12:56pm / Toad for SAP Solutions
Latest post by on 1 Nov 2017 at 9:25am

Transition from Toad for Sybase 2.1.1 to Toad for SAP Solutions 3...

Expand content
I recently received the "free period ended" message and upgraded to Toad for SAP Solutions 3.1. In Query Builder, when I double click on certain tables (that had no issues in my previous version...

I recently received the "free period ended" message and upgraded to Toad for SAP Solutions 3.1.  In Query Builder, when I double click on certain tables (that had no issues in my previous version), I am seeing a "Domain error during explicit conversion of INT value '0' to a BIT field" message.  I can click OK and the table shows is added but the table doesn't show all of the fields.  These tables were set up by others, I simply query off of them.

2223 5 / Create an account to join the discussion.
Wayne Westlake
Follow / 6 Sep 2017 at 11:04pm / Toad for SAP Solutions
Latest post by on 7 Sep 2017 at 1:07pm

32-bit version of Free Toad?

Expand content
Is there no longer a 32-bit version of Toad starting with 3.2? Unfortunately some of our workstations require 32-bit Win7 for in-house applications.

Is there no longer a 32-bit version of Toad starting with 3.2?  Unfortunately some of our workstations require 32-bit Win7 for in-house applications.

278 2 / Create an account to join the discussion.
ZivIL
Follow / 6 Aug 2017 at 3:06am / Toad for SAP Solutions
Latest post by on 7 Aug 2017 at 8:22pm

Feature Question: Is there an option to save as .xlsx?

Expand content
Per subject, does the Toad client offer an option to save multiple (/all) open result sets as a single .xlsx file, under multiple spread sheet tabs? (A result set on each excel tab) Thanks in advance...

Per subject, does the Toad client offer an option to save multiple (/all) open result sets as a single .xlsx file, under multiple spread sheet tabs? 

(A result set on each excel tab)

Thanks in advance,

Ziv.

347 4 / Create an account to join the discussion.
ss
Follow / 1 Aug 2017 at 10:21am / Toad for SAP Solutions
Latest post by on 3 Aug 2017 at 7:15am

Toad Error

Expand content
After successfully make connection to Toad for SAP , when right click on any table to choose anything appear the attached error or when open editor to write query appear the same error this error appear...

After successfully make connection to Toad for SAP , when right click on any table to choose anything appear the attached error or when open editor to write query appear the same error

this error appear when working on anything in toad

when try from different machine and different user appear the same error

How can i solve this error

327 3 / Create an account to join the discussion.
h.blum
Follow / 20 Jul 2017 at 2:46pm / Toad for SAP Solutions
Latest post by on 21 Jul 2017 at 11:46am

TSAP 3.2.0.96 ( HANA ) do not show views under explorer

Expand content
Hi, I have installed TSAP 3.2 And in the explorer, all tabs are ok, but the "views" tab do not show any views. Parallel with TSAP 3.1 I can see all views. There is no filter on "views"...

Hi,

I have installed TSAP 3.2

And in the explorer, all tabs are ok,

but the "views" tab do not show any views.

Parallel with TSAP 3.1 I can see all views.

There is no filter on "views" tab

Holger

387 4 / Create an account to join the discussion.
Omar Romero
Follow / 18 Jul 2016 at 12:23am / Toad for SAP Solutions
Latest post by on 21 Jul 2017 at 9:07am

Cannot connect to SYBASE IQ 16: "Could not load the encryption...

Expand content
Hello everyone, I´m new in the forum and in using Toad and I have the following problem: when I´m trying to connect to my SYBASE IQ 16.0.0.429 server by Toad 3.1.0.315 in a windows 7 64bit...

Hello everyone, I´m new in the forum and in using Toad and I have the following problem: when I´m trying to connect to my SYBASE IQ 16.0.0.429 server by Toad 3.1.0.315 in a windows 7 64bit lap-top I set all the right connection parameters but when I try to connect the following message appears: "Could not load the encryption DLL"dbfips16.dll"", I can connect by InteractiveSQL but I really want to use toad, can someone help me with this error? 

Thanks in advance and kind regards.

Omar Romero

Unanswered 2581 9 / Create an account to join the discussion.
wudeewen
Follow / 11 Jul 2017 at 10:08pm / Toad for SAP Solutions
Latest post by on 13 Jul 2017 at 9:57pm

Version 3.1.0.315 cannot display table columns

Expand content
I was using the freeware version 3.0.0.129 without any issue, until the 1 year expiration. I was prompted to download the latest (2016) version 3.1.0.315. Upon installation, I immediately found out,...

I was using the freeware version 3.0.0.129 without any issue, until the 1 year expiration. I was prompted to download the latest (2016) version 3.1.0.315.

Upon installation, I immediately found out, while the new version inherited the saved connections, when I connected to the server, it only lists the table names, but cannot retrieve the column definition that normally shows in the bottom of Object Explorer. Instead, I got error message

"Attempt to insert NULL value into column 21 in work table (table id 4288282623); column does not allow NULLS.  UPDATE fails."

I found if I close Toad for SAP and restart, the same error message will show up except with a different table id. I tried to use object_name() to get the work table name, only to get Sybase Database Error "Arithmetic overflow during implicit conversion of BIGINT value '4288282623' to a INT field ."

I suspect it's some script for creating the work table. I even copied the script from Tools --> Options --> SQL Dictionary --> Db.CommonSql --> DescribeTableColumns from the old version 3.0.0.129. I found it is the same as the new version. I could run the script in 3.0 before, but when I created an editor and pasted the script and run, the very same error message "Attempt to insert NULL value into column 21 in work table (table id 4288282623); column does not allow NULLS.  UPDATE fails." shows up.

The target SAP is ASE 16. On another connection to a ASE 15.7 server which the old 3.0 version had no issue on, it will connect to the server but no table will be listed. If I right click at the table area and select Refresh from the drop down, I will get an error "Invalid column name 'sysstat4'".

Is there any way to let me keep using the old but working version 3.0.0.129, instead of the 3.1.0.315? Or is there any way (such as updating the script) so the work table's column 21 can allow NULL value? In the current state it is not usable.

Thanks!

Answered 625 6 / Create an account to join the discussion.
ss
Follow / 9 Jul 2017 at 11:26am / Toad for SAP Solutions
Latest post by on 10 Jul 2017 at 11:38am

Toad

Expand content
Can we create hach file from Toad for SAP? Can we export tables as pcp file? Can we exported tables as inserted sql statements

Can we create hach file from Toad for SAP?

Can we export tables as pcp file?

Can we exported tables as inserted sql statements

520 5 / Create an account to join the discussion.
vineetkumar.kurrewar
Follow / 7 Jul 2017 at 1:40pm / Toad for SAP Solutions
Latest post by on 7 Jul 2017 at 1:47pm

Toad for HANA

Expand content
Hello Experts - I wanted to know if Toad for HANA 3.2 supports multi tenant architecture of HANA databases. As we already know that from HANA 2.0 multi-tenancy is a mandate. Awaiting replies...

Hello Experts -

I wanted to know if Toad for HANA 3.2 supports multi tenant architecture of HANA databases.

As we already know that from HANA 2.0 multi-tenancy is a mandate.

Awaiting replies. Thank you.

Regards

Vineet

470 1 / Create an account to join the discussion.
h.blum
Follow / 16 Nov 2016 at 2:32pm / Toad for SAP Solutions
Latest post by on 5 Jun 2017 at 8:28am

select statement does not run in Toad for SAP but in HANA studio

Expand content
Hi@all, this script does not run in Toad for SAP ( HANA ) 3.1.0.315 select X.COMPETENCE_CENTERS, X.ESTIMATED_PROJECT_COSTS_KEUR, X.IMPACT_ON_EBITDA_PER_YEAR_KEUR, round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR...

Hi@all,

this script does not run in Toad for SAP ( HANA ) 3.1.0.315

select
X.COMPETENCE_CENTERS,
X.ESTIMATED_PROJECT_COSTS_KEUR,
X.IMPACT_ON_EBITDA_PER_YEAR_KEUR,
round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1),
case
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 0.1 and 0.9 then '0.5'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 1.0 and 1.9 then '1'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 2.0 and 2.9 then '2'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 3.0 and 3.9 then '3'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 4.0 and 4.9 then '4'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 5.0 and 5.9 then '5'
else '9'
end
from TOP_PROJECTS X;

I get only "SAP HANA Database Error:"

but no error number.

In SAP HANA studio 2 it works.

Any idea ?

1286 2 / Create an account to join the discussion.
h.blum
Follow / 3 Mar 2017 at 8:53am / Toad for SAP Solutions
Latest post by on 5 Jun 2017 at 8:27am

Script not running in Toad but in HANA Studio

Expand content
Hi, this script will not run in Toad but in HANA Studio: select x."Payback period in year", case when x."Payback period in year" > 0 and x."Payback period in year"...

Hi,

this script will not run in Toad but in HANA Studio:

select
x."Payback period in year",
case
when x."Payback period in year" > 0 and x."Payback period in year" <= 1.5 then '1'
when x."Payback period in year" > 1.5 and x."Payback period in year" <= 2.5 then '2'
else 'x'
end
from TOP_INVESTMENTS x

And I get not error message / number in Toad from HANA

Holger

Unanswered 1023 9 / Create an account to join the discussion.
sonic_spin
Follow / 18 Nov 2015 at 12:22pm / Toad for SAP Solutions
Latest post by on 24 May 2017 at 2:36pm

Toad for SAP Solutions ( IQ connection problem )

Expand content
I'm trying to connect to Sybase IQ 16 with Toad for SAP Solutions 3 from my laptop as a client. After setting up all connection manager fields I’m getting a massage which states... <Database...

I'm trying to connect to Sybase IQ 16 with Toad for SAP Solutions 3 from my laptop as a client.

After setting up all connection manager fields I’m getting a massage which states... <Database error> <Database server not found>

Do i need an ODBC connection on my laptop (client side?)

 

Note: with same connection settings Aqua Data Studio connects without any problem.

Answered 6498 15 / Create an account to join the discussion.
AzaMull
Follow / 14 Mar 2017 at 6:41pm / Toad for SAP Solutions
Latest post by on 29 Mar 2017 at 2:03am

Tables are locked by 'Toad for SAP 3.1.0.bugs.1109' when using...

Expand content
There is a problem with Toad for SAP which causes issues during production releases which had DDL changes. How to reproduce: 1, Open Toad -> and connect to a Sybase IQ server via Connection manager...

There is a problem with Toad for SAP which causes issues during production releases which had DDL changes.

How to reproduce:

1, Open   Toad -> and connect to a Sybase IQ server via Connection manager

2. Go to View- > Object Explorer.

Now Check for table locks by using sp_iqlocks. You will see shared locks on ALL  tables on the server, across all schemas.

Thus, if someone has a Toad session open during the release,  any DDL on a tables such as alters, will fail with a table is in use error.

I don't understand why Toad needs to lock all tables .

We have many Toad sessions connected, and this is not feasible for us to control everyone and tell them not to use Toad during the release.

Has anyone come across this issue and do you have solution ?

Version : Licensed Toad for SAP 3.1.0 bugs 1109

Unanswered 871 4 / Create an account to join the discussion.
thompsojmd
Follow / 2 Feb 2017 at 4:41pm / Toad for SAP Solutions
Latest post by on 2 Feb 2017 at 7:03pm

Can Add/Remove Connection be locked in Connection Manager

Expand content
I am looking at deploying Toad to a large group of Data Analysts and Developers. Some should have access to production data and some should not. I am wondering if there is anyway to lock the ability to...

I am looking at deploying Toad to a large group of Data Analysts and Developers. Some should have access to production data and some should not. I am wondering if there is anyway to lock the ability to add or remove connections in Connection Manager. I really like the ability to import groups of connections, but I don't want many of the users to be able to change this for security reasons.

850 2 / Create an account to join the discussion.
Deandyno
Follow / 30 Jan 2017 at 7:03pm / Toad for SAP Solutions
Latest post by on 31 Jan 2017 at 8:41pm

User database groups

Expand content
Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ? Thanks, Dean

Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ?

Thanks, Dean

Unanswered 823 2 / Create an account to join the discussion.
hcsiu
Follow / 20 Jan 2017 at 2:50am / Toad for SAP Solutions
Latest post by on 20 Jan 2017 at 7:25am

Toad for SAP Solutions 3.0.0.129_Mod. error

Expand content
When we run Toad_for_SAP_Solutions_3.0.0.129_Mod.exe, there is an error message saying: C:\Users\<userid>\AppData\Roaming\Quest Software\Toad for SAP Solutions 3.0\SQLFormatter\Long Format Leading...

When we run Toad_for_SAP_Solutions_3.0.0.129_Mod.exe, there is an error message saying:

C:\Users\<userid>\AppData\Roaming\Quest Software\Toad for SAP Solutions 3.0\SQLFormatter\Long Format Leading Comma Uppercase.xml' already exists.

We checked and the xml file is not found.

Please kindly help how to fix this problem.

Thnaks a million.

Best regards.

808 1 / Create an account to join the discussion.
Deandyno
Follow / 5 Dec 2016 at 6:06pm / Toad for SAP Solutions
Latest post by on 15 Dec 2016 at 3:52am

Query Plan doesn't show

Expand content
I see that the Query Plan window was supposed to be fixed in 2.1 version, we're running 3.0 and no information is populated in the Query Plan window. This is for straight SQL and thru a procedure...

I see that the Query Plan window was supposed to be fixed in 2.1 version, we're running 3.0 and no information is populated in the Query Plan window.

This is for straight SQL and thru a procedure, nothing in the window in either case.

1368 7 / Create an account to join the discussion.
plankton
Follow / 14 Dec 2016 at 2:06pm / Toad for SAP Solutions
Latest post by on 14 Dec 2016 at 3:00pm

Issue With Executing Multiple Select Statements- Results Are Produced...

Expand content
Hi, I'm new to Toad and am currently using Toad for Sybase version 2.1.0.2921. I need the functionality that was built in for this post ( http://www.toadworld.com/products/toad-for-sap-solutions...

Hi,

I'm new to Toad and am currently using Toad for Sybase version 2.1.0.2921. I need the functionality that was built in for this post (http://www.toadworld.com/products/toad-for-sap-solutions/f/24/t/21931?pi11637=2). Is there an enhancement for Toad for Sybase that would give me this functionality? If not, would I be able to switch to Toad for SAP and still work off of a Sybase-ASE server?

-Thanks

Unanswered 966 2 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 2:16pm / Toad for SAP Solutions

We are now on Twitter!!! Contact a Technical Support expert today

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

837 0 / Create an account to join the discussion.
murp1977
Follow / 12 Sep 2016 at 9:26am / Toad for SAP Solutions
Latest post by on 15 Sep 2016 at 8:11am

Toad for Data Analysts

Expand content
Hi All, Could anyone please share Standard Licensing rules for "TOAD for Data Analysts"? I believe that Dell Software has standardised licensing agreements so are the Licensing Rules for...

Hi All,

Could anyone please share Standard Licensing rules for "TOAD for Data Analysts"?

I believe that Dell Software has standardised licensing agreements so are the Licensing Rules for "TOAD for Data Analysts" basically the same across the board for the following also:

  • Toad for Oracle
  • Toad for SQL Server
  • Toad for Data Analysts
  • Toad Data Modeler
  • Toad for MySQL

Regards

1600 1 / Create an account to join the discussion.