Daniel Castro wrote:
>
> I am getting the folowing error in SAPDB when I do a select statement:
>
> Select error SQL State = S1000
> [SAP AG][SQLOD32.DLL][SAP DB] General error;-9404 POS(1)
> System error: AK
> System Error: VAK721 1.
>
> Drop the DB instance and recreate it, and restoring the
> backup will solve
> this?
>
> Best regards,
This very unprecise (without info about release of MaxDB, not the slightest
info about the statement as I assume that not EVERY select-statement will
result in that error) is not very helpful.
But in this very special case I found an error in the PTS (WEBPTS) with exactly
that description:
-9404 System error: AK System error: VAK721 1 at selects executed as prepared
statement and with in conditions with duplicate in values.
Example:
SELECT *
FROM T
WHERE K1 IN ('A', 'B', 'A') AND K2 IN ('AAA','BBB','AAA') AND I = ?
corrected with 7.5.00.30 / 7.6.00.10
Therefore, until other info to the list, not to me directly, I would say: use a
newer kernel version
or do not use duplicates in the in-clause and this problem will not occur any
more.
Elke
SAP Labs berlin
BTW: dropping database and restoring it is a very bad idea in this context,
will only cause work, but not help
>
> --
> Daniel Castro - דניאל
> Website: http://danielti.no-ip.info:2139
> MSN: [EMAIL PROTECTED]
> Skype: danielti2005
> ICQ : 316727989
> Jabber: danielti
> Linux User: 387864
> AOL User: Danielti2005
> Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli
> Deo Gloria
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
