Unable to Start SAP via MAXDB

[Former Member]

Hi there

I am new to MAX DB database .

I am unable to start sap  , please advice as per attachment below .Thanks

Regards

Clement

dev_w0.txt.zip

dev_disp.txt.zip

[karthikeyan_natarajan4]

Hi Clement,

when R3trans-d and R3trans -x test gives 0, then next step is to check the log file, which might be full.

Use DBMGUI to check the size of log file, if you don't have it, download from - http://www.sdn.sap.com/irj/scn/downloads?rid=/library/uuid/8092b159-c165-2910-958a-ea4e3e5f56cf

If you log area is 100% full, backup it and restart the database, which will clear the log file free. you can this post.

http://scn.sap.com/message/14035969#14035969

Also, please paste us the startDEV.log

regards

karthik

[Former Member]

Hello Karthik

Not able to download dbmgui , giving the error below

Unfortunately we have trouble completing your download request. Please contact sdn@sap.com for further support.

Attach is the startsap log :-

SAP-R/3-Startup Program

Starting at 2013/05/16 13:55:37

Startup Profile: "D:\usr\sap\ERP\SYS\profile\START_DVEBMGS10_iwdfvm2160"

Starting Programs

(580) Execute: D:\usr\sap\ERP\SYS\exe\uc\NTI386\sapcpe.EXE pf=\\iwdfvm2160\sapmnt\ERP\SYS\profile\ERP_DVEBMGS10_iwdfvm2160

(5332) Execute: D:\usr\sap\ERP\SYS\exe\uc\NTI386\strdbs.cmd ERP

(4012) CreateProcess: D:\usr\sap\ERP\DVEBMGS10\exe\msg_server.EXE pf=\\iwdfvm2160\sapmnt\ERP\SYS\profile\ERP_DVEBMGS10_iwdfvm2160

(2888) CreateProcess: D:\usr\sap\ERP\DVEBMGS10\exe\disp+work.EXE pf=\\iwdfvm2160\sapmnt\ERP\SYS\profile\ERP_DVEBMGS10_iwdfvm2160

(5636) CreateProcess: D:\usr\sap\ERP\DVEBMGS10\exe\igswd.EXE -mode=profile pf=\\iwdfvm2160\sapmnt\ERP\SYS\profile\ERP_DVEBMGS10_iwdfvm2160

[MichaelTe]

Hello Clement,

to check if your log is full you can use the following command:

http://wiki.sdn.sap.com/wiki/display/MaxDB/Log+Area+Full

Using the following DBMCLI command you get a list of the active database tasks. 
dbmcli -d <database_name> -u <dbm_user>,<password> show active 
If the log area is full, all active tasks are in state log full.

Beside of that, please post the output of the command as user <sid>adm:

xuser list

Regards, Michael

[Former Member]

Hi Micheal & all

The following is the output

C:\>dbmcli -d ERP -u CONTROL,admin123 show active

OK

SERVERDB: ERP

ID   UKT  Win   TASK       APPL Current         Timeout Region     Wait

          tid   type        pid state          priority cnt try    item

Console command finished (2013-05-16 22:44:30).

C:\>xuser list

-----------------------------------------------------------------

XUSER Entry  1

--------------

Key         :DEFAULT

Username    :SAPERP

UsernameUCS2:S.A.P.E.R.P. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password    :?????????

PasswordUCS2:?????????

Dbname      :ERP

Nodename    :localhost

Sqlmode     :SAPR3

Cachelimit  :-1

Timeout    

Isolation   

Charset     :<unspecified>

-----------------------------------------------------------------

XUSER Entry  2

--------------

Key         :c

Username    :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password    :?????????

PasswordUCS2:?????????

Dbname      :ERP

Nodename    :localhost

Sqlmode     :<unspecified>

Cachelimit  :-1

Timeout     :-1

Isolation   :-1

Charset     :<unspecified>

Regards

Clement

[Former Member]

Hi '

The following is the screen shot of log area :-

Regards

Clement

[Former Member]

The log is not full (notice that now the database is in overwrite mode, so the log shouldn't grow....).

R3trans has return code 000.

Could you retry to start SAP via command line?

[MichaelTe]

Hello Clement,

according to Note 39439 - XUSER entries for SAP MaxDB there have to be 3, or with Java, 4 entries:

2. Which XUSER entries are required?
              XUSER entries are required for the following database users: 
DBA user: SAP<SID> (SAP BASIS 6.10 or higher):
xuser -U DEFAULT -u SAP<SID>,<password> -d  <database_name> -n <database_server> -S SAPR3 -t 0 -I 0 set
DBM user: for example, CONTROL:
xuser -U c -u CONTROL,<password> -d <database_name> -n <database_server> -S INTERNAL set
Database administrator: for example, SUPERDBA:
xuser -U w -u SUPERDBA,<password> -d <database_name> -n <database_server> -S INTERNAL set
Additional XUSER entry for J2EE: DBM user (for example, CONTROL):
                xuser -U c_J2EE -u CONTROL,<password> -d <database_name> -n <database_server> -S INTERNAL set 

Add the XUSER Entry for the user SUPERDBA.

Regards, Michael

[Former Member]

Hi All

Tried both solution adding SUPERDBA to XUSERLIST and also starting in the command line , still no luck at all .

Please advice further.Thanks

Regards

Clement

[Former Member]

Hi All

Anymore clue to solve this issue ?

Regards

Clement

[Former Member]

Have you some new logs?

[Former Member]

Hi Matteo

I took over when the system is went down , don't know anyone change anything ,the scenario is this is not an upgrade ,  I have recreated the XUSER  , the log is not full  as well and the yet it says XUSER is unknown  in the log :-

Attach is the log :-

Regards

Clement

xuserlist.txt.zip

dev_w0.txt.zip

dev_disp.txt.zip

[karthikeyan_natarajan4]

Hi Clement,

Let's try this,

Xuser -U DEFAULT -u SAPERP, <password> -d ERP -n localhost -S SAPR3 -t 0 -i 0 set

Look this one too

http://scn.sap.com/docs/DOC-40842

From the xuser list, XUSER Entry  2 - CONTROL (DBM user) set the sqlmode to internal which is unspecified in the output of xuser list.

xuser -U c -u CONTROL,<password> -d <database_name> -n <database_server> -S INTERNAL set

regards

karthik

[Former Member]

Hi

How can I log in SAPService<SID> as per below , currently it doesn't permit me .

Please logon as user SAPService<SID> and check the xuser list and see if the Dbname is wrong.

xuser -c SAPSERVICE<SID> -U DEFAULT -u SAP<SID>,PASSWORd -d <SID>
                                        -n <SERVER NAME> -S SAPR3 -t0 -I 0 set

Regards

Clement

[karthikeyan_natarajan4]

Hi Clement,

try login using SAPService<SID> from OS level. (logoff and login using this user)

[Former Member]

This message was moderated.

[Former Member]

You have to insert SAPService<sid> in the user group (of windows OS) of "rdp users" so that after you can connect to the server via rdp with this user, the password should be the same of <sid>adm

[Former Member]

Manage to log in with SAPServiceERP , still no difference  and heres the output of xuser list :-

xuserlist.txt.zip

[MichaelTe]

Hello Clement,

could you try to make the entries for user "erpadm" and "SAPServiceERP" in the "xuser" with the real hostname, instead of localhost?

Regards, Michael

[Former Member]

Hi,

If your R3trans-d and R3trans -x showing 0 and then may be if your Log file may be full..try to check from MAX DB studio or Os level if your using LINUX/UNIX operating system.

Regards

Ashok

[AtulKumarJain]

Hi Clement,

Please check

http://scn.sap.com/thread/1179925

http://scn.sap.com/thread/3332362

Best Regards,

Atul

[MichaelTe]

Hi Clement,

please check the following notes:

Note 1444798 - Remote shadow instance on MaxDB

Note 39439 - XUSER entries for SAP MaxDB

Regards,

Michael

[Former Member]

Hello All

After executing

xuser -U DEFAULT -u SAPERP,admin1234 -d ERP -n tx300-s4 set.

I have ran R3trans -d and I am still encountering the error as per attachment :-

Please advice further.Thanks

Regards

Clement

test.txt.zip

[Former Member]

The error reported in trans.log is:

*** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

Are you sure to have run the command xuser correctly? Check username and password.

[MichaelTe]

Hello Clement,

I think you now messed up your XUSER file.

In an earlier post you said (and the screenshot shows) that "R3trans -x" and "R3trans -d" returned 0. Which would be ok. Now you entered new data in the XUSER file with your command:

 xuser -U DEFAULT -u SAPERP,admin1234 -d ERP -n tx300-s4 set.

And the tests with R3trans are failing. So you entered wrong data.

But this has nothing to do with your initial problem.

You now need to enter the correct data with the XUSER command (maybe you entered a wrong password).

Also your command for XUSER is wrong. According to Note 39439 - XUSER entries for SAP MaxDB it has to be:

 xuser -U DEFAULT -u SAPERP,admin1234 -d ERP -n tx300-s4 -S SAPR3 -t 0 -I 0 set

After that the commands "R3trans -x" and "R3trans -d" should return 0.

And you would be at the beginning.

By the way: Are you doing a Upgrade?

Regards, Michael

[Former Member]

Hi Micheal

Yes I have messed up the XUSER ,I manage to fix it with the correct password , it is still giving me the same error as my orginal post .

What else I need to check ?

One more thing is the C drive only have 4.7 GB free space

Regards

Clement

C:\>r3trans -d

This is r3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

unicode enabled version

r3trans finished (0000).

C:\>r3trans -x

This is r3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

unicode enabled version

r3trans finished (0000).

[Aleksandr]

Clement,

In Your log trans:

2EETW169 no connect possible: "DBMS = ADABAS D

--- DBNAME = ''"

I think that is your problem.

Solve:

http://scn.sap.com/thread/1979638

https://scn.sap.com/thread/1955800

[Former Member]

Hello,

it seem some problem in the connection to the database.

In dev_w0 there are these errors:

C  Try to connect (DEFAULT) on connection 0 ...

C  *** ERROR => Connect to database failed, rc = -10757 (XUSER error (the USERKEY is unknown))

[dbsdbsql.cpp 113]

C  Try to connect (SQLOPT) on connection 0 ...

C  *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Database name is missing))

[dbsdbsql.cpp 137]

Try to run "R3trans -d" and "R3trans -x" (with user <sid>adm) and check the trans.log file produced for errors.

[Former Member]

Hello Matteo

R3trans -d and R3trans -x is ok

[Former Member]

Hi Clemet,

I think your database is not up.

To check whether your db is up and running do below steps.

1. Is Maxdb studio installed on the server? if not download from sap marketplace and install it.

If it is installed you can see the database is up and running or not.

2. If Your database is fine then run r3trans -d from os level then give us trans.log file.

let me know if you require more information.

Thanks,

Venkat

[former_member144433]

Hi Patrick,

You are using very old version of the tools. Can you please update the system with the latest kernel valid for your system from the SMP which will resolve the startup issue.

Thank You.

Regards,

Deepika

[Former Member]

It seem some problem with yhe user XUSER, check the note

Note 1444798 - Remote shadow instance on MaxDB

Note 39439 - XUSER entries for SAP MaxDB

Regards