24988 Sql Error
SAP NetWeaver AdministratorWhere is this place located?All Places SAP NetWeaver Administrator 17 Replies Latest reply: Oct 15, 2013 12:44 PM by Arménio Teles Tweet Max Database Manager error: -24988 SQL error... Arménio Teles Oct maxdb 24988 err_sql sql error 11, 2013 5:38 PM Currently Being Moderated Hello,We are facing an error sapdb 24988 sql error in our Max Database in Database Manager 7.6 (version 7.6.03.10).Whenever we try to get access to some features (for instance clicking in some buttons like Data Area, Log Area, Backup History, etc...) in Database Manager it always show the following error:-24988 SQL error [sql_execute SELECT DEVICENAME,READS,WRITES,WRITEPAGES FROM SYSMON_IOACCESS];-4004,Unknown table or unknown schema:SYSMON_IOACCESSCan you help me please, how can I solve this problem!?Thank you,regards,samid 1342Views Re: Max Database Manager error: -24988 SQL error... Reagan Benjamin Oct 11, 2013 6:40 PM (in response to Arménio Teles) Currently Being Moderated HelloTry updating the DBM GUI and see if that helps.RegardsRB Alert Moderator Like (0) Re: Max Database Manager error: -24988 SQL error... Arménio Teles Oct 12, 2013 3:36 AM (in response to Reagan Benjamin) Currently Being Moderated Hello Reagan,Can you tell me how can I check which version has the Max Database?... sorry, I don´t have much experience in SAP Max Databases!Because, I believe there are some requirements that must be checked before updating the DBMGUI, as it mentioned in the following link:http://www.sdn.sap.com/irj/scn/maxdb-downloadsAm I right?!Regards,samid Alert Moderator Like (0) Re: Max Database Manager error: -24988 SQL error... Rishi Abrol Oct 12, 2013 4:19 AM (in response to Arménio Teles) Currently Being Moderated Hi,Please check the below two note.Note 836947 - Error in the database catalog for UNICODE systemsNote 877349 - rename user => -4004, Unknown table nameWhen you start the Gui it tells you what version it is.ThanksRishi Abrol Alert Moderator Like (0) Re: Max Database Manager error: -24988 SQL error... Reagan Benjamin Oct 12, 2013 10:42 PM (in response to Arménio Teles) Currently Being Moderated Can you tell me how can I check which version has the Max Database?Try these commandsdbmcli -d SID -u control,password versionsu - sqdsidxinstinfo SIDYou can install MaxDB DB Manager on your local machine/laptop
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: http://scn.sap.com/thread/3437273 > > > > >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 https://lists.mysql.com/maxdb/18379 to 'all > > >>lists') and so 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 > >
the error-24988 sql error [sql_connect ...]; 1,database not runningSearching in the list archiv is not possible (next link resets to 'alllists') and so i http://maxdb.mysql.narkive.com/x3QvHbZB/24988-sql-error-sql-connect-1-database-not-running found nothing.db_cold/offline/warm don' t work - so what can i do?SuSE Linux http://grokbase.com/t/mysql/maxdb/039x4z5nnc/24988-sql-error-sql-connect-1-database-not-running ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build 027-121-048-452regardsAndreas Ernst--MaxDB Discussion Mailing ListFor list archives: http://lists.mysql.com/maxdbTo unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org jean-michel OLTRA 2003-09-29 12:25:58 UTC PermalinkRaw Message Le lundi 29 septembre 2003, Andreas Ernst a écrit...bonjour,Post by Andreas Ernstdb_cold/offline/warm don' t work - so what can i do?db_online ?--jean-michel--MaxDB Discussion Mailing sql error ListFor list archives: http://lists.mysql.com/maxdbTo unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org Zabach, Elke 2003-09-29 14:45:55 UTC PermalinkRaw Message Post by Andreas ErnstHi 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 runningSearching in the list archiv is not possible (next linkresets to 'alllists') and so i found nothing.db_cold/offline/warm don' t work 24988 sql error - so what can i do?'don't work'...what do they return/say?what does knldiag says?do you find some info in the archive when looking for that what knldiag tells you?ElkeSAP Labs BerlinPost by Andreas ErnstSuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build 027-121-048-452regardsAndreas Ernst--MaxDB Discussion Mailing ListFor list archives: http://lists.mysql.com/maxdb--MaxDB Discussion Mailing ListFor list archives: http://lists.mysql.com/maxdbTo unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org Andreas Ernst 2003-09-30 08:22:12 UTC PermalinkRaw Message Hi Elke,Post by Zabach, ElkePost by Andreas ErnstHi 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 runningSearching in the list archiv is not possible (next linkresets to 'alllists') and so 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_onlineOKAEONLINE - Simone> db_coldERROR-24988 sql error [db_cold]; 1,database not running1,database not runningAEONLINE - Simone> db_offlineERROR-24988 sql error [db_offline]; 1,database not running1,database not runningAEONLINE - Simone> db_warmOKdb_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_online2003-09-30 10:01:27 0x000053c5 0 DBM commandparam_startsession2003-0
one of the two DBs will not start.I get the error-24988 sql error [sql_connect ...]; 1,database not runningSearching in the list archiv is not possible (next link resets to 'alllists') and so i found nothing.db_cold/offline/warm don' t work - so what can i do?SuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build 027-121-048-452regardsAndreas Ernst reply Tweet Search Discussions Search All Groups maxdb 10 responses Oldest Nested jean-michel OLTRA Le lundi 29 septembre 2003, Andreas Ernst a écrit... bonjour, db_online ? -- jean-michel jean-michel OLTRA at Sep 29, 2003 at 12:29 pm ⇧ Le lundi 29 septembre 2003, Andreas Ernst a écrit...bonjour,db_cold/offline/warm don' t work - so what can i do?db_online ?--jean-michel reply | permalink Zabach, Elke 'don't work'... what do they return/say? what does knldiag says? do you find some info in the archive when looking for that what knldiag tells you? Elke SAP Labs Berlin Zabach, Elke at Sep 29, 2003 at 5:55 pm ⇧ 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 runningSearching in the list archiv is not possible (next linkresets to 'alllists') and so i found nothing.db_cold/offline/warm don' t work - so what can i do?'don't work'...what do they return/say?what does knldiag says?do you find some info in the archive when looking for that what knldiag tells you?ElkeSAP Labs BerlinSuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build 027-121-048-452regardsAndreas Ernst--MaxDB Discussion Mailing ListFor list archives: http://lists.mysql.com/maxdbTo unsubscribe:http://lists.mysql.com/maxdb?unsub=elke.zabach@sap.com reply | permalink Andreas Ernst Hi Elke, Zabach, Elke schrieb: 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 Andreas Ernst at Sep 30, 2003 at 8:22 am ⇧ Hi Elke,Zabach, Elke schrieb: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 runningSearching in the list archiv is not possible (next linkresets to 'alllists') and so i found nothin