TP problem

[Former Member]

Hi Gurus,

Iam trying to apply the spam tool 30 right now spam tool 24,it is showing tp not connected ,I have configured tp three times but no use Iam gettting the same problem.What is the problem I dont know can give me solution.Please check the bellow error

Best Regards,

krishnamurthy kikkisetti

TP Error:

The import was stopped, since an error occurred during the phase

CHECK_REQUIREMENTS, which the Support Package Manager is unable to

resolve without your input.

After you have corrected the cause of the error, continue with the

import by choosing Support Package -> Import queue from the initial

screen of the Support Package Manager.

The following details help you to analyze the problem:

- Error in phase: CHECK_REQUIREMENTS

- Reason for error: TP_CANNOT_CONNECT_SYSTEM

- Return code: 0232

- Error message: connect failed

[Former Member]

Hi,

It seems tp is unable to connect to the Database.

check with r3trans -d, wats the error message.

and check your r3trans,tp versions, that should be greater than the kernel version.

Can you check for exact cause in log files.

-Srini

[Former Member]

HI Srinivas,

I have donr r3trans -d but it is giving returncode 2 ,finished with <0012>

BR,

kk

[Former Member]

Can you please answere the queston i asked you.

Thanks

Rsihi Abrol

[Former Member]

Hi RishiAbrol ,

I have updated the kernal and restarted the server but before updated the kernal also I have faced tp problem due to that reason,I have upgraded kernal.

BR,

kk

[Former Member]

Is you database comming up.What is the os of your system.

Can you please run r3trans-d and paste the Trans .log

Thanks Rishi Abrol

[Former Member]

HI, Iam using windows 2003 64 bit

4 ETW000 r3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 27.05.2009 - 15:05:46

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] Wed May 27 15:05:49 2009 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 7852 0.007852

4 ETW000 [dev trc ,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbmssslib.dll"

4 ETW000 35 0.007887

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 13 0.007900

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll

4 ETW000 21 0.007921

4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.144)

4 ETW000 414 0.008335

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll

4 ETW000 22 0.008357

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll

4 ETW000 23 0.008380

4 ETW000 [dev trc ,00000] New connection 0 created 28 0.008408

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 30 0.008438

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

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

4 ETW000 19 0.008475

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 26 0.008501

4 ETW000 [dev trc ,00000] Thread ID:2692 2611 0.011112

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

4 ETW000 [dev trc ,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000 24 0.011151

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 29 0.011180

4 ETW000 [dev trc ,00000] patchlevel 0 11 0.011191

4 ETW000 [dev trc ,00000] patchno 144 11 0.011202

4 ETW000 [dev trc ,00000] patchcomment MSSQL: ODBC fastload on separate connection (1131805)

4 ETW000 20 0.011222

4 ETW000 [dev trc ,00000] np:(local) connection used on SARITA 51 0.011273

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'dbo' 15 0.011288

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 8179 0.019467

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

4 ETW000 156 0.019623

4 ETW000 [dev trc ,00000] Provider Release:9.00.3042.00 42589 0.062212

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 453 0.062665

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

4 ETW000 68 0.062733

4 ETW000 [dev trc ,00000] CheckCodepageType: line 24513. hr: 0x80040e37 Invalid object name 'DBPROPERTIES'.

4 ETW000 3731 0.066464

4 ETW000 [dev trc ,00000] sloledb.cpp [CheckCodepageType,line 24513]: Error/Message: (err 208, sev 16), Invalid object name 'DBPROPERTIES'.

4 ETW000 41 0.066505

4 ETW000 [dev trc ,00000] Procname: [CheckCodepageType -- no proc] 12 0.066517

4 ETW000 [dev trc ,00000] Cache sizes: header 104 bytes, 100 names (164800 bytes), 100 dynamic statements (575200 bytes), total 740104 bytes

4 ETW000 60 0.066577

4 ETW000 [dev trc ,00000] Initializing private procedure name cache. 13 0.066590

4 ETW000 [dev trc ,00000] procedure cache created/attached 18 0.066608

4 ETW000 [dev trc ,00000] Connected to db server : [SARITA] server_used : [np:(local)], dbname: ***, dbuser: dbo

4 ETW000 25 0.066633

4 ETW000 [dev trc ,00000] pn_id:SARITA_*** 10 0.066643

4 ETW000 [dev trc ,00000] Using MARS (on sql 9.0) 13 0.066656

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 18 0.066674

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

[Former Member]

4 ETW000 7068 0.073742

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13165. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 26 0.073768

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.073797

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000001150549]

4 ETW000 18 0.073815

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.

4 ETW000 60 0.073875

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000001150549]

4 ETW000 18 0.073893

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 VERSION FROM SVERS ]

4 ETW000 30 0.073923

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum: 1112312

4 ETW000 21 0.073944

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on open 19 0.073963

4 ETW000 [dev trc ,00000] DbSlRead - <##Y4SARITA***00000026960000000001150549>

4 ETW000 18 0.073981

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on fetch 13 0.073994

4 ETW000 [dev trc ,00000] DbSlRead - <##Y4SARITA***00000026960000000001150549>

4 ETW000 23 0.074017

4 ETW000 [dblink ,01299] ***LOG BZA=>table SVERS does not exist on database [dblink#5 @ 1299]

4 ETW000 239 0.074256

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SARITA***00000026960000000002150549

4 ETW000 211 0.074467

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13165. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 418 0.074885

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.074914

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000002150549]

4 ETW000 18 0.074932

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 58 0.074990

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000002150549]

4 ETW000 18 0.075008

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 COMPCNT FROM "DDNTT" ]

4 ETW000 27 0.075035

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 21 0.075056

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED 198 0.075254

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SARITA***00000026960000000003150549

4 ETW000 35 0.075289

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13165. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 416 0.075705

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.075734

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000003150549]

4 ETW000 18 0.075752

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 58 0.075810

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000003150549]

4 ETW000 18 0.075828

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 VERSION FROM "DDNTT" ]

4 ETW000 27 0.075855

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 20 0.075875

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED 197 0.076072

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SARITA***00000026960000000004150549

4 ETW000 124 0.076196

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13165. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 422 0.076618

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.076647

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000004150549]

4 ETW000 18 0.076665

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 57 0.076722

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000004150549]

4 ETW000 18 0.076740

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 DBASE FROM "DDNTT" ]

4 ETW000 27 0.076767

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 21 0.076788

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED

4 ETW000 215 0.077003

4 ETW000 [dbntab ,01276] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#4 @ 12761]

4 ETW000 26 0.077029

4 ETW000 [twdydbacc.c ,00571] i:0 47 0.077076

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: PGMID 12 0.077088

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 10 0.077098

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 0 10 0.077108

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 0 10 0.077118

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:4 10 0.077128

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SARITA***00000026960000000005150549

4 ETW000 34 0.077162

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13165. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 414 0.077576

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.077605

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000005150549]

4 ETW000 17 0.077622

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXT'.

4 ETW000 58 0.077680

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000005150549]

4 ETW000 18 0.077698

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 COMPCNT FROM "XXXXT" ]

4 ETW000 27 0.077725

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 82 0.077807

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM XXXXT FAILED 200 0.078007

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SARITA***00000026960000000006150549

4 ETW000 35 0.078042

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13165. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 412 0.078454

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.078483

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000006150549]

4 ETW000 18 0.078501

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXT'.

4 ETW000 57 0.078558

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000006150549]

4 ETW000 18 0.078576

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 VERSION FROM "XXXXT" ]

4 ETW000 28 0.078604

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 20 0.078624

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM XXXXT FAILED 197 0.078821

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SARITA***00000026960000000007150549

4 ETW000 35 0.078856

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13165. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 408 0.079264

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.079293

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000007150549]

4 ETW000 17 0.079310

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13165]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXT'.

4 ETW000 57 0.079367

4 ETW000 [dev trc ,00000] Procname: [##Y4SARITA***00000026960000000007150549]

4 ETW000 18 0.079385

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 DBASE FROM "XXXXT" ]

4 ETW000 27 0.079412

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 20 0.079432

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM XXXXT FAILED

4 ETW000 214 0.079646

4 ETW000 [dbntab ,01276] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#4 @ 12761]

4 ETW000 27 0.079673

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)

4 ETW000 670 0.080343

4 ETW000 [dev trc ,00000] Rollback: TestConnection(1) successful 348 0.080691

[Former Member]

Can you please Stop the SAP system and the services of oracle and restart the services and the sap with the database.

Is this you fresh installation or you did System copy on this system.

Thanks Rishi Abrol

[Former Member]

Hi

Please check the following notes: 1) SAP Note 534765 - db connect fails because of wrong db schema in environment

2) SAP Note 556232 - Environment settings for R/3/Oracle on Windows

Tell me if you face any issues.

Ravi

[Former Member]

HI ravi raj,

Iam MS sql 2005,I have done homogeneous system copy that time it has given problem for schema ,due to that reason I took new schema .Now how to set schema varible can you give me direct solution.

BR,

kk

[Former Member]

Hi

See the section 'Schema Conversion' under the SAP Note 683447 - SAP Tools for MS SQL Server

Hope it helps.

Ravi

[Former Member]

Hi Ravi,

I have the schema in default profile,now I want one clarification,If we do the database refresh through system copy hardware key and installation number will be change or not.If we done the data base refresh it will be help ful for us.

BR,

kk

[Former Member]

HI ravi,

I got the solution for this,thanks for your helpfull answer.

BR,

kk

[Former Member]

Hi

Please check the connection of tp to database, you may refer: http://help.sap.com/saphelp_45B/helpdata/en/3d/ad5bc24ebc11d182bf0000e829fbfe/content.htm

Ravi

[Former Member]

hello all,

I am getting following errors while importing support

packages Queue SPAMu2026

- Error in phase: CHECK_REQUIREMENTS

- Reason for error: TP_CANNOT_CONNECT_SYSTEM

- Return code: 0232

- Error message: connect failed

I have checked the TPPRAM file, RFC connection and

it's normalu2026

I even changed the directory to /usr/sap/trans/bin and

executed command "tp connect <SID>" and same erroru2026

Return code: 0232

Also I tested the connectivity from STMS

RFC Link tp was started successfully

tp Version 340.15.02

DB Connect Link to database failed

Offline Call connect failed

any ideas? any suggestions? I really need help.

BR,

kk

[Former Member]

Hi,

Is your database up because r3trans -d command failed.

Did you upgrade the kernel.Did you restart the Sap application with the database.

Please let me know.

Thnaks Rishi Abrol

[Former Member]

Hi,

can you look at this

[http://help.sap.com/saphelp_45b/helpdata/EN/7e/c6c2ad98a711d2b429006094b9ea64/content.htm]

Regards,

Muralidhar

[Former Member]

Hi,

Can you please check the Note 96907 - SPAM Error: TP_CANNOT_CONNECT_SYSTEM CHECK_REQUIREMENTS

Thanks

Rishi Abrol