NW2004s - Maxdb error

[Former Member]

Hello,

I tried to install NW2004s and got below error msg. I have enough disc space(30 GB free space). It is on winxp prof(sp 2).

ERROR 2006-08-30 06:48:42

FCO-00011 The step sdb_create_db_instance with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_CreateDB|ind|ind|ind|ind|9|0|NW_ADA_DB|ind|ind|ind|ind|6|0|SdbPreInstanceDialogs|ind|ind|ind|ind|2|0|SdbInstanceDialogs|ind|ind|ind|ind|1|0|SDB_INSTANCE_CREATE|ind|ind|ind|ind|0|0|sdb_create_db_instance was executed with status ERROR .

Any leads will be properly rewarded..

thanks,

parth

[Former Member]

Hi,

I am installing SAP NW2004s but i am facing "DATABASE CREATION ERROR".

I installed Oracle10G(10.0.1.0.2) and define SID="ORA" and while passing database id i pass "ORA" but it gives error me or 13 step as "database creation error".

So plz frnds help me to resolve this error.

Lalit

[markus_doehr2]

First: 10.2.0.1 is NOT SUPPORTED (check the installation guides and the notes) - you need 10.2.0.2.

Check the output of ora_sql_result.log for the error.

--

Markus

[Former Member]

as this problem is related to MAXDB may be it would a good idea to post in in the Forum SAP on MAXDB??

peter

[Former Member]

You are right pete. I have redirected the query to MaxDB forum. At the beginning, I was not sure whether the error was related to OS or MaxDB, so started off with OS.

thanks,

partha

[kal_sadaram]

Hi Partha,

Did you had any luck with this error? I am getting the same error and I suspect may be it has something to do with the SAP GUI? I am not 100% sure about it but I am guessing it could be.

Please let me know if you have found a solution to this problem.

Thanks

K

[kal_sadaram]

I finally managed to figure out the problem for my error. The problem was that I previously installed NW and the license was expired and I was trying to uninstall and reinstall over it.

I did a clean installation on a new machine and it all worked with no errors what so ever

[former_member192029]

Hi

Check the point

1) The file C:WINNTsystem32driversetcservices (Windows 2000) or C:Windowssystem32driversetcservices (Windows XP) must not include an entry for the ports 3601, 3201 and 50000 to 50030. A possible entry can be excluded by using the hash symbol (#).

Rest check the pre requiste

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/77317c8d-0701-0010-f093-ed3...

Cheers

Jawahar Govindaraj

[Former Member]

Hi Jawahar,

Thanks for your time.

The mentioned conditions are met, still got the error msg.

thanks,

partha

[former_member229109]

Hello Partha,

-> Please check the errors in the XCMDOUT.LOG file.

-> What outputs you will get when you will run the following commands on

the database server:

dbmcli -s inst_enum

dbmcli -s db_enum

xinstinfo

sdbregview -l

xinstinfo <DB-SID>

dbmcli -s -d <DB-SID> -u <dbm-user>,<pwd> db_state

-> Please run 'sdbverify' & update with results.

-> Is it brand new installation of the database or you have ( had?)the database software installed on the server?

Thank you & best regards, Natalia Khlopina

[Former Member]

Hello Nat,

I got the below message when I ran the given command.

Error! Connection failed to node (local) for database (no dbname): dbmsrv executable not found

FYI: This is my second try to install it. During first time also, got the same error msg. After that I removed all earlier traces of NSPDB/SAP and started again..

After the first try, still SAPDB services were there. But I disabled and began the second attempt.

Somewhere some networking issue..:-(

regds

parth

[former_member229109]

Dear Mr. Ghosh,

-> Which command failed with this error?

-> Did you delete the database software manually?

Please keep in mind, to use the sdbuninst tool ( as pro SAP note 599129 ), when you would like to uninstall the database software.

And you need to be 'Administrator' to run the install or uninstall of the database software/instance.

If you was running installation on Windows & manually deleted the database software of the dependent & independent packages, please see the SAP note 572836 (If you've got access to OSS/Service Market Place ), the cleanup exe file attached to this note & instructions are done how to use it.

( Alternatively, if all database software was deleted on the server, you could delete registry keys

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SAP DBTech-*

and these services will disappear. After the registry entries are deleted, you need to restart PC to remove the left database services from the NT services. So the easy way is to use the cleanup tool & reboot PC. )

Thank you and best regards, Natalia Khlopina

[Former Member]

Natalia,

I did follow your guidelines and there was no issues while creating MaxDB creation issue. The only difference was the password, I gave the password as just 'admin' (without using any numbers in password).

But stuck at 17 of 24 phase(Import ABAP) with below message heading as "Reload.exe - Unable to Locate Component"

with error message as below:

"This application has failed to start because libSQLDBC76.dll was not found. Re-installing the application may fix this problem".

I just used the files downloaded from sdn..Not sure where the files are missing. Please guide me.

Thanks,

partha

[Former Member]

There is a typo..

Please read 'Reload.exe' as 'R3load.exe' in earlier message.

thanks,

[former_member229109]

Hello Partha,

1)

I would like to repeat the questions::

-> What outputs you will get when you will run the following commands on

the database server:

dbmcli -s inst_enum

dbmcli -s db_enum

xinstinfo

sdbregview -l

xinstinfo <DB-SID>

dbmcli -s -d <DB-SID> -u <dbm-user>,<pwd> db_state

-> Please run 'sdbverify' & update with results.

-> Did you solve the database software installation problems?

2)

When you will run 'xinstinfo' you will get, for example:

IndepData : C:\sapdb\data

IndepPrograms : C:\sapdb\programs

If you installed the MAXDB version 7.6, please check libSQLDBC76.dll

In the directory <IndepPrograms>\pgm.

Please check that the PATH variable was adjusted by <IndepPrograms>\pgm

& <IndepPrograms>\bin.

Thank you & best regards, Natalia Khlopina

[Former Member]

Hi Natalia,

Here is the output..

<b>dbmcli -s inst_enum</b>

OK

7.6.00.18 d:\sapdb\nsp\db

<b>dbmcli -s db_enum</b>

OK

NSP d:\sapdb\nsp\db 7.6.00.18 slow <b>offline</b>

NSP d:\sapdb\nsp\db 7.6.00.18 fast running

<b>Note: One of above DB is offline.</b>

<b>dbmcli -s -d <DB-SID> -u <dbm-user>,<pwd> db_state</b>

OK

State

ONLINE

<b>xinstinfo NSP</b>

IndepData : d:\sapdb\data

IndepPrograms : d:\sapdb\programs

InstallationPath : d:\sapdb\nsp\db

Kernelversion : KERNEL 7.6.00 BUILD 018-123-113-357

Rundirectory : d:\sapdb\data\wrk\NSP

<b>sdbregview -l</b>

DB Analyzer d:/sapdb/programs 7.6.00.18 32 bit valid

Server Utilities d:/sapdb/programs 7.6.00.18 32 bit valid

PCR 7300 d:/sapdb/programs 7.3.00.54 valid

Base d:/sapdb/programs 7.6.00.18 32 bit valid

Redist Python d:/sapdb/programs 7.6.00.18 32 bit valid

PCR 7301 d:/sapdb/programs 7.3.01.19 valid

JDBC d:/sapdb/programs 7.6.00.16 valid

Messages d:/sapdb/programs MSG 0.3017 valid

ODBC d:/sapdb/programs 7.6.00.18 32 bit valid

Database Kernel d:/sapdb/nsp/db 7.6.00.18 32 bit valid

Loader d:/sapdb/programs 7.6.00.18 32 bit valid

PCR 7104 d:/sapdb/programs 7.1.04.45 valid

PCR 7600 d:/sapdb/programs 7.6.00.09 32 bit valid

SQLDBC d:/sapdb/programs 7.6.00.18 32 bit valid

SQLDBC 7600 d:/sapdb/programs 7.6.00.18 32 bit valid

PCR 7403 d:/sapdb/programs 7.4.03.40 32 bit valid

I ran "<b>sdbverify"</b> and got below summary:

VERIFICATION SUMMARY:

*********************

INVALID PACKAGES: 0

VALID PACKAGES: 16

INCONSISTENT PACKAGES: 0

TOTAL FILES: 449

MISSED FILES: 0

MODIFIED FILES: 0

FILES WITH MODIFIED PERMISSIONS: 0

I verified for 'libSQLDBC76.dll' file under pgm folder. It is there.

ONLY THE ISSUE IS, I COULD NOT SEE ANY PATH VARIABLE SET FOR "<IndepPrograms>\pgm AND <IndepPrograms>\bin"

AS MENTIONED IN YOUR REPLY.

In environment variables, I see only the

PATH ='D:\usr\sap\NSP\SYS\exe\nuc\NTI386' and

SAPEXE='D:\usr\sap\NSP\SYS\exe\nuc\NTI386'

No other variables are set related to SAP.

<b>Below is from R3load.exe log file:</b>

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

D:\usr\sap\NSP\SYS\exe\nuc\NTI386\R3load.exe: START OF LOG: 20060902123751

D:\usr\sap\NSP\SYS\exe\nuc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

D:\usr\sap\NSP\SYS\exe\nuc\NTI386\R3load.exe: version R7.00/V1.4

Compiled Sep 14 2005 23:24:01

D:\usr\sap\NSP\SYS\exe\nuc\NTI386\R3load.exe -testconnect

(DB) ERROR: DbSlControl(DBSL_CMD_IMP_FUNS_SET) rc = 20

(DB) ERROR: DbSlErrorMsg rc = 20

D:\usr\sap\NSP\SYS\exe\nuc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\NSP\SYS\exe\nuc\NTI386\R3load.exe: END OF LOG: 20060902123753

I was looking at XCMDout.txt file also. All the test sql to connect to DB was valid.

ERROR 2006-09-02 12:37:53

CJS-30023 Process call 'D:\usr\sap\NSP\SYS\exe\nuc\NTI386\R3load.exe -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.

<b>Below is from sapinst.log file</b>

ERROR 2006-09-02 12:37:53

FCO-00011 The step testDatabaseConnection with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|10|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|testDatabaseConnection was executed with status ERROR .

FYI: I am using nspadm OS login to installation. And using 'superdba'/'admin' as loginid/password to connect to database.

Please let me know your findings..

thanks,

partha

[Former Member]

Natalia,

One more thing, I found out from control panel ..

SAPDB: M760018 (omststknl.exe) and SAPDB: NSP(omststknl.exe) services could not be started at all.

thanks,