cancel
Showing results for 
Search instead for 
Did you mean: 

Disp+ work process stopped in Ides system

Former Member
0 Kudos

Hi experts,

I am Using Ecc 6.0 Ides version in windows 2003, db is oracle 10.2

I am unable to start the sap as  Disp+work is getting stopped after a min showing all the wp's in ended state . below im providing is the log file of

dev_ms and dev_w0 .

dev_ms

---------------------------------------------------

trc file: "dev_ms", trc level: 1, release: "700"

---------------------------------------------------

[Thr 3028] Fri Mar 01 16:03:21 2013

[Thr 3028] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid   560 (PC with Windows NT)

relno      7000

patchlevel 0

patchno    73

intno      20050900

make:      multithreaded, Unicode, optimized

pid        3024

[Thr 3028] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3024) [msxxserv.c   1824]

[Thr 3028] Fri Mar 01 16:03:22 2013

[Thr 3028] load acl file = C:\usr\sap\PRO\SYS\global\ms_acl_info.DAT

[Thr 3028] MsGetOwnIpAddr: my host addresses are :

[Thr 3028]   1 : [192.168.1.101] server (HOSTNAME)

[Thr 3028]   2 : [127.0.0.1] server (LOCALHOST)

[Thr 3028]   3 : [192.168.1.100] server (NILIST)

[Thr 3028] Fri Mar 01 16:03:23 2013

[Thr 3028] MsHttpInit: full qualified hostname = server

[Thr 3028] HTTP logging is switch off

[Thr 3028] set HTTP state to LISTEN

[Thr 3028] ms/icf_info_server : deleted

[Thr 3028] *** I listen to port sapmsPRO (3601) ***

[Thr 3028] *** I listen to internal port 3901 (3901) ***

[Thr 3028] *** HTTP port 8101 state LISTEN ***

[Thr 3028] CUSTOMER KEY: >G0962748780<

[Thr 3028] Fri Mar 01 16:04:41 2013

[Thr 3028] *** ERROR => MsSClientHandle: no server provides service ENQ  (4), requested from server_PRO_01 [msxxserv.c   4679]

[Thr 3028] Fri Mar 01 16:15:02 2013

[Thr 3028] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.1.101) after 300 secs received [msxxserv.c   3165]

[Thr 3028] *** ERROR => MsSCheckConnections: disconnect now [192.168.1.101] [msxxserv.c   3169]

Dev_w0

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "700"

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

B Fri Mar 01 16:03:32 2013

B  create_con (con_name=R/3)

B  Loading DB library 'C:\usr\sap\PRO\DVEBMGS01\exe\dboraslib.dll' ...

B  Library 'C:\usr\sap\PRO\DVEBMGS01\exe\dboraslib.dll' loaded

B  Version of 'C:\usr\sap\PRO\DVEBMGS01\exe\dboraslib.dll' is "700.08", patchlevel (0.73)

B  New connection 0 created

M sysno      01

M sid        PRO

M systemid   560 (PC with Windows NT)

M relno      7000

M patchlevel 0

M patchno    75

M intno      20050900

M make:      multithreaded, Unicode, optimized

M pid        3284

M

M  kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)

M  length of sys_adm_ext is 572 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3284) [dpxxdisp.c   1299]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M Fri Mar 01 16:03:33 2013

M  DpShMCreate: sizeof(wp_adm)        18304    (1408)

M  DpShMCreate: sizeof(tm_adm)        3994272    (19872)

M  DpShMCreate: sizeof(wp_ca_adm)        24000    (80)

M  DpShMCreate: sizeof(appc_ca_adm)    8000    (80)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M  DpShMCreate: sizeof(comm_adm)        528064    (1048)

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

M  DpShMCreate: sizeof(file_adm)        0    (72)

M  DpShMCreate: sizeof(vmc_adm)        0    (1440)

M  DpShMCreate: sizeof(wall_adm)        (38456/34360/64/184)

M  DpShMCreate: sizeof(gw_adm)    48

M  DpShMCreate: SHM_DP_ADM_KEY        (addr: 06840040, size: 4653368)

M  DpShMCreate: allocated sys_adm at 06840040

M  DpShMCreate: allocated wp_adm at 06841E40

M  DpShMCreate: allocated tm_adm_list at 068465C0

M  DpShMCreate: allocated tm_adm at 068465F0

M  DpShMCreate: allocated wp_ca_adm at 06C15890

M  DpShMCreate: allocated appc_ca_adm at 06C1B650

M  DpShMCreate: allocated comm_adm at 06C1D590

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 06C9E450

M  DpShMCreate: allocated gw_adm at 06C9E490

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 06C9E4C0

M  DpShMCreate: allocated wall_adm at 06C9E4C8

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation flat

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

M  ThInit: running on host server

M Fri Mar 01 16:03:34 2013

M  calling db_connect ...

C  Prepending C:\usr\sap\PRO\DVEBMGS01\exe to Path.

C Fri Mar 01 16:03:36 2013

C  Oracle Client Version: '10.2.0.1.0'

C  Client NLS settings: AMERICAN_AMERICA.UTF8

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@PRO on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   05B9FDF8   05BA5394   05BA4C1C

C  Attaching to DB Server PRO (con_hdl=0,svchp=05BA4B68,svrhp=05BB6434)

C  Starting user session (con_hdl=0,svchp=05BA4B68,srvhp=05BB6434,usrhp=05C01C58)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c      4391]

C  *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c    10933]

C  Try to connect with default password

C  Connecting as SAPSR3/<pwd>@PRO on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   05B9FDF8   05BA5394   05BA4C1C

C  Starting user session (con_hdl=0,svchp=05BA4B68,srvhp=05BB6434,usrhp=05C01C58)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c      4391]

C  *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c    10933]

B  ***LOG BY2=> sql error 1017   performing CON [dbsh#2 @ 1204] [dbsh    1204 ]

B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh    1204 ]

B  ***LOG BY2=> sql error 1017   performing CON [dblink#3 @ 431] [dblink  0431 ]

B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#3 @ 431] [dblink  0431 ]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]

M  Info for wp 0

M    stat = 4

M    reqtype = 1

M    act_reqtype = -1

M    rq_info = 0

M    tid = -1

M    mode = 255

M    len = -1

M    rq_id = 65535

M    rq_source = 255

M    last_tid = 0

M    last_mode = 0

M    semaphore = 0

M    act_cs_count = 0

M    control_flag = 0

M    int_checked_resource(RFC) = 0

M    ext_checked_resource(RFC) = 0

M    int_checked_resource(HTTP) = 0

M    ext_checked_resource(HTTP) = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M    vm = V-1

M  *****************************************************************************

M  *

M  *  LOCATION    SAP-Server server_PRO_01 on host server (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Fri Mar 01 16:03:36 2013

M  *  RELEASE     700

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10354

M  *  COUNTER     1

M  *

M  *****************************************************************************

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   720]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  260]

M  Entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 3284) [dpnttool.c   327]

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi vimal ,

Actually in  services.msc i can see my services sap<sid>_00 is starting  user with local system . when i change it to user ./sapservicesid . i am not able to see any update log in dev_disp and dev_w0.

which is the correct user to start the sap services.?

regards

krishna

Former Member
0 Kudos

Hi,

   Did you do any kernel upgrade? It is recommended to start the services using ./sapservicesid..However in sometimes, we can also start it using local account user.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi evryone,

Problem Solved by adding ora_dba profile to sid adm user

Thanks ,

Krishna

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Krishna,

   The issue seems to be due to incorrect SAPSR3 password.Please try the following.

1.login to sidadm -> command prompt -> sqlplus "/as sysdba"

2.select username,account_status from dba_users;

3.see whether sapsr3 user is locked.. If yes, execute alter user sapsr3 account unlock;

4.and try to start the system

5. if the user is not locked, try to reset the password using the following command,

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

example

brconnect -u system/<password of system user> -f chpass -o SAPSR3 < password for SAPSR3>

It will reset the password .

Then try to start the system it will come up.

Thanks and Regards,

Vimal

Former Member
0 Kudos

hi joseph,

thanks for the quick reply i checked the dba_users they are not locked

SQL> select username,account_status from dba_users;

USERNAME                       ACCOUNT_STATUS

------------------------------ -----------------------------

OPS$SERVER\SAPSERVICEPRO       OPEN

OPS$SERVER\SAPSERVICESR3       OPEN

OPS$SERVER\PROADM                   OPEN

SYS                                                OPEN

SYSTEM                                        OPEN

SAPSR3                                     OPEN

SAPSR3DB                                   OPEN

OUTLN                                      LOCKED

TSMSYS                         EXPIRED & LOCKED

DIP                            EXPIRED & LOCKED

DBSNMP                         EXPIRED & LOCKED

11 rows selected.

Former Member
0 Kudos

Ok Krishna,

Please login in as sidadm -> command prompt and execute the below command.

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

example

brconnect -u system/<password of system user> -f chpass -o SAPSR3 < password for SAPSR3>

It has to fix your issue.

Former Member
0 Kudos

Hi Joseph,

i have used the default password in brconnect for the system. it was completed successfully. But again after restarting the sap disp+work process is running for 30 sec and getting stopped.

Thanks & regards,

Former Member
0 Kudos

Hi,

Please execute R3trans.log and paste the trans.log for further analysis .

Thanks and Regards,

Vimal

Former Member
0 Kudos

hi

r3 trans -d executed successfully completed 0000

below is the trans.log

4 ETW000 r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 01.03.2013 - 16:59:56

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]  Fri Mar 01 16:59:58 2013                           11504  0.011504

4 ETW000  [dev trc     ,00000]  db_con_init called                                    43  0.011547

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

4 ETW000  [dev trc     ,00000]  Loading DB library 'dboraslib.dll' ...                40  0.011634

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

4 ETW000  [dev trc     ,00000]      using "C:\usr\sap\PRO\SYS\exe\uc\NTI386\dboraslib.dll"

4 ETW000                                                                              36  0.053606

4 ETW000  [dev trc     ,00000]  Library 'dboraslib.dll' loaded                        17  0.053623

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

4 ETW000                                                                              35  0.053658

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

4 ETW000                                                                           25928  0.079586

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

4 ETW000                                                                              30  0.079616

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

4 ETW000                                                                              38  0.079654

4 ETW000  [dev trc     ,00000]  New connection 0 created                              25  0.079679

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                                                                              37  0.079716

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

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

4 ETW000                                                                              27  0.079764

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                                                                              33  0.079797

4 ETW000  [dev trc     ,00000]  CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000                        DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000                          assuming using instant client with unspecified location.

4 ETW000                                                                           13214  0.093011

4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.1.0'                50544  0.143555

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

4 ETW000  [dev trc     ,00000]  Client NLS settings: AMERICAN_AMERICA.UTF8          2438  0.146040

4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPSR3's password           28  0.146068

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

4 ETW000                                                                              37  0.146105

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

4 ETW000                                                                             731  0.146836

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1   02D3DDD8   02D4330C   02D42B94

4 ETW000                                                                              92  0.146928

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

4 ETW000  [dev trc     ,00000]  Allocating server context handle                      25  0.165143

4 ETW000  [dev trc     ,00000]  Attaching to DB Server PRO (con_hdl=0,svchp=02D42AE0,svrhp=02D54354)

4 ETW000                                                                              55  0.165198

4 ETW000  [dev trc     ,00000]  Assigning server context 02D54354 to service context 02D42AE0

4 ETW000                                                                           17126  0.182324

4 ETW000  [dev trc     ,00000]  Allocating user session handle                        30  0.182354

4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=02D42AE0,srvhp=02D54354,usrhp=02D8F920)

4 ETW000                                                                              47  0.182401

4 ETW000  [dev trc     ,00000]  Assigning user session 02D8F920 to service context 02D42AE0

4 ETW000                                                                           37488  0.219889

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

4 ETW000                                                                              53  0.219942

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

4 ETW000                                                                              87  0.220029

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

4 ETW000                                                                           81753  0.301782

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

4 ETW000                                                                              41  0.301823

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

4 ETW000                                                                             587  0.302410

4 ETW000  [dev trc     ,00000]  Got SAPSR3's password from OPS$-user               15242  0.317652

4 ETW000  [dev trc     ,00000]  Disconnecting from connection 0 ...                   26  0.317678

4 ETW000  [dev trc     ,00000]  Rolling back transaction ...                          26  0.317704

4 ETW000  [dev trc     ,00000]  Closing user session (con_hdl=0,svchp=02D42AE0,usrhp=02D8F920)

4 ETW000                                                                             158  0.317862

4 ETW000  [dev trc     ,00000]  Now I'm disconnected from ORACLE                     432  0.318294

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

4 ETW000                                                                              32  0.318326

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

4 ETW000                                                                              39  0.318365

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1   02D3DDD8   02D4330C   02D42B94

4 ETW000                                                                              32  0.318397

4 ETW000  [dev trc     ,00000]  Assigning username to user session 02D8F920           18  0.318415

4 ETW000  [dev trc     ,00000]  Assigning password to user session 02D8F920           22  0.318437

4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=02D42AE0,srvhp=02D54354,usrhp=02D8F920)

4 ETW000                                                                              95  0.318532

4 ETW000  [dev trc     ,00000]  Assigning user session 02D8F920 to service context 02D42AE0

4 ETW000                                                                            6599  0.325131

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

4 ETW000                                                                              48  0.325179

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

4 ETW000                                                                              64  0.325243

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

4 ETW000                                                                             921  0.326164

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

4 ETW000                                                                              58  0.326222

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                                                                             343  0.326565

4 ETW000  [dev trc     ,00000]         ETER                                                                                                                     

4 ETW000                                                                              31  0.326596

4 ETW000  [dev trc     ,00000]  Database NLS settings: AMERICAN_AMERICA.UTF8       15901  0.342497

4 ETW000  [dev trc     ,00000]         SELECT UPPER(INSTANCE_NAME), HOST_NAME, VERSION, TO_CHAR (STARTUP_TIME, 'YYYYMMDD') FROM V$INSTANCE                      

4 ETW000                                                                            1430  0.343927

4 ETW000  [dev trc     ,00000]  Database instance PRO is running on SERVER with ORACLE version 10.2.0.2.0 since 20130301

4 ETW000                                                                            1899  0.345826

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

4 ETW000                                                                              38  0.345864

4 ETW000  [dev trc     ,00000]  Connection 0 opened (DBSL handle 0)                25666  0.371530

4 ETW000  [dev trc     ,00000]  Fri Mar 01 16:59:59 2013                            7865  0.379395

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

4 ETW000                                                                              34  0.379429

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

4 ETW000                                                                          160080  0.539509

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

4 ETW000  [dev trc     ,00000]  NTAB: standalone processing                        10527  1.295420

4 ETW000  [dev trc     ,00000]  NTAB: read profile                                    24  1.295444

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

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

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

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

4 ETW000  [dev trc     ,00000]  NTAB: compute_hash_card: 2003.                        33  1.295544

4 ETW000  [dev trc     ,00000]  NTAB: maxcnt 1000.                                    36  1.295580

4 ETW000  [dev trc     ,00000]  NTAB: hfactor 2003.                                   16  1.295596

4 ETW000  [dev trc     ,00000]  NTAB: mem_protocol_size 104                           15  1.295611

4 ETW000  [dev trc     ,00000]  NTAB: hdr_backpack_offset 0                           16  1.295627

4 ETW000  [dev trc     ,00000]  NTAB: hdr_backpack_size 0                             15  1.295642

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: header_size 44.                           16  1.295658

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: item_size 36.                             16  1.295674

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: item_cnt 1000.                            16  1.295690

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: unit_size 4                               16  1.295706

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: unit_cnt 128000.                          16  1.295722

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: data_size 512000.                         17  1.295739

4 ETW000  [dev trc     ,00000]  NTAB: IREC: header_size 44.                           17  1.295756

4 ETW000  [dev trc     ,00000]  NTAB: IREC: item_size 36.                             16  1.295772

4 ETW000  [dev trc     ,00000]  NTAB: IREC: item_cnt 250.                             16  1.295788

4 ETW000  [dev trc     ,00000]  NTAB: IREC: unit_size 8                               16  1.295804

4 ETW000  [dev trc     ,00000]  NTAB: IREC: unit_cnt 12800.                           16  1.295820

4 ETW000  [dev trc     ,00000]  NTAB: IREC: data_size 102400.                         16  1.295836

4 ETW000  [dev trc     ,00000]  NTAB: STAB: header_size 44.                           17  1.295853

4 ETW000  [dev trc     ,00000]  NTAB: STAB: item_size 36.                             16  1.295869

4 ETW000  [dev trc     ,00000]  NTAB: STAB: item_cnt 250.                             16  1.295885

4 ETW000  [dev trc     ,00000]  NTAB: STAB: unit_size 4                               16  1.295901

4 ETW000  [dev trc     ,00000]  NTAB: STAB: unit_cnt 25600.                           16  1.295917

4 ETW000  [dev trc     ,00000]  NTAB: STAB: data_size 102400.                         17  1.295934

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: header_size 148.                          16  1.295950

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: item_size 24.                             16  1.295966

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: item_cnt 1000.                            17  1.295983

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: unit_size 256                             16  1.295999

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: unit_cnt 1000.                            16  1.296015

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: data_size 256000.                         17  1.296032

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: hh_p 2d60608, hh_len 44                  666  1.296698

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: aa_p 2d682b8, aa_len 8012                 20  1.296718

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: ia_p 40d04a0, ia_len 36000                23  1.296741

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: dat_p 40db008, dat_len 512000             18  1.296759

4 ETW000  [dev trc     ,00000]  NTAB: IREC: hh_p 2d60460, hh_len 44                   17  1.296776

4 ETW000  [dev trc     ,00000]  NTAB: IREC: aa_p 4158010, aa_len 8012                 17  1.296793

4 ETW000  [dev trc     ,00000]  NTAB: IREC: ia_p 4159f68, ia_len 9000                 17  1.296810

4 ETW000  [dev trc     ,00000]  NTAB: IREC: dat_p 415c298, dat_len 102400             18  1.296828

4 ETW000  [dev trc     ,00000]  NTAB: STAB: hh_p 2d74ef8, hh_len 44                   17  1.296845

4 ETW000  [dev trc     ,00000]  NTAB: STAB: aa_p 41752a0, aa_len 8012                 17  1.296862

4 ETW000  [dev trc     ,00000]  NTAB: STAB: ia_p 41771f8, ia_len 9000                 17  1.296879

4 ETW000  [dev trc     ,00000]  NTAB: STAB: dat_p 4179528, dat_len 102400             18  1.296897

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: hh_p 3347c8, hh_len 148                   85  1.296982

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: aa_p 4192530, aa_len 8012                 19  1.297001

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: ia_p 4194488, ia_len 24000                18  1.297019

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: dat_p 419a250, dat_len 256000             17  1.297036

4 ETW000  [dev trc     ,00000]  NTAB: ntab_mem_protocol 3347c8, ntab_mp_p 3347c8, ntab_proc_id 0

4 ETW000                                                                              32  1.297068

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: hh_p 2d60608, ha_list 2d682b8, hi_list 40d04a0, buffer 40db008

4 ETW000                                                                              56  1.297124

4 ETW000  [dev trc     ,00000]  NTAB: IREC: hh_p 2d60460, ha_list 4158010, hi_list 4159f68, buffer 415c298

4 ETW000                                                                              28  1.297152

4 ETW000  [dev trc     ,00000]  NTAB: STAB: hh_p 2d74ef8, ha_list 41752a0, hi_list 41771f8, buffer 4179528

4 ETW000                                                                              28  1.297180

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: hh_p 334830, ha_list 4192530, hi_list 4194488, buffer 419a250

4 ETW000                                                                              28  1.297208

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

4 ETW000                                                                              34  1.297242

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

4 ETW000                                                                              38  1.297280

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

4 ETW000                                                                              38  1.297318

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

4 ETW000                                                                              35  1.297353

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

4 ETW000                                                                              88  1.297441

4 ETW000  [twdydbacc.c ,00612]  i:0                                               909806  2.207247

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       PGMID                         49  2.207296

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      1                             16  2.207312

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      0                             15  2.207327

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   4                             14  2.207341

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:4                             15  2.207356

4 ETW000  [twdydbacc.c ,00612]  i:1                                                   27  2.207383

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       OBJECT                        21  2.207404

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      1                             14  2.207418

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      4                             14  2.207432

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   4                             14  2.207446

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:4                             14  2.207460

4 ETW000  [twdydbacc.c ,00612]  i:2                                                   24  2.207484

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       OBJ_NAME                      15  2.207499

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      1                             14  2.207513

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      8                             13  2.207526

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   40                            22  2.207548

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:40                            15  2.207563

4 ETW000  [twdydbacc.c ,00612]  i:3                                                   24  2.207587

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       KORRNUM                       14  2.207601

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.207615

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      48                            14  2.207629

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   10                            15  2.207644

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:10                            14  2.207658

4 ETW000  [twdydbacc.c ,00612]  i:4                                                   24  2.207682

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       SRCSYSTEM                     14  2.207696

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.207710

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      58                            14  2.207724

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   10                            14  2.207738

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:10                            14  2.207752

4 ETW000  [twdydbacc.c ,00612]  i:5                                                   24  2.207776

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       AUTHOR                        15  2.207791

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             15  2.207806

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      68                            14  2.207820

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   12                            14  2.207834

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:12                            15  2.207849

4 ETW000  [twdydbacc.c ,00612]  i:6                                                   24  2.207873

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       SRCDEP                        15  2.207888

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.207902

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      80                            18  2.207920

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             14  2.207934

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             14  2.207948

4 ETW000  [twdydbacc.c ,00612]  i:7                                                   24  2.207972

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       DEVCLASS                      15  2.207987

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208001

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      81                            14  2.208015

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   30                            14  2.208029

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:30                            14  2.208043

4 ETW000  [twdydbacc.c ,00612]  i:8                                                   24  2.208067

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       GENFLAG                       14  2.208081

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208095

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      111                           14  2.208109

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             14  2.208123

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             14  2.208137

4 ETW000  [twdydbacc.c ,00612]  i:9                                                   24  2.208161

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       EDTFLAG                       15  2.208176

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208190

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      112                           16  2.208206

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             14  2.208220

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             14  2.208234

4 ETW000  [twdydbacc.c ,00612]  i:10                                                  24  2.208258

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       CPROJECT                      15  2.208273

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208287

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      113                           14  2.208301

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   8                             14  2.208315

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:8                             14  2.208329

4 ETW000  [twdydbacc.c ,00612]  i:11                                                  24  2.208353

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       MASTERLANG                    15  2.208368

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208382

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      121                           14  2.208396

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             13  2.208409

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             17  2.208426

4 ETW000  [twdydbacc.c ,00612]  i:12                                                  24  2.208450

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       VERSID                        14  2.208464

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208478

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      122                           14  2.208492

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   20                            15  2.208507

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:20                            14  2.208521

4 ETW000  [twdydbacc.c ,00612]  i:13                                                  24  2.208545

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       PAKNOCHECK                    14  2.208559

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208573

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      142                           14  2.208587

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             14  2.208601

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             14  2.208615

4 ETW000  [twdydbacc.c ,00612]  i:14                                                  24  2.208639

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       OBJSTABLTY                    15  2.208654

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208668

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      143                           14  2.208682

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             14  2.208696

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             14  2.208710

4 ETW000  [twdydbacc.c ,00612]  i:15                                                  24  2.208734

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       COMPONENT                     14  2.208748

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208762

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      144                           14  2.208776

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   30                            14  2.208790

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:30                            14  2.208804

4 ETW000  [twdydbacc.c ,00612]  i:16                                                  24  2.208828

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       CRELEASE                      15  2.208843

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             16  2.208859

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      174                           15  2.208874

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   10                            14  2.208888

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:10                            14  2.208902

4 ETW000  [twdydbacc.c ,00612]  i:17                                                  24  2.208926

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       DELFLAG                       17  2.208943

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.208957

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      184                           14  2.208971

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             14  2.208985

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             14  2.208999

4 ETW000  [twdydbacc.c ,00612]  i:18                                                  24  2.209023

4 ETW000  [twdydbacc.c ,00613]  db_fd_p[i].fname:       TRANSLTTXT                    15  2.209038

4 ETW000  [twdydbacc.c ,00614]  db_fd_p[i].is_key:      0                             14  2.209052

4 ETW000  [twdydbacc.c ,00615]  db_fd_p[i].offset:      185                           14  2.209066

4 ETW000  [twdydbacc.c ,00616]  db_fd_p[i].db_length:   1                             14  2.209080

4 ETW000  [twdydbacc.c ,00617]  db_fd_p[i].fixed_length:1                             14  2.209094

4 ETW000  [dev trc     ,00000]  Fri Mar 01 17:00:00 2013                              61  2.209155

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

4 ETW000                                                                              28  2.209183

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

4 ETW000                                                                              31  2.209214

4 ETW000  [twdydbacc.c ,00760]  buffer:'Ÿ3Ÿ3'                                      44512  2.253726

4 ETW000  [twdydbacc.c ,00765]  i:0                                                   22  2.253748

4 ETW000  [twdydbacc.c ,00766]  tw_fd_p[i].offset:0                                   15  2.253763

4 ETW000  [twdydbacc.c ,00765]  i:1                                                   14  2.253777

4 ETW000  [twdydbacc.c ,00766]  tw_fd_p[i].offset:4                                   14  2.253791

4 ETW000  [twdydbacc.c ,00765]  i:2                                                   17  2.253808

4 ETW000  [twdydbacc.c ,00766]  tw_fd_p[i].offset:8                                   14  2.253822

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

4 ETW000                                                                              39  2.253861

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

4 ETW000                                                                           12920  2.266781

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

4 ETW000                                                                           73147  2.339928

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

4 ETW000  [dev trc     ,00000]  Fri Mar 01 17:00:01 2013                           36560  2.376488

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

4 ETW000                                                                              31  2.376519

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

4 ETW000                                                                           44947  2.421466

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

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                                                                             837  2.482794

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

4 ETW000                                                                              54  2.482848

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

4 ETW000                                                                              32  2.482880

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

4 ETW000                                                                              31  2.482911

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

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

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

4 ETW000                                                                              43  2.530753

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

4 ETW000                                                                              62  2.530815

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

4 ETW000                                                                              31  2.530846

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

4 ETW690 "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                                                                              65  2.531962

4 ETW000 COMMIT (0).

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   : 01.03.2013 - 17:00:01

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:                71016  0.071016

4 ETW000  [dev trc     ,00000]  Disconnecting from connection 0 ...                   23  0.071039

4 ETW000  [dev trc     ,00000]  Closing user session (con_hdl=0,svchp=02D42AE0,usrhp=02D8F920)

4 ETW000                                                                             221  0.071260

4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=02D42AE0,srvhp=02D54354)

4 ETW000                                                                             472  0.071732

4 ETW000  [dev trc     ,00000]  Now I'm disconnected from ORACLE                     415  0.072147

4 ETW000  [dev trc     ,00000]  Disconnected from connection 0                        25  0.072172

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

4 ETW000                                                                              31  0.072203

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

4 ETW000                                                                              30  0.072233

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 01.03.2013 - 17:00:01

Former Member
0 Kudos

Hi Krishna,

    It seems that now the connectivity is there.

I would suggest you to try to restart your System and try to start the SAP system using MMC and see whether it works or not.

If not, please share the dev_w0 log for analysis.

Thanks and Regards,

Vimal

Former Member
0 Kudos

hi vimal,

i have restarted the system and started the sap using mmc . still disp+work goes to dialog queue still and finaly stopped. below i am pasting the dev_w0 log

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "700"

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

B Fri Mar 01 17:28:13 2013

B  create_con (con_name=R/3)

B  Loading DB library 'C:\usr\sap\PRO\DVEBMGS01\exe\dboraslib.dll' ...

B Fri Mar 01 17:28:14 2013

B  Library 'C:\usr\sap\PRO\DVEBMGS01\exe\dboraslib.dll' loaded

B  Version of 'C:\usr\sap\PRO\DVEBMGS01\exe\dboraslib.dll' is "700.08", patchlevel (0.73)

B  New connection 0 created

M sysno      01

M sid        PRO

M systemid   560 (PC with Windows NT)

M relno      7000

M patchlevel 0

M patchno    75

M intno      20050900

M make:      multithreaded, Unicode, optimized

M pid        3400

M

M  kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)

M  length of sys_adm_ext is 572 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3400) [dpxxdisp.c   1299]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M  DpShMCreate: sizeof(wp_adm)                    18304          (1408)

M  DpShMCreate: sizeof(tm_adm)                    3994272          (19872)

M  DpShMCreate: sizeof(wp_ca_adm)                    24000          (80)

M  DpShMCreate: sizeof(appc_ca_adm)          8000          (80)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M  DpShMCreate: sizeof(comm_adm)                    528064          (1048)

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

M  DpShMCreate: sizeof(file_adm)                    0          (72)

M  DpShMCreate: sizeof(vmc_adm)                    0          (1440)

M  DpShMCreate: sizeof(wall_adm)                    (38456/34360/64/184)

M  DpShMCreate: sizeof(gw_adm)          48

M  DpShMCreate: SHM_DP_ADM_KEY                    (addr: 06840040, size: 4653368)

M  DpShMCreate: allocated sys_adm at 06840040

M  DpShMCreate: allocated wp_adm at 06841E40

M  DpShMCreate: allocated tm_adm_list at 068465C0

M  DpShMCreate: allocated tm_adm at 068465F0

M  DpShMCreate: allocated wp_ca_adm at 06C15890

M  DpShMCreate: allocated appc_ca_adm at 06C1B650

M  DpShMCreate: allocated comm_adm at 06C1D590

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 06C9E450

M  DpShMCreate: allocated gw_adm at 06C9E490

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 06C9E4C0

M  DpShMCreate: allocated wall_adm at 06C9E4C8

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation flat

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

M  ThInit: running on host server

M Fri Mar 01 17:28:15 2013

M  calling db_connect ...

C  Prepending C:\usr\sap\PRO\DVEBMGS01\exe to Path.

C Fri Mar 01 17:28:17 2013

C  Oracle Client Version: '10.2.0.1.0'

C  Client NLS settings: AMERICAN_AMERICA.UTF8

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@PRO on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   05B9FDF8   05BA5394   05BA4C1C

C  Attaching to DB Server PRO (con_hdl=0,svchp=05BA4B68,svrhp=05BB6434)

C  Starting user session (con_hdl=0,svchp=05BA4B68,srvhp=05BB6434,usrhp=05C01C58)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c      4391]

C  *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c    10933]

C  Try to connect with default password

C  Connecting as SAPSR3/<pwd>@PRO on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   05B9FDF8   05BA5394   05BA4C1C

C  Starting user session (con_hdl=0,svchp=05BA4B68,srvhp=05BB6434,usrhp=05C01C58)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c      4391]

C  *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c    10933]

B  ***LOG BY2=> sql error 1017   performing CON [dbsh#2 @ 1204] [dbsh    1204 ]

B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh    1204 ]

B  ***LOG BY2=> sql error 1017   performing CON [dblink#3 @ 431] [dblink  0431 ]

B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#3 @ 431] [dblink  0431 ]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]

M  Info for wp 0

M    stat = 4

M    reqtype = 1

M    act_reqtype = -1

M    rq_info = 0

M    tid = -1

M    mode = 255

M    len = -1

M    rq_id = 65535

M    rq_source = 255

M    last_tid = 0

M    last_mode = 0

M    semaphore = 0

M    act_cs_count = 0

M    control_flag = 0

M    int_checked_resource(RFC) = 0

M    ext_checked_resource(RFC) = 0

M    int_checked_resource(HTTP) = 0

M    ext_checked_resource(HTTP) = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M    vm = V-1

M  *****************************************************************************

M  *

M  *  LOCATION    SAP-Server server_PRO_01 on host server (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Fri Mar 01 17:28:17 2013

M  *  RELEASE     700

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10354

M  *  COUNTER     1

M  *

M  *****************************************************************************

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   720]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  260]

M  Entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 3400) [dpnttool.c   327]

Former Member
0 Kudos

Hi,

Please check the below note and see whether it helps.

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Thanks and Regards,

Vimal