topic Re: Batch session in Application Development and Automation Discussions

Batch session

Former Member — Thu, 13 Jan 2011 07:32:25 GMT

Dear Gurus,

In my SAP System a batch session (SM35) is in locked state and i need to find out the user who locked the Batch session.

Can you please provide me the procedure by which i can find required information

Kuldeep Tanwar

Re: Batch session

Former Member — Thu, 13 Jan 2011 08:14:30 GMT

Hi,

In SM35 select the session which is locked and click on Log (F7).

You'll get the status and the user who locked. Click on Display(F2) you'll get a detailed message.

Regards,

Srini.

Re: Batch session

Former Member — Thu, 13 Jan 2011 08:21:54 GMT


> Hi,
> 
>      In SM35 select  the session which is locked and click on Log (F7).
>      You'll get the status and the user who locked. Click on Display(F2) you'll get a detailed message.
> 
> Regards,
> Srini.

I assume it shows the name of the user who created the session. I locked the session created by one of my collegue and checked on Log(f7) .

I found out his name in the log list and not mine. Infact i was the one who locked the session. So there has to be my name in log list.

Am i missing out anything ?

Re: Batch session

RaymondGiuseppi — Thu, 13 Jan 2011 08:32:59 GMT

Call transaction SM12, restrict on table APQI (lock object is BDC_QID)

Regards,

Raymond

Re: Batch session

Former Member — Thu, 13 Jan 2011 08:45:27 GMT

Hi all,

In table APQI also i am not able to see the user who locked the batch session

Re: Batch session

Former Member — Thu, 13 Jan 2011 10:31:05 GMT

Hi,

Iam not sure if you are missing anything ...

but I can see the below message ... The below session was created by user YYYY and XXXX user locked the session.

"Session MATERIALVIEW is being processed by user XXXXXX in mode A on server <Server>"

Regards,

Srini.

Re: Batch session

Former Member — Thu, 13 Jan 2011 12:14:07 GMT

Dear Srini,

I am getting following Fields for table APQ1.Please let me know for which field i need to enter Lock object ?

DESTSYS Target system

DESTAPP Target application

DATATYP Data type

GROUPID Group name

PROGID Program

FORMID Modules

QATTRIB Attribute

QID Queue name

QSTATE Status

QERASE Deletion indicator

USERID User ID

PASSWD Password

CREATOR User ID

CREDATE Created on

CRETIME Time created

STARTPGID Driver program

STARTMODE Start mode

STARTDATE Start date

STARTTIME Start time

PUTACTIVE PUTQ active flag

PUTPID PUTQ process ID

PUTTRANS PUTQ trans.count

PUTBLOCK Queue sum log.blocks

PUTDATE PUTQ last PUTQ/error

PUTTIME PUTQ last time/error

GETACTIVE Driver status GET

GETPID GETQ process ID

GETTRANS GETQ trans.count

GETBLOCK Queue sum log.blocks

GETDATE GETQ last GETQ/error

GETTIME GETQ last time/error

TRANSCNT Transaction counter

MSGCNT Message counter

TRANSCNTE Transaction counter

MSGCNTE Message counter

TRANSCNTD Transaction counter

MSGCNTD Message counter

TRANSCNTF Transaction counter

MSGCNTF Message counter

Regards

Kuldeep Tanwar

Re: Batch session

RaymondGiuseppi — Thu, 13 Jan 2011 12:15:11 GMT

OK, I made a confusion between locked (folder status) and locked (EN/DEQUEUE_BDC_QIDi during execution)

I fear that this data is not maintained in SAP system, fiel is not present in APQI, and APQI is not subject to log data change (SE11 technical settings) and not managed in a change object (SCDO) - also a BDC can be created in locked state (parameter HOLDDATE of BDC_OPEN_GROUP)

Regards,

Raymond

Re: Batch session

Former Member — Thu, 13 Jan 2011 12:37:23 GMT

> Hi,

> Iam not sure if you are missing anything ...

> but I can see the below message ... The below session was created by user YYYY and XXXX user locked the session.

> "Session MATERIALVIEW is being processed by user XXXXXX in mode A on server <Server>"

> Regards,

> Srini.

Hi Srini,

Could you please tell me the process you are following in SM35.

I had an existing session created by user 'X' on 01/10/2011. I locked that session via Session--->Lock. Thereafter i checked in log.

Inside log overview i don't find the lock : log message done by me.

Edited by: K.Manas on Jan 13, 2011 1:37 PM