24988 Err_sql Sql Error
Contents |
Sybase Support Portal SAP PartnerEdge SAP Training & Certification Shop SAP Service Marketplace SAP Store Analytics Content and Collaboration Customer Relationship Mgmt Data Management Enterprise Management Financial
Messages 24988
Management Human Capital Management Product Lifecycle Mgmt Supplier Relationship Mgmt Supply Chain 24988 sql error maxdb Management Technology Platform Additional Information Technology Platform SAP NetWeaver 7.3 Messages Messages Number Ranges From -1 to -699 From -700 to -899 From -900 to -999 From -1000 to -1999 From -2000 to -2999 From -3000 to -3999 From -4000 to -4999 From -5000 to -5999 From -6000 to -6999 From -7000 to -7999 From -8000 to -9799 From -10000 to -10999 From -11000 to -11099 From -11100 to -11199 From -11200 to -11399 From -22000 to -22999 From -23000 to -23999 From -24000 to -24999 -24905: ERR_NOEBIDLIST: no information on external backup IDs available -24906: ERR_EBFDIRTY: invalid format of external backup history -24907: ERR_DBAWRONG - wrong SYSDBA -24909: ERR_DBAUNKNOWN - SYSDBA unknown -24910: ERR_PARAMVER - wrong version of param help file (cserv.pcf)
sorry, the second command should be "dbmcli ... db_state". > -----Original Message----- > From: Hahn, Uwe > Sent: Dienstag, 30. September 2003 13:28 > To: 'Andreas Ernst'; SAPDB > Subject: RE: -24988 sql error [sql_connect ...]; 1,database > not running > > > It seems to be a communication problem. > What does "x_cons AEONLINE show state" and "x_cons AEONLINE > show state" print out ? > Uwe > > > -----Original Message----- > > From: Andreas Ernst [mailto:ae@stripped] > > Sent: Dienstag, 30. September 2003 10:22 > > To: Zabach, Elke; SAPDB > > Subject: Re: -24988 sql error [sql_connect ...]; 1,database > > not running > > > > > > Hi Elke, > > > > Zabach, Elke schrieb: > > > > https://help.sap.com/saphelp_nw73/helpdata/en/0a/403052f725496d91b83386ef0d6119/content.htm >Andreas Ernst wrote: > > > > > > > > >>Hi all, > > >> > > >>after a server crash, one of the two DBs will not start. > > >> > > >>I get the error > > >> > > >>-24988 sql error [sql_connect ...]; 1,database not running > > >> > > >>Searching in the list archiv is not possible (next link > > >>resets to 'all > > >>lists') and so https://lists.mysql.com/maxdb/18379 i found nothing. > > >> > > >>db_cold/offline/warm don' t work - so what can i do? > > >> > > >> > > > > > >'don't work'... > > >what do they return/say? > > > > > AEONLINE - Simone> db_online > > OK > > AEONLINE - Simone> db_cold > > ERROR > > -24988 sql error [db_cold]; 1,database not running > > 1,database not running > > > > AEONLINE - Simone> db_offline > > ERROR > > -24988 sql error [db_offline]; 1,database not running > > 1,database not running > > > > AEONLINE - Simone> db_warm > > OK > > > > db_online/warm always says ok, but the database is still > not running. > > > > database protokoll manager (dbmprt): > > > > 2003-09-30 10:00:47 0x000053c5 0 DBM > > command db_online > > 2003-09-30 10:01:27 0x000053c5 0 DBM command > > param_startsession > > 2003-09-30 10:01:27 0x000053c5 0 DBM command > > param_abortsession > > 2003-09-30 10:01:56 0x000053c5 0 DBM command > > param_startsession > > 2003-09-30 10:01:57 0x000053c5 0 DBM command > > param_abortsession > > 2003-09-30 10:05:17 0x000053c5 0 DBM > command db_cold > > 2003-09-30 10:05:17 0x000053c5 ERR -24988 DBM > > ERR_SQL: sql error > > 0x000053c5 ERR -24988 DBM > 1,database not > > running > > 2003-09-30 10:05:21
use to work, butnow I get this message:----------------------------------***@atchoum:/usr/local/sapdb/indep_prog/bin> ./dbmcli -n atchoum.cpln.ch-d DW03_P -u dba,dba db_offlineOK***@atchoum:/usr/local/sapdb/indep_prog/bin> ./dbmcli -n http://sapdb.general.listserv.sap.narkive.com/PFbHIEQI/24988-err-sql-sql-error-1-database-not-running atchoum.cpln.ch-d DW03_P -u dba,dba db_startOK***@atchoum:/usr/local/sapdb/indep_prog/bin> ./dbmcli -n atchoum.cpln.ch-d DW03_P -u dba,dba db_warmERR-24988,ERR_SQL: sql error1,database not running----------------------------------I check the permission about the file 'Registry.dcom' and 'Registry1.dcom',everything is alright.Thanks for any idea,Sébastien Koller Vorsprach, Bernd 2002-11-27 07:45:53 UTC PermalinkRaw Message Post by Koller Sébastien----------------------------------atchoum.cpln.ch-d DW03_P -u dba,dba sql error db_offlineOKatchoum.cpln.ch-d DW03_P -u dba,dba db_startOKatchoum.cpln.ch-d DW03_P -u dba,dba db_warmERR-24988,ERR_SQL: sql error1,database not running----------------------------------There is a problem during the so called "RESTART" (transitionfrom state cold to warm). Check the files knldiag and knldiag.errin the rundirectory of the database for more information.Bernd--SAP Labs Berlin Koller Sébastien 2002-11-27 09:35:19 24988 err_sql sql UTC PermalinkRaw Message Post by Koller Sébastien----------------------------------atchoum.cpln.ch-d DW03_P -u dba,dba db_offlineOKatchoum.cpln.ch-d DW03_P -u dba,dba db_startOKatchoum.cpln.ch-d DW03_P -u dba,dba db_warmERR-24988,ERR_SQL: sql error1,database not running----------------------------------There is a problem during the so called "RESTART" (transitionfrom state cold to warm). Check the files knldiag and knldiag.errin the rundirectory of the database for more information.Bernd--SAP Labs BerlinI found this in my knldiag.err:2002-11-27 12:29:54 --- Starting GMT 2002-11-2711:29:54 7.3.0 Build 024-000-085-5552002-11-27 12:30:21 2563 ERR 53000 FBM No Free Block available: 382002-11-27 12:30:21 2563 ERR 52050 SHUTDOWN savepoint/no_more_spaceI have a lot of place on my disks, so what does it mean?Thanks,Sébastien Koller Vorsprach, Bernd 2002-11-27 12:43:19 UTC PermalinkRaw Message Post by Koller Sébastien2002-11-27 12:29:54 --- Starting GMT 2002-11-2711:29:54 7.3.0 Build 024-000-085-5552002-11-27 12:30:21 2563 ERR 53000 FBM No Free Blockavailable: 382002-11-27 12:30:21 2563 ERR 52050 SHUTDOWN savepoint/no_more_spaceI have a lot of p