I was using the freeware version 22.214.171.124 without any issue, until the 1 year expiration. I was prompted to download the latest (2016) version 126.96.36.1995.
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 188.8.131.52. 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 184.108.40.206, instead of the 220.127.116.115? 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.