You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
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.
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.
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,
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
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
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 126.96.36.1999 server by Toad 188.8.131.525 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.
I was using the freeware version 184.108.40.206 without any issue, until the 1 year expiration. I was prompted to download the latest (2016) version 220.127.116.115.
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 18.104.22.168. 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 22.214.171.124, instead of the 126.96.36.1995? 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.
Can we create hach file from Toad for SAP?
Can we export tables as pcp file?
Can we exported tables as inserted sql statements
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.
this script does not run in Toad for SAP ( HANA ) 188.8.131.525
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' endfrom TOP_PROJECTS X;
I get only "SAP HANA Database Error:"
but no error number.
In SAP HANA studio 2 it works.
Any idea ?
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' endfrom TOP_INVESTMENTS x
And I get not error message / number in Toad from HANA
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.
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
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.
Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ?
When we run Toad_for_SAP_Solutions_184.108.40.206_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.
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.
I'm new to Toad and am currently using Toad for Sybase version 220.127.116.1121. 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?
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
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: