STMS problem in TMS Alerts

[Former Member]

Hello all, i am getting beloww error in STMS alerts, does any bosy know how to correct it?

I re-created TMS configuration and also regenerated RFC destination and reset user TMSADM but nothing worked.

I am trying to import a client 900 on a different isolated system from another sap system (systems are based upon ECC6 EHP4).

Error occurred in ETT TMS communication

Message no. XT149

Diagnosis

An error occurred in the TMS communication layer of the following SAP

system:

System: ETT.DOMAIN_ETT(000)

Function: TMS_CC_READ_CCCFLOW_OF_TRKORR

Error: SERVICE_NOT_AVAILABLE ()

System Response

The function terminates.

Procedure

Check your transport control station configuration with transaction STMS.

I think this problem is related to STMS, it does not have any connection to Client import. can anybody plese suggest me what to do?

We are on MS windows 2003 server with SQL server 2005 as backend.

Mani

[tomas_black · Accepted solution]

Hello Mani,

never saw this specific error code. I suggest creating an OSS message under component BC-CTS-TMS asking for a consultant to log on and analyse this issue in details, I believe it's the fastest and safest way to fix this.

Or, alternatively, please put the content of dev trace files dev_rd, dev_rfc and the correspondent dev_w* (repeat the process to get fresh new log files).

If you're trying to import a request (and is not able to do so because of this error) please do it manually on the OS level with the following command:

tp import <request_name> clientxxx <SID> u18 pf= TP_DOMAIN_SID.PFL

Best regards,

Tomas Black

[Former Member · Accepted solution]

thanks Tomas and Sanujit, i am importing it at OS level now its running. i think there is some problem at SAP Gui level i am not able to add request to import buffer from STMS_import >> Extras >> other requests >> add ( i tried with a test request). but i was able to import the same request from OS level. so after successfully importing test request i tried to run client import at OS level, its running fine untill now.

can anybody tell me how i can check if the import is still runnign at OS level or not or ther is any error. I have client import file size around 8 GB, dos anybody know how much time it will take to complete at OS level.

For your information here is the log error from DEV_W0 and DEV_RD file, there is nothing in DEV_RFC latest file.

DEV_W0

C Sat Sep 18 19:47:27 2010

C OpenOledbConnection: line 23839. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err -1, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Sat Sep 18 19:47:42 2010

C OpenOledbConnection: line 23839. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err -1, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23839]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to np:SAP5\ETT.

C Retrying without protocol specifier: SAP5\ETT

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Provider Release:9.00.3042.00

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Cache sizes: header 104 bytes, 20000 names (32960000 bytes), 500 dynamic statements (2876000 bytes), total 35836104 bytes

C Using shared procedure name cache SAP5_ETT_ETTETT_ETT_MEM initialized by another process.

C Connected to db server : [SAP5\ETT] server_used : [SAP5\ETT], dbname: ETT, dbuser: ett

C pn_id:SAP5_ETT_ETTETT_ETT

C Using MARS (on sql 9.0)

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20100918 194657 SAP5\ETT

B Successful reconnect for connection:

B 0: name = R/3, con_id = 000000000 state = ACTIVE , perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

B ***LOG BYY=> work process left reconnect status [dblink#1 @ 733] [dblink 0733 ]

A ** RABAX: level LEV_RX_ROLLBACK completed.

A ** RABAX: level LEV_RX_DB_ALIVE entered.

A ** RABAX: level LEV_RX_DB_ALIVE completed.

A ** RABAX: level LEV_RX_HOOKS entered.

A ** RABAX: level LEV_RX_HOOKS completed.

A ** RABAX: level LEV_RX_STANDARD entered.

A ** RABAX: level LEV_RX_STANDARD completed.

A ** RABAX: level LEV_RX_STOR_VALUES entered.

A ** RABAX: level LEV_RX_STOR_VALUES completed.

A ** RABAX: level LEV_RX_C_STACK entered.

A

A Sat Sep 18 19:47:43 2010

A ** RABAX: level LEV_RX_C_STACK completed.

A ** RABAX: level LEV_RX_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_MEMO_CHECK completed.

A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK completed.

A ** RABAX: level LEV_RX_INTERFACES entered.

A ** RABAX: level LEV_RX_INTERFACES completed.

A ** RABAX: level LEV_RX_GET_MESS entered.

A ** RABAX: level LEV_RX_GET_MESS completed.

A ** RABAX: level LEV_RX_INIT_SNAP entered.

A ** RABAX: level LEV_RX_INIT_SNAP completed.

A ** RABAX: level LEV_RX_WRITE_SYSLOG entered.

A ** RABAX: level LEV_RX_WRITE_SYSLOG completed.

A ** RABAX: level LEV_RX_WRITE_SNAP_BEG entered.

A ** RABAX: level LEV_RX_WRITE_SNAP_BEG completed.

A ** RABAX: level LEV_RX_WRITE_SNAP entered.

A

A Sat Sep 18 19:47:44 2010

A ** RABAX: level LEV_SN_END completed.

A ** RABAX: level LEV_RX_WRITE_SNAP_END entered.

A ** RABAX: level LEV_RX_WRITE_SNAP_END completed.

A ** RABAX: level LEV_RX_SET_ALERT entered.

A ** RABAX: level LEV_RX_SET_ALERT completed.

A ** RABAX: level LEV_RX_COMMIT entered.

A ** RABAX: level LEV_RX_COMMIT completed.

A ** RABAX: level LEV_RX_SNAP_SYSLOG entered.

A ** RABAX: level LEV_RX_SNAP_SYSLOG completed.

A ** RABAX: level LEV_RX_RESET_PROGS entered.

A ** RABAX: level LEV_RX_RESET_PROGS completed.

A ** RABAX: level LEV_RX_STDERR entered.

A Sat Sep 18 19:47:44 2010

A

A ABAP Program SAPMSSY2 .

A Source RSBTCTRC Line 60.

A Error Code DBIF_REPO_INTERNAL_ERROR.

A Module $Id: //bas/701_REL/src/krn/runt/abload5.c#1 $ SAP.

A Function db_info Line 251.

A ** RABAX: level LEV_RX_STDERR completed.

A ** RABAX: level LEV_RX_RFC_ERROR entered.

A ** RABAX: level LEV_RX_RFC_ERROR completed.

A ** RABAX: level LEV_RX_RFC_CLOSE entered.

A ** RABAX: level LEV_RX_RFC_CLOSE completed.

A ** RABAX: level LEV_RX_IMC_ERROR entered.

A ** RABAX: level LEV_RX_IMC_ERROR completed.

A ** RABAX: level LEV_RX_DATASET_CLOSE entered.

A ** RABAX: level LEV_RX_DATASET_CLOSE completed.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS entered.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS completed.

A ** RABAX: level LEV_RX_ERROR_SAVE entered.

A ** RABAX: level LEV_RX_ERROR_SAVE completed.

A ** RABAX: level LEV_RX_ERROR_TPDA entered.

A ** RABAX: level LEV_RX_ERROR_TPDA completed.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.

A ** RABAX: level LEV_RX_END entered.

A ** RABAX: level LEV_RX_END completed.

A ** RABAX: end no http/smtp

A ** RABAX: end RX_BTCHLOG|RX_VBLOG

A Internal error when accessing program CX_SY_OPEN_SQL_DB=============CP ..

A

M *** WARNING => PfStatWrite: missing STAT_END for opcode STAT_REPLOAD [pfxxstat.c 4127]

X Tue Sep 21 01:35:36 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

X

X Tue Sep 21 01:35:45 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

X

X Tue Sep 21 01:37:36 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

X

X Tue Sep 21 01:37:45 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

X

X Tue Sep 21 01:37:53 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

X

X Tue Sep 21 01:39:36 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

A

A Tue Sep 21 01:42:07 2010

A GENER request remote generation: RSTMSTPL.

X

X Tue Sep 21 01:48:01 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

X

X Tue Sep 21 01:48:36 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

A

A Tue Sep 21 02:02:54 2010

A GENER starting remote generation: CL_OO_CTS=====================CP (requested by W13).

X

X Tue Sep 21 02:05:45 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

X

X Tue Sep 21 02:05:54 2010

X *** ERROR => EmActiveData: Invalid Context Handle -1 [emxx.c 2214]

N

N Tue Sep 21 03:07:30 2010

N ***LOG TZ1=> System time zone found in TTZCU is not valid.

[sign.c 1268]

this is from DEV_RD file

-

---

trc file: "dev_rd", trc level: 1, release: "701"

-

---

Sat Sep 18 19:25:36 2010

***LOG S00=> GwInitReader, gateway started ( 5144) [gwxxrd.c 1757]

systemid 562 (PC with Windows NT)

relno 7010

patchlevel 0

patchno 11

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 5144

gateway runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)

gateway (version=701.2008.08.22)

gw/local_addr : 0.0.0.0

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

Bind service sapgw00 (socket) to port 3300

GwPrintMyHostAddr: my host addresses are :

1 : [172.16.9.8] sap5.hq1.nakisa.net (HOSTNAME)

2 : [127.0.0.1] sap5.hq1.nakisa.net (LOCALHOST)

Full qualified hostname = sap5.hq1.nakisa.net

DpSysAdmExtCreate: ABAP is active

DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

DpShMCreate: sizeof(wp_adm) 29792 (1752)

DpShMCreate: sizeof(tm_adm) 5912704 (29416)

DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

DpShMCreate: sizeof(comm_adm) 552080 (1088)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1864)

DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000EE30050, size: 6614144)

DpShMCreate: allocated sys_adm at 000000000EE30050

DpShMCreate: allocated wp_adm at 000000000EE32270

DpShMCreate: allocated tm_adm_list at 000000000EE396D0

DpShMCreate: allocated tm_adm at 000000000EE39730

DpShMCreate: allocated appc_ca_adm at 000000000F3E2DB0

DpShMCreate: allocated comm_adm at 000000000F3E4CF0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000F46B980

DpShMCreate: allocated gw_adm at 000000000F46BA00

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000F46BA30

MtxInit: -2 0 0

Sat Sep 18 19:26:26 2010

GwDpInit: attached to gw_adm at 000000000F46BA00

Mani

[tomas_black · Accepted solution]

Hello Mani,

the error seen in dev_w0 is likely not related to the original problem you reported in STMS. Moreover, there's nothing useful in dev_rd or dev_rfc, like you said....

Please create an OSS message under BC-CTS component and ask it to be handled by me (Tomas Black), open up both R/3 and WTS/SSH connection to the OS level (is it Windows or Unix/Linux?). I'll log on and check the problem, then I'll update this thread to inform the solution to the community as well.

Please inform on this thread the number of the OSS message.

Best regards,

Tomas Black

[Former Member]

Hi Mani,

You can check the current status of the import, though STMS, Import Monitor.

Regards,

Sanujit

[Former Member]

Mani,

If I am correct, you have exported a client from another system and trying to import it on the this system (If I am right the SID of this system is ETT).

Is this system is a single system STMS configuration ?

Have you tried importing any other TR on to this system, and is it going fine ?

Regards,

Sanujit

[Former Member]

Hi Mani,

Check whether the systems are in a domain.

Check the stms configurations from -

---

stms ---> system overview

from Menu SAP system ---> check.

Regards

Sushant

Edited by: Sushant G on Sep 20, 2010 3:59 PM

[Former Member]

thanks Sushant, well both source and destination system are in different domains if thats what your question.

I am trying to import a new client. Can you something on the same now.

Mandeep

[tomas_black]

Hello Mandeep,

like I said on my previous reply, please post the lines which contain the error messages from dev_rd, dev_rfc and the correspondent dev_w* trace files.

Best regards,

Tomas Black