Skip to Content
avatar image
Former Member

r3trans finished (0012).

Dear Experts,

After restoring the database to my development server and try to start the server the dispatcher got down and turns to grey colour and when we run the command r3trans -d it is throwing the fallowing error :

This is r3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = MSSQL

SERVER = 'HOSTNAME\SID' DBNAME = 'SID'"

r3trans finished (0012).

We are using the MSSQL 2005 server database and windows 2008 server.

Can any body help me in this.

Regards,

Rajiv.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 25, 2011 at 09:56 AM

    Hi,

    Provide us with logs from dev_disp, dev_w0.

    Regards,

    Vishnu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2011 at 10:24 AM

    Dear Expert,

    Here are the Logs;

    dev_disp

    Wed May 25 03:18:56 2011

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

    length of sys_adm_ext is 576 bytes

    • SWITCH TRC-HIDE on ***

    ***LOG Q00=> DpSapEnvInit, DPStart (15 3856) [dpxxdisp.c 1287]

    shared lib "dw_xml.dll" version 117 successfully loaded

    shared lib "dw_xtc.dll" version 117 successfully loaded

    shared lib "dw_stl.dll" version 117 successfully loaded

    shared lib "dw_gui.dll" version 117 successfully loaded

    shared lib "dw_mdm.dll" version 117 successfully loaded

    rdisp/softcancel_sequence : -> 0,5,-1

    use internal message server connection to port 3915

    Wed May 25 03:19:01 2011

    • WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

    ***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5534]

    MtxInit: 30000 0 0

    DpSysAdmExtInit: ABAP is active

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

    DpIPCInit2: start server >HOSTNAME_SID_15 <

    DpShMCreate: sizeof(wp_adm) 29792 (1752)

    DpShMCreate: sizeof(tm_adm) 5912704 (29416)

    DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

    DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

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

    DpShMCreate: sizeof(comm_adm) 552080 (1088)

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

    DpShMCreate: sizeof(slock_adm) 0 (104)

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

    DpShMCreate: sizeof(file_adm) 0 (72)

    DpShMCreate: sizeof(vmc_adm) 0 (1864)

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

    DpShMCreate: sizeof(gw_adm) 48

    DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000008400050, size: 6614144)

    DpShMCreate: allocated sys_adm at 0000000008400050

    DpShMCreate: allocated wp_adm at 0000000008402270

    DpShMCreate: allocated tm_adm_list at 00000000084096D0

    DpShMCreate: allocated tm_adm at 0000000008409730

    DpShMCreate: allocated wp_ca_adm at 00000000089ACFB0

    DpShMCreate: allocated appc_ca_adm at 00000000089B2DB0

    DpShMCreate: allocated comm_adm at 00000000089B4CF0

    DpShMCreate: system runs without slock table

    DpShMCreate: system runs without file table

    DpShMCreate: allocated vmc_adm_list at 0000000008A3B980

    DpShMCreate: allocated gw_adm at 0000000008A3BA00

    DpShMCreate: system runs without vmc_adm

    DpShMCreate: allocated ca_info at 0000000008A3BA30

    DpShMCreate: allocated wall_adm at 0000000008A3BA40

    MBUF state OFF

    DpCommInitTable: init table for 500 entries

    DpRqQInit: Parameter rdisp/queue_lock_level = 2

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

    Wed May 25 03:19:02 2011

    ThTaskStatus: rdisp/reset_online_during_debug 0

    EmInit: MmSetImplementation( 2 ).

    MM global diagnostic options set: 0

    <ES> client 0 initializing ....

    <ES> InitFreeList

    <ES> block size is 4096 kByte.

    <ES> Info: em/initial_size_MB( 6134MB) not multiple of em/blocksize_KB( 4096KB)

    <ES> Info: em/initial_size_MB rounded up to 6136MB

    Using implementation view

    <EsNT> Using memory model view.

    <EsNT> Memory Reset disabled as NT default

    <ES> 1533 blocks reserved for free list.

    ES initialized.

    mm.dump: set maximum dump mem to 96 MB

    rdisp/http_min_wait_dia_wp : 1 -> 1

    ***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1682]

    ***LOG Q0K=> DpMsAttach, mscon ( Hostname) [dpxxdisp.c 12696]

    DpStartStopMsg: send start message (myname is >hostname_SID_15 <)

    DpStartStopMsg: start msg sent

    Wed May 25 03:19:03 2011

    CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

    CCMS: start to initalize 3.X shared alert area (first segment).

    DpMsgAdmin: Set release to 7010, patchlevel 0

    MBUF state PREPARED

    MBUF component UP

    DpMBufHwIdSet: set Hardware-ID

    ***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048]

    DpMsgAdmin: Set patchno for this platform to 117

    Release check o.K.

    dev_w0

    ed May 25 03:19:02 2011

    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 1956) [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: 000000000A600050, size: 6614144)

    M DpShMCreate: allocated sys_adm at 000000000A600050

    M DpShMCreate: allocated wp_adm at 000000000A602270

    M DpShMCreate: allocated tm_adm_list at 000000000A6096D0

    M DpShMCreate: allocated tm_adm at 000000000A609730

    M DpShMCreate: allocated wp_ca_adm at 000000000ABACFB0

    M DpShMCreate: allocated appc_ca_adm at 000000000ABB2DB0

    M DpShMCreate: allocated comm_adm at 000000000ABB4CF0

    M DpShMCreate: system runs without slock table

    M DpShMCreate: system runs without file table

    M DpShMCreate: allocated vmc_adm_list at 000000000AC3B980

    M DpShMCreate: allocated gw_adm at 000000000AC3BA00

    M DpShMCreate: system runs without vmc_adm

    M DpShMCreate: allocated ca_info at 000000000AC3BA30

    M DpShMCreate: allocated wall_adm at 000000000AC3BA40

    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 ThInit: rdisp/cleanup_after_crash = 1

    M ThInit: running on host TOWQASEC6

    M calling db_connect ...

    B

    B Wed May 25 03:19:03 2011

    B Loading DB library 'E:\usr\sap\NTQ\DVEBMGS15\exe\dbmssslib.dll' ...

    B Library 'E:\usr\sap\NTQ\DVEBMGS15\exe\dbmssslib.dll' loaded

    B Version of 'E:\usr\sap\NTQ\DVEBMGS15\exe\dbmssslib.dll' is "700.08", patchlevel (0.117)

    C Callback functions for dynamic profile parameter registered

    C Thread ID:3236

    C Thank You for using the SLOLEDB-interface

    C Using dynamic link library 'E:\usr\sap\NTQ\DVEBMGS15\exe\dbmssslib.dll'

    C dbmssslib.dll patch info

    C patchlevel 0

    C patchno 117

    C patchcomment Tables ########## in SM50 or SM66 (1523684)

    C Local connection used on TOWQASEC6 to named instance: np:TOWQASEC6\NTQ

    C CopyLocalParameters: dbuser is 'ntq'

    C Using Provider SQLNCLI

    C OpenOledbConnection: MARS property was set successfully.

    C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'ntq' setuser 'ntq']

    C

    C Wed May 25 03:19:04 2011

    C sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

    C Procname: [ExecuteAndFlush - no proc]

    C setuser 'ntq' failed -- connect terminated

    C Using Provider SQLNCLI

    C OpenOledbConnection: MARS property was set successfully.

    C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'ntq' setuser 'ntq']

    C sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

    C Procname: [ExecuteAndFlush - no proc]

    C setuser 'ntq' failed -- connect terminated

    C Using Provider SQLNCLI

    C OpenOledbConnection: MARS property was set successfully.

    C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'ntq' setuser 'ntq']

    C sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

    C Procname: [ExecuteAndFlush - no proc]

    C setuser 'ntq' failed -- connect terminated

    C failed to establish conn to np:TOWQASEC6\NTQ.

    C Retrying without protocol specifier: TOWQASEC6\NTQ

    C Using Provider SQLNCLI

    C OpenOledbConnection: MARS property was set successfully.

    C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'ntq' setuser 'ntq']

    C sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

    C Procname: [ExecuteAndFlush - no proc]

    C setuser 'ntq' failed -- connect terminated

    C Using Provider SQLNCLI

    C OpenOledbConnection: MARS property was set successfully.

    C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'ntq' setuser 'ntq']

    C sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

    C Procname: [ExecuteAndFlush - no proc]

    C setuser 'ntq' failed -- connect terminated

    C Using Provider SQLNCLI

    C OpenOledbConnection: MARS property was set successfully.

    C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'ntq' setuser 'ntq']

    C sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

    C Procname: [ExecuteAndFlush - no proc]

    C setuser 'ntq' failed -- connect terminated

    C failed to establish conn. 0

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

    B ***LOG BY0=> Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission. [dbsh#2 @ 1208] [dbsh 1208 ]

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

    B ***LOG BY0=> Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission. [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 10651]

    M

    M Info for wp 0

    M

    M pid = 1956

    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 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 HOSTNAME_SID_15 on host HOSTNAME (wp 0)

    M * ERROR ThInit: db_connect

    M *

    M * TIME Wed May 25 03:19:04 2011

    M * RELEASE 701

    M * COMPONENT Taskhandler

    M * VERSION 1

    M * RC 13

    M * MODULE thxxhead.c

    M * LINE 10916

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

    Regards,

    Rajiv.

    Add comment
    10|10000 characters needed characters exceeded

  • May 25, 2011 at 11:54 AM

    What is the output of trans.log ?

    Regards,

    Subhash

    Add comment
    10|10000 characters needed characters exceeded

    • HI Rajiv,

      It seems Your database restoration steps has not been completed properly.

      4 ETW000  [dev trc     ,00000]  Procname: [ExecuteAndFlush - no proc]                                     18  0.133036
      4 ETW000  [dev trc     ,00000]  setuser 'ntq' failed -- connect terminated                                23  0.133059
      4 ETW000  [dev trc     ,00000]  failed to establish conn. 0                                             4762  0.137821
      4 ETW000  [dblink      ,00433]  ***LOG BY2=>sql error -1     performing CON [dblink#4 @ 433]             130  0.137951
      4 ETW000  [dblink      ,00433]  ***LOG BY0=>Setuser failed because of one of the following reasons: the database principal 'ntq' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

      Could you please check the same.

      Regards,

      Subhash