cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work.exe stops after 1.13m

Former Member
0 Kudos

Hi i did the refresh of the database...well i did it on the dirty way where I copied ans renames the data ans log file. i had all SAP services down as wel as SQL ones...For some reason R/3 wond come back up with disp+work.exe goes back down after turning green?

Below is the log. Pay attention on bolded bit, it seems that something is wrong with user.

Windows server 2003 64bit

SLQ2005 SP1

ECC6

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Sun Feb 10 13:59:41 2008

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\QA9\SYS\exe\run\dbmssslib.dll' ...

B Library 'E:\usr\sap\QA9\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'E:\usr\sap\QA9\SYS\exe\run\dbmssslib.dll' is "700.08", patchlevel (0.131)

B New connection 0 created

M sysno 00

M sid QA9

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 133

M intno 20050900

M make: multithreaded, ASCII, 64 bit, optimized

M pid 1276

M

M kernel runs with dp version 232(ext=109) (@(#) DPLIB-INT-VERSION-232)

M length of sys_adm_ext is 364 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc30 1276) [dpxxdisp.c 1301]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

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

M

M Sun Feb 10 13:59:42 2008

M DpShMCreate: sizeof(wp_adm) 29520 (952)

M DpShMCreate: sizeof(tm_adm) 50008992 (24992)

M DpShMCreate: sizeof(wp_ca_adm) 120000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 120000 (60)

M DpCommTableSize: max/headSize/ftSize/tableSize=2000/16/2208048/2208064

M DpShMCreate: sizeof(comm_adm) 2208064 (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 (1616)

M DpShMCreate: sizeof(wall_adm) (256048/346336/64/104)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000DA40050, size: 53096384)

M DpShMCreate: allocated sys_adm at 000000000DA40050

M DpShMCreate: allocated wp_adm at 000000000DA41BF0

M DpShMCreate: allocated tm_adm_list at 000000000DA48F40

M DpShMCreate: allocated tm_adm at 000000000DA48FA0

M DpShMCreate: allocated wp_ca_adm at 00000000109FA340

M DpShMCreate: allocated appc_ca_adm at 0000000010A17800

M DpShMCreate: allocated comm_adm at 0000000010A34CC0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 0000000010C4FE00

M DpShMCreate: allocated gw_adm at 0000000010C4FE80

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0000000010C4FEB0

M DpShMCreate: allocated wall_adm at 0000000010C4FEC0

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 30 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host ACSPT009

M

M Sun Feb 10 13:59:43 2008

M calling db_connect ...

C Parameter format rsdb/mssql/deadlock_priority is deprecated in release 6.20. Please use format dbs/mss/<parameter>. See note 28667.

C Parameter format rsdb/mssql/packet_size is deprecated in release 6.20. Please use format dbs/mss/<parameter>. See note 28667.

C Parameter format rsdb/mssql/pn_cache_size is deprecated in release 6.20. Please use format dbs/mss/<parameter>. See note 28667.

C Parameter format rsdb/mssql/stats_on is deprecated in release 6.20. Please use format dbs/mss/<parameter>. See note 28667.

C Parameter format rsdb/mssql/maxincnt is deprecated in release 6.20. Please use format dbs/mss/<parameter>. See note 28667.

C Parameter format rsdb/mssql/dbname is deprecated in release 6.20. Please use format dbs/mss/<parameter>. See note 28667.

C Parameter format rsdb/mssql/add_procs is deprecated in release 6.20. Please use format dbs/mss/<parameter>. See note 28667.

C Thread ID:4612

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'E:\usr\sap\QA9\SYS\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 131

C patchcomment MSSQL: BCP failed: Invalid character value (1097943)

C np:(local) connection used on ACSPT009

C CopyLocalParameters: dbuser is 'qa9'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Provider Release:9.00.2047.00

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C ERROR: schema user qa9 has administrator fixed server role (user_name() is 'dbo').

C This is not allowed. Please check the Server Roles of user qa9.

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

M in_ThErrHandle: 1

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

M

M Info for wp 30

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_VB2WP

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 req.vm = no VM

M attachedVm = no VM

M

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

M *

M * LOCATION SAP-Server ACSPT009_QA9_00 on host ACSPT009 (wp 30)

M * ERROR ThInit: db_connect

M *

M * TIME Sun Feb 10 13:59:43 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10585

M * COUNTER 1

M *

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 724]

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

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 (Workproc30 1276) [dpnttool.c 327]

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

look at sap note Note 551915 - R/3 won't start after database restore or database copy

read it carefully

QA9 is your sap sid,

in your case system running with database user 'dbo'. which is wrong

All the tables in such systems belong to user 'sid' (the system ID in

lower case, in your case it is qa9).

change the owner of database, download the file user_restore.zip which is attached to note 551915 unzip it and run the query according to note,

further more also look at sap Note 151603 - Copying an SQL Server database which is helpful to copy sap database on sql server ( homogeneous system copy)

regards,

kaushal

Answers (0)