Jump to content


Photo
- - - - -

FYI: Slight change in 5.5 543 on Windows


1 reply to this topic

#1 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 18 November 2004 - 04:11 PM

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

#2 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 18 November 2004 - 05:50 PM

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...



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users