Alberto J. Sol�s Ruiz wrote:
>
>
> -----Mensaje original-----
> De: Alberto J. Sol�s Ruiz [mailto:[EMAIL PROTECTED]
> Enviado el: lunes, 29 de septiembre de 2003 14:09
> Para: [EMAIL PROTECTED]
> Asunto: help on error code -24988
>
>
> Hello, I receive this message when I try to do a database
> structure check
> from the database manager GUI, my version is:
> kernel 7.4.3 build 028-123-049-366
> runtime envoronmebt W32/INTEL 7.4.3 build 028-123-049-366
>
> the full error is:
> error code -24988
> sql error [util_execute VERIFY]; -9041,Message not available
>
> thanks and regards
>
> Alberto
checking the archive I found:
The World's Most Popular Open Source Database Search lists for:
Mailing Lists MySQL website Support Documentation
Archives FAQ Search
List: MaxDB � Previous MessageNext Message �
From: Becker, Holger Date: December 20 2002 10:14am
Subject: RE: -9041 General error;-9041 POS(1) System error: BD Index not a
ccessible.
Alix Jermyn wrote:
> But, could you tell me why I get this error. We installed another SAP DB instance on
> another server, successfully created the same table via the same script, and ran
> into the
> same problem (and fixed it as below). In neither case has the problem reappeared
> after
> the inital setup.
> I am just a little worried that a production server should should so easily get
> corrupted indexes, or if we are doing something that causes this.
> This causes us a particular problem in that inserts to the affected table inside a
> dbproc return with $rc = 0, and so further processing occurs, ending with a
> successful
> subtrans end, commiting it all and leaving us with a non-existent row.
>>"Marcin P" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
>> MeddelandeHi, Alix
>> It is of course possible.
>> You have to repair (or let's say - create once again) this index.
>> The easiest way us to use DBM GUI ->Recovery -> Index
>> select this index, and then Recover.
>> And it works perfectly :)))
>>
>>>
>>> U�ytkownik "Alix Jermyn" <[EMAIL PROTECTED]>
> napisa� w wiadomo�ci
>>> news:[EMAIL PROTECTED]
>>> Using SAP DB v7.3 via Sql Studio I get the following error when trying the
>>> simple insert below:
>>>
>>> insert into country(ISO_CODE) values ('QQQ')
>>>
>>> -9041 General error;-9041 POS(1) System error: BD Index not accessible.
>>> [ODBC] [S1000] General error
If you stop your database without a normal shoutdown
indexes may become "not accessible" in SAP DB.
To speed up the restart SAP DB doesn't recreate indexes at
restart time if a create index is found in the log.
Instead the administartor could recreate these indexes
via DBM GUI or dbmcli when the database is idle.
Kind regards,
Holger
Thread
RE: -9041 General error;-9041 POS(1) System error: BD Index not a - Becker, Holger,
December 20 2002 10:20am
If you are having problems unsubscribing from the list, please check our
troubleshooting page.
Copyright � 2003 MySQL AB. All rights reserved.
Elke
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
