Import ABAP ends in error

[Former Member]

Hello Experts,

I am doing an ECC5.0 installation on Linux and MaxDB as the underlying database. I get the follwing error during IMPORT ABAP phase.

"NO profile used.sapparam: SAPSYSTEMNAME neither in profile nor in commandline/usr/sap/RH1/SYS/exe/run/R3load: START OF LOG:

test DATABASEconnection was executed with status ERROR.

Can you please provide assistance as to how to resolve this. Any pointers to any other threads will be appreciated.

Thanks!

Rahul.

[markus_doehr2]

Execute

R3trans -d

as user <sid>adm and check the logfile trans.log

Markus

[Former Member]

Hi Sven,

Appreciate your response. I guess the Max DB DVD that i am using is not the right one. Please look at the log below and suggest.

Markus,

This is response of R3trans -d .

"This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/RH1/SYS/exe/run') or dbms_type ('ADA')"

R3trans finished (0012)."

Below is the error log.

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

/usr/sap/RH1/SYS/exe/run/R3load: START OF LOG: 20101204115740

/usr/sap/RH1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/RH1/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Aug 28 2006 22:58:57

/usr/sap/RH1/SYS/exe/run/R3load -testconnect

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

(DB) ERROR: DbSlErrorMsg rc = 20

/usr/sap/RH1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/RH1/SYS/exe/run/R3load: END OF LOG: 20101204115740

Please advise as to what may be going wrong here?

Thanks!

Rahul.

[Former Member]

when you perform the R3trans -d, there will be a trans.log file created, please paste the log.

Can you please make sure that the database is up.

also check the environment variables mentioned in your response are set correctly.

[Former Member]

Hi.

1. Yes the DB is started.

2. Below is the log file for the R3trans -d command

" 4 ETW000 R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 06.12.2010 - 23:44:09

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Dec 6 23:44:09 2010 149 0.000149

4 ETW000 [dev trc ,00000] db_con_init called 34 0.000183

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 45 0.000228

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/RH1/SYS/exe/run/dbsdbslib.so' ...

4 ETW000 50 0.000278

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= libSQLDBC76.so: cannot open shared object file: No such file or directory -> DLENOACCESS (0,Success)

4 ETW000 445 0.000723

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/RH1/SYS/exe/run/dbsdbslib.so'

4 ETW000 31 0.000754

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/RH1/SYS/exe/run') or dbms_type ('ADA')"

I dont see any problems with the environment variables.

Thanks!

Rahul.

~

[markus_doehr2]

> 4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/RH1/SYS/exe/run/dbsdbslib.so' ...

> 4 ETW000 50 0.000278

> 4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= libSQLDBC76.so: cannot open shared object file: No such file or directory -> DLENOACCESS (0,Success)

Is that library (dbsdbslib.so) existing in that directory?

Markus

[Former Member]

Hi Markus,

First of all I would like to thank you for your continues assistance.

I do have the dbsdbslib.so in the run folder but i am not sure about this libSQLDBC76.so file. Searched on net but couldnt get much of an information on this.

I guess thats where the problem is. I am just guessing, do you think this file is required? Have you in your previous stints ever used this file as an exception?

Thanks!

Rahul.

[hannes_kuehnemund]

libSQLDBC76.so is delivered with maxdb. Make sure that your LD_LIBRARY_PATH variable contains the path of the folder holding this file ....

[Former Member]

Hello All,

Many thanks for helping me. finally the problem is resolved.

libSQLDBC76.so was missing from the db DVD. I copied it from another dump of MAX DB DVD, started the installation again and it went ahead.

Thanks!

Rahul.

[Former Member]

Please mark this thread as answered.

[Former Member]

Please confirm that the database is up and running. The error message shows that the database cannot be reached.

Kind regards,