Problem while applying service packs

Hi All,

We installes SAP ERP 6.0 SR3 ABAP+JAVA(Central instance).

We are trying to import SAP_BASIS service packs from SP13 to SP14, SP15....

we started import through spam in the down status it is showing 'CMDIMPORT finished with returncode 0'

We opened MMC and checked work processsers

ALL DIA showing

Program SAPMSSY1 client 001 User PILDUSER Time 7000

SP) showing

Program 'job activation' client 000 User SAPSYS Action Update Table TSPOPTIONS

How to resolve this issue ?

How to find the problem?

What are the logs i have to check?

SPAM got Struck?

Regards,

Phanikumar.

SAP Managed Tags:
NW AS Java Administrator (NWA)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

It sounds like a memory or the database issue.

First check if there is no issue with tablespace, archive and check the space for the drive, which has sap instance directory.

then check if you have any memory error in dev_disp

PILDUSER is the User for the System Landscape Directory in PI and you need to findout if its being used in the SLD.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

The avilable drive space is 82GB.

Tell me how to check the table and archive space.

developer trace for one of the work processor dev_w09

trc file: "dev_w9", trc level: 1, release: "700"

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ

M sysno 04

M sid ECC

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 236

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 3588

M Fri Apr 09 10:34:15 2010

M kernel runs with dp version 243000(ext=110000) (@(#) DPLIB-INT-VERSION-243000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 9 3588) [dpxxdisp.c 1349]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M Fri Apr 09 10:34:16 2010

M DpShMCreate: sizeof(wp_adm) 29792 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000FA00050, size: 6614144)

M DpShMCreate: allocated sys_adm at 000000000FA00050

M DpShMCreate: allocated wp_adm at 000000000FA02270

M DpShMCreate: allocated tm_adm_list at 000000000FA096D0

M DpShMCreate: allocated tm_adm at 000000000FA09730

M DpShMCreate: allocated wp_ca_adm at 000000000FFACFB0

M DpShMCreate: allocated appc_ca_adm at 000000000FFB2DB0

M DpShMCreate: allocated comm_adm at 000000000FFB4CF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000001003B980

M DpShMCreate: allocated gw_adm at 000000001003BA00

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000001003BA30

M DpShMCreate: allocated wall_adm at 000000001003BA40

M rdisp/queue_size_check_value : -> off

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 9 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M ThInit: running on host ecc6

M Fri Apr 09 10:34:17 2010

M calling db_connect ...

B create_con (con_name=R/3)

B Loading DB library 'F:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' ...

B Library 'F:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' loaded

B Fri Apr 09 10:34:18 2010

B Version of 'F:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' is "700.08", patchlevel (0.234)

B New connection 0 created

C Prepending F:\usr\sap\ECC\DVEBMGS04\exe to Path.

C Fri Apr 09 10:34:19 2010

C Oracle Client Version: '10.2.0.4.0'

C application info callback registered

C Fri Apr 09 10:34:20 2010

C Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 251109)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 UTF8 0000000012720080 0000000012727BD0 0000000012738328

C Attaching to DB Server ECC (con_hdl=0,svchp=00000000127381E8,srvhp=000000001273B238)

C Fri Apr 09 10:34:21 2010

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=00000000127381E8, srvhp=000000001273B238, usrhp=00000000127931C0)

C Fri Apr 09 10:34:22 2010

C CbApplInfoGet() failed (ignored 1).

C Now '/@ECC' is connected: con_hdl=0, nls_hdl=0, session_id=1054.

C Fri Apr 09 10:34:23 2010

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=00000000127381E8,usrhp=00000000127931C0)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR3/<pwd>@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 251109)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 UTF8 0000000012720080 0000000012727BD0 0000000012738328

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=00000000127381E8, srvhp=000000001273B238, usrhp=00000000127931C0)

C Now 'SAPSR3/<pwd>@ECC' is connected: con_hdl=0, nls_hdl=0, session_id=1077.

C Database NLS settings in V$NLS_PARAMETERS: AMERICAN_AMERICA.UTF8

C Fri Apr 09 10:34:24 2010

C DB instance ECC is running on ECC6 with ORACLE version 10.2.0.4.0 since APR 09, 2010, 10:30:44

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX HC PRM RCT FRC TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO NO YES NO NO 000 255 255 20100409 103418 ECC6

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif,*.png

I Fri Apr 09 10:35:49 2010

I MtxInit: 9 0 0

M SHM_PRES_BUF (addr: 0000000014010050, size: 4400000)

M SHM_ROLL_AREA (addr: 000007FFDDA80050, size: 268435456)

M SHM_PAGING_AREA (addr: 0000000014450050, size: 134217728)

M SHM_ROLL_ADM (addr: 000000001C460050, size: 2760892)

M SHM_PAGING_ADM (addr: 00000000091D0050, size: 525344)

M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0000000009700050

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12176 bytes (50 server) at 00000000003E0050

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 9 initializing ....

X Using implementation view

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M Deactivate statistics hyper index locking

B dbntab: NTAB buffers attached

B dbntab: Buffer FTAB(hash header) (addr: 000000001C7A00E0, size: 584)

B dbntab: Buffer FTAB(anchor array) (addr: 000000001C7A0330, size: 320072)

B dbntab: Buffer FTAB(item array) (addr: 000000001C7EE580, size: 1280000)

B dbntab: Buffer FTAB(data area) (addr: 000000001C926D80, size: 30720000)

B dbntab: Buffer IREC(hash header) (addr: 000000001E6800E0, size: 584)

B dbntab: Buffer IREC(anchor array) (addr: 000000001E680330, size: 320072)

B dbntab: Buffer IREC(item array) (addr: 000000001E6CE580, size: 320000)

B dbntab: Buffer IREC(data area) (addr: 000000001E71C780, size: 6144000)

B dbntab: Buffer STAB(hash header) (addr: 000000001ED000E0, size: 584)

B dbntab: Buffer STAB(anchor array) (addr: 000000001ED00330, size: 320072)

B dbntab: Buffer STAB(item array) (addr: 000000001ED4E580, size: 320000)

B dbntab: Buffer STAB(data area) (addr: 000000001ED9C780, size: 3072000)

B dbntab: Buffer TTAB(hash header) (addr: 000000001F0900E0, size: 2360)

B dbntab: Buffer TTAB(anchor array) (addr: 000000001F090A20, size: 320072)

B dbntab: Buffer TTAB(item array) (addr: 000000001F0DEC70, size: 800000)

B dbntab: Buffer TTAB(data area) (addr: 000000001F1A2170, size: 5840000)

B db_con_shm_ini: WP_ID = 9, WP_CNT = 17, CON_ID = -1

B dbstat: TABSTAT buffer attached (addr: 000000001F74D0B0)

B dbtbxbuf: Buffer TABL (addr: 0000000022250160, size: 30000000, end: 0000000023EEC4E0)

B dbtbxbuf: Buffer TABLP (addr: 0000000023EF0160, size: 10240000, end: 00000000248B4160)

B dbexpbuf: Buffer EIBUF (addr: 00000000248C0170, size: 4194304, end: 0000000024CC0170)

B dbexpbuf: Buffer ESM (addr: 0000000024CD0170, size: 4194304, end: 00000000250D0170)

B dbexpbuf: Buffer CUA (addr: 00000000250E0170, size: 3072000, end: 00000000253CE170)

B dbexpbuf: Buffer OTR (addr: 00000000253D0170, size: 4194304, end: 00000000257D0170)

B dbcalbuf: Buffer CALE (addr: 00000000257E0050, size: 500000, end: 000000002585A170)

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

Please check and give me the solution.

Regards,

Phanikumar.

Hi vijay,

I am unable to paste the complete trace i am pasting the continution of the trace here.

S Fri Apr 09 10:35:52 2010

S *** init spool environment

S TSPEVJOB updates inside critical section: event_update_nocsec = 0

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 0000000012930420

S Fri Apr 09 10:35:53 2010

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 1 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S found spool memory service RSPO-RCLOCKS at 000000002EAF00D0

S doing lock recovery

S Fri Apr 09 10:35:54 2010

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 000000002EAF0610

S using messages for server info

S size of spec char cache entry: 297032 bytes (timeout 100 sec)

S size of open spool request entry: 2512 bytes

S immediate print option for implicitely closed spool requests is disabled

A Fri Apr 09 10:35:55 2010

A **GENER Trace switched on ***

A ~~-PXA~~--

A PXA INITIALIZATION

A PXA: Locked PXA-Semaphore.

A System page size: 4kb, total admin_size: 20832kb, dir_size: 20764kb.

A PXA allocated (address 000007FFEDAB0050, size 300000K)

A System name

A ORACLE...........................ECC........20100405120420.....................................

A is used for RFC security.

A Sharedbuffer token: 41534050...33 (len: 111)====== 326daf5f4dcc833d527b2f70...

A abap/pxa = shared protect gen_remote

A PXA INITIALIZATION FINISHED

A ~~-PXA~~--

A Fri Apr 09 10:35:58 2010

A ABAP ShmAdm attached (addr=000007FED88DB000 leng=20955136 end=000007FED9CD7000)

A >> Shm MMADM area (addr=000007FED8D83F00 leng=247168 end=000007FED8DC0480)

A >> Shm MMDAT area (addr=000007FED8DC1000 leng=15818752 end=000007FED9CD7000)

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 35354 bytes at 0000000008A30050

N Fri Apr 09 10:36:00 2010

N SsfSapSecin: putenv(SECUDIR=F:\usr\sap\ECC\DVEBMGS04\sec): ok

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is F:\usr\sap\ECC\DVEBMGS04\exe\sapsecu.dll .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N Fri Apr 09 10:36:01 2010

N ===...sucessfully completed.

N =================================================

N Fri Apr 09 10:36:04 2010

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

W ITS Plugin: Path dw_gui

W ITS Plugin: Description ITS Plugin - ITS rendering DLL

W ITS Plugin: sizeof(SAP_UC) 2

W ITS Plugin: Release: 700, [7000.0.236.20050900]

W ITS Plugin: Int.version, [33]

W ITS Plugin: Feature set: [21]

W ===... Calling itsp_Init in external dll ===>

W Fri Apr 09 10:36:05 2010

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

E Profile-Parameter: enque/deque_wait_answer = FALSE

E Replication is disabled

E EnqCcInitialize: local lock table initialization o.k.

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

S server @>SSRV:ecc6_ECC_04@< appears or changes (state 1)

M SosICreateNewAnchorArray: sos_search_anchor_semantics = 1

Y Fri Apr 09 10:36:08 2010

Y DYLOAD SAPMHTTP 0010: waited 200 ms, load is under construction

Y Fri Apr 09 10:36:09 2010

Y DYLOAD SAPMHTTP 0010: waited 200 ms, load is under construction

A Fri Apr 09 10:36:17 2010

A **GENER Trace switched off ***

M Fri Apr 09 14:23:13 2010

M ThAlarmHandler (1)

M ThAlarmHandler: set CONTROL_TIMEOUT/DP_CONTROL_JAVA_EXIT and break sql

C User requested cancel of current SQL on connection 0

B db_sqlbreak() = 0

M program canceled

M reason = max run time exceeded

M user = PILDUSER

M client = 001

M terminal = ecc6

M report = SAPMSSY1

M ThAlarmHandler: return from signal handler

C OCIStmtExecute() failed with -1=OCI_ERROR

C SQL error 1013:

C SQL cancelled; calling registered fct. at 00000000004C4C30

M program canceled

M reason = max run time exceeded

M user = PILDUSER

M client = 001

M terminal = ecc6

M report = SAPMSSY1

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_COVERAGE_ANALYSER entered.

A ** RABAX: level LEV_RX_COVERAGE_ANALYSER completed.

A ** RABAX: level LEV_RX_SAVE_SHMLOCKS entered.

A ** RABAX: level LEV_RX_SAVE_SHMLOCKS completed.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS entered.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS 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_STOR_VALUES entered.

A ** RABAX: level LEV_RX_STOR_VALUES completed.

A ** RABAX: level LEV_RX_C_STACK entered.

A Fri Apr 09 14:23:14 2010

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_AFTER_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_AFTER_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_BEG entered.

A ** RABAX: level LEV_RX_WRITE_SNAP_BEG completed.

A ** RABAX: level LEV_RX_WRITE_SNAP entered.

M Fri Apr 09 14:33:14 2010

M ThAlarmHandler (2)

Regards,

Phanikumar

You can see the tablespace usage/free using brtools under space management.

PILDUSER logs in Client 001 and you support pack is going on in client 000.

So there is no relationship.

PILDUSER session got cancelled after timeout + ORA 1013 error.

You need to see the support package processing in /usr/sap/trans/log & /usr/sap/trans/tmp in the trans file system and from SPAM.


M M Fri Apr 09 14:23:13 2010 M ThAlarmHandler (1) M ThAlarmHandler: set CONTROL_TIMEOUT/DP_CONTROL_JAVA_EXIT and break sql C User requested cancel of current SQL on connection 0 B db_sqlbreak() = 0 M program canceled M reason = max run time exceeded M user = PILDUSER M client = 001 M terminal = ecc6 M report = SAPMSSY1 M ThAlarmHandler: return from signal handler C OCIStmtExecute() failed with -1=OCI_ERROR C SQL error 1013: C SQL cancelled; calling registered fct. at 00000000004C4C30 M program canceled M reason = max run time exceeded M user = PILDUSER M client = 001 M terminal = ecc6 M report = SAPMSSY1

Ask a Question

Top Q&A Solution Author

User

Count