cancel
Showing results for 
Search instead for 
Did you mean: 

ERR 18432 MESSAGES Event log is full, rc = 1502

Former Member
0 Kudos

Hello, Everyone

When I tried to start a maxdb service, it failed. Then I opened the file of knldiag.err , and I found the following lines:

2010-05-02 11:30:57 0x508 ERR 18432 MESSAGES Event log is full, rc = 1502

2010-05-02 11:31:08 0x9E0 ERR 20125 RTE Database automatic restart failed

2010-05-02 12:35:22 0x98 ERR 18431 MESSAGES Could not write to event log, rc = 5

2010-05-02 12:35:23 ___ Stopping GMT 2010-05-02 04:35:23 7.6.00 Build 037-121-149-748

2010-05-02 13:39:23 --- Starting GMT 2010-05-02 05:39:23 7.6.00 Build 037-121-149-748

2010-05-02 13:39:25 0x1650 ERR 18432 MESSAGES Event log is full, rc = 1502

2010-05-02 13:39:26 0x14D4 ERR 20125 RTE Database automatic restart failed

2010-05-02 14:05:23 0x111C ERR 18431 MESSAGES Could not write to event log, rc = 31

2010-05-02 14:05:24 ___ Stopping GMT 2010-05-02 06:05:24 7.6.00 Build 037-121-149-748

What's the matter with it ?

How can I solve this problem?

Any advice will be appreciated!

Best regards.

Fang

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi Fang,

I'm not like the windows guru but I think the error ur talking about:

2010-05-02 11:30:57 0x508 ERR 18432 MESSAGES Event log is full, rc = 1502

is refering to the windows event log being full and not the maxDB log being full.

There's a tool that comes with maxDB called xsysrc .. it looks up sys error number/text:

C:\Users\me>where xsysrc

C:\sapdb\programs\bin\xsysrc.exe

C:\Users\me>xsysrc 1502

Errortext for errorcode 1502:

'The event log file is full. ==> this is what ur seeing.

You can also look up other rc codes u listed here ( rc = 5, rc = 31 ) in the similar way.

Former Member
0 Kudos

Dear Junco Ueda,

Thank you very much for you kind reply.

As you pointed out, the system event log is full, so I cleared it.

But I still failed to start the service.

This time the last serveral lines of knldiag gave the following message:

2010-05-06 21:33:54 0x2E0 3 RunTime State changed from STARTING to ADMIN

2010-05-06 21:33:54 0x2E0 19601 DBSTATE SERVERDB is ready

============================================ begin of write cycle ==================

2010-05-06 21:33:54 0x2E0 20223 RTE Database tries automatic restart

2010-05-06 21:33:54 0x1450 19821 TASKING Thread 5200 starting

2010-05-06 21:33:56 0x1450 ERR 20125 RTE Database automatic restart failed

-


current write position

I could not figure out this problem. Would you please give me some advice on how to handle this?

Thanks in advance.

Fang

Answers (6)

Answers (6)

Former Member
0 Kudos

I'm unsure why such a large shm needs to be allocated.

There is a direct command to cleanup the shm but at this point, I'm unsure if you want to go there w/out first investigating what is the story with the huge allocation of shm.

Lastly, can you take a look at this thread and see if it helps at all:

If not and you are a sap cust, maybe opening a customer message at this point will be the best bet.

Former Member
0 Kudos

Hello, Junco Ueda

Thanks for your reply.

I read the recommended message but found that was not my case.

My windows box is windows XP professional with service pack 2.

That db was running for a long time. But suddenly failed to start.

I do not know why the dbm.shm file size is that large. Perhaps I have to execute the command to cleanup the dbm.shm file.

But the problem is that when I execute dbmcli command to start up the db, the nearly 4GB size of dbm.shm file was created again!

I have to solve this problem as soon as possible. Any advice will be appreciated!

Fang

former_member229109
Active Contributor
0 Kudos

Hello Fang,

1. Please let us know if you are SAP customer first.

2. If you are SAP customer:

u2022 Could you please create the SAP ticket on this issue

u2022 What SAP system version do you have?

3. Could you post the output of the commands:

dbmcli u2013s dbm_version

dbmcli dbm_version

dbmcli u2013n <database server> dbm_version

dbmcli db_enum u2013s

xinstinfo XNCXTYHC

<InstallationPath>\pgm\dbmshm CHECK f:\sdb\data\wrk XNCXTYHC

Post the output.

Is the drive f:\ a local database drive?

If not, please post more details on the installation architecture of the system.

4. Could you please set the u201CStart Typeu201D for MAXDB services to Manual on MAXDB server.

Then reboot the server.

Stop the x_server. Stop all applications.

Close all dbmcli & DBMGUI sessions.

Logon as your user first:

<InstallationPath>\pgm\dbmshm DELETE f:\sdb\data\wrk XNCXTYHC

Login to the database server locally as administrator & run :

<InstallationPath>\pgm\dbmshm DELETE f:\sdb\data\wrk XNCXTYHC

Could you connect to the database after that?

u2022 Restart the x_server.

u2022 dbmcli u2013d XNCXTYHC u2013n <database server name> -u <dbm-user>,<pwd>

<enter>

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hello, Natalia

1. First, I am not a SAP customer. Thanks a lot for so much help.

3. The output of the commands

(1) dbmcli dbm_version

OK

VERSION = 7.6.00

BUILD = DBMServer 7.6.00 Build 037-121-149-748

OS = WIN32

INSTROOT = F:\sdb\7600

LOGON = True

CODE = ASCII

SWAP = full

UNICODE = (unknown)

INSTANCE = (unknown)

SYSNAME = Windows XP

(2) dbmcli db_enum -s

OK

ZYCJDXTJ F:\sdb\7600 7.6.00.37 fast running

ZYCJDX1 F:\sdb\7600 7.6.00.37 fast offline

YEFANGCU F:\sdb\7600 7.6.00.37 fast offline

XNJXTCHU F:\sdb\7600 7.6.00.37 fast running

XNJCSDB F:\sdb\7600 7.6.00.37 fast running

xncxtyhc F:\sdb\7600 7.6.00.37 fast offline

XNCXTDB0 F:\sdb\7600 7.6.00.37 fast offline

XNCXTCH1 F:\sdb\7600 7.6.00.37 fast offline

WANGZON1 F:\sdb\7600 7.6.00.37 fast running

TUANWANG F:\sdb\7600 7.6.00.37 fast offline

HELUOCUN F:\sdb\7600 7.6.00.37 fast offline

CWZ32009 F:\sdb\7600 7.6.00.37 fast offline

CWZ22009 F:\sdb\7600 7.6.00.37 fast offline

CWZ12008 F:\sdb\7600 7.6.00.37 fast offline

CWYF2008 F:\sdb\7600 7.6.00.37 fast offline

CWTW2009 F:\sdb\7600 7.6.00.37 fast offline

CWTW2008 F:\sdb\7600 7.6.00.37 fast offline

cwgp2009 F:\sdb\7600 7.6.00.37 fast offline

cwgp2008 F:\sdb\7600 7.6.00.37 fast offline

cwgo2008 F:\sdb\7600 7.6.00.37 fast offline

CWGA2008 F:\sdb\7600 7.6.00.37 fast offline

CW312008 F:\sdb\7600 7.6.00.37 fast running

cw112008 F:\sdb\7600 7.6.00.37 fast offline

CJDXDB F:\sdb\7600 7.6.00.37 fast running

AOWEI1 F:\sdb\7600 7.6.00.37 fast running

.M760037 F:\sdb\7600 7.6.00.37 fast offline

.M760037 F:\sdb\7600 7.6.00.37 quick offline

.M760037 F:\sdb\7600 7.6.00.37 slow offline

.M760037 F:\sdb\7600 7.6.00.37 test offline

(3) xinstinfo XNCXTYHC

IndepData : f:\sdb\data

IndepPrograms : f:\sdb\programs

InstallationPath : F:\sdb\7600

Kernelversion : KERNEL 7.6.00 BUILD 037-121-149-748

Rundirectory : f:\sdb\data\wrk\XNCXTYHC

Edited by: worldisflat on May 18, 2010 9:29 AM

Former Member
0 Kudos

Hello, Natalia

1. First, I am not a SAP customer. Thanks a lot for so much help.

3. The output of the commands

(1) dbmcli dbm_version

OK

VERSION = 7.6.00

BUILD = DBMServer 7.6.00 Build 037-121-149-748

OS = WIN32

INSTROOT = F:\sdb\7600

LOGON = True

CODE = ASCII

SWAP = full

UNICODE = (unknown)

INSTANCE = (unknown)

SYSNAME = Windows XP

(2) dbmcli db_enum -s

OK

ZYCJDXTJ F:\sdb\7600 7.6.00.37 fast running

ZYCJDX1 F:\sdb\7600 7.6.00.37 fast offline

YEFANGCU F:\sdb\7600 7.6.00.37 fast offline

XNJXTCHU F:\sdb\7600 7.6.00.37 fast running

XNJCSDB F:\sdb\7600 7.6.00.37 fast running

xncxtyhc F:\sdb\7600 7.6.00.37 fast offline

XNCXTDB0 F:\sdb\7600 7.6.00.37 fast offline

XNCXTCH1 F:\sdb\7600 7.6.00.37 fast offline

WANGZON1 F:\sdb\7600 7.6.00.37 fast running

TUANWANG F:\sdb\7600 7.6.00.37 fast offline

HELUOCUN F:\sdb\7600 7.6.00.37 fast offline

CWZ32009 F:\sdb\7600 7.6.00.37 fast offline

CWZ22009 F:\sdb\7600 7.6.00.37 fast offline

CWZ12008 F:\sdb\7600 7.6.00.37 fast offline

CWYF2008 F:\sdb\7600 7.6.00.37 fast offline

CWTW2009 F:\sdb\7600 7.6.00.37 fast offline

CWTW2008 F:\sdb\7600 7.6.00.37 fast offline

cwgp2009 F:\sdb\7600 7.6.00.37 fast offline

cwgp2008 F:\sdb\7600 7.6.00.37 fast offline

cwgo2008 F:\sdb\7600 7.6.00.37 fast offline

CWGA2008 F:\sdb\7600 7.6.00.37 fast offline

CW312008 F:\sdb\7600 7.6.00.37 fast running

cw112008 F:\sdb\7600 7.6.00.37 fast offline

CJDXDB F:\sdb\7600 7.6.00.37 fast running

AOWEI1 F:\sdb\7600 7.6.00.37 fast running

.M760037 F:\sdb\7600 7.6.00.37 fast offline

.M760037 F:\sdb\7600 7.6.00.37 quick offline

.M760037 F:\sdb\7600 7.6.00.37 slow offline

.M760037 F:\sdb\7600 7.6.00.37 test offline

(3) xinstinfo XNCXTYHC

IndepData : f:\sdb\data

IndepPrograms : f:\sdb\programs

InstallationPath : F:\sdb\7600

Kernelversion : KERNEL 7.6.00 BUILD 037-121-149-748

Rundirectory : f:\sdb\data\wrk\XNCXTYHC

Former Member
0 Kudos

(4) F:\sdb\7600\pgm>dbmshm CHECK f:\sdb\data\wrk XNCXTYHC

ERR

-24835,ERR_SHMNOINFOFILE: Shared memory missing information file

-24834,ERR_SHMNODATAFILE: Shared memory missing data file

f:\ is a local database drive.

4. The ouput of <InstallationPath>\pgm\dbmshm DELETE f:\sdb\data\wrk XNCXTYHC

OK

5. I could not connect to the database after that by using dbmcli -n localhost -d xncxtyhc -u dbm,B1234567

The output is as follows:

Error! Connection failed to node (local) for database xncxtyhc:

-24700,ERR_DBMSRV_NOSTART: Could not start DBM server.

-24832,ERR_SHMNOTAVAILABLE: Shared memory not available

-24686,ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory

-24827,ERR_SHMALLOCFAILED: ID f:\sdb\data\wrk\XNCXTYHC.dbm.shm, requested size 4283826678

I checked the size of f:\sdb\data\wrk\XNCXTYHC.dbm.shm, it is 4,283,826,678.

My system is Windows XP service pack 2 with physicial memory sized 2GB.

I guessed the reason is -24835,ERR_SHMNOINFOFILE: Shared memory missing information file, but I don't know what it is and how to create it.

Wish your kind reply and thanks in advance.

Fang

former_member229109
Active Contributor
0 Kudos

Hello Fang,

1. You created many database instances based on one database kernel installation.

Do you have problems to connect to another database instances?

2. Itu2019s 32bit server and you have 7 database instances running on this server. Correct?

3. Did you connect to the database server via WTS connection?

4. Do you have another windows 32bit server , where you could copy the XNCXTYHC

Database instance?

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

hi,

Sounds like the last db shutdown wasn't a clean one. Can u try:

1. If u have appservers that connect to the DB, stop them.

2. stop x_server.

3. check NO dbmsrv processes are running on the db server.

4. close all dbmgui/dbmcli sessions.

5. rename: // save the originals, just in case u need them later.

f:\sdb\data\wrk\XNCXTYHC.dbm.shm => f:\sdb\data\wrk\XNCXTYHC.dbm.shm.old

f:\sdb\data\wrk\XNCXTYHC.dbm.shi => f:\sdb\data\wrk\XNCXTYHC.dbm.shi.old

6. try: dbmcli -d xncxtyhc -u ITACCEL,A1234567

If no error, then

restart x_server

restart app

restart db (db_online)

7. if all is good, u can go ahead and delete the *.old ones.

Former Member
0 Kudos

Dear Junco Ueda,

I followed your advice and executed all of the commands. But I still got the same error.

2010-05-08 18:24:52 0x000011c8 ERR -24700 DBMSrv ERR_DBMSRV_NOSTART: Could not start DBM server.

0x000011c8 ERR -24832 DBMSrv ERR_SHMNOTAVAILABLE: Shared memory not available

0x000011c8 ERR -24686 DBMSrv ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory

0x000011c8 ERR -24827 DBMSrv ERR_SHMALLOCFAILED: ID f:\sdb\data\wrk\XNCXTYHC.dbm.shm, requested size 4283826678

2010-05-08 18:24:52 0x000011c8 INF 226 DBMSrv DBM Server client disconnect: PID 1780 on computer ITACCEL_PC_LAKE

I checked the file size of XNCXTYHC.dbm.shm, it is exactly 4283826678 and the spare space of F drive is nearly 4.37GB. Other db's dbm.shm is only 875B(less then 1KB).

When I checked the system event log, I found strange messages as follows:

The Apache service named reported the following error:

>>> httpd.exe: Syntax error on line 35 of L:/\xe5\xbc\x80\xe5\x8f\x91\xe8\x8c\x83\xe4\xbe\x8b/EPC-Setup/jinhersoft/apache/conf/httpd.conf: ServerRoot must be a valid directory .

So I have the following questions:

1. Why XNCXTYHC.dbm.shm requires so large a size as to be 4283826678B?

2. Why Apache service needs to be started ( and shutdown) when a db is going to be started (and shutdown)? Is this behavior due to virus?

3. Is there other direct command to cleanup the DBM server Shared Memory?

Your answer is highly appreciated!

Fang

Former Member
0 Kudos

You can also check these files for any errors during the start up. Anything good in there?

Directory of C:\sapdb\data\wrk:

dbmsrv_<hostname>.err

dbmsrv_<hostname>.prt

Former Member
0 Kudos

Dear Junco Ueda,

I executed the following command and got the error messages as follows:

F:\>dbmcli -d xncxtyhc -u ITACCEL,A1234567

Error! Connection failed to node (local) for database xncxtyhc:

-24700,ERR_DBMSRV_NOSTART: Could not start DBM server.

-24832,ERR_SHMNOTAVAILABLE: Shared memory not available

-24686,ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory

-24827,ERR_SHMALLOCFAILED: ID f:\sdb\data\wrk\XNCXTYHC.dbm.shm, requested size 4283826678

It seems that the shared memory is not enough. The required size is nearly 4280MB. It is incredible!

So how can I cleanup the DBM server Shared Memory? what kind of command show I type?

Thanks in advance.

Fang

Former Member
0 Kudos

hi,

Can you paste the entire output to the below command, at the dos prompt:

>> dbmcli -d <sid> -u <dbm userame, password>

for example, for my local system:

>> dbmcli -d MESSY -u control, control

Former Member
0 Kudos

hi Fang,

knldiag isn't telling us much there. Can you take a look at knldiag.err and even dbm.prt to see if there are any errors reported about 2010-05-06 21:33:54, during the last startup?

Can you also paste the output of db_state? I think db is stuck in admin mode.

Former Member
0 Kudos

Dear Junco Ueda,

Thank you very much for your kind reply.

Unfortunately, the error message is little and provides less hints.

knldiag.err gave the following error message:

2010-05-06 21:33:52 --- Starting GMT 2010-05-06 13:33:52 7.6.00 Build 037-121-149-748

2010-05-06 21:33:56 0x1450 ERR 20125 RTE Database automatic restart failed

dbm.prt had no message at that time.

When I tried to connect it via database manager, the following error message popped up:

-100 ERR_DBMSRV_NOSTART: Could not start DBM.

What is the possible problem?

Is there any way to get more information?

Your advice will be highly appreciated!

Fang

Former Member
0 Kudos

Hello, Dear Experts:

Because nobody answered my question, I have to sincerely ask help again from the experts.

The sap db service of windows could not startup due to the error of ERR 18432 MESSAGES Event log is full, rc = 1502.

I guessed the possible reason as log file is full. But how can I do something to expand the size of the log file? The database manager could not connected to the DB instance !

I am desperated because I can not afford to lose the DATA and I can not find any material to solve it.

Please help me. Any advice will be highly appreciated!

Fang