on 11-26-2015 7:02 AM
Hi,
Yesterday evening without making any change to our SAP ERP system, disp+work process stopped working.
We restarted server, we started sap and system turned green. After few seconds (without trying to connect to the system) system turned yellow and we show that disk+work process was on stop status.
In dev_w0 file we found the following errors:
...
***LOG BY2=> sql error 0 performing CON [dbsh#2 @ 1208] [dbsh 1208 ]
B ***LOG BY0=> <message text not available> [dbsh#2 @ 1208] [dbsh 1208 ]
B ***LOG BY2=> sql error 0 performing CON [dblink#4 @ 433] [dblink 0433 ]
B ***LOG BY0=> <message text not available> [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 10652]
Info for wp 0
M
M pid = 4380
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 * LOCATION SAP-Server sap1_PRD_00 on host sap1 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed Nov 25 17:29:02 2015
M * RELEASE 701
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10917
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 4380) [dpnttool.c 334]
We haven't made any chance to the system. SQL management tool connects successfully to SQL server.
Can anyone help us to locate the cause of this.
thanks.
we found solution.
Tivoli backup agent update installed slq native client 10.0.
We set environment variable MSSQL_FORCEOLEDB=1 (sap note 1082356) and problem solved.
thanks everyone.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Stilianos
Can you please provide output of R3trans -d command from <sid>adm user? It seems that there is issue in connectivity to DB, which can occur due to password of SAPService<SID> user of SQL database has expired or account might be locked.
Regards
Raj Mohan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Can you please refer following sap link.
I hope this helps you in resolving the issue.
Regards
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.