Error executing Transaction SM19

[Former Member]

Hi All

I want to enable User Audit log. For that I am trying to enable it dynamically using transaction SM19. But when I am running this transaction system takes long time and then sessing terminates giving message Workprocess restarted.. It happens to only this transaction. One of the reason for this as per note 766771 is authorization. But I have SAP_ALL authorization.

what could be problem? Can any body help?

Thanks in advance.

[Former Member]

Hi

Please post the trace file of the work process in error.

Regards

Rahul

[Former Member]

Following is the file

Mon May 29 11:00:30 2006

M ***LOG TZ1=> System time zone found in TTZCU is not valid.

[sign.c 1229]

C

C Mon May 29 11:00:41 2006

C *** ERROR => OCI-call 'OCILobWrite' failed: rc = 1691

[dboci.c 2649]

C *** ERROR => ORA-1691 occurred when writing to a LOB

[dbsloci.c 10713]

C sc_p=04C80E98,no=104,idc_p=04C8FCF0,con=0,act=1,slen=123,smax=256,#vars=5,stmt=1F605C88,table=DYNPLOAD

C prep=0,lit=0,nsql=0,lobret=1,#exec=1,dbcnt=1,upsh_p=04C80EE4,ocistmth_p=1F606A68

C IN : cols=4,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=45,vmax=32,bound=1,iobuf_p=096A7378,vda_p=1F606FB8

C lobs=1,lmax=4,lpcnt=0,larr=1F607408,lcurr_p=00000000,rret=0

C OUT: cols=1,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=32,bound=0,iobuf_p=00000000,vda_p=1F607548

C lobs=1,lmax=4,lpcnt=0,larr=1F6074A8,lcurr_p=00000000,rret=1

C UPDATE "DYNPLOAD" SET "DATA" = :A0 WHERE "PROGNAME" = :A1 AND "DYNPNUMBER" = :A2 AND "TYPE" = :A3 RE\

C TURNING "DATA" INTO :A4;

B ***LOG BY4=> sql error 1691 performing MOD on table DYNPLOAD [dbdynpdb#? @ 510] [dbdynpdb0510 ]

B ***LOG BY0=> ORA-01691: unable to extend lob segment SAPEC6.SYS_LOB0000100582C00004$$ by 1024 in tablespace PSAPEC6640

ORA-27059: skgfrsz: could not reduce file size

OSD-04005: SetFilePointer() failure, unable to read from file

O/S-Error: (OS 112) There is not enough space on the disk.

ORA-27059: skgfrsz: could not reduce file size

OSD-04005: SetFilePointer() failure, unable to read from file

O/S-Error: (OS 112) There is not enough space on the disk.

ORA-27059: skgfrsz: could not reduce file size

OSD-04005: SetFilePointer() failure, unable to read from file

O/S-Error: (OS 112) There is not enough space on the disk.

ORA-27059: skgfrsz: could not reduce file size

OSD-04005: SetFilePointer() failure, unable to read from file

O/S-Error: (OS 112) There is not enough space on the disk.

ORA-27059: skgfrsz: could not reduce file size

OSD-04005: SetFilePointer() failure, unable to read from file

O/S-Error: (O.. [dbdynpdb#? @ 510] [dbdynpdb0510 ]

B *** ERROR => Input values: Table = DYNPLOAD, prog = SAPMSM19 , dynpnr = 0300, langu =

[dbdynpdb2.c 510]

M call semaphore clean-up function ...

M ***LOG Q0E=> DpSigGenHandler, Exception (c0000005) [dpnttool.c 462]

M -

---

C-STACK -

---

SAP (R) - R/3(TM) Callstack, Version 1.0

Copyright (C) SAP AG. All rights reserved.

-

---

Application exception occurred:

Exception : c0000005 (Access Violation)

App : disp+work.EXE (pid=3556)

When : 5/29/2006 11:0:42.31

Threads : 2

-

---

Computer Name : PUNESAP3

User Name : SAPServiceEC6

-

---

Number of Processors: 2

Processor Type: x86 Family 15 Model 4 Stepping 1

Windows Version : 5.0 Current Build: 2195

-

---

Stack Dump for Thread Id 994

eax=01f9e499 ebx=00000000 ecx=00000000 edx=75202c65 esi=00000001 edi=7c36a42b

eip=73696420 esp=03ff5684 ebp=65687420 iopl=0 nv up ei pl nz na po nc

cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00010206

function : <nosymbols>

--> Stack Back Trace <--

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

03ff5680 4f0a2e6b 322d4152 39353037 6b73203a 73726667 <nosymbols>

65687420 00000000 00000000 00000000 00000000 00000000 <nosymbols>

-

---

Stack Dump for Thread Id a64

eax=04009470 ebx=00000103 ecx=04c27598 edx=00000000 esi=00000000 edi=00000000

eip=77f884ff esp=064afeb0 ebp=064afef0 iopl=0 nv up ei pl zr na po nc

cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246

function : ZwFsControlFile

77f884f4 b848000000 mov eax,0x48

77f884f9 8d542404 lea edx,[esp+0x4] ss:0a4a4053=000c2500

77f884fd cd2e int 2e

77f884ff c22800 ret 0x28

77f88502 8bff mov edi,edi

--> Stack Back Trace <--

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

064afef0 0101d972 00000a58 00000000 04c27468 04c27468 ntdll!ZwFsControlFile

064aff80 7c349565 00000000 04c27468 03fffa74 04c27598 disp+work!SigIMsgFunc [signt.c (563)]

064affb4 7c57b388 04c27598 04c27468 03fffa74 04c27598 MSVCR71!endthreadex

064affec 00000000 7c3494f6 04c27598 00000000 00000000 KERNEL32!lstrcmpiW

-

---

M -

---

M

M Mon May 29 11:00:42 2006

M call clean-up function ...

M in_ThErrHandle: 1

M ThSigHandler: signal (step 4, th_errno 11, action 4)

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = 1

M rq_info = 384

M tid = 17

M mode = 0

M len = 8

M rq_id = 3081

M rq_source = 1

M last_tid = 17

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 = 20

M tab_name = > <

M

M Modeinfo for User T17/M0

M

M tm state = 2

M uid = 19846

M term type = 0x4

M display = 0x8

M cpic_no = 0

M cpic_idx = -1

M usr = >PRABHU <

M terminal = >punesap3 <

M client = >999<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M imode = 2

M mode state = 0x42

M mode clean_state = 1

M task_type = ZTTADIA

M th_errno = 11

M rollout_reason = 4

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 4

M roll state = 2

M abap state = 2

M em state = 3

M eg state = 1

M spa state = 3

M enq state = 0

M softcancel = 0

M next hook = T-1/U-1/M255

M master hook = T-1/U-1/M255

M slave hook = T-1/U-1/M255

M debug_tid = 255

M debug_mode = 0

M mode type = 0x1

M debug = 0

M tcode = >SM19 <

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 0

M act enq infos = 0

M em_hyper_hdl = NULL

M plugin_info = NULL

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 0

M

M

M *****************************************************************************

M *

M * LOCATION SAP-Server punesap3_EC6_00 on host punesap3 (wp 0)

M * ERROR ThSigHandler: signal

M *

M * TIME Mon May 29 11:00:42 2006

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 11

M * MODULE thxxhead.c

M * LINE 9780

M * COUNTER 1

M *

M *****************************************************************************

M

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 ThrSaveSPAFields: save spa fields

M Entering ThSetStatError

M ThIErrHandle: don't try rollback again

M ThIErrHandle: call ThrCoreInfo

A TH VERBOSE LEVEL FULL

A ** RABAX: level LEV_RX_PXA_RELEASE_MTX entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_MTX completed.

A ** RABAX: level LEV_RX_VMIT_CLEANUP entered.

A ** RABAX: level LEV_RX_VMIT_CLEANUP completed.

A ** RABAX: level LEV_RX_ROLLBACK entered.

A ** RABAX: level LEV_RX_ROLLBACK completed.

A ** RABAX: level LEV_RX_DB_ALIVE entered.

A ** RABAX: level LEV_RX_DB_ALIVE completed.

A ** RABAX: level LEV_RX_HOOKS entered.

A ** RABAX: level LEV_RX_HOOKS completed.

A ** RABAX: level LEV_RX_STANDARD entered.

A ** RABAX: level LEV_RX_STANDARD completed.

A ** RABAX: level LEV_RX_C_STACK entered.

A ** RABAX: level LEV_RX_C_STACK completed.

A ** RABAX: level LEV_RX_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_MEMO_CHECK completed.

A ** RABAX: level LEV_RX_INTERFACES entered.

A ** RABAX: level LEV_RX_INTERFACES completed.

A ** RABAX: level LEV_RX_GET_MESS entered.

A ** RABAX: level LEV_RX_GET_MESS completed.

A ** RABAX: level LEV_RX_INIT_SNAP entered.

A ** RABAX: level LEV_RX_INIT_SNAP completed.

A ** RABAX: level LEV_RX_WRITE_SYSLOG entered.

A ** RABAX: level LEV_RX_WRITE_SYSLOG completed.

A ** RABAX: level LEV_RX_WRITE_SNAP entered.

M ThGetTransId2: got trans id (spa) >B62C8D3948CB41E9B89A8949E30E28A4< (32)

M SosSearchAnchor: search anchor for 17

A ** RABAX: level LEV_SN_END completed.

A ** RABAX: level LEV_RX_SET_ALERT entered.

A ** RABAX: level LEV_RX_SET_ALERT completed.

A ** RABAX: level LEV_RX_COMMIT entered.

A ** RABAX: level LEV_RX_COMMIT completed.

A ** RABAX: level LEV_RX_SNAP_SYSLOG entered.

A ** RABAX: level LEV_RX_SNAP_SYSLOG completed.

A ** RABAX: level LEV_RX_RESET_PROGS entered.

A ** RABAX: level LEV_RX_RESET_PROGS completed.

A ** RABAX: level LEV_RX_STDERR entered.

A ** RABAX: level LEV_RX_STDERR completed.

A ** RABAX: level LEV_RX_RFC_ERROR entered.

A ** RABAX: level LEV_RX_RFC_ERROR completed.

A ** RABAX: level LEV_RX_RFC_CLOSE entered.

A ** RABAX: level LEV_RX_RFC_CLOSE completed.

A ** RABAX: level LEV_RX_IMC_ERROR entered.

M SosSearchAnchor: search anchor for 4

A ** RABAX: level LEV_RX_IMC_ERROR completed.

A ** RABAX: level LEV_RX_DATASET_CLOSE entered.

A ** RABAX: level LEV_RX_DATASET_CLOSE completed.

[JPReyes]

Looks pretty evident to me...

"There is not enough space on the disk"

Regards

Juan

[Former Member]

Thanks Juan for your reply. I had already confirmed that it is a problem regarding disk space.

Thanks once again for your help.