cancel
Showing results for 
Search instead for 
Did you mean: 

tp: Link to database failed.

Former Member
0 Kudos

Hi

i am trying to applying the patcc in solution mnaager system.

it is throwing error like tp unable to connect the db.

then i have checked the tp check-->transport tool from stms transaction.

ther it is passing all the tests but from tp call these two are failed

*1.DB Connect Link to database failed *

*2.Offline Call Connect Failed *

if i clicked either one of error symbol i am getting the below log information.

i have checked dbms_type=mss and DIR_LIBRARY path to .../sys/exe/run/uc/../nti386

still i am getting error: my db is mssql kernel patch level at 185 SP level 16.

tp connect SID pf=D:///usr///tp_domain.sid.pfl is CONNECTED.

The log:

This is tp version 372.04.65 (release 700, unicode enabled)

Warning: Parameter DBLIBPATH is no longer used.

ERROR: Connect to SM1 failed (20090827185006, probably wrong environment).

TRACE-INFO: 1: [dev trc ,00000] Thu Aug 27 18:50:06 2009

TRACE-INFO: 2: [dev trc ,00000] load shared library (D:\usr\sap\SM1\SYS\exe\uc\NTI3

TRACE-INFO: 3: [dev trc ,00000] using "D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmsssl

TRACE-INFO: 4: [dev trc ,00000] Thread ID:2952

TRACE-INFO: 5: [dev trc ,00000] Thank You for using the SLOLEDB-interface

TRACE-INFO: 6: [dev trc ,00000] Using dynamic link library 'D:\usr\sap\SM1\SYS\exe\

TRACE-INFO: 7: [dev trc ,00000] dbmssslib.dll patch info

TRACE-INFO: 8: [dev trc ,00000] patchlevel 0

TRACE-INFO: 9: [dev trc ,00000] patchno 182

TRACE-INFO: 10: [dev trc ,00000] patchcomment MSSQL: COPYTOSHADOW, R3

TRACE-INFO: 11: [dev trc ,00000] np:(local) connection used on SAPSOLMA

TRACE-INFO: 12: [dev trc ,00000] CopyLocalParameters: dbuser is 'dbo'

TRACE-INFO: 13: [dev trc ,00000] Using Provider SQLNCLI

TRACE-INFO: 14: [dev trc ,00000] OpenOledbConnection: MARS property was

TRACE-INFO: 15: [dev trc ,00000] Provider Release:9.00.4035.00

TRACE-INFO: 16: [dev trc ,00000] Using Provider SQLNCLI

TRACE-INFO: 17: [dev trc ,00000] OpenOledbConnection: MARS property was

TRACE-INFO: 18: [dev trc ,00000] i'm dbo but there exists 1 users <> db

TRACE-INFO: 19:

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

standard output from tp and from tools called by tp:

kindly suggest ....even i copied sapmssslib.dll and pdb new verion also.

Regards

Balaji

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
0 Kudos

Hi,

I believe you have to update Tp to latest Patch.

Also could you whether Tp process exist in the task manager

Regards

Sid

Former Member
0 Kudos

BRO... you saved my day too...!!

Former Member
0 Kudos

not answered

Former Member
0 Kudos

Hi Balaji,

Check that the environment variables of <sid>adm are also found from Registry under:

HKEY_LOCAL_MACHINE\SOFTWARE\SAP\<SID>\Environment

I had a similar tp problem, and found those missing (as a result of registry corruption during HW maintenance). Adding them solved the issue in my case.

cheers,

Kevin

Former Member
0 Kudos

mark

g_awater
Explorer
0 Kudos

Kevin's reply just saved my night, thanks

Former Member
0 Kudos

I had a similar problem.

Not exactly this registry key, but your tip took me to the solution: inconsistent registry entries conflicting with the environment variables set.

Great contribute!

former_member256962
Participant
0 Kudos

Hi,

Problem could e simple.R3trans -d workd perfectly since you run it from sidadm where env is set perfetly.But here your service SAPSID_<> runs with SAPServiceSID user for which the environment is not set

Either set the environment for SAPServiceSID user or change the service user to sidadm which will solve the issue for sure

Thanks & Regards,

Ravindran D

Former Member
0 Kudos

Hi Ravindran

But As the SAPserviceSID user, i am unable to log into the system, is there any alternate to set the env with out login as sapserviceSID.

And kindly let me know how to change the service user to SIDADM.

Thanks & Regards

Balaji

Former Member
0 Kudos

Hi Ravindran

But As the SAPserviceSID user, i am unable to log into the system, is there any alternate to set the env with out login as sapserviceSID.

And kindly let me know how to change the service user to SIDADM.

Thanks & Regards

Balaji

Former Member
0 Kudos

Hi

Please see below link

http://www.sap-img.com/basis/sap-message-tp-cannot-connect-system.htm

or try below steps

Configure the TMS in this R/3 System again.

You need to:

1. logon to the transport domain controller with admin user in client 000.

2. Run STMS

3. System overview

4. select QAS

5. Menu line option "SAP system" --> "Approve"

6. Distribute configuration

When you are logged on the transport domain server and run STMS --> System Overview. Is QAS listed? If so, select it and perform the checks under "SAP Systems" in menu line.

If they are not successful you might want to try the following to configure the TMS on QAS from scratch.

First delete QAS from system overview on the domain server.

Then do the following steps...

In your QAS system in client 000.

Run tcode SE06 --> Database copy or Database migration --> Perform post-installation actions.

Then confirm that you want to delete all old CTS/TMS config and type in QAS as source system for the database copy.

Then run STMS again and type in the correct data for the transport domain controller.

Logon to the transport domain controller in client 000. Run STMS. Open system overview.

Choose the SID of the QAS system and click on "SAP System" in the menu and choose Approve.

This will add the QAS system to your TMS config again.

Perform the checks from menu line "SAP Systems" again.

It seems like a lot maybe, but it only takes a couple of minutes to perform.

cheers,

Sudhakar

Former Member
0 Kudos

Hi sudhakar

It is a single system SOLMAN.

Regards

Balaji

Former Member
0 Kudos

Is it resolved?

Former Member
0 Kudos

No it is not resolved Mike.

Regards

BALAJI

Former Member
0 Kudos

To the message of SAPServiceSID user cannot be log in. Login as SIDADM goto Program Files-->Adminstrative Tools --> Local Security Policy check for deny log on locally remove user SAPServiceSID. This will allow you to login as SAPServiceSID.

Now give us the status of your problem.

Former Member
0 Kudos

Hi Mike

Still same problem continues after changing the env for SAPserviceSID also.

Regards

Balaji

former_member227283
Active Contributor
0 Kudos

Hi Balaji,

did you updated the library and DDL file.

Can you share the envoriment which is present for user SIDADM.

Thanks

Anil

Former Member
0 Kudos

Hi balaji,

Can you check once if the SID ADM user at OS level is not corrupted due to any reason?

I encountered once the scenario.

Thanks & Regards,

Sujit.

Former Member
0 Kudos

Hi Surjit

i was able to login with SIDADM. could you please let me know how to check whether the user is currupted or not.

Regards

Balaji

Former Member
0 Kudos

Hi

I have updated only kernel ,with sapexe.sar and sapexedb.sar.

Environment for SIDADM is

C:\Documents and Settings\sm1adm>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\sm1adm\Application Data

CLIENTNAME=INHYDJHBPO-535

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=SAPSOLMAN

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=mss

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\sm1adm

lib=C:\Program Files\SQLXML 4.0\bin\

LOGONSERVER=
SERVER-38

MSSQL_DBNAME=SM1

MSSQL_SCHEMA=sm1

MSSQL_SERVER=SAPSOLMAN

NUMBER_OF_PROCESSORS=2

OS=Windows_NT

Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Mi

crosoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools

\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Micro

soft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;D:\usr\sap\SM1\SYS\exe\uc\NTI

386

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 15 Model 4 Stepping 3, GenuineIntel

PROCESSOR_LEVEL=15

PROCESSOR_REVISION=0403

ProgramFiles=C:\Program Files

PROMPT=$P$G

SAPEXE=D:\usr\sap\SM1\SYS\exe\uc\NTI386

SAPLOCALHOST=SAPSOLMAN

SAPSYSTEMNAME=SM1

SESSIONNAME=RDP-Tcp#1

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP\1

TMP=C:\WINDOWS\TEMP\1

USERDNSDOMAIN=APOLLO.LOCAL

USERDOMAIN=APOLLO

USERNAME=sm1adm

USERPROFILE=C:\Documents and Settings\sm1adm

windir=C:\WINDOWS

C:\Documents and Settings\sm1adm>

Regards

Balaji

Former Member
0 Kudos

Check your kernel version and is it 32bit or 64bit exact compatibility to your system. Stop and start the system.

All the Best!!!

Former Member
0 Kudos

Hi

Still same problem continues, after upgrading the kernel to 185 also.

Regards

Balaji

Former Member
0 Kudos

Hi Balaji,

You have three sets of errors:

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to SM1 failed (20090908184602).

ERROR: No connect due to DbSl Load Lib Failure

Client of SQL might not be correct path, check out

ERROR: environment variable dbms_type is not set.

In the environment variable of SIDADM user variable enter DBMS_TYPE = MSS

Restart the application server.

This should resolve upto certain extent.

Keep us posted.

Former Member
0 Kudos

Hi Mike

Regarding:

ERROR: No connect due to DbSl Load Lib Failure

Client of SQL might not be correct path, check out

I am not sure where to check this path, And dev_wX trace logs are showing that DbSl Load Lib successfully loaded.)

and tp connect and r3trans -d return code is 000.

kindly let me know where to check this path exactly

Regarding:

ERROR: environment variable dbms_type is not set.

In the environment variable of SIDADM user variable enter DBMS_TYPE = MSS

This has been already set for SIDADM and for testing purpose i put it for system variable also.

Regards

Balaji

Former Member
0 Kudos

Hi,

Please reconfigure the STMS in solution manager system.

Thanks & Regards,

Vidyadhar K

Former Member
0 Kudos

Hi

still same problem exists after reconfiguring the STMS in solman.

Regards

Balaji

Former Member
0 Kudos

Hi

While applying the patch this is the log:

Import phase 'CHECK_REQUIREMENTS' (08.09.2009, 18:46:02)

Error during executing the tp command 'tp CONNECT SM1 ...'

tp return code: '0249' , tp message: 'connect failed due to DbSL load lib failure' , tp output:

This is tp version 372.04.70 (release 700, unicode enabled)

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to SM1 failed (20090908184602).

INFO: no trace information stored

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0249

standard output from tp and from tools called by tp:

.

but at os level for sidadm user the environment variable is set DBMS_TYPE=mss.

when i execute the same ('tp CONNECT SM1 ...) comand at os level it is working fine.

Any idea?

Regards

Balaji nampally

Former Member
0 Kudos

can you try to check with r3trans -d and see the log.

Former Member
0 Kudos

R3trans -d return code is 0000

and translog

4 ETW000 r3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

4 ETW000 unicode enabled version

4 ETW000 date&time : 31.08.2009 - 17:46:10

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 Aug 31 17:46:13 2009 19793 0.019793

4 ETW000 [dev trc ,00000] db_con_init called 53 0.019846

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

4 ETW000 [dev trc ,00000] Loading DB library 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll' ...

4 ETW000 73 0.019978

4 ETW000 [dev trc ,00000] load shared library (D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll), hdl 0

4 ETW000 17950 0.037928

4 ETW000 [dev trc ,00000] using "D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll" 34 0.037962

4 ETW000 [dev trc ,00000] Library 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll' loaded 37 0.037999

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll

4 ETW000 55 0.038054

4 ETW000 [dev trc ,00000] Version of 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll' is "700.08", patchlevel (0.216)

4 ETW000 5930 0.043984

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll

4 ETW000 62 0.044046

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll

4 ETW000 57 0.044103

4 ETW000 [dev trc ,00000] New connection 0 created 48 0.044151

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 67 0.044218

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 38 0.044256

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 30 0.044286

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 66 0.044352

4 ETW000 [dev trc ,00000] Thread ID:2964 2202 0.046554

4 ETW000 [dev trc ,00000] Thank You for using the SLOLEDB-interface 39 0.046593

4 ETW000 [dev trc ,00000] Using dynamic link library 'D:\usr\sap\SM1\SYS\exe\uc\NTI386\dbmssslib.dll'

4 ETW000 63 0.046656

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 64 0.046720

4 ETW000 [dev trc ,00000] patchlevel 0 33 0.046753

4 ETW000 [dev trc ,00000] patchno 216 32 0.046785

4 ETW000 [dev trc ,00000] patchcomment Wrong table name in ST05 trace (1364307) 104 0.046889

4 ETW000 [dev trc ,00000] np:(local) connection used on SAPSOLMAN 133 0.047022

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'sm1' 38 0.047060

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 10186 0.057246

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 225 0.057471

4 ETW000 [dev trc ,00000] Provider Release:9.00.4035.00 161464 0.218935

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 33466 0.252401

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully. 214 0.252615

4 ETW000 [dev trc ,00000] Cache sizes: header 68 bytes, 100 names (158400 bytes), 100 dynamic statements (569600 bytes), total 728068 bytes

4 ETW000 32083 0.284698

4 ETW000 [dev trc ,00000] Initializing private procedure name cache. 37 0.284735

4 ETW000 [dev trc ,00000] procedure cache created/attached 41 0.284776

4 ETW000 [dev trc ,00000] Connected to db server : [SAPSOLMAN] server_used : [np:(local)], dbname: SM1, dbuser: sm1

4 ETW000 59 0.284835

4 ETW000 [dev trc ,00000] pn_id:SAPSOLMAN_SM1SM1_SM1 32 0.284867

4 ETW000 [dev trc ,00000] Using MARS (on sql 9.0) 164 0.285031

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 47 0.285078

4 ETW000 [dev trc ,00000] The IRow interface is supported by this OLEDB provider 59574 0.344652

4 ETW000 [dev trc ,00000] NTAB: Structure of NTAB on DB is VERS_B 156958 0.501610

4 ETW000 [dev trc ,00000] NTAB: UNICODELG(SVERS) = 2, SAP_UC_LN = 2 60 0.501670

4 ETW000 [dev trc ,00000] NTAB: standalone processing 4653 0.506323

4 ETW000 [dev trc ,00000] NTAB: read profile 35 0.506358

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4SAPSOLMAsm100000028760000000003174613 127 0.509411

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:717}

4 ETW000 63 0.566698

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 ) 45151 0.611849

4 ETW000 Connected to DBMS = MSSQL --- SERVER = 'SAPSOLMAN' DBNAME = 'SM1' --- SYSTEM = 'SM1'.

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1320}

4 ETW000 130504 0.742353

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4SAPSOLMAsm100000028760000000003174613 29755 0.772108

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 77996 0.850104

4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000 3679 0.853783

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SAPSOLMAsm100000028760000000007174613 128 0.853911

4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8) 31188 0.885099

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=1) 156 0.885255

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1424}

4 ETW000 110 0.885365

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 430 0.885795

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1432}

4 ETW000 84 0.885879

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 3540 0.889419

4 ETW690 COMMIT "0" "0"

4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0) 124 0.889543

4 ETW000 trace to file pointer closed

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

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 31.08.2009 - 17:46:14

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

[dev trc ,00000] Mon Aug 31 17:46:14 2009 9045 0.009045

[dev trc ,00000] Disconnecting from ALL connections: 28 0.009073

[dev trc ,00000] Disconnected from connection 0 2056 0.011129

[dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1) 72 0.011201

[dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 36 0.011237

Disconnected from database.

End of Transport (0000).

date&time: 31.08.2009 - 17:46:14