Unable to start MaxDB.

[Former Member]

I'm using NW CE EHP1. Till yesterday everything was working perfectly. Now I am getting the following error while starting MaxDB service on Windows XP:

The MaxDB: CE1 service on Local Computer started and then

stopped. Some services stop automatically if they have no work to do, for

example, the Performance Logs and Alert Service.

Any suggestion?

Thanks in advance.

[Former Member]

Hi, I have the same problem as Livio

Can you please help me??

KnlMsg :

<MSGL _NO="110693" _PROCESS="4840" _THREAD="0x50C" _TIME="2010-09-08 13:57:57.580">

<MSG _NO="1" _TYPE="Error" _ID="20062" _COMP="RTE" _TEXT="RTE error opening diag pipe failed:2">

<MSG_ARGS

FILE="RTEDiagPipe.cpp"

_LINE="84"

_TIME="2010-09-08 13:57:57.393"

/>

</MSG>

</MSGL>

<MSGL _NO="110694" _PROCESS="4840" _THREAD="0x50C" _TIME="2010-09-08 13:57:57.955">

<MSG _NO="1" _TYPE="Error" _ID="20039" _COMP="RTE" _TEXT=" Param file KERNEL 7.7.06 BUILD 009-123-202-944">

<MSG_ARGS

FILE="RTEConfParameterAccessKernelInterface.cpp"

_LINE="2820"

_TIME="2010-09-08 13:57:57.955"

/>

</MSG>

<MSG _NO="2" _TYPE="Error" _ID="20038" _COMP="RTE" _TEXT=" Running kernel SlowKnl 7.7.04 Build 021-123-186-883">

<MSG_ARGS

FILE="RTEConfParameterAccessKernelInterface.cpp"

_LINE="2819"

_TIME="2010-09-08 13:57:57.924"

/>

</MSG>

<MSG _NO="3" _TYPE="Error" _ID="20037" _COMP="RTE" _TEXT="incompatible versions:">

<MSG_ARGS

FILE="RTEConfParameterAccessKernelInterface.cpp"

_LINE="2818"

_TIME="2010-09-08 13:57:57.924"

/>

</MSG>

</MSGL>

KnlDiag :

Thread 0x50C Task - 2010-09-08 13:57:57 ERR RTE 20062: RTE error opening diag pipe failed:2,_FILE=RTE_DiagPipe.cpp,_LINE=84

Thread 0x50C Task - 2010-09-08 13:57:57 ERR RTE 20039: Param file KERNEL 7.7.06 BUILD 009-123-202-944,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2820

2010-09-08 13:57:57 ERR RTE 20038: Running kernel SlowKnl 7.7.04 Build 021-123-186-883,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2819

2010-09-08 13:57:57 ERR RTE 20037: incompatible versions:,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2818

Thanks in advance,

Himanshu

[Former Member]

I have the same problem of Livio.

I'm using NW CE EHP1 SP04, and the Operating System is Windiows XP Professional Ver. 2002 SP 3.

Yesterday, as usual, I shoot down everything regularly and switched off the machine.

This morning, I switched the machine on and the MaxDb doesn't start anymore.

Looking at system services, the .UMDB service is started, while the CE1 service not.

If I start the CE1 service manually, the event viewer shows 3 information events like the following:

-

---

The description for Event ID ( 20039 ) in Source ( MAXDB ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: SAP DBTech-CE1; :

- INFO TID: 0x5AC PID: 0x5A8 MsgID: 20039

; Param file KERNEL 7.7.06 BUILD 009-123-202-944.

-

---

I generated the knldiag as well. It's content is the following:

-

---

Thread 0xA70 Task - 2010-01-11 16:43:12 ERR RTE 20062: RTE error opening diag pipe failed:2,_FILE=RTE_DiagPipe.cpp,_LINE=84

Thread 0xA70 Task - 2010-01-11 16:43:12 ERR RTE 20039: Param file KERNEL 7.7.06 BUILD 009-123-202-944,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2820

2010-01-11 16:43:12 ERR RTE 20038: Running kernel Kernel 7.7.04 Build 021-123-186-883,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2819

2010-01-11 16:43:12 ERR RTE 20037: incompatible versions:,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2818

-

---

Can you help me?

I had this problem also some months ago and I had to reinstall the whole NW CE.

Adolfo.

[lbreddemann]

> ERR RTE 20039: Param file KERNEL 7.7.06 BUILD 009-123-202-944

> Running kernel Kernel 7.7.04 Build 021-123-186-883

> ERR RTE 20037: incompatible versions

Hmm... looks like somebody has copied parameter files from one instance to another.

This doesn't work and it isn't supposed to.

Or maybe a downgrade of the database had been tried here.

Anyhow, I see two options here:

1) install the 7.7.06 software via SDBINST and start the instance with that

or

2) restore the 7.7.04 database via "INSTANCE INITIALIZE" -> "RECOVERY".

> Can you help me?

> I had this problem also some months ago and I had to reinstall the whole NW CE.

Then you should know how you produced this situation - it's nothing that just happens.

regards,

Lars

[lbreddemann]

> The MaxDB: CE1 service on Local Computer started and then

> stopped.

You may want to check the KNLDIAG/KNLMSG file to find out why the MaxDB stopped working.

> Some services stop automatically if they have no work to do, for

> example, the Performance Logs and Alert Service.

This is not the case for MaxDB...

best regards,

Lars

[Former Member]

Lars,

in the C:\sapdb\data\wrk\CE1 directory I found a file named KnlMsg whose content is updated anytime I try to start MaxDB. I hope it's the right file. Here is its content following a failed attempt to start MaxDB.

<MSGL _NO="109716" _PROCESS="5768" _THREAD="0x6D0" _TIME="2009-06-02 15:42:45.281">

<MSG _NO="1" _TYPE="Error" _ID="20062" _COMP="RTE" _TEXT="RTE error opening diag pipe failed:2">

<MSG_ARGS

FILE="RTEDiagPipe.cpp"

_LINE="84"

_TIME="2009-06-02 15:42:45.265"

/>

</MSG>

</MSGL>

<MSGL _NO="109717" _PROCESS="5768" _THREAD="0x6D0" _TIME="2009-06-02 15:42:45.281">

<MSG _NO="1" _TYPE="Error" _ID="20039" _COMP="RTE" _TEXT=" Param file KERNEL 7.7.06 BUILD 009-123-202-944">

<MSG_ARGS

FILE="RTEConfParameterAccessKernelInterface.cpp"

_LINE="2820"

_TIME="2009-06-02 15:42:45.281"

/>

</MSG>

<MSG _NO="2" _TYPE="Error" _ID="20038" _COMP="RTE" _TEXT=" Running kernel Kernel 7.7.04 Build 021-123-186-883">

<MSG_ARGS

FILE="RTEConfParameterAccessKernelInterface.cpp"

_LINE="2819"

_TIME="2009-06-02 15:42:45.281"

/>

</MSG>

<MSG _NO="3" _TYPE="Error" _ID="20037" _COMP="RTE" _TEXT="incompatible versions:">

<MSG_ARGS

FILE="RTEConfParameterAccessKernelInterface.cpp"

_LINE="2818"

_TIME="2009-06-02 15:42:45.281"

/>

</MSG>

</MSGL>

I couldn't find any knldiag file.

Thank you for your cooperation.

[markus_doehr2]

> in the C:\sapdb\data\wrk\CE1 directory I found a file named KnlMsg whose content is updated anytime I try to start MaxDB. I hope it's the right file. Here is its content following a failed attempt to start MaxDB.

- open a cmd.exe

- cd c:\sapdb\data\wrk\CE1

- enter "protconv > knldiag"

This will create a text file with the content of the .xml log.

Markus

[Former Member]

Markus,

following your explanation, I got the knldiag file, and here is its content:

Thread 0x6D0 Task - 2009-06-02 15:42:45 ERR RTE 20062: RTE error opening diag pipe failed:2,_FILE=RTE_DiagPipe.cpp,_LINE=84

Thread 0x6D0 Task - 2009-06-02 15:42:45 ERR RTE 20039: Param file KERNEL 7.7.06 BUILD 009-123-202-944,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2820

2009-06-02 15:42:45 ERR RTE 20038: Running kernel Kernel 7.7.04 Build 021-123-186-883,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2819

2009-06-02 15:42:45 ERR RTE 20037: incompatible versions:,_FILE=RTEConf_ParameterAccessKernelInterface.cpp,_LINE=2818

Compared with the knlmsg file, the content seems to be the same, but the format is different.

Having looked at these files I still have no idea of the reason of the failure.

Any suggestion?

Thanks.

[markus_doehr2]

Did you install something else on the system? It seems that the parameters are for a newer than the installed version.

Markus

[Former Member]

Markus,

I didn't install anything manually. In addition, I spent a couple of hours checking whether

some automatic update took place, but I found nothing.

Database Studio 7.7.06.09, which I installed a long time ago, shows the possible db states

(online, admin, offline) as grayed out.

This NW CE system is used to test locally the applications just developed with NWDS

and hence it doesn't hold relevant data. If necessary, it can be reinstalled (but I would

prefere not).

Thanks.

Livio

[markus_doehr2]

I have only one idea left..

dbmcli -U c db_offline
dbmcli -U c param_checkall
dbmcli -U c db_online

If that does not work I'm out of ideas

Markus

[markus_doehr2]

If the system has no user key for "c" you may use

dbmcli -U c_J2EE ...

instead.

Markus

[Former Member]

"dbmcli -U c db_offline" returns

"Error! XUser not found"

"dbmcli -U c_J2EE db_offline" returns

"Error! Connection failed to node NB-LAZZLIV1 for database CE1:

-24950,ERR_USRFAIL: user authorization failed

[lbreddemann]

>

> Compared with the knlmsg file, the content seems to be the same, but the format is different.

Nearly correct - the KNLMSG file itself is a XML representation of the database messages. Via protconv, the GUIs or the DBM-commands a human readable version is build up and additional informatin (if available) are added.

Concerning the error you face:

>error opening diag pipe failed:2,_FILE=RTE_DiagPipe.cpp,_LINE=84

This indicates that Windows wasn't able to find the "file".

What's meant is that the pipe cannot be opened.

Do you see any error messages in the Windows event logs?

Under which user do you run the MaxDB Service?

regards.

Lars

[Former Member]

Thank you Lars. Here are the informations you requested.

1. I couldn't find the RTE_DiagPipe.cpp anywhere.

2. In the event log there is a couple of error messages:

"The SAPCE1_00 service hung on starting" and

"The SAPCE1_01 service hung on starting"

The strange thing is that SAPCE1_00 and SAPCE1_01 don't appear

in the list of services. I compared this with a working NW CE system,

and I discovered that there those two service are up and running!

3. The MaxDB service is run under the Local System account.

Besides, the "allow service to interact with desktop" option is checked.

Thank you for the cooperation.

Livio.

[lbreddemann]

> 1. I couldn't find the RTE_DiagPipe.cpp anywhere.

Of course not - it's just a reference to the source code file that contains the part of the program where this error occured.

> 2. In the event log there is a couple of error messages:

> "The SAPCE1_00 service hung on starting" and

> "The SAPCE1_01 service hung on starting"

> The strange thing is that SAPCE1_00 and SAPCE1_01 don't appear

> in the list of services. I compared this with a working NW CE system,

> and I discovered that there those two service are up and running!

Hmm... this has nothing directly to do with MaxDB as these are SAP NetWeaver services.

However maybe the same thing happened to them what happened to your MaxDB instance...!?

> 3. The MaxDB service is run under the Local System account.

> Besides, the "allow service to interact with desktop" option is checked.

As it should be.

Pretty weired.

Actually, without system access I'm out of ideas now.

If this would be my database, I would go and reinstall the MaxDB software, re-create the MaxDB instance and attach the existing volumes to this instance.

However this is rather something for somebody actually knowing what he/she does there.

So why don't you open a support message instead?

regards,

Lars

[Former Member]

Thank you Lars for your kind cooperation.

I will reinstall MaxDB.

Livio.

[Former Member]

Hi,

Check nelow sap notes. It may help you.

Note 1020860 - MaxDB/SAPDB Database does not start

Note 846890 - FAQ: MaxDB Administration

Thanks,

Sushil

[lbreddemann]

Just a remark...

... throwing notes at questions/problems without understanding what these notes are about

... what the problem may be and how to approach it ...

... that rarely helps anybody

... that is what I try to prevent in support from happening

... just my two pence ...

regards,

Lars

[Former Member]

got it Lars