on 06-26-2007 11:21 AM
Hello,
I have the problem that disp+work exe start but after one minute the precedure stopped. The Messages in syslog are "Message server disconnected DB-Connect Failed, Return Code 008192. Can anybody help me?
Best regards Mohamed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mohamed,
perhaps you may have more luck when posting your problem in the
SAP on SQL Server
forum. This forum is for MaxDB.
Best Regards
Alexander Schröder
Check your logfiles in the SAP run directory, especially
dev_ms (for the messageserver) and
dev_w0 (for one of your workprocesses)
If you can´t find out, what´s wrong copy the last lines to the message and send it here.
--
Markus
guys... any luck on this ???
as always if a system is not coming up, check the trace files (I don't know how often I have written that already)
which trace... wud appriciate ur help
Read the thread.. I asked for the trace files dev_w0 and dev_ms which are located in the work directory of the instance.
trc file: "dev_w0", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
B
B Tue Oct 09 19:07:25 2007
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\BI7\DVEBMGS70\exe\dbmssslib.dll' ...
B Library 'F:\usr\sap\BI7\DVEBMGS70\exe\dbmssslib.dll' loaded
B Version of 'F:\usr\sap\BI7\DVEBMGS70\exe\dbmssslib.dll' is "700.08", patchlevel (0.72)
B New connection 0 created
M sysno 70
M sid BI7
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 80
M intno 20050900
M make: multithreaded, ASCII, optimized
M pid 7580
M
M kernel runs with dp version 217(ext=109) (@(#) DPLIB-INT-VERSION-217)
M length of sys_adm_ext is 360 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 7580) [dpxxdisp.c 1301]
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) 11440 (880)
M DpShMCreate: sizeof(tm_adm) 3397704 (16904)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528040/528048
M DpShMCreate: sizeof(comm_adm) 528048 (1048)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1196)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 06350040, size: 4024776)
M DpShMCreate: allocated sys_adm at 06350040
M DpShMCreate: allocated wp_adm at 063519F0
M DpShMCreate: allocated tm_adm_list at 063546A0
M DpShMCreate: allocated tm_adm at 063546D0
M DpShMCreate: allocated wp_ca_adm at 06691F18
M DpShMCreate: allocated appc_ca_adm at 06696568
M DpShMCreate: allocated comm_adm at 06697CD8
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 06718B88
M DpShMCreate: allocated gw_adm at 06718BC8
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 06718BF8
M DpShMCreate: allocated wall_adm at 06718C00
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation flat
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M ThInit: running on host ATTNWSRV
M Tue Oct 09 19:07:26 2007
M calling db_connect ...
C Process 7580
C GetProfileParameter( wait_and_see ) returned [<null>]
C GetProfileParameter( deadlock_priority ) returned [<null>]
C GetProfileParameter( packet_size ) returned [8192]
C GetProfileParameter( rpc_batch ) returned [<null>]
C batched RPC will be used
C GetProfileParameter( dbsl_profile ) returned [1]
C dbsl profile written to dbsl_w0
C GetProfileParameter( pn_cache_size ) returned [20000]
C GetProfileParameter( par_stmt_cache_size ) returned [500]
C GetProfileParameter( dbcon_pn_size ) returned [<null>]
C GetProfileParameter( dbcon_par_stmt_cache_size ) returned [<null>]
C GetProfileParameter( stats_on ) returned [1]
C GetProfileParameter( network ) returned [<null>]
C GetProfileParameter( sp_prefix ) returned [<null>]
C GetProfileParameter( rdisp/TRACE ) returned [1]
C GetProfileParameter( set_rowcount ) returned [<null>]
C GetProfileParameter( set_fast1 ) returned [<null>]
C GetProfileParameter( use_integrated_security ) returned [<null>]
C GetProfileParameter( conn_str ) returned [<null>]
C GetProfileParameter( ignore_moduledrop ) returned [<null>]
C GetProfileParameter( use_cursor ) returned [<null>]
C GetProfileParameter( cursor_type ) returned [<null>]
C GetProfileParameter( fupd_cursor_type ) returned [<null>]
C GetProfileParameter( set_topn ) returned [<null>]
C GetProfileParameter( short_col_headers ) returned [<null>]
C GetProfileParameter( update_with_updlock ) returned [<null>]
C GetProfileParameter( maxincnt ) returned [<null>]
C GetProfileParameter( transmit_defaults ) returned [<null>]
C GetProfileParameter( square_brackets ) returned [<null>]
C GetProfileParameter( with_recompile ) returned [<null>]
C GetProfileParameter( max_duration ) returned [<null>]
C GetProfileParameter( irow_supported ) returned [<null>]
C GetProfileParameter( ins_block_increment ) returned [<null>]
C GetProfileParameter( max_ins_block_columns ) returned [<null>]
C GetProfileParameter( unc_rd_begin_tran ) returned [<null>]
C GetProfileParameter( use_rpc_call_string ) returned [<null>]
C GetProfileParameter( perm_stmt_reuse_cnt ) returned [<null>]
C GetProfileParameter( batch_stmt_reuse_cnt ) returned [<null>]
C GetProfileParameter( temp_stmt_reuse_cnt ) returned [<null>]
C GetProfileParameter( prepare ) returned [<null>]
C GetProfileParameter( par_stmt_prepare ) returned [<null>]
C GetProfileParameter( profile_with_timestamp ) returned [<null>]
C GetProfileParameter( no_utab_workaround ) returned [<null>]
C GetProfileParameter( use_block_fetch ) returned [<null>]
C GetProfileParameter( connect_retries ) returned [<null>]
C GetProfileParameter( connect_timeout ) returned [<null>]
C GetProfileParameter( use_system_locale ) returned [<null>]
C GetProfileParameter( ignore_stmtids ) returned [<null>]
C GetProfileParameter( recompile_par_stmts ) returned [0]
C GetProfileParameter( subst_params ) returned [<null>]
C GetProfileParameter( provider ) returned [<null>]
C GetProfileParameter( lob_rc ) returned [<null>]
C GetProfileParameter( buffer_cvarlobs ) returned [<null>]
C GetProfileParameter( allow_multipleconnections ) returned [<null>]
C GetProfileParameter( fupdorder ) returned [<null>]
C GetProfileParameter( no_vbdata_workaround ) returned [<null>]
C GetProfileParameter( use_mars ) returned [<null>]
C GetProfileParameter( as_c ) returned [<null>]
C GetProfileParameter( save_stmt_string ) returned [<null>]
C GetProfileParameter( server ) returned [ATTNWSRV]
C GetProfileParameter( user ) returned [<null>]
C GetProfileParameter( passwd ) returned [<null>]
C GetProfileParameter( dbname ) returned [BI7]
C GetProfileParameter( schema ) returned [dbo]
C Warning: Env(MSSQL_SCHEMA) [bi7] <> Prof(dbs/mss/schema) [dbo]. Profile value will be used.
C GetProfileParameter( auth/shadow_upgrade ) returned [<null>]
C GetProfileParameter( add_procs ) returned [<null>]
C Thread ID:7584
C Thank You for using the SLOLEDB-interface
C Using dynamic link library 'F:\usr\sap\BI7\DVEBMGS70\exe\dbmssslib.dll'
C dbmssslib.dll patch info
C patchlevel 0
C patchno 72
C patchcomment MSSQL: Thread check in DbSlDisconnect (969143)
C COMPUTERNAME: ATTNWSRV
C np:(local) connection used on ATTNWSRV
C CopyLocalParameters: dbuser is 'dbo'
C Formatted connect string : [Driver=SQL Server;Server=np:(local);Trusted_Connection=yes;WSID=ATTNWSRV;APP=R3D00(0)comm rd [MDAC] OLEDB]
C
C Tue Oct 09 19:07:27 2007
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 Packet size is set to: 8192
C OpenOledbConnection: line 23391. hr: 0x8000ffff Login failed for user 'ATTNWSRV\SAPServiceBI7'.
C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 18456, sev 0), Login failed for user 'ATTNWSRV\SAPServiceBI7'.
C Procname: [OpenOledbConnection - no proc]
C sloledb.cpp [OpenOledbConnection,line 23391]: Error/Message: (err 0, sev 0), Invalid connection string attribute
C failed to establish conn to np:(local).
C Retrying without protocol specifier: (local)
C Formatted connect string : [Driver=SQL Server;Server=(local);Trusted_Connection=yes;WSID=ATTNWSRV;APP=R3D00(0)comm rd [MDAC] OLEDB]
C Tue Oct 09 19:07:28 2007
C failed to establish conn. 0
B ***LOG BY2=> sql error 0 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> <message text not available> [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error 0 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> <message text not available> [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1411]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10169]
M Info for wp 0
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 semaphore = 0
M act_cs_count = 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 vm = no VM
M *****************************************************************************
M *
M * LOCATION SAP-Server ATTNWSRV_BI7_70 on host ATTNWSRV (wp 0)
M * ERROR ThInit: db_connect
M * TIME Tue Oct 09 19:07:28 2007
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10367
M * COUNTER 1
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 720]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]
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 7580) [dpnttool.c 327]
> C Tue Oct 09 19:07:27 2007
> 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 Packet size is set to: 8192
> C OpenOledbConnection: line 23391. hr: 0x8000ffff
> Login failed for user 'ATTNWSRV\SAPServiceBI7'.
> C sloledb.cpp [OpenOledbConnection,line 23391]:
> Error/Message: (err 18456, sev 0), Login failed for
> user 'ATTNWSRV\SAPServiceBI7'.
The entered user doesn't seem to be valid and you seem to use not the recommended client library. Check the mentioned note for more information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.