disp+work.EXE stopped - urjent

[Former Member]

Hi,

disp+work.EXE is getting stopped. Below is the trace file for this.

I am unlocking SAPSR3 user and resetting the password, still as soon i start SAP again the trace file is showing that user SAPSR3 is locked.

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        CHP

M systemid   562 (PC with Windows NT)

M relno      7010

M patchlevel 0

M patchno    133

M intno      20020600

M make:      multithreaded, Unicode, 64 bit, optimized

M pid        2136

M

M 

M Tue Feb 11 16:54:42 2014

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

M  length of sys_adm_ext is 576 bytes

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

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) 29792 (1752)

M  DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M  DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M  DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

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

M  DpShMCreate: sizeof(comm_adm) 552080 (1088)

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

M  DpShMCreate: sizeof(slock_adm) 0 (104)

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

M  DpShMCreate: sizeof(file_adm) 0 (72)

M  DpShMCreate: sizeof(vmc_adm) 0 (1864)

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

M  DpShMCreate: sizeof(gw_adm) 48

M  DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000B000050, size: 6614144)

M  DpShMCreate: allocated sys_adm at 000000000B000050

M  DpShMCreate: allocated wp_adm at 000000000B002270

M  DpShMCreate: allocated tm_adm_list at 000000000B0096D0

M  DpShMCreate: allocated tm_adm at 000000000B009730

M  DpShMCreate: allocated wp_ca_adm at 000000000B5ACFB0

M  DpShMCreate: allocated appc_ca_adm at 000000000B5B2DB0

M  DpShMCreate: allocated comm_adm at 000000000B5B4CF0

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 000000000B63B980

M  DpShMCreate: allocated gw_adm at 000000000B63BA00

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 000000000B63BA30

M  DpShMCreate: allocated wall_adm at 000000000B63BA40

M  DpRqQInit: Parameter rdisp/queue_lock_level = 2

M  rdisp/queue_size_check_value :  -> on,50,30,40,500,50,500,80

M  ThTaskStatus: rdisp/reset_online_during_debug 0

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation view

X  <EsNT> Using memory model view.

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

X  mm.dump: set maximum dump mem to 96 MB

M 

M Tue Feb 11 16:54:43 2014

M  ThInit: rdisp/cleanup_after_crash = 1

M  ThInit: running on host abtmdrsap01

M  calling db_connect ...

B  Loading DB library 'S:\usr\sap\CHP\DVEBMGS00\exe\dboraslib.dll' ...

B  Library 'S:\usr\sap\CHP\DVEBMGS00\exe\dboraslib.dll' loaded

B  Version of 'S:\usr\sap\CHP\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.110)

C  Prepending S:\usr\sap\CHP\DVEBMGS00\exe to Path.

C  Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910)

C  application info callback registered

C  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

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

C  Connecting as /@CHP on connection 0 (nls_hdl 0) ... (dbsl 701 140910)

C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      0000000004841700 0000000004849250 000000000484AA68

C  Attaching to DB Server CHP (con_hdl=0,svchp=000000000484A928,srvhp=000000000484B6D8)

C  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=000000000484A928, srvhp=000000000484B6D8, usrhp=00000000048585F0)

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C     ORA-01017: invalid username/password; logon denied                                                                       

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

[dbsloci.c    11437]

C  Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.

C  Connecting as SAPSR3/<pwd>@CHP on connection 0 (nls_hdl 0) ... (dbsl 701 140910)

C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      0000000004841700 0000000004849250 000000000484AA68

C  Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=000000000484A928, srvhp=000000000484B6D8, usrhp=00000000048585F0)

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 28000:

C     ORA-28000: the account is locked                                                                                         

C  Detaching from DB Server (con_hdl=0,svchp=000000000484A928,srvhp=000000000484B6D8)

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

[dbsloci.c    11437]

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

B  ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1208] [dbsh    1208 ]

B  ***LOG BY2=> sql error 28000  performing CON [dblink#4 @ 433] [dblink  0433 ]

B  ***LOG BY0=> ORA-28000: the account is locked [dblink#4 @ 433] [dblink  0433 ]

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

M  in_ThErrHandle: 1

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

M 

M  Info for wp 0

M 

M    pid = 2136

M    severity = 0

M    status = 0

M    stat = WP_RUN

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    rq_info = 0

M    tid = -1

M    mode = 255

M    len = -1

M    rq_id = 65535

M    rq_source =

M    last_tid = 0

M    last_mode = 0

M    semaphore = 0

M    act_cs_count = 0

M    csTrack = 0

M    csTrackRwExcl = 0

M Tue Feb 11 16:54:44 2014

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 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    attachedVm = no VM

M 

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

M  *

M  *  LOCATION    SAP-Server abtmdrsap01_CHP_00 on host abtmdrsap01 (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Tue Feb 11 16:54:44 2014

M  *  RELEASE     701

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10917

M  *  COUNTER     1

M  *

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

M 

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

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 2136) [dpnttool.c   334]

[karthikeyan_natarajan4 · Accepted solution]

Hi Suman,

Have you used any special character in new password?

check this note

1534597 - Using such special characters as "@" in a password

1576837 - ORA-01017: invalid username/password;

regards

kartik

[former_member188883]

Hi Suman,

Could you check database connection using R3trans -d. If it fails share the trans.log

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thanks for the quick guidance

Below is the trans log as pointed.

4 ETW000 R3trans version 6.14 (release 701 - 19.01.11 - 11:44:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 11.02.2014 - 17:17:54

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]  Tue Feb 11 17:17:57 2014                                                5752  0.005752

4 ETW000  [     dev trc,00000]  db_con_init called                                                        80  0.005832

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dboraslib.dll' ...                                   866  0.013375

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 0000000187280000

4 ETW000                                                                                               61508  0.074883

4 ETW000  [     dev trc,00000]      using "S:\usr\sap\CHP\SYS\exe\uc\NTAMD64\dboraslib.dll"               20  0.074903

4 ETW000  [     dev trc,00000]  Library 'dboraslib.dll' loaded                                            23  0.074926

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

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

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

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

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  35  0.180057

4 ETW000  [     dev trc,00000]  000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  57  0.180114

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

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

4 ETW000  [     dev trc,00000]  000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  51  0.180219

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

4 ETW000                        DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000                          assuming using instant client with unspecified location.

4 ETW000  [     dev trc,00000]  -->oci_init1                                                             883  0.195844

4 ETW000  [     dev trc,00000]  Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910)                 42725  0.238569

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='CHP'                                      37  0.238606

4 ETW000  [     dev trc,00000]  -->oci_initialize(con_hdl=0, char='', nchar='')                           27  0.238633

4 ETW000  [     dev trc,00000]  application info callback registered                                      20  0.238653

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000                                                                                               15850  0.254503

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=0000000003E1CA10)

4 ETW000                                                                                                 794  0.255297

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0000000003E1E1C8)

4 ETW000                                                                                                  62  0.255359

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=41004D00450052004900430041004E0000000000000000000000000000000000

4 ETW000                                                                                               18948  0.274307

4 ETW000  [     dev trc,00000]                     terr=41004D0045005200490043004100000000000000000000000000000000000000

4 ETW000                                                                                                  41  0.274348

4 ETW000  [     dev trc,00000]                     char=5500540046003100360000000000000000000000000000000000000000000000

4 ETW000                                                                                                  38  0.274386

4 ETW000  [     dev trc,00000]  Client character set UTF16 -> UTF8                                        19  0.274405

4 ETW000  [     dev trc,00000]  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000                                                                                                  32  0.274437

4 ETW000  [     dev trc,00000]  charset='', chset='UTF8', UNI_ASC=FALSE/FALSE                             21  0.274458

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

4 ETW000  [     dev trc,00000]  Connecting as /@CHP on connection 0 (nls_hdl 0) ... (dbsl 701 140910)

4 ETW000                                                                                                  38  0.274517

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

4 ETW000                                                                                                  42  0.274559

4 ETW000  [     dev trc,00000]    0 UTF8                                                      0000000003E14F20 0000000003E1CA10 0000000003E1E1C8

4 ETW000                                                                                                  39  0.274598

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

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          38  0.275728

4 ETW000  [     dev trc,00000]  Attaching to DB Server CHP (con_hdl=0,svchp=0000000003E1E088,srvhp=0000000003E228F8)

4 ETW000                                                                                                  69  0.275797

4 ETW000  [     dev trc,00000]  Assigning server context 0000000003E228F8 to service context 0000000003E1E088

4 ETW000                                                                                               58450  0.334247

4 ETW000  [     dev trc,00000]  Allocating user session handle                                            50  0.334297

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000003E1E088, srvhp=0000000003E228F8, usrhp=0000000003E2F4E0)

4 ETW000                                                                                                  59  0.334356

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR               31904  0.366260

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:               99  0.366359

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                       

4 ETW000                                                                                                  40  0.366399

4 ETW000  [    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '1017'                       1311  0.367710

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 1017                                    563  0.368273

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con_hdl=0, rc=1017)                                    30  0.368303

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1017                                    65  0.368368

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                       

4 ETW000                                                                                                  47  0.368415

4 ETW000  [     dev trc,00000]  Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.

4 ETW000                                                                                                 854  0.369269

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

4 ETW000                                                                                                  33  0.369302

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

4 ETW000                                                                                                  36  0.369338

4 ETW000  [     dev trc,00000]    0 UTF8                                                      0000000003E14F20 0000000003E1CA10 0000000003E1E1C8

4 ETW000                                                                                                  39  0.369377

4 ETW000  [     dev trc,00000]  Assigning username to user session: con_hdl=0, usrhp=0000000003E2F4E0

4 ETW000                                                                                                  31  0.369408

4 ETW000  [     dev trc,00000]  Assigning password to user session: con_hdl=0, usrhp=0000000003E2F4E0

4 ETW000                                                                                                 102  0.369510

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0000000003E1E088, srvhp=0000000003E228F8, usrhp=0000000003E2F4E0)

4 ETW000                                                                                               58600  0.428110

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR                3711  0.431821

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 28000:              79  0.431900

4 ETW000  [     dev trc,00000]     ORA-28000: the account is locked                                                                                         

4 ETW000                                                                                                  38  0.431938

4 ETW000  [     dev trc,00000]  server_detach(con_hdl=0,stale=1,svrhp=0000000003E228F8)                   22  0.431960

4 ETW000  [     dev trc,00000]  Detaching from DB Server (con_hdl=0,svchp=0000000003E1E088,srvhp=0000000003E228F8)

4 ETW000                                                                                                  33  0.431993

4 ETW000  [     dev trc,00000]  Deallocating server context handle 0000000003E228F8 from con_hdl=0     16582  0.448575

4 ETW000  [    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '28000'                        53  0.448628

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 28000                                    23  0.448651

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con_hdl=0, rc=28000)                                   21  0.448672

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 28000                                   62  0.448734

4 ETW000  [     dev trc,00000]     ORA-28000: the account is locked                                                                                         

4 ETW000                                                                                                  37  0.448771

4 ETW000  [    dblink  ,00433]  ***LOG BY2=>sql error 28000  performing CON [dblink#4 @ 433]            2632  0.451403

4 ETW000  [    dblink  ,00433]  ***LOG BY0=>ORA-28000: the account is locked [dblink#4 @ 433]             34  0.451437

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'CHP'"

[karthikeyan_natarajan4]

Hi Suman,

Check this note 951167 - ORA-28000: the account is locked