Tags for exception
User defined exception from procedure
Hi, I have a stored procedure which is checking counts from four tables. I need to raise exception if the counts are not matich with a predefined value. Can anyone help me on how to achieve this? I am using Terdata 14 version.
procedure exception
Receiving "Change Password Command failed with ODBC. Error:DBException in ExecuteSQL: Character String truncated
Hi. I am receiving the above error when trying to perform a password change via a third party password reset tool. We are using Windows Server 2012 R2 and the password software requires the 32 bit version of the ODBC driver. We are using 15. We have confirmed that the ODBC connection is working.
error database exception sql truncated
How to handle exceptions 'Call failed' in procedure?
Hi, All I have a main procedure which is used to invoke other sub-procedures. I've added the 'DECLARE EXIT HANDLER FOR SQLEXCEPTION' in the main procedure. But when any exception raised in sub-procedure, the HANDLER in main procedure doesn't work. So how can I catch exceptions generated in all sup-procedures?
procedure exception
JDBCException - Insufficient memory to parse this request.
Hi, We are facing problems with the JDBC driver, when issuing (real) unicode  SQL with more then 32kb text: Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC] [Error 3702] [SQLState HY001] Insufficient memory to parse this request.
jdbc exception
TPT - Getting unhandled win32 exception in executor.exe
Hello, For months, I've successfully been using TPT/tbuild, executed via a DOS batch script.  Now IT gave me a fresh, newly-installed PC, and now toward the end of the tbuild I am getting : unhandled win32 exception occurred in executor.exe. 
tpt tbuild win32 exception executor
SQLA Unable to load saved DB Tree -
Hi, SQLA fails to load the saved DB tree when the table description has line breaks in it. It throws:
error sqla exception dbtree
TPT13103: Error 5 retrieving DML Group Attribute
tpt dml error win32 exception
OLELoad generating win32 exception
load oleload win32 exception