AW: AK System error: VAK724 error

Problem solved with 7.5.0.25
As workaround (but performance loss) set parameter OPTIM_INV_ONLY='NO'

Gert

-----Ursprüngliche Nachricht-----
Von: Don Hayes [mailto:dhayes@xxxxxxxxx] 
Gesendet: Donnerstag, 24. März 2005 23:44
An: maxdb@xxxxxxxxxxxxxxx
Betreff: AK System error: VAK724 error


I get this error when running the query below:
 
S1000(-9404)[MySQL MaxDB][SQLOD32 DLL][MaxDB] General error;-9404
POS(1) System error: AK System error: VAK724 1 (0.02 secs)
 
SELECT   REG.primarypatronid, PATRONS.patronlookup, REG.patronid 
FROM     dbo.reg REG
         INNER JOIN dbo.patrons PATRONS ON
REG.primarypatronid=PATRONS.patronid 
WHERE    REG.primarypatronid != 3 
AND      REG.patronid in (3,103934,99444,102281) 
AND      REG.regstatus != 'V'
 
If I remove the regstatus or the primarypatronid parameters it works
OK. It worked as is with 7.5.0.5.
 
Running 7.5.0.24 on Win 32.
 
Don Hayes
Database Administrator
Tualatin Hills Parks & Recreation District
Phone: (503) 614-1219
FAX: (503) 629-5398

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx