Restoring SQL database

[former_member183788]

Dear Experts,

        My disp+work.exe is not working after the restoration of SQL 2005 in solution manager 7.0. What are the steps to be taken care while restoring SQL database.How can i use STM tool for correcting the errors?

[Former Member · Accepted solution]

Hi Ish,

   Please attach the dev_w0 logs which is available in work directory.

As well as please explain in detail about your issue.

Thanks and Regards,

Vimal

[former_member183788 · Accepted solution]

Hi Maria,

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      02

M sid        NSM

M systemid   562 (PC with Windows NT)

M relno      7010

M patchlevel 0

M patchno    122

M intno      20020600

M make:      multithreaded, Unicode, 64 bit, optimized

M pid        2344

M

M 

M Sun Jan 06 00:56:03 2013

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 2344) [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: 0000000009C00050, size: 6614144)

M  DpShMCreate: allocated sys_adm at 0000000009C00050

M  DpShMCreate: allocated wp_adm at 0000000009C02270

M  DpShMCreate: allocated tm_adm_list at 0000000009C096D0

M  DpShMCreate: allocated tm_adm at 0000000009C09730

M  DpShMCreate: allocated wp_ca_adm at 000000000A1ACFB0

M  DpShMCreate: allocated appc_ca_adm at 000000000A1B2DB0

M  DpShMCreate: allocated comm_adm at 000000000A1B4CF0

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 000000000A23B980

M  DpShMCreate: allocated gw_adm at 000000000A23BA00

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 000000000A23BA30

M  DpShMCreate: allocated wall_adm at 000000000A23BA40

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 solman

M  calling db_connect ...

B  Loading DB library 'D:\usr\sap\NSM\DVEBMGS02\exe\dbmssslib.dll' ...

B 

B Sun Jan 06 00:56:04 2013

B  Library 'D:\usr\sap\NSM\DVEBMGS02\exe\dbmssslib.dll' loaded

B  Version of 'D:\usr\sap\NSM\DVEBMGS02\exe\dbmssslib.dll' is "700.08", patchlevel (0.118)

C  Callback functions for dynamic profile parameter registered

C  Thread ID:4596

C  Thank You for using the SLOLEDB-interface

C  Using dynamic link library 'D:\usr\sap\NSM\DVEBMGS02\exe\dbmssslib.dll'

C  dbmssslib.dll patch info

C    patchlevel   0

C    patchno      118

C    patchcomment Problems with the use of literals in non-unicode systems (1524929)

C  np:(local) connection used on SOLMAN

C  CopyLocalParameters: dbuser is 'nsm'

C  Using Provider SQLNCLI

C  OpenOledbConnection: MARS property was set successfully.

C 

C Sun Jan 06 00:56:05 2013

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

C  sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'nsm' 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 'nsm' failed -- connect terminated

C  Using Provider SQLNCLI

C  OpenOledbConnection: MARS property was set successfully.

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

C  sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'nsm' 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 'nsm' failed -- connect terminated

C  Using Provider SQLNCLI

C  OpenOledbConnection: MARS property was set successfully.

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

C  sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'nsm' 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 'nsm' failed -- connect terminated

C  failed to establish conn to np:(local).

C  Retrying without protocol specifier: (local)

C  Using Provider SQLNCLI

C  OpenOledbConnection: MARS property was set successfully.

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

C  sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'nsm' 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 'nsm' failed -- connect terminated

C  Using Provider SQLNCLI

C  OpenOledbConnection: MARS property was set successfully.

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

C  sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'nsm' 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 'nsm' failed -- connect terminated

C  Using Provider SQLNCLI

C  OpenOledbConnection: MARS property was set successfully.

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

C  sloledb.cpp [ExecuteAndFlush,line 6756]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'nsm' 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 'nsm' 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 'nsm' 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 'nsm' 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 = 2344

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 solman_NSM_02 on host solman (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Sun Jan 06 00:56:05 2013

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

[Former Member · Accepted solution]

Hi,

    Please check the Note 151603 - Copying an SQL Server database as well as Note 683447 - SAP Tools for MS SQL Server and see whether it helps.

Thanks and Regards,

Vimal