TP connect to database fails in 4.0B_EXTN

[Former Member]

Hi,

When we try to check the TP tools through STMS. It shows that database connect

failed.

On running the TP connect <SID> pf=...., command through the command

line,it also fails.

The 'TP' cannot connect to the database. I have applied the newest

TP available on the SAP service marketplace.

Our System details are as below.

OS - Windows 2003

Database - SQL 2000

SAP Version - 40B

Kernel Version - 40B_EXTN

We have installed this SAP version because we would like to upgrade our

SAP version from 4.0B to ECC 6.0

The error on the running the command is shown as below.

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

F:\usr\sap\trans\bin>tp connect DEH

This is tp version 252.08.37 (release 40B) for MSSQL database

ERROR: SAP-System not installed properly.

Systems name (DEH) is different from name in TADIR (SAP)

PANIC PANIC PANIC 20061218162044

ERROR: SAP-System not installed properly. Systems name (DEH) is

different from n

ame in TADIR (SAP)

ERROR: EXIT(16) -> process ID is: 4804

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0233

tp finished with return code: 233

meaning:

SAP-System not installed properly (HEAD SYST)

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

Please can any body help me out and provide with a solution.

Regards,

Anwar

[andreas_herzog · Accepted solution]

did you run transaction SE06 after you installed your sap system? what about implementing the tms on your system using transaction STMS?

GreetZ, AH

[Former Member · Accepted solution]

Hi Greetz,

I have run the transaction SE06 and have already configured the STMS in client 000 through user DDIC.

But on checking the Transport tool through STMS,evrything seems to be fine and ok except for the message "Link to Database failed".

Then I tried to connect the Database through the Tp command,but it also failed.

The R3trans -d command is successful.

Regards,

Anwar

[former_member185954 · Accepted solution]

Hi,

Check SAP Notes for Kernel upgrade procedure for SAP and MSSQL installations.

I recollect something like

Deleting the automatically generated stored procedures. Execute the following SQL statements:

o use <SAPSID> go

sap_droproc

Also i recollect one more thing.

use SE38 transaction and execute a report called 'MSSPROCS' , this will regenerate the MSSQL Procedures for proper use.

Ensure that you backup your database before doing the above things, cause right now i do not have a proof statement that they will work.

Regards,

Siddhesh

[former_member185954 · Accepted solution]

Hi,

You might want to check this note:

Note 102461 - Installation of 4.0B/40B_COM kernel with 4.0A/40B system

Also check notes

Note 50966 - SAP System not installed properly. System name ..

Note 128126 - Database Connect for external tools

Note 85846 - Rel. operating systems SAP Kernel 4.0x/4.5x MS SQL Server

Note 555223 - FAQ: Microsoft SQL Server

Regards,

Siddhesh

[Former Member]

Hi

I think u did not configure the STMS in 000 client after installtion SAP in your system.

Configuring Transport Management System

Logon to 000 client of R/3 system which, is to be designated as Transport Domain Controller.

The TMS enables system administrators and technical consultants centrally manage the transport configuration of multiple R/3 systems.

Transport domain: All R/3 Systems that are planned to manage centrally using TMS form a transport domain.

Transport Domain controller: The R/3 System with the reference configuration is called as the transport domain controller. And all R/3 systems hold copies of this reference configuration.

RFC are generated when TMS is configured for R/3 systems to communicate with all R/3 systems in a domain.

regards

kiran.v

[Former Member]

Hi Kiran,

I have already configured the STMS in client 000 through user DDIC.

But on checking the Transport tool through STMS,evrything seems to be fine and ok except for the message "Link to Database failed".

Then I tried to connect the Database through the Tp command,but it also failed.

The R3trans -d command is successful.

Regards,

Anwar