DBIF_RSQL_SQL_ERROR during SAP_BASIS component upd...

Hi Mates,

We are trying to update SAP_BASIS component from SAPKB73102 to 73103 in IDES. However while updating i got the below errors.

I rectified the first error by increasing saptools space. But i am not able to reslve the second issue. Is there sany db space i still need to increase.

I am attaching the sapdb file.Please check and help.

sp_helpdb

1> sp_helpdb

2> go

name

db_size

owner dbid

created

durability

lobcomplvl

inrowlen

status

--------------------------------------------------------

----------------------------------------------------

-------------------- --------------------

------------------------------------------------

--------------------------------------------

----------------------------------------

--------------------------------

-----------------------------------------------------------------------

--------------------------------------------------------------------------------

-----------------------------------------

251904.0 MB

sapsa 4

Jan 17, 2014

full

100

2000

ddl in tran, allow nulls by default, abort tran on log full, allow wide

dol rows, deferred table allocation, page compression, allow increment

al dumps, deallocate first text page,full logging for all

master

248.0 MB

sa 1

Jan 17, 2014

full

NULL

mixed log and data

model

24.0 MB

sa 3

Jan 17, 2014

full

NULL

mixed log and data

saptempdb

2048.0 MB

sa 6

Oct 21, 2015

no_recovery

NULL

select into/bulkcopy/pllsort, trunc log on chkpt, ddl in tran, allow nu

lls by default, abort tran on log full, mixed log and data, user create

d temp db, allow wide dol rows

saptools

5752.0 MB

sapsa 5

Jan 17, 2014

full

NULL

trunc log on chkpt, ddl in tran, allow nulls by default, abort tran on

log full, allow wide dol rows, allow incremental dumps,full logging for

all

sybmgmtdb

180.0 MB

sa 31515

Jan 17, 2014

full

NULL

select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data

sybsystemdb

48.0 MB

sa 31513

Jan 17, 2014

full

NULL

trunc log on chkpt, mixed log and data

sybsystemprocs

200.0 MB

sa 31514

Jan 17, 2014

full

NULL

trunc log on chkpt, mixed log and data

tempdb

1048.0 MB

sa 2

Oct 21, 2015

no_recovery

NULL

select into/bulkcopy/pllsort, trunc log on chkpt, ddl in tran, allow nu

lls by default, abort tran on log full, mixed log and data, allow wide

dol rows

(1 row affected)

(return status = 0)

Thanks&Regards,

Adarsh

SAP Managed Tags:
SAP Adaptive Server Enterprise

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)

Hello Adarsh,

Can we see the dev_w* log file of the worker process number displayed in the second ABAP dump, as well as your ASE errorlog? (/sybase/<SID>/ASE-15_0/install/<SID>.log)

Thank you

Regards,

Cris

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

Comment

Hi Maria,

I am attaching the error files in this space.Please do check.

Thanks&Regards,

Adarsh

Hi Maria,

Thanks for the reply,

I am not able to attach the files here, so i am attaching in this thread.PLease do check.

Thanks&Regards,

Adarsh

Hello Adarsh,

From dev_w* log file I can see the ODBC driver is quite old:

C Driver: Adaptive Server Enterprise Driver release: 15.7.0.1010

C Driver full version: Sybase ASE ODBC Driver/15.7/SP101 PL/P/AMD64/Windows/drvmain/Build 1010/64-bit/Normal/Thu May 23 UTC 05:08:17 2013/SQLLEN8

C GetServerInfo version: Adaptive Server Enterprise/15.7/EBF 24749 SMP SP135 /P/X64/Windows Server/ase157sp133x/3927/64-bit/OPT/Thu Jun 04 12:50:11 2015

I'd start by upgrading the ODBC driver to same SP as the ASE, see SAP Note 1607816 - SYB: Installing Service Packs for SAP ASE (Windows) for details, I also copy them below:

=> To get the latest patch from SWDC:

--> Databases
--> SAP Adaptive Server Enterprise
--> Database Patches
--> SAP ASE for Business Suite
--> SYBASE ASE 15.7 FOR BUS. SUITE

--> OS Windows -> File name is DBCLNT157SPxx , currently the last is the SP18.

=> To upgrade the ODBC driver:

Log in as user <sid>adm.
Perform a file system backup of the directory
<drive>:\usr\sap\<SID>\SYS\global\syb\NTAMD64\
Copy the suitable <DBCLNT>.SAR file to the directory
<drive>:\usr\sap\<SID>\SYS\global\syb\NTAMD64\
Unpack the <DBCLNT>.SAR file using the command:
<DRIVE>:\usr\sap\<SID>\SYS\global\syb\NTAMD64\$>SAPCAR -xvf <DBCLNT>.SAR
Note: Replace <DBCLNT> with the file name as it applies

Then retry your BASIS SP upgrade.

Regards,

Cris

Hi Maria,

I installed the latest ODBC driver but i am still getting the same error. Is there any problem with procedure cache. i am attaching the work process log. Request you to please check and provide any suggestion if possible.

---------------------------------------------------

trc file: "dev_w1", trc level: 1, release: "721"

---------------------------------------------------

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, MJ

M sysno 00

M sid <DB>

M systemid 562 (PC with Windows NT)

M relno 7210

M patchlevel 0

M patchno 22

M intno 20020600

M make multithreaded, Unicode, 64 bit, optimized

M profile \\MIGIDES\sapmnt\MIT\SYS\profile\MIT_DVEBMGS00_MIGIDES

M pid 3120

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

M length of sys_adm_ext is 588 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workp. 1 3120) [dpxxdisp.c 1377]

I Tue Oct 27 09:59:47 2015

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

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

M DpIPCInit2: read dp-profile-values from sys_adm_ext

M DpShMCreate: sizeof(wp_adm) 61136 (2264)

M DpShMCreate: sizeof(tm_adm) 5517056 (27448)

M DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

M DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1384064/1384080

M DpShMCreate: sizeof(comm_adm) 1384080 (2744)

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

M DpShMCreate: sizeof(slock_adm) 0 (296)

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

M DpShMCreate: sizeof(file_adm) 0 (80)

M DpShMCreate: sizeof(vmc_adm) 0 (2152)

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

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: sizeof(j2ee_adm) 3952

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000C050050, size: 7193040)

M DpShMCreate: allocated sys_adm at 000000000C050060

M DpShMCreate: allocated wp_adm_list at 000000000C053070

M DpShMCreate: allocated wp_adm at 000000000C053260

M DpShMCreate: allocated tm_adm_list at 000000000C062140

M DpShMCreate: allocated tm_adm at 000000000C062190

M DpShMCreate: allocated wp_ca_adm at 000000000C5A50A0

M DpShMCreate: allocated appc_ca_adm at 000000000C5B4AB0

M DpShMCreate: allocated comm_adm at 000000000C5C44C0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000C716360

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated gw_adm at 000000000C716410

M DpShMCreate: allocated j2ee_adm at 000000000C716450

M DpShMCreate: allocated ca_info at 000000000C7173D0

M DpShMCreate: allocated wall_adm at 000000000C717460

M DpCommAttachTable: attached comm table (header=000000000C5C44C0/ft=000000000C5C44D0)

M DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 1 initializing ....

X <ES> EsILock: use spinlock for locking

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 DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M ThStart: taskhandler started

M ThInit: initializing DIA work process W1

M Tue Oct 27 09:59:51 2015

M ThInit: running on host MIGIDES

M Tue Oct 27 09:59:59 2015

M calling db_connect ...

B Loading DB library 'D:\usr\sap\MIT\DVEBMGS00\exe\dbsybslib.dll' ...

B Library 'D:\usr\sap\MIT\DVEBMGS00\exe\dbsybslib.dll' loaded

B Version of 'D:\usr\sap\MIT\DVEBMGS00\exe\dbsybslib.dll' is "721.02", patchlevel (0.0)

C trace file set

C Callback functions for dynamic profile parameter registered

B read_con_info_ssfs(): DBSL supports extended connect protocol

B ==> connect info for default DB will be read from ssfs

C Tue Oct 27 10:00:14 2015

C database is local: connect_timeout: 3

C Thread ID:3124

C lib_dbsl 721 05/24/2012 08:08:00

C 720_EXT build

C Using dynamic link library 'D:\usr\sap\MIT\DVEBMGS00\exe\dbsybslib.dll'

C dbsybslib.dll patch info

C patchlevel 0

C patchno 0

C lpc:(local) connection used on MIGIDES

C Tue Oct 27 10:00:17 2015

C lpc:(local) connection used on MIGIDES

C spid 38 comm rd ODBC

C spid 55 unc rd ODBC

C Driver: Adaptive Server Enterprise Driver release: 15.7.0.1340

C Driver full version: SAP ASE ODBC Driver/15.7/SP134 PL/P/AMD64/Windows/drvmain/Build 1340/64-bit/Normal/Thu Jun 18 UTC 18:17:33 2015/SQLLEN8

C GetServerInfo version: Adaptive Server Enterprise/15.7/EBF 24749 SMP SP135 /P/X64/Windows Server/ase157sp133x/3927/64-bit/OPT/Thu Jun 04 12:50:11 2015

C GetServerInfo release: 15.7.0.135

C GetServerInfo architecture: unknown

C GetServerInfo edition: P

C GetServerInfo byte width: 64 bit

C DbSlConnect hdl: 0

C trace file set

B Connection 0 opened (DBSL handle 0)

M ThInit: db_connect o.k.

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

I MtxInit: 1 0 0

M SHM_PRES_BUF (addr: 0000000013480050, size: 4400128)

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

M SHM_PAGING_AREA (addr: 00000000138C0050, size: 134217728)

M SHM_ROLL_ADM (addr: 000000001B8D0050, size: 2767448)

M SHM_PAGING_ADM (addr: 0000000003910050, size: 787488)

M ThCreateNoBuffer allocated 548152 bytes for 1000 entries at 0000000002C80050

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 31008 bytes (50 server) at 0000000002280050

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 1 initializing ....

X Using implementation view

X ES initialized.

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

B db_con_shm_ini: WP_ID = 1, WP_CNT = 27, CON_ID = -1

B dbtbxbuf: Buffer TABL (addr: 0000000036F50160, size: 30000128, end: 0000000038BEC560)

B dbtbxbuf: Buffer TABLP (addr: 0000000038BF0160, size: 10240000, end: 00000000395B4160)

B dbsync[db_syinit]: successfully attached to shared memory, sync_adm_p = 0000000002290050

B dbsync[db_syinit]: Buffer synchronisation started with

B sync_concept = SEQ_NR

B sendon = 1

B bufreftime = 120

B max_gap_wait_time = 60

B ddlog_del_time = 60

B last_counter = 280013657

B oldest_gap = (2147483647,00000000000000)

B time_of_last_sync = 20151027095935

B MySysId = 'MIGIDES 00'

B dbexpbuf[EXP_SHB]: buffer EIBUF installed with

B semkey = 35

B shmkey = 54

B wp_n = 27

B sclass = 0

B block_length = 256

B max_objects = 2000

B max_obj_size = 859808

B pref_obj_size = 0

B est_large_obj_size = 16384

B free_vec_lg = 65

B hash_vec_size = 4001

B buffer_l = 4194304

B max_blocks = 13437

B free_blocks = 13399

B mutex_n = 4001

B max_mtx_wait_time = 17000

B recovery_delay = 500000

B tracing = 0

B force_checks = 0

B protect_shm = 0

B dbexpbuf[EXP_SHM]: buffer ESM installed with

B semkey = 56

B shmkey = 65

B wp_n = 27

B sclass = 0

B block_length = 256

B max_objects = 2000

B max_obj_size = 859808

B pref_obj_size = 0

B est_large_obj_size = 16384

B free_vec_lg = 65

B hash_vec_size = 4001

B buffer_l = 4194304

B max_blocks = 13437

B free_blocks = 13437

B mutex_n = 4001

B max_mtx_wait_time = 17000

B recovery_delay = 500000

B tracing = 0

B force_checks = 0

B protect_shm = 0

B dbexpbuf[EXP_CUA]: buffer CUA installed with

B semkey = 30

B shmkey = 47

B wp_n = 27

B sclass = 10

B block_length = 512

B max_objects = 1500

B max_obj_size = 625888

B pref_obj_size = 0

B est_large_obj_size = 98304

B free_vec_lg = 193

B hash_vec_size = 3001

B buffer_l = 3072000

B max_blocks = 4891

B free_blocks = 4726

B mutex_n = 3001

B max_mtx_wait_time = 17000

B recovery_delay = 500000

B tracing = 0

B force_checks = 0

B protect_shm = 0

B dbexpbuf[EXP_OTR]: buffer OTR installed with

B semkey = 55

B shmkey = 64

B wp_n = 27

B sclass = 13

B block_length = 256

B max_objects = 2000

B max_obj_size = 859808

B pref_obj_size = 0

B est_large_obj_size = 20480

B free_vec_lg = 81

B hash_vec_size = 4001

B buffer_l = 4194304

B max_blocks = 13437

B free_blocks = 13437

B mutex_n = 4001

B max_mtx_wait_time = 17000

B recovery_delay = 500000

B tracing = 0

B force_checks = 0

B protect_shm = 0

I MPI: dynamic quotas disabled.

I MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%

M CCMS uses Shared Memory Key 73 for monitoring.

M CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

M CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

G RelWritePermissionForShm( pLocation = 120, pEnforce = 0 )

G GetWritePermissionForShm( pLocation = 99, pEnforce = 1 )

G RelWritePermissionForShm( pLocation = 100, pEnforce = 1 )

S *** init spool environment

S TSPEVJOB updates outside critical section: event_update_nocsec = 1

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 00000000123B3FE0

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 00000000436A00D0

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 00000000436A08E0

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 ***GENER* Trace switched on ***

A ---PXA-------------------------------------------

A PXA INITIALIZATION

A System page size: 4kb, total admin_size: 23160kb, dir_size: 22312kb.

A Attached to PXA (address 000007FFEDAB0050, size 300000K, 1 fragments of 276840K )

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

A abap/pxa = shared protect gen_remote

A PXA: checking structure sizes: 752|264|16

A PXA INITIALIZATION FINISHED

A ---PXA-------------------------------------------

A ATRA: pfclock execution time = 0

A ABAP ShmAdm attached (addr=000007DFED142000 leng=20955136 end=000007DFEE53E000)

A >> Shm MMADM area (addr=000007DFED639C80 leng=242240 end=000007DFED674EC0)

A >> Shm MMDAT area (addr=000007DFED675000 leng=15503360 end=000007DFEE53E000)

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

H HTTP> Parameter icf/ssocookie_mandatory set to 0

B dbtran INFO (init_connection '<DEFAULT>' [SYBASE:721.02]):

B max_blocking_factor = 50, min_blocking_factor = 1,

B max_in_blocking_factor = 128, min_in_blocking_factor = 1,

B max_union_blocking_factor = 50, min_union_blocking_factor = 1,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

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

B escape_as_literal = 0,

B select * =0x0f, character encoding = STD / []:X,

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

M ThrCreateShObjects allocated 56138 bytes at 00000000022A0050

Y dyWpInit

Y ztta/dynpro_ara 800000

Y ztta/cua_ara 500000

Y ztta/diag_ara 250000

M PXA: Shutdown function successfully registered!

N SsfSapSecin: getenv(SECUDIR)=="D:\usr\sap\MIT\DVEBMGS00/sec"

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

N === SSF INITIALIZATION:

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

N ===...SSF library is D:\usr\sap\MIT\DVEBMGS00\exe\sapcrypto.dll .

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

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

N ===...SECUDIR="D:\usr\sap\MIT\DVEBMGS00/sec"

N ===...loading of Security Toolkit successfully completed.

N === CommonCryptoLib (SAPCRYPTOLIB) Version 8.4.30 pl40 (Sep 25 2014) MT-safe

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

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

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: 721, [7210.0.22.20020600]

W ITS Plugin: Int.version, [34]

W ITS Plugin: Feature set: [30]

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

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

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

N SignInit: successfully obtained handle for Security Context cache

N VSI: WP init in ABAP VM completed with rc=0

E EnqLockTableAttach2: attach to lock table (size = 33554432)

E EnqLockTableMapToLocalContext: enque/use_pfclock2 = FALSE

E Tue Oct 27 10:00:18 2015

E EnqId_Initialize: local EnqId initialization o.k.

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

A UpdateProfile (new settings): off,krn_impl,(no dyn check),(no logging),(no stat err),(local generation),(no commit)

A UpdateProfile (new exceptions): (tmp_err),(home_err),(local_err)

A UpdateProfile (new version): 0

A ***GENER* Trace switched off ***

S Tue Oct 27 10:00:19 2015

S using action cache size 20 (prof=20)

S creating spool memory service RSPO-ACTIONS at 00000000436AA620

E Enqueue Info: enque/use_pfclock2 = FALSE

E Enqueue Info: row condense enabled

B dbrda: Redirect database access is disabled via rsdb/rda profile parameter setting.

M Tue Oct 27 10:02:01 2015

M SecAudit(rsauinit): WP attached to existing shared memory.

M SecAudit(RsauShmInit): addr of SHM for Audit.. = 0000000002C40050

M SecAudit(RsauShmInit): addr of RSAUSHM........ = 0000000002C41050

M SecAudit(RsauShmInit): addr of RSAUSLOTINFO... = 0000000002C41660

M SecAudit(RsauShmInit): addr of RSAUSLOTS...... = 0000000002C41670

B Tue Oct 27 10:03:29 2015

B dbsync[collect_new_with_gaps]: sequence gap [280013658, 285013372] found at 20151027100329

B dbsync[collect_new_with_gaps]: sequence 280013658 is missing since 20151027100129 (for 120 seconds)

B dbsync[collect_new_with_gaps]: max. wait time (60) exceeded, sequence 280013658 discarded

B ***LOG BS6=> Synchronisation record 280013658 missing in table DDLOG [dbsync 2323]

M Tue Oct 27 10:04:35 2015

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8C7FCE8FC4A39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 0

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 74

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = NULL

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 0

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8C7FCE8FC4A39E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8C7FCE8FC4A39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 0

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 75

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = NULL

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 0

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8C7FCE8FC4A39E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8C7FCE8FC4A39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 0

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 76

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = NULL

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 0

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8C7FCE8FC4A39E}_{conn-id=00000000000000000000000000000000}_0

N RSEC: The entry with identifier "/RFC/MIB02"

N was encrypted by system "(ID3|0120003411)"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

B Tue Oct 27 10:10:33 2015

B dbmyclu : info : my major identification is 3232271410, minor one 100.

B dbmyclu : info : Time Reference is 1.12.2001 00:00:00h GMT.

B dbmyclu : info : my initial uuid is E57C64D92A730AF1839E000C292E42EA.

B dbmyclu : info : current optimistic cluster level: 3

B dbmyclu : info : pessimistic reads set to 2.

G Tue Oct 27 10:10:34 2015

G GetWritePermissionForShm( pLocation = 281, pEnforce = 0 )

G RelWritePermissionForShm( pLocation = 277, pEnforce = 0 )

M Tue Oct 27 10:10:36 2015

M ThEMsgArrived: sysmsg_for_rfc = 0

G Tue Oct 27 10:10:46 2015

G GetWritePermissionForShm( pLocation = 283, pEnforce = 0 )

G RelWritePermissionForShm( pLocation = 277, pEnforce = 0 )

C Tue Oct 27 10:17:22 2015

C ERROR: -1 in function ExeNormalModify (execute) [line 20362]

C (701) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is not enough procedure

C cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA

C to reconfigure ASE with more procedure cache.

C statement id is ==> [3 VRSMODISRC 268435456 20050924011536]

C Tue Oct 27 10:17:23 2015

C transaction aborted by server

B ***LOG BY4=> sql error 0 performing INS on table VRSMODISRC [dbtran 7634]

B ***LOG BY0=> <message text not available> [dbtran 7634]

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS'

B RSLT: {dbsl=99, tran=1}

B FHDR: {tab='VRSMODISRC', fcode=130, mode=1, bpb=0, dbcnt=0, crsr=0,

B hold=0, keep=1, xfer=1, pkg=0, upto=0, init:b=0,

B init:p=0000000000000000, init:#=0, wa:p=0000000000000000, wa:#=4516}

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS'

B STMT: {stmt:#=0, bndfld:#=0, prop=0x1, distinct=0,

B fld:#=16, alias:p=0000000000000000, fupd:#=0, tab:#=0, where:#=0,

B groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0}

B CRSR: {tab='', id=0, hold=0, prop=0x10004, max.in@0=0, fae:blk=0,

B con:id=0, con:vndr=6, val=2,

B key:#=4, xfer=1, xin:#=128633, row:#=0, upto=0, wa:p=0X000007DF63F59400}

A Tue Oct 27 10:17:24 2015

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

A ** RABAX: level LEV_RX_HOTSPOT_TRACE 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 Tue Oct 27 10:17:25 2015

A ** RABAX: level LEV_RX_STANDARD completed.

A ** RABAX: level LEV_RX_STOR_VALUES entered.

A Tue Oct 27 10:17:37 2015

A ** RABAX: level LEV_RX_STOR_VALUES completed.

A ** RABAX: level LEV_RX_C_STACK entered.

A Tue Oct 27 10:17:42 2015

A ** RABAX: level LEV_RX_C_STACK completed.

A ** RABAX: level LEV_RX_MEMO_CHECK entered.

A Tue Oct 27 10:17:44 2015

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.

A Tue Oct 27 10:17:47 2015

A ** RABAX: level LEV_SN_END completed.

A ** RABAX: level LEV_RX_WRITE_SNAP_END entered.

A ** RABAX: level LEV_RX_WRITE_SNAP_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 Tue Oct 27 10:17:47 2015

A ABAP Program SAPLSVRX .

A Source LSVRXF09 Line 77.

A Error Code DBIF_RSQL_SQL_ERROR.

A Module $Id: //bas/721_REL/src/krn/runt/absapsql.c#7 $ SAP.

A Function ab_HandleRsqlErrors Line 726.

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.

A ** RABAX: level LEV_RX_IMC_ERROR completed.

A ** RABAX: level LEV_RX_DATASET_CLOSE entered.

A ** RABAX: level LEV_RX_DATASET_CLOSE completed.

A ** RABAX: level LEV_RX_ERROR_SAVE entered.

A ** RABAX: level LEV_RX_ERROR_SAVE completed.

A ** RABAX: level LEV_RX_ERROR_TPDA entered.

A ** RABAX: level LEV_RX_ERROR_TPDA completed.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.

A ** RABAX: level LEV_RX_END entered.

A ** RABAX: level LEV_RX_END completed.

A ** RABAX: end no http/smtp

A ** RABAX: end RX_GOTO_RABAX

A SQL error 0 when accessing table VRSMODISRC..

N Tue Oct 27 10:19:54 2015

N RSEC: The entry with identifier "/RFC/DIICLNT800"

N was encrypted by system "(ID3|INITIAL )"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

N RSEC: The entry with identifier "/RFC/T90CLNT090"

N was encrypted by system "(ID3|INITIAL )"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

M Tue Oct 27 10:19:56 2015

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CC35FF2DAC39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 91

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE816710

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CC35FF2DAC39E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CC35FF2DAC39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 92

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE816710

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CC35FF2DAC39E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CC35FF2DAC39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 93

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE816710

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CC35FF2DAC39E}_{conn-id=00000000000000000000000000000000}_0

N Tue Oct 27 10:19:57 2015

N RSEC: The entry with identifier "/RFC/MIB02"

N was encrypted by system "(ID3|0120003411)"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

N Tue Oct 27 10:24:47 2015

N RSEC: The entry with identifier "/RFC/DIICLNT800"

N was encrypted by system "(ID3|INITIAL )"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

N RSEC: The entry with identifier "/RFC/T90CLNT090"

N was encrypted by system "(ID3|INITIAL )"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

M Tue Oct 27 10:24:52 2015

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CD9BA02C0C39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 114

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE816710

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CD9BA02C0C39E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CD9BA02C0C39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 115

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE816710

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CD9BA02C0C39E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CD9BA02C0C39E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 116

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE816710

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CD9BA02C0C39E}_{conn-id=00000000000000000000000000000000}_0

N RSEC: The entry with identifier "/RFC/MIB02"

N was encrypted by system "(ID3|0120003411)"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

A Tue Oct 27 10:29:47 2015

A Local time adjusted (0 sec).

N Tue Oct 27 10:30:17 2015

N RSEC: The entry with identifier "/RFC/DIICLNT800"

N was encrypted by system "(ID3|INITIAL )"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

N RSEC: The entry with identifier "/RFC/T90CLNT090"

N was encrypted by system "(ID3|INITIAL )"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CF0142734239E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 133

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE81E790

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CF0142734239E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CF0142734239E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 134

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE81E790

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CF0142734239E}_{conn-id=00000000000000000000000000000000}_0

M *** ERROR => ThCheckReqInfo: message send/receive failed [thxxhead.c 18809]

M {root-id=000C292E42EA1ED59F8CF0142734239E}_{conn-id=00000000000000000000000000000000}_0

M Modeinfo for User T1/M0

M tm state = 2

M uid = 2

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >SAPSYS <

M terminal = > <

M client = >000<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M blockSoftCanel = NO

M Session Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C06F640/0/0/0000000000000000

M imode = 1

M mode state = 0x42

M task_type = ZTTAAUTOABAP

M lastThFc = THFCCOMT

M lastAction = TH_IACT_NO_ACTION

M rollout_reason = 0

M last_rollout_level = 7

M async_receives = 0

M cpic_receive = 0

M em handle = 1

M roll state = DP_ROLL_INITIALIZED

M abap state = DP_ROLL_INITIALIZED

M em state = DP_EM_ATTACHED

M eg state = DP_EM_NO_CONTEXT

M spa state = DP_SPA_INITIALIZED

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

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

M debug_mode = 255

M mode type = 0x1

M debug = DP_DEBUGGING_OFF

M msg_count = 135

M tcode = > <

M act_wp = 1

M last_wp = 1

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 9

M act enq infos = 0

M em_hyper_hdl = 000007DFEE542100

M plugin_info = 000007DFEE81E790

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 1

M Context Resources:

M HEAD: adr/max_elems/act_elems/tbl = 000000000C069128/0/0/0000000000000000

M ThPrintDataBlks: associated blocks: wp/appc=150/150, len=8/80

M *** ERROR => ThSysAdmMsg: ThAdmSend failed [thxxab.c 9600]

M {root-id=000C292E42EA1ED59F8CF0142734239E}_{conn-id=00000000000000000000000000000000}_0

N RSEC: The entry with identifier "/RFC/MIB02"

N was encrypted by system "(ID3|0120003411)"

N and cannot be decrypted here ("(MIT|0020787070)").

A TH VERBOSE LEVEL FULL

A ** RABAX: end RX_GET_MESSAGE

Thanks&Regards,

Adarsh

Hi Adarsh,

I can see you got the below error :

C ERROR: -1 in function ExeNormalModify (execute) [line 20362]

C (701) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is not enough procedure

C cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA

C to reconfigure ASE with more procedure cache.

Can you please check the procedure cache and the memory configuration as below :

sp_configure "procedure cache size"

sp_monitorconfig "procedure cache"

sp_configure "memory"

Please check with increasing the procedure cache by another 20% of the current configuration . You should have the free memory available for this requirement. Please check if this is helpful.

~Regards Gaurav

Dear Gaurav,

I am attaching the details below. Could you please help me if i have to increase the procedue cache size.

Microsoft Windows [Version 6.0.6001]

1> sp_configure "procedure cache size"

2> go

Parameter Name Default Memory Used

Config Value

Run Value

Unit Type

------------------------------ ----------- -----------

-----------------------------------------------------------------------

--------------------------------------------------------------------------------

------------------------

-----------------------------------------------------------------------

--------------------------------------------------------------------------------

------------------------

-------------------- --------------------

procedure cache size 14000 600088

262144

memory pages(2k) dynamic

(1 row affected)

(return status = 0)

1> sp_monitorconfig "procedure cache"

2> go

Usage information at date and time: Oct 31 2015 9:19AM.

Name Num_free Num_active Pct_act Max_Used

Reuse_cnt Instance_Name

------------------------- ----------- ----------- ------- -----------

----------- ------------------------------

procedure cache size 152219 109925 41.93 110714

0 NULL

(1 row affected)

(return status = 0)

1> sp_configure "memory"

2> go

Msg 17411, Level 16, State 1:

Server 'MIT', Procedure 'sp_configure', Line 413:

Configuration option is not unique.

(1 row affected)

Parameter Name Default Memory Used

Config Value

Run Value

Unit Type

------------------------------ ----------- -----------

-----------------------------------------------------------------------

--------------------------------------------------------------------------------

------------------------

-----------------------------------------------------------------------

--------------------------------------------------------------------------------

------------------------

-------------------- ----------

additional network memory 0 10240

10485760

bytes dynamic

allocate max shared memory 0 0

switch dynamic

compression memory size 0 276

memory pages(2k) dynamic

engine memory log size 0 2

memory pages(2k) dynamic

heap memory per user 4096 12249088

49152

bytes dynamic

kernel resource memory 4096 65816

32768

memory pages(2k) dynamic

lock shared memory 0 0

switch static

max memory 78848 2560000

1280000

memory pages(2k) dynamic

memory alignment boundary 16384 0

16384

bytes static

memory dump compression level 0 0

number dynamic

memory per worker process 1024 4

1024

bytes dynamic

messaging memory 400 0

400

memory pages(2k) dynamic

pci memory size 32768 0

32768

memory pages(2k) static

replication agent memory size 4096 8194

4096

memory pages(2k) dynamic

shared memory starting address 0 0

number static

total logical memory 78848 2300748

1150374

1156990

memory pages(2k) read-only

total physical memory 0 2560000

1280000

memory pages(2k) read-only

transfer utility memory size 4096 8194

4096

memory pages(2k) dynamic

An additional 246020 K bytes of memory is available for reconfiguration. This is

the difference between 'max memory' and 'total logical memory'.

(return status = 1)

Thanks&Regards,

Adarsh

HI,

I would say double it.

I see your current value is 262144.

So make it sp_configure 'procedure cache size'.524288

Also what is the size of the following parameters in your systems:

number of open indexes

number of open objects

number of open partitions

max memory

Kind Regards,

Johan

Hi Nicolas,

I am providing the details you had specified for.Please do check and reply.Can you please provide commands to increase the procedure cache size if possible.

Microsoft Windows [Version 6.0.6001]

1> use master

2> go

1> sp_countmetadata "open indexes"

2> go

There are 231535 user indexes in all database(s), requiring 733972 Kbytes of

memory. The 'open indexes' configuration parameter is currently set to 60000.

(return status = 0)

1> sp_countmetadata "open objects"

2> go

There are 115927 user objects in all database(s), requiring 255506 Kbytes of

memory. The 'open objects' configuration parameter is currently set to 60000.

(return status = 0)

1> sp_countmetadata "open partitions"

2> go

There are 231535 user partitions in all database(s), requiring 316597 Kbytes of

memory. The 'open partitions' configuration parameter is currently set to 50000.

(return status = 0)

1> sp_configure "max memory"

2> go

Parameter Name Default Memory Used

Config Value

Run Value

Unit Type

------------------------------ ----------- -----------

-----------------------------------------------------------------------

--------------------------------------------------------------------------------

------------------------

-----------------------------------------------------------------------

--------------------------------------------------------------------------------

------------------------

-------------------- --------------------

max memory 78848 2560000

1280000

memory pages(2k) dynamic

(1 row affected)

(return status = 0)

I also tried to increase the procedure cache but i am getting the below error.How should i increase max memory..is it the db size that i have to increase?

1> use master

2> go

1> sp_configure "procedure cache",524288

2> go

Msg 5861, Level 16, State 2:

Server 'MIT', Procedure 'sp_configure', Line 1310:

The current 'max memory' value '1280000', is not sufficient to change the

parameter 'procedure cache size' to '524288'. 'max memory' should be greater

than 'total logical memory' '1457055' required for the configuration.

(1 row affected)

(return status = 1)

Thanks&Regards,

Adarsh

Hi,

Set the following minimum:

sp_configure 'number of open indexes',150000

sp_configure 'number of open objects',150000

sp_configure 'number of open partitions',150000

If your server has enough physical memory change max memory as follows, which is 10.5GB for Sybase.

sp_configure 'max_memory',5376000

For sp_procedure cache size I am not what the recommendation is but on my systems I have seen it hit max a couple of time so just double it each time. If I am not mistaken the values below constitutes double your current setting.

sp_configure 'procedure cache size'.524288

Regards,

Johan

Adarsh,

I can see you have configured max memory to ASE server 2500 MB (2.4 GB). Free memory to ASE server is only 240 MB.

The current procedure cache is 512 MB.

Can you please check the memory (RAM) available at the OS/machine and the free available memory that can be added to ASE parameter "max memory" . Then Increase the procedure cache size from 512 MB to 1GB .

Hope this will be helpful.

~Gaurav

Ask a Question

Top Q&A Solution Author

User

Count