Import of a request failing : ERROR: connect failed due to DbSL load lib fa

[Former Member]

Hi,

I am using ecc6, on hp-unix and oracle as database.

When i try to import a request from stms, i get this error.

DURING IMPORT ERROR:

Transport control program tp ended with error code 0249

Errors: connect failed due to DbSL load lib failure

TP ERROR:

Transport control program tp ended with error code 0249

Message no. XT200

Diagnosis

An error occurred when executing a tp command.

Command: IMPORT E07K901512 DEV client100 U01 pf=/usr/sap/tr

Return code: 0249

Error text: connect failed due to DbSL load lib failure

Request: E08K901525

System Response

The function terminates.

Procedure

Correct the error and execute the command again if necessary.

THEN I TRIED TO IMPORT USING TP COMMAND:

WITH OUT DIR_LIBRARY

% ./tp connect DEV

This is ./tp version 370.00.09 (release 700, unicode enabled)

E-TPSETTINGS could not be opened.

EXIT

ERROR: System : Parameter SAPEVTPATH not set. Batch jobs cannot be started.

Error in TPSETTINGS: transdir not set.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0208

tp finished with return code: 208

meaning:

error in transportprofil (param missing, unknown,...)

%

% ./R3trans -d

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

unicode enabled version

2EETW169 no connect possible: "environment variable DIR_LIBRARY is not set."

./R3trans finished (0012).

%

% # export DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run

% ./R3trans -d

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

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- ORACLE_SID =

'DEV'"

./R3trans finished (0012).

%

% ./tp connect DEV

This is ./tp version 370.00.09 (release 700, unicode enabled)

E-TPSETTINGS could not be opened.

EXIT

ERROR: System : Parameter SAPEVTPATH not set. Batch jobs cannot be started.

Error in TPSETTINGS: transdir not set.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0208

tp finished with return code: 208

meaning:

error in transportprofil (param missing, unknown,...)

%

COULD SOMEONE GIVE ME A SOLUTION TO OVERCOME THIS.

YOUR SOLUTION AND GREATELY APPRITIATED.

REGARDS,

DHANANJAY

[Former Member · Accepted solution]

Hi DHANANJAY,

This error is because the path for sapevt in unknown.

First set the parameter DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run

Execute command export DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run for this.

Regards

Ashok

[Former Member · Accepted solution]

Hi Ashok,

% # export DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run

% ./R3trans -d

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

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- ORACLE_SID =

'DEV'"

./R3trans finished (0012).

%

% ./tp connect DEV

This is ./tp version 370.00.09 (release 700, unicode enabled)

E-TPSETTINGS could not be opened.

EXIT

ERROR: System : Parameter SAPEVTPATH not set. Batch jobs cannot be started.

Error in TPSETTINGS: transdir not set.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0208

tp finished with return code: 208

meaning:

error in transportprofil (param missing, unknown,...)

%

STILL THE PROBLEM IS NOT SOLVED.

PLEASE ADVISE.

Regards,

Dhananjay

[Former Member · Accepted solution]

Hi DHANANJAY,

Could you please check below settings are there in tp profile.

TRANSDIR = ....\trans

<SID>/DBHOST = <HOSTNAME>

<SID>/DBNAME = <SID>

<SID>/DBTYPE = ora

Regards

Ashok

[Former Member · Accepted solution]

Hi Ashok,

These are the values in the profile.

I am trying to add the request to the buffer and then importing the request. So i don't think DIR_TRANS parameter is not required.

#parameter created by: SAP* 07.05.2007 20:00:10

login/no_automatic_user_sapstar = 0

SAPDBHOST = blrhp03

j2ee/dbtype = ora

j2ee/dbname = DEV

j2ee/dbhost = blrhp03

SAPSYSTEMNAME = DEV

SAPGLOBALHOST = blrhp03

rdisp/bufrefmode = sendoff,exeauto

DIR_PUT = /usr/sap/$(SAPSYSTEMNAME)/put

#----

---

1. SAP Messaging Service for ABAP

#----

---

rdisp/mshost = blrhp03

rdisp/msserv = sapmsDEV

rdisp/msserv_internal = 3911

#----

---

1. SAP Messaging Service for ABAP

#----

---

login/system_client = 001

<removed_by moderator>

READ the "Rules of Engagement"

Regards,

Dhananjay

Edited by: Juan Reyes on Sep 5, 2008 10:26 AM

[Former Member · Accepted solution]

Hi DHANANJAY,

Check tp parameter file in the directory usr/sap/trans/bin

TP_DOMAIN_<sid>.PFL

Before moving to tp you have check why database connection failed.

When you executed command r3trans -d logfile trans.log will be created.

Please check this file for exact error information.

Paste the log file here.

Regards

Ashok

Edited by: Ashok Dalai on Aug 28, 2008 8:09 AM

[Former Member · Accepted solution]

Hello,

Check wether the Import Queue is Open or Locked.

Regards,

Rizwanulhaq

[Former Member]

Hi,

This response is probably a bit late but I'm sure it could benefit someone out there with a similar problem.

I had the same error/problem and found that my problem was caused by a missing NFS mount.

I remounted my transport directory (/usr/sap/trans) and retried the transport and it worked.

Regards!

[Former Member]

Hello Dhananjay,

Go to stms, click on system overview->extras and select Distribute and activate configuration. Your error should be resolved after this.

Thanks!

Rahul.

[Former Member]

Hi Dhanajay,

Firstly check if R3trans -d is working fine.

If so, please chek if the following parameters are set properly.

DIR_LIBRARY=/usr/sap/<SID>/SYS/exe/run

TRANSDIR = ....\trans

<SID>/DBHOST = <HOSTNAME>

<SID>/DBNAME = <SID>

<SID>/DBTYPE = ora

Execute the below command and check the transport profile:

tp check all pf=/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL

Please confirm the permission of the /oracle/ directory

The permission of the /oracle should be 755.

Also check if the import queue is not locked.

Also please ensure the Kernel is of latest version, if not, please update the DBSL shared library.Please look at the note 19466.

Finally you can try once distributing and activating the transport routes once.

When you executed command R3trans -d logfile trans.log will be created.

Please check this file for exact error information.

Paste the log file here.

Let us know the outcome.

Regards,

Sujit.

[erick-acosta]

Try deleting or renaming old files in usr/sap/trans/buffer <sid>old, <sid>tmp, <sid>

Hope it helps.

Regards,

Erick

[Former Member]

Hi,

You have specify the transport profile, it worked for me.

Example:

tp check all pf=/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL

Should work.

KR,

Anthony

[Former Member]

Hi ,

Update your entire kernel to the latest patch and also update the DBSL shared library.Please look at the note 19466.

when the instance / SQL will get restarted, the entries will get overwritten with what was in the

SAP<SID> user environment variable settings and then proceeded to

update the variable entries dirctly in the user environment variable

entries, then stop and restart the instance / SQL. The user env var entries were now copied to the registry.

I think after this now tp can connect to db and will get solved.

Regards,

Pradeep Srigiri

[Former Member]

From when are you getting this error? It looks like kernel issue.

[Former Member]

Hi

Check if file dbmssslib.dll exists in usr\sap\SID\SYS\exe\run

then, make sure that it is 64-bit compliant, go download the latest version.

Also check the sap note 175627.

Hope it helps you.

Edited by: Rama Krishna on Aug 28, 2008 9:00 AM

[Former Member]

Hi,

I think you have performed some database related activities after which you are getting this error?

The error is due to the permission problem with the /oracle directory.

Please confirm the permission of the /oracle/ directory

The permission of the /oracle should be 755.

For extra information about the permission of directories you can refer the SAP note 583861.

Hope It will solve your problem.

Thanks,

Satyabrat