cancel
Showing results for 
Search instead for 
Did you mean: 

TP only works from OS level

Former Member
0 Kudos

Hello,

we have a strange problem regarding tp. When trying to import a transport from the STMS I always get the following error in the tp Systemlog

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to SGC failed (20100209095138).

If I check the transporttool for the system I get two errors.

DB Connect Link to database failed

Offline Call connect failed due to DbSL load lib fa..

When I'm importing the transports at the command line it works perfectly.

This is tp version 340.16.54 (release 640, unicode enabled)

This is R3trans.exe version 6.13 (release 640 - 26.10.09 - 15:44:00).

unicode enabled version

R3trans.exe finished (0000).

This is R3trans.exe version 6.13 (release 640 - 26.10.09 - 15:44:00).

unicode enabled version

R3trans.exe finished (0000).

tp finished with return code: 0

meaning:

Everything OK

Any suggestions what might be the error?

Thanks in advance

Marco

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

ERROR: environment variable dbms_type is not set.

Assuming that your database is ORACLE...

Please set the dbms_type=ORA environment variable in your ora<sid> and <sid>adm users login profile...

Also check that SHLIB_PATH or LD_LIBRARY_PATH are correctly defined...

For example:

export SHLIB_PATH=/usr/sap/<SID>/SYS/exe/run:/oracle/<SID>/102_64/lib

Regards.

Rajesh Narkhede

Former Member
0 Kudos

DB is SQL Server, and the parameters are all set correctly.

Former Member
0 Kudos

Hi,

Could you also check the same in transport profile...

D:\usr\sap\trans\bin\TP_DOMAIN_<SID>.PFL

For MS SQL it should be

dbms/type = mss

Also update your kernel to latest, if it is not...

Regards.

Rajesh Narkhede

Edited by: Rajesh Narkhede on Feb 9, 2010 3:59 PM

Former Member
0 Kudos

as i said, the parameters are definetly set correct. There must be some other issue

Former Member
0 Kudos

Hi,

You may need to update your KERNEL, as I said in above reply...

(As you are saying profile parameters are correct...)

Regards.

Rajesh Narkhede

Former Member
0 Kudos

Like Rajesh, I suspect a mistake with environment variables.

But in Windows you have to check users <sid>adm and SAPService<SID>.

From command line, you most probably are using <sid>adm.

But from SAPGUI behind the scene SAPService<SID> will be used.

hope this helps

Former Member
0 Kudos

Thanks but i checked the user authorizations and the variables again, it's all ok and I'm still getting the error.

Former Member
0 Kudos

a restart of the system solved the problem.