Skip to Content
avatar image
Former Member

disp+work stopped in sql database windowsNT 5.2 Service pack1 server

Hello Gurus,

in my windows XI Server im facing a problem ,the disp+work is not starting (stopped),remaining all services are started .while i tried to execute r3trans -d its giving the following error:

4 ETW000 r3trans version 6.13 (release 640 - 27.03.07 - 11:20:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 27.08.2010 - 11:27:43

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] Fri Aug 27 11:27:46 2010 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

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

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000 0.000000

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

.and i checked the dev_disp,dev_msg,dev_w0 logs also

dev_w0 logs as follows

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Fri Aug 27 13:19:02 2010

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\DXI\SYS\exe\run\dbmssslib.dll' ...

B Library 'C:\usr\sap\DXI\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'C:\usr\sap\DXI\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.182)

B New connection 0 created

M sysno 00

M sid DXI

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 182

M intno 20020600

M make: multithreaded, Unicode

M pid 5916

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 33000 (1320)

M DpShMCreate: sizeof(tm_adm) 2969176 (14772)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpShMCreate: sizeof(comm_adm) 290000 (580)

M DpShMCreate: sizeof(vmc_adm) 0 (424)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 077B0040, size: 3404152)

M DpShMCreate: allocated sys_adm at 077B0040

M DpShMCreate: allocated wp_adm at 077B1B88

M DpShMCreate: allocated tm_adm_list at 077B9C70

M DpShMCreate: allocated tm_adm at 077B9C98

M DpShMCreate: allocated wp_ca_adm at 07A8EAF0

M DpShMCreate: allocated appc_ca_adm at 07A948B0

M DpShMCreate: allocated comm_adm_list at 07A967F0

M DpShMCreate: allocated comm_adm at 07A96808

M DpShMCreate: allocated vmc_adm_list at 07ADD4D8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 07ADD500

M DpShMCreate: allocated wall_adm at 07ADD508

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Fri Aug 27 13:19:03 2010

M calling db_connect ...

C Thread ID:3088

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 182

C patchcomment MSSQL: MSSTATS dual clock (1048180)

C np:(local) connection used on SAPXIDEV

C CopyLocalParameters: dbuser is 'dxi'

C

C Fri Aug 27 13:19:04 2010

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: MARS property was not set.

C

C Fri Aug 27 13:19:05 2010

C Provider Release:08.10.1830

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C Cache sizes: header 68 bytes, 20000 names (31680000 bytes), 1000 dynamic statements (5696000 bytes), total 37376068 bytes

C Using shared procedure name cache SAPXIDEV_DXIDXI_DXI_MEM initialized by another process.

C Connected to db server : [SAPXIDEV] server_used : [np:(local)], dbname: DXI, dbuser: dxi

C pn_id:SAPXIDEV_DXIDXI_DXI

C Not using MARS (on sql 8.0)

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20100827 131903 SAPXIDEV

C The IRow interface is supported by this OLEDB provider

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif

I

I Fri Aug 27 13:19:09 2010

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0BDD0040, size: 4400000)

M SHM_ROLL_AREA (addr: 86D00040, size: 268435456)

M SHM_PAGING_AREA (addr: 104F0040, size: 134217728)

M SHM_ROLL_ADM (addr: 0C210040, size: 2678942)

M SHM_PAGING_ADM (addr: 0C4A0040, size: 525344)

M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0C530040

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12160 bytes (50 server) at 0C5C0040

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

X ES initialized.

B db_con_shm_ini: WP_ID = 0, WP_CNT = 25, CON_ID = -1

B dbtbxbuf: Buffer TABL (addr: 185000C8, size: 30000000, end: 1A19C448)

B dbtbxbuf: Buffer TABLP (addr: 1A1A00C8, size: 10240000, end: 1AB640C8)

B dbexpbuf: Buffer EIBUF (addr: 0FBE00D0, size: 4194304, end: 0FFE00D0)

B dbexpbuf: Buffer ESM (addr: 1AB700D0, size: 4194304, end: 1AF700D0)

B dbexpbuf: Buffer CUA (addr: 1AF800D0, size: 3072000, end: 1B26E0D0)

B dbexpbuf: Buffer OTR (addr: 1B2700D0, size: 4194304, end: 1B6700D0)

M rdisp/reinitialize_code_page 🤯 -> 0

M icm/accept_remote_trace_level 🤯 -> 0

M rdisp/no_hooks_for_sqlbreak 🤯 -> 0

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

N SncInit(): Initializing Secure Network Communication (SNC)

N PC with Windows NT (mt,ascii,SAP_UC/size_t/void* = 16/32/32)

N SncInit(): found snc/data_protection/max=3, using 3 (Privacy Level)

N SncInit(): found snc/data_protection/min=1, using 1 (Authentication Level)

N SncInit(): found snc/data_protection/use=9, using 3 (Privacy Level)

N SncInit(): found snc/gssapi_lib=c:\usr\sap\dxi\sys\exe\run\sapcrypto.dll

N File "c:\usr\sap\dxi\sys\exe\run\sapcrypto.dll" dynamically loaded as GSS-API v2 library.

N The internal Adapter for the loaded GSS-API mechanism identifies as:

N Internal SNC-Adapter (Rev 1.0) to SECUDE 5/GSS-API v2

N *** ERROR => SncInit(): Missing profile paramter "snc/identity/as"

N [sncxxpar0614]<<- ERROR: SncInit()==SNCERR_INIT

N sec_avail = "false"

M ***LOG R19=> ThSncInit, SncInitU ( SNC-000001) [thxxsnc.c 223]

M *** ERROR => ThSncInit: SncInitU (SNCERR_INIT) [thxxsnc.c 225]

M in_ThErrHandle: 1

M *** ERROR => SncInitU (step 1, th_errno 44, action 3, level 1) [thxxhead.c 9613]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 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 PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M TrThHookFunc: called for WP 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 254]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 5916) [dpnttool.c 357]

please help me to solve this issue guyss,please help me ...........

Thanks&Regards,

Peervali

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 30, 2010 at 02:23 AM

    => Invalid profile parameter dbms/type (or environment variable dbms_type) = , cannot load DB library

    You are getting the above error while R3trans -d because the required environment variables are not set properly. Are you using user <sid>adm to execute the command?

    • ERROR => SncInit(): Missing profile paramter "snc/identity/as" N [sncxxpar0614]

    you have enabled SNC but not all profile parameters are properly set. This will prevent system to start.

    you have to set this properly.

    Provider SQLNCLI could not be initialized

    SQLNCLI need to be installed for MSSSQL 2005. But this is just a warning

    Add comment
    10|10000 characters needed characters exceeded