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:
SELECT SUM(CLI_TRAN_AMOUNT) FROM CLIENTAR
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)
@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...
FYI: Slight change in 5.5 543 on Windows
1 reply to this topic
Reply to this topic
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users