Can not open new Session

Dear Expert,

I have problem with my SAP system (ECC 6.00). When I want to create a new session, I got message

No Connect to Database, Session Terminated

I have checked my database and it's ok.....

Regards,

MAL

SAP Managed Tags:
NW AS Java Administrator (NWA)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi M.A.L how you check your database ? Can you provide the information about DB and OS version, SP levell and other. Can you chek the "R3trans -d" ? Regards.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear Expert,

I use R3trans -d and the result below

This is r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

r3trans finished (0000).

My OS is Win Server 2003 SP2.

Regards,

MAL

Can you post the trans.log ? And please answer on my question about DB and OS versions. Where you see this error? Are you possible to create new connect from sap gui ? Regadrs.

P.S can you check may be offline backup is running ?

Dear Expert,

I use Oracle 10. My OS is Windows server 2003 R2 Enterprise Edition SP2. I can not create new session from SAP GUI.. I Use SAP GUI 7.10 Patch 7. (I get the message when i try to create a new session, even to export file i get this error)

And below is my trans.log

4 ETW000 r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

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

4 ETW000

4 ETW000 date&time : 21.04.2008 - 11:30:08

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 Apr 21 11:30:08 2008 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 'dboraslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 5601 0.005601

4 ETW000 [dev trc ,00000] using "G:\usr\sap\JMP\sys\exe\run\dboraslib.dll"

4 ETW000 19 0.005620

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 8 0.005628

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

4 ETW000 14 0.005642

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

4 ETW000 87 0.005729

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

4 ETW000 14 0.005743

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

4 ETW000 23 0.005766

4 ETW000 [dev trc ,00000] New connection 0 created 15 0.005781

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 18 0.005799

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

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

4 ETW000 13 0.005825

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 15 0.005840

4 ETW000 [dev trc ,00000] Prepending G:\usr\sap\JMP\sys\exe\run to Path. 141 0.005981

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 22225 0.028206

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 20 0.028226

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 2032 0.030258

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPJMR3's password 15 0.030273

4 ETW000 [dev trc ,00000] Connecting as /@JMP on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 21 0.030294

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 17 0.030311

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 02655DF0 0037F9C4 0037F24C

4 ETW000 16 0.030327

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 16 0.030343

4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.030357

4 ETW000 [dev trc ,00000] Attaching to DB Server JMP (con_hdl=0,svchp=0037F198,srvhp=0265E57C)

4 ETW000 100 0.030457

4 ETW000 [dev trc ,00000] Assigning server context 0265E57C to service context 0037F198

4 ETW000 29566 0.060023

4 ETW000 [dev trc ,00000] Allocating user session handle 18 0.060041

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0037F198,srvhp=0265E57C,usrhp=026A9E78)

4 ETW000 30 0.060071

4 ETW000 [dev trc ,00000] Assigning user session 026A9E78 to service context 0037F198

4 ETW000 31084 0.091155

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 36 0.091191

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 43 0.091234

4 ETW000 [dev trc ,00000] Now '/@JMP' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 433 0.091667

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 28 0.091695

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 243 0.091938

4 ETW000 [dev trc ,00000] Got SAPJMR3's password from OPS$-user 473 0.092411

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 11 0.092422

4 ETW000 [dev trc ,00000] Rolling back transaction ... 15 0.092437

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0037F198,usrhp=026A9E78)

4 ETW000 121 0.092558

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 338 0.092896

4 ETW000 [dev trc ,00000] Connecting as SAPJMR3/<pwd>@JMP on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 16 0.092912

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 15 0.092927

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 02655DF0 0037F9C4 0037F24C

4 ETW000 16 0.092943

4 ETW000 [dev trc ,00000] Assigning username to user session 026A9E78 9 0.092952

4 ETW000 [dev trc ,00000] Assigning password to user session 026A9E78 11 0.092963

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0037F198,srvhp=0265E57C,usrhp=026A9E78)

4 ETW000 14 0.092977

4 ETW000 [dev trc ,00000] Assigning user session 026A9E78 to service context 0037F198

4 ETW000 19690 0.112667

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 35 0.112702

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 25 0.112727

4 ETW000 [dev trc ,00000] Now 'SAPJMR3/<pwd>@JMP' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 296 0.113023

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 19 0.113042

4 ETW000 [dev trc ,00000] SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET') ORDER BY PARAM

4 ETW000 213 0.113255

4 ETW000 [dev trc ,00000] ETER

4 ETW000 15 0.113270

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC 245 0.113515

4 ETW000 [dev trc ,00000] SELECT UPPER(INSTANCE_NAME),HOST_NAME,VERSION,TO_CHAR(STARTUP_TIME,'MON DD, YYYY, HH24:MI:SS') FROM V$INSTANCE

4 ETW000 24 0.113539

4 ETW000 [dev trc ,00000] DB instance JMP is running on JMSAP04 with ORACLE version 10.2.0.2.0 since MAR 31, 2008, 07:51:48

4 ETW000 284 0.113823

4 ETW000 [dev trc ,00000] SELECT SUBSTR(NAME,1,3), TO_CHAR(CREATED,'YYYYMMDDHHMMSS') FROM V$DATABASE

4 ETW000 19 0.113842

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 1431 0.115273

4 ETW000 [dev trc ,00000] SELECT VERSION FROM SVERS

4 ETW000 3789 0.119062

4 ETW000 [dev trc ,00000] SELECT COMPCNT FROM "DDNTT"

4 ETW000 369 0.119431

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

4 ETW000 [dev trc ,00000] NTAB: standalone processing 27 0.119657

4 ETW000 [dev trc ,00000] NTAB: read profile 9 0.119666

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 8 0.119674

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 8 0.119682

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 7 0.119689

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 8 0.119697

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 12 0.119709

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 18 0.119727

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 7 0.119734

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 7 0.119741

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 8 0.119749

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 11 0.119760

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 44. 8 0.119768

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 36. 8 0.119776

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 8 0.119784

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 8 0.119792

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 8 0.119800

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 8 0.119808

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 44. 7 0.119815

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 36. 8 0.119823

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 8 0.119831

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 7 0.119838

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 8 0.119846

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 8 0.119854

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 44. 8 0.119862

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 36. 7 0.119869

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 8 0.119877

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 7 0.119884

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 8 0.119892

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 8 0.119900

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 148. 8 0.119908

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 24. 8 0.119916

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 7 0.119923

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 152 8 0.119931

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 8 0.119939

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 152000. 8 0.119947

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 266e5e8, hh_len 44 592 0.120539

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 3a836a0, aa_len 8012 10 0.120549

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 3a855f8, ia_len 36000 9 0.120558

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 3a90008, dat_len 512000 8 0.120566

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 267ef10, hh_len 44 9 0.120575

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 26aa1b8, aa_len 8012 8 0.120583

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 3b0d010, ia_len 9000 8 0.120591

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 3b0f340, dat_len 102400 8 0.120599

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 266e978, hh_len 44 9 0.120608

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 3b28348, aa_len 8012 8 0.120616

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 3b2a2a0, ia_len 9000 8 0.120624

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 3b2c5d0, dat_len 102400 8 0.120632

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 2698f60, hh_len 148 8 0.120640

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 3b455d8, aa_len 8012 9 0.120649

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 3b47530, ia_len 24000 8 0.120657

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 3b4d2f8, dat_len 152000 8 0.120665

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 2698f60, ntab_mp_p 2698f60, ntab_proc_id 0

4 ETW000 84 0.120749

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 266e5e8, ha_list 3a836a0, hi_list 3a855f8, buffer 3a90008

4 ETW000 41 0.120790

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 267ef10, ha_list 26aa1b8, hi_list 3b0d010, buffer 3b0f340

4 ETW000 14 0.120804

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 266e978, ha_list 3b28348, hi_list 3b2a2a0, buffer 3b2c5d0

4 ETW000 13 0.120817

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 2698fc8, ha_list 3b455d8, hi_list 3b47530, buffer 3b4d2f8

4 ETW000 13 0.120830

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000 19 0.120849

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000 22 0.120871

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000 22 0.120893

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000 20 0.120913

4 ETW000 [dev trc ,00000] SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TABNAME = :A0 ORDER BY TABNAME, BLOCKNR

4 ETW000 57 0.120970

4 ETW000 [twdydbacc.c ,00565] i:0 421 0.121391

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: PGMID 10 0.121401

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 1 7 0.121408

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 0 6 0.121414

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 4 7 0.121421

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:4 20 0.121441

4 ETW000 [twdydbacc.c ,00565] i:1 8 0.121449

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: OBJECT 7 0.121456

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 1 7 0.121463

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 4 6 0.121469

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 4 7 0.121476

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:4 6 0.121482

4 ETW000 [twdydbacc.c ,00565] i:2 7 0.121489

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: OBJ_NAME 7 0.121496

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 1 6 0.121502

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 8 7 0.121509

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 40 6 0.121515

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:40 7 0.121522

4 ETW000 [twdydbacc.c ,00565] i:3 7 0.121529

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: KORRNUM 7 0.121536

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 9 0.121545

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 48 7 0.121552

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 10 6 0.121558

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:10 6 0.121564

4 ETW000 [twdydbacc.c ,00565] i:4 8 0.121572

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: SRCSYSTEM 7 0.121579

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121585

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 58 7 0.121592

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 10 6 0.121598

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:10 6 0.121604

4 ETW000 [twdydbacc.c ,00565] i:5 7 0.121611

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: AUTHOR 7 0.121618

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121624

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 68 7 0.121631

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 12 6 0.121637

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:12 7 0.121644

4 ETW000 [twdydbacc.c ,00565] i:6 7 0.121651

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: SRCDEP 7 0.121658

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121664

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 80 6 0.121670

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 7 0.121677

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 6 0.121683

4 ETW000 [twdydbacc.c ,00565] i:7 7 0.121690

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: DEVCLASS 7 0.121697

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121703

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 81 7 0.121710

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 30 6 0.121716

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:30 7 0.121723

4 ETW000 [twdydbacc.c ,00565] i:8 7 0.121730

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: GENFLAG 7 0.121737

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121743

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 111 6 0.121749

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 7 0.121756

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 6 0.121762

4 ETW000 [twdydbacc.c ,00565] i:9 7 0.121769

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: EDTFLAG 7 0.121776

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121782

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 112 7 0.121789

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 6 0.121795

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 7 0.121802

4 ETW000 [twdydbacc.c ,00565] i:10 7 0.121809

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: CPROJECT 9 0.121818

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121824

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 113 7 0.121831

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 8 6 0.121837

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:8 6 0.121843

4 ETW000 [twdydbacc.c ,00565] i:11 8 0.121851

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: MASTERLANG 6 0.121857

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 7 0.121864

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 121 7 0.121871

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 6 0.121877

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 6 0.121883

4 ETW000 [twdydbacc.c ,00565] i:12 8 0.121891

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: VERSID 7 0.121898

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121904

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 122 6 0.121910

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 20 7 0.121917

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:20 6 0.121923

4 ETW000 [twdydbacc.c ,00565] i:13 8 0.121931

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: PAKNOCHECK 7 0.121938

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121944

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 142 7 0.121951

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 6 0.121957

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 6 0.121963

4 ETW000 [twdydbacc.c ,00565] i:14 8 0.121971

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: OBJSTABLTY 7 0.121978

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.121984

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 143 7 0.121991

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 6 0.121997

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 6 0.122003

4 ETW000 [twdydbacc.c ,00565] i:15 8 0.122011

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: COMPONENT 7 0.122018

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.122024

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 144 7 0.122031

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 30 6 0.122037

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:30 6 0.122043

4 ETW000 [twdydbacc.c ,00565] i:16 8 0.122051

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: CRELEASE 7 0.122058

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.122064

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 174 7 0.122071

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 10 6 0.122077

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:10 7 0.122084

4 ETW000 [twdydbacc.c ,00565] i:17 9 0.122093

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: DELFLAG 7 0.122100

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 6 0.122106

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 184 7 0.122113

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 6 0.122119

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 7 0.122126

4 ETW000 [twdydbacc.c ,00565] i:18 8 0.122134

4 ETW000 [twdydbacc.c ,00566] db_fd_p.fname: TRANSLTTXT 6 0.122140

4 ETW000 [twdydbacc.c ,00567] db_fd_p.is_key: 0 7 0.122147

4 ETW000 [twdydbacc.c ,00568] db_fd_p.offset: 185 6 0.122153

4 ETW000 [twdydbacc.c ,00569] db_fd_p.db_length: 1 7 0.122160

4 ETW000 [twdydbacc.c ,00570] db_fd_p.fixed_length:1 6 0.122166

4 ETW000 [dev trc ,00000] SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFOR

4 ETW000 31 0.122197

4 ETW000 [dev trc ,00000] M, REFNAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COMPCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = :A0

4 ETW000 15 0.122212

4 ETW000 [twdydbacc.c ,00713] buffer:'g CRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = jmsap04) (PORT = 1527))) (CONNECT_DATA = (SID = JMP) (GLOBAL_NAME = JMP.WORLD)))'

4 ETW000 321 0.122533

4 ETW000 [twdydbacc.c ,00718] i:0 7 0.122540

4 ETW000 [twdydbacc.c ,00719] tw_fd_p.offset:0 6 0.122546

4 ETW000 [twdydbacc.c ,00718] i:1 6 0.122552

4 ETW000 [twdydbacc.c ,00719] tw_fd_p.offset:4 7 0.122559

4 ETW000 [twdydbacc.c ,00718] i:2 6 0.122565

4 ETW000 [twdydbacc.c ,00719] tw_fd_p.offset:8 6 0.122571

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

4 ETW000 19 0.122590

4 ETW000 [dev trc ,00000] SELECT * FROM "TADIR" WHERE "PGMID" = :A0 AND "OBJECT" = :A1 AND "OBJ_NAME" = :A2

4 ETW000 91 0.122681

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

4 ETW000 281 0.122962

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'JMP' --- SYSTEM = 'JMP'.

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

4 ETW000 179 0.123141

4 ETW000 [dev trc ,00000] INSERT INTO "PATCHHIST" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 )

4 ETW000 309 0.123450

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

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 75 0.123889

4 ETW000 [dev trc ,00000] SELECT EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP,PATCHNO,DBSLPATCHN FROM PATCHHIST WHERE EXECUTABLE = 'R3

4 ETW000 36 0.123925

4 ETW000 [dev trc ,00000] trans' AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM PATCHHIST WHERE EXECUTABLE = 'R3trans' AND SAPRELEASE = '700' AND HOSTN

4 ETW000 15 0.123940

4 ETW000 [dev trc ,00000] AME = 'JMSAP04' AND PLATFORM = 'NT' AND DBVENDOR = 'ORA')

4 ETW000 15 0.123955

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

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=0) 265 0.124237

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

4 ETW000 17 0.124254

4 ETW000 [dev trc ,00000] DELETE FROM "PATCHHIST" WHERE "EXECUTABLE" = :A0 AND "SAPRELEASE" = :A1 AND "HOSTNAME" = :A2 AND "PLATFORM" = :A3 AND "DBV

4 ETW000 31 0.124285

4 ETW000 [dev trc ,00000] ENDOR" = :A4 AND "TIMESTAMP" = :A5

4 ETW000 15 0.124300

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

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)

4 ETW000 41 0.124597

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 : 21.04.2008 - 11:30:08

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

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 113 0.000113

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 15 0.000128

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0037F198,usrhp=026A9E78)

4 ETW000 314 0.000442

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0037F198,srvhp=0265E57C)

4 ETW000 405 0.000847

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 361 0.001208

4 ETW000 [dev trc ,00000] Disconnected from connection 0 14 0.001222

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000 13 0.001235

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 11 0.001246

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 21.04.2008 - 11:30:08

Regards,

MAL

I not have understood you, first you are login in to SAP , after some times , you can't login again and can't work properly ? Are you chek the backup is not running? Can you chek the connection from another PC ? Regards.

Dear Sergo,

I can log on into SAP System. But if try to open new session (/o) I always get the error. And all the users have the same problem like me.

Regards,

MAL

Can you chek messages in SM21 ?

Dear Expert,

This the log I see in SM21:

Delete session 001 after error 024

Session 001 was already disconnected

> Request type: DIALOG

Regards,

MAL

Can you chek the system events on your windows server? Also check the t-code db13,backup are sucessfull ? Regards. May be it's network problem (netcard for example) , check events. Regards.

Dear Expert,

I have solved the problem by restarted my SAP Server.

Regards,

Mikael

Ask a Question

Top Q&A Solution Author

User

Count