the connected user (SAPECC) does not work with the...

Former Member · ‎02-18-2015

Dear SAP Gurus,

I have installed SAP ECC IDES System on Windows Server 2008R2 with MaxDB about 6 months ago.

Yesterday I wanted to use it again, but the process disp+work.exe is stopped after it is started for some seconds.

I really appreciate any helps.

Thanks.

following is the content of dev_w0

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

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

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

*

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, MJ

*

B

B Wed Feb 18 16:09:59 2015

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\ECC\DVEBMGS00\exe\dbsdbslib.dll' ...

B Library 'E:\usr\sap\ECC\DVEBMGS00\exe\dbsdbslib.dll' loaded

B Version of 'E:\usr\sap\ECC\DVEBMGS00\exe\dbsdbslib.dll' is "700.08", patchlevel (0.24)

B New connection 0 created

M sysno 00

M sid ECC

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 32

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 2696

M

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

M length of sys_adm_ext is 576 bytes

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

I

I Wed Feb 18 16:10:00 2015

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: 000000000D9C0050, size: 6614144)

M DpShMCreate: allocated sys_adm at 000000000D9C0050

M DpShMCreate: allocated wp_adm at 000000000D9C2270

M DpShMCreate: allocated tm_adm_list at 000000000D9C96D0

M DpShMCreate: allocated tm_adm at 000000000D9C9730

M DpShMCreate: allocated wp_ca_adm at 000000000DF6CFB0

M DpShMCreate: allocated appc_ca_adm at 000000000DF72DB0

M DpShMCreate: allocated comm_adm at 000000000DF74CF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000DFFB980

M DpShMCreate: allocated gw_adm at 000000000DFFBA00

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000DFFBA30

M DpShMCreate: allocated wall_adm at 000000000DFFBA40

M rdisp/queue_size_check_value : -> off

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.

M

M Wed Feb 18 16:10:01 2015

M ThInit: running on host ibsserver75

M calling db_connect ...

C

C DBSDBSLIB : version 700.08, patch 0.024 (Make PL 0.32)

C MAXDB shared library (dbsdbslib) patchlevels (last 10)

C (0.024) Default value for max. input variables is 2000 (note 655018)

C (0.024) Profile parameter to define max. input variables (note 655018)

C (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841)

C (0.024) Input parameters for SQL statements increased (note 655018)

C (0.018) Create index serial for MaxDB 7.6 (note 1267841)

C (0.018) More trace in case of packed to string conversion error (note 1262799)

C (0.016) R3trans export aborts with signal 6 (note 1262245)

C (0.009) IA64 alignment errors (note 1245982)

C (0.007) Support DB-Type 'SAP DB' by UPDSTAT (note 1225668)

C

C Loading SQLDBC client runtime ...

C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 015-123-202-938

C SQLDBC client runtime is MaxDB 7.6.5.015 CL 202938

C SQLDBC supports new DECIMAL interface : 0

C SQLDBC supports VARIABLE INPUT data : 1

C SQLDBC supports keepAlive indicator : 0

C INFO : SQLOPT= -I 0 -t 0 -S SAPR3

C Try to connect (DEFAULT) on connection 0 ...

C Attach to SAP DB : Kernel 7.7.06 Build 010-123-204-327

C Database release is SAP DB 7.7.06.010

C INFO : Database 'ECC' instance is running on 'ibsserver75'

C DB max. input host variables : 2000

C INFO : SAP DB Packet_Size = 131072

C INFO : SAP DB Min_Reply_Size = 4096

C INFO : SAP DB Comm_Size = 126976

C INFO : DBSL buffer size = 126976

C INFO : SAP DB MaxLocks = 300000

C INFO : Connect to DB as 'SAPECC'

C *** ERROR => the connected user (SAPECC) does not work with the right user/schema

[dbslsdb.cpp 4818]

C *** ERROR => application has to work with schema SAPR3 (dbs/ada/schema)

[dbslsdb.cpp 4820]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M pid = 2696

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 ibsserver75_ECC_00 on host ibsserver75 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Wed Feb 18 16:10:01 2015

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10783

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

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 (Workproc 0 2696) [dpnttool.c 334]

Following is the content of the profile

E:\usr\sap\ECC\SYS\profile\ECC_DVEBMGS00_ibsserver75

SAPSYSTEMNAME = ECC

SAPGLOBALHOST = ibsserver75

SAPSYSTEM = 00

INSTANCE_NAME = DVEBMGS00

DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTAMD64

DIR_EXECUTABLE = $(DIR_INSTANCE)\exe

rdisp/wp_no_dia = 10

rdisp/wp_no_btc = 3

icm/server_port_0 = PROT=HTTP,PORT=80$$

#-----------------------------------------------------------------------

# SAP Message Server parameters are set in the DEFAULT.PFL

#-----------------------------------------------------------------------

ms/server_port_0 = PROT=HTTP,PORT=81$$

rdisp/wp_no_enq = 1

rdisp/wp_no_vb = 1

rdisp/wp_no_vb2 = 1

rdisp/wp_no_spo = 1

rsdb/dbid = ECC

dbs/ada/schema = SAPECC

Following is the content of the profile

E:\usr\sap\ECC\SYS\profile\Default.pfl

SAPDBHOST = ibsserver75

j2ee/dbtype = sap

j2ee/dbname = ECC

j2ee/dbhost = ibsserver75

j2ee/dbadminurl = http://ibsserver75:9999/webdbm?Server=ibsserver75&Database=ECC&User=control

SAPSYSTEMNAME = ECC

SAPGLOBALHOST = ibsserver75

rdisp/bufrefmode = sendoff,exeauto

#-----------------------------------------------------------------------

# SAP Message Server for ABAP

#-----------------------------------------------------------------------

rdisp/mshost = ibsserver75

rdisp/msserv = sapmsECC

rdisp/msserv_internal = 3900

#-----------------------------------------------------------------------

# SAP Message Server for ABAP

#-----------------------------------------------------------------------

login/system_client = 001

Following is the content of the profile

E:\usr\sap\ECC\SYS\profile\START_DVEBMGS00_ibsserver75

SAPSYSTEMNAME = ECC

SAPGLOBALHOST = ibsserver75

SAPSYSTEM = 00

INSTANCE_NAME = DVEBMGS00

DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTAMD64

DIR_EXECUTABLE = $(DIR_INSTANCE)\exe

DIR_PROFILE = $(DIR_INSTALL)\profile

_PF = $(DIR_PROFILE)\ECC_DVEBMGS00_ibsserver75

#-----------------------------------------------------------------------

# Copy SAP Executables

#-----------------------------------------------------------------------

Start_Program_00 = immediate $(DIR_CT_RUN)\sapcpe$(FT_EXE) pf=$(_PF)

#-----------------------------------------------------------------------

# Start ABAP database

#-----------------------------------------------------------------------

_DB = $(DIR_CT_RUN)\strdbs.cmd

Start_Program_01 = immediate $(_DB) ECC

#-----------------------------------------------------------------------

# Start SAP message server

#-----------------------------------------------------------------------

_MS = $(DIR_EXECUTABLE)\msg_server$(FT_EXE)

Start_Program_02 = local $(_MS) pf=$(_PF)

#-----------------------------------------------------------------------

# Start application server

#-----------------------------------------------------------------------

_DW = $(DIR_EXECUTABLE)\disp+work$(FT_EXE)

Start_Program_03 = local $(_DW) pf=$(_PF)

#-----------------------------------------------------------------------

# Start internet graphics server

#-----------------------------------------------------------------------

_IG = $(DIR_EXECUTABLE)\igswd$(FT_EXE)

Start_Program_04 = local $(_IG) -mode=profile pf=$(_PF)

rsdb/dbid = ECC

dbs/ada/schema = SAPECC

I have tried to change the dbs/ada/schema in both profile files to SAPR3 but nothing changed in the log file.

Former Member · ‎03-06-2015

Hi,

The line from SAP Note 39439 should work

xuser -U DEFAULT -u SAPR3,<password> -d <database_name> -n <database_server> -S SAPR3 -t 0 -I 0 set

Please corret the entry and try R3trans -d.

Regards,

Nikhil

Former Member · ‎03-06-2015

Hi,

Sorry that I missed the DB is MaxDB

I guess the issue might be with the xuser entries.

Check them using command xuser list and correct the entries for user SAPR3 which normally comed under DEFAULT.

Refer the below notes for details:

39439 - XUSER entries for SAP MaxDB

1409913 - Windows: Access to XUser data is not possible

Regards,

Nikhil

Former Member · ‎03-06-2015

Hi,

Check id the db related environment paths are present for the user at os level.

Give env command to get the results

Regards,

Nikhil

manumohandas82 · ‎03-01-2015

Hi Donny ,

Please execute R3trans -d and paste the trans.log

Thanks ,

Manu

willi_eimler · ‎02-27-2015

Hi,

it seems you have problems with the connect to database.


C  *** ERROR => the connected user (SAPECC) does not work with the right user/schema
 [dbslsdb.cpp  4818]
C  *** ERROR => application has to work with schema SAPR3 (dbs/ada/schema)
 [dbslsdb.cpp  4820]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1449]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10563]
M

Please check if the environment variable of the user sidadm wich contains the schema of the db is the same as the schem in db.

Best regards

Willi Eimler

Former Member · ‎02-27-2015

Anybody help ?

the connected user (SAPECC) does not work with the right user/schema

Accepted Solutions (0)

Answers (6)

Answers (6)

S/4HANA Cloud Live connection SAP Analytcis Cloud

Re: How can we use a odata connection of dataspher...

Re: Scheduled Report shows successful status; but ...

Re: Blending Tables (Import Models)

Re: Object store secret mys-object-store-secret no...