I’m having a problem where TDA will hang or occasionally crash when including an unbound (CLOB) field in the result set.
I am using a very simple query through a BMC Remedy ODBC driver.
e.g. “SELECT id, largefield FROM table1 WHERE id=1”
This will hang and I have to kill the background process. It has occasionally crashed the app as well (thrown exception).
This same exact query works totally fine through a utility like msqry.exe (its very quick too; the actual amount of data in my sample record has just 20 chars in the unbound field). The query will only work in TDA if i remove all unbound fields from the result set.
As a note; if the query criteria would result in more than 1 ticket: canceling the background process will usually return the first row of data (including the unbound field). Remaining rows never appear. Sometimes TDA just immediately crashes.
The backend for this Remedy instance is Oracle; field is a CLOB.
Is this a known issue? Are there any settings I can look at? I made a post a while ago regarding issues caused when Block Cursor Size > 1; I tried playing w/ this value to no avail.
Message was edited by: keeena