1 reply to this topic

[Joseph Bove]

Gang,

Just so you are aware:

There is a slight change in the manner in which ProIV handles SQL on 5.5 543 for SQL Server.

If you are doing something like:

SQL
SELECT SUM(CLI_TRAN_AMOUNT) FROM CLIENTAR
ENDSQL

If the timeout occurs during this SQL call, you'll get a spurious error and a rollback. [The error message is always misleading which makes the actual problem very hard to troubleshoot.]

As such, you'll want to do the following:

@SQLTIMEOUT = 100 (or some appropriate value)

SQL
...
ENDSQL

@SQLTIMEOUT = 0

Setting the @SQLTIMEOUT to zero actually just restores the system wide default. If you've not set one, ProIV by default uses a value of 3 seconds.

Hope that saves someone somewhere some time...

Joseph

[Joseph Bove]

Blah - In last post please read 543 as 345

We are not on a special ProIV beta list that lets us get kernel 1 year before they exist...