Question Re: work process trace in Technology Q&A

work process trace

former_member684999 — Mon, 02 Nov 2020 09:30:27 GMT

How to check work process trace ?

Re: work process trace

pfefferf — Mon, 02 Nov 2020 10:08:18 GMT

Please add more details.

Re: work process trace

jmodaal — Mon, 02 Nov 2020 10:16:04 GMT

Hello,

the trace files of a work process can be viewn in transaction SM50 (be sure you are logged on the correct application server if there is more than one -> SM51) by selecting the work process and then selecting "Administration" > "Trace" > "Display File" > "Current" resp. "Previous".

Re: work process trace

former_member684999 — Mon, 02 Nov 2020 10:29:42 GMT

Hi florian.pfeffer ,

I had raised an incident to SAP where in the issue was that an 'express document failed' error was popping up in transaction MM01 and MM02 (because of the FM MATERIAL_UPDATE_DB, as checked in SM13). The materials were created but were not saving.

So, SAP replied that they checked work process trace and found that the error was with the connection to LCADB (in Tcode DBCO ). So they suggested to verify the password and maintain the password again.

We maintained the password for LCADB and the issue was resolved. Below was their reply (in bold) :

B Connect to LCA as LCADB with vddsdb.damen.com:31515
C Try to connect as LCADB/<pwd>@vddsdb.damen.com:31515 on connection 1 ...
C connect property [APPLICATION = ABAP:EDS]
C connect property [APPLICATIONVERSION = 777 PL 115]
...

C connect property [SPATIALTYPES = 1]
C connect to LCADB/<pwd>@vddsdb.damen.com:31515 on connection 1 ...
C *** ERROR => Connect to database failed, rc=1, rcSQL=10
[dbhdbsql.cpp 616]
C {root-id=0265CE6BC94C1EEB86CEBECABFD639AB}_{conn-id=00000000000000000000000000000000}_0
C SQLCODE : 10
C SQLERRTEXT : authentication failed
B ***LOG BY2=> sql error 10 performing CON [dbds 1138]
B ***LOG BY0=> authentication failed [dbds 1138]
M *** WARNING => ThVBDext: error while processing MATERIAL_UPDATE_DB [thxxvb.c 3204]

This error indicated the credential of database connection LCA is maintained

The connection information as below :

DB Connection LCA
DBMS HDB
User Name LCADB
DB password
Conn. info vddsdb.damen.com:31515

So could you please verify the password of user LCADB is maintained correctly in the T-code DBCO?

You may need to reset the password and refresh the connection again.

So, basically how did they check this work process trace?

Re: work process trace

sankar_27 — Mon, 02 Nov 2020 14:11:51 GMT

Hi Apurva ,

Enable below steps and replicate error scenario and check current trace and do not forget reset trace once your job is done.

Execute SAP transaction SM51 , select the required server(s)
Now press F5 to select all WP and go to Process > Trace > Active Components.
Change the trace level to 2 and deselect all the components except Security
Save the changes and your trace level is increased now.

Thanks , Sankar