Hi Martin,
Thank you for this information. I am happy this worked for you.
Regards
| | | ---------------Original Message---------------
From: matino
Sent: Friday, November 19, 2010 5:29 AM
Subject: COMMIT/ROLLBACK error on DEFAULT database connection after system copy
Hello
I have made a system copy of SAP Netweaver 7.01 ABAP Trial version using R3Load functionality.
After copy I'm able to start the new system and it's running fine until I execute any transaction which requires commit on database (e.g set-up TMS).
At this point I got short dump COMMIT/ROLLBACK error on "DEFAULT" database connection after system copy.
When I take a look into SM21 and I click to display any log, the workprocess is restarted.
R3trans -d gives return code (0000).
Any suggestion is welcome.
Thanks,
Martin
OS system: WinXP
DB: MaxDB 7.7 (default one for ABAP Trial version)
Here is the output of dev_w0:
trc file: "dev_w0", trc level: 1, release: "701"
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Fri Nov 19 10:48:32 2010
B create_con (con_name=R/3)
B Loading DB library 'C:\usr\sap\NSP\DVEBMGS84\exe\dbsdbslib.dll' ...
B Library 'C:\usr\sap\NSP\DVEBMGS84\exe\dbsdbslib.dll' loaded
B Version of 'C:\usr\sap\NSP\DVEBMGS84\exe\dbsdbslib.dll' is "700.08", patchlevel (0.24)
B New connection 0 created
M sysno 84
M sid NSP
M systemid 560 (PC with Windows NT)
M relno 7010
M patchlevel 0
M patchno 29
M intno 20020600
M make: multithreaded, Unicode, optimized
M pid 5044
M
M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 5044) [dpxxdisp.c 1323]
I
I Fri Nov 19 10:48:33 2010
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M
M Fri Nov 19 10:48:34 2010
M DpShMCreate: sizeof(wp_adm) 15336 (1704)
M DpShMCreate: sizeof(tm_adm) 4415616 (21968)
M DpShMCreate: sizeof(wp_ca_adm) 1664 (80)
M DpShMCreate: sizeof(appc_ca_adm) 1600 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064
M DpShMCreate: sizeof(comm_adm) 528064 (1048)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (96)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1544)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05F60040, size: 5043824)
M DpShMCreate: allocated sys_adm at 05F60040
M DpShMCreate: allocated wp_adm at 05F62170
M DpShMCreate: allocated tm_adm_list at 05F65D58
M DpShMCreate: allocated tm_adm at 05F65D88
M DpShMCreate: allocated wp_ca_adm at 0639BE08
M DpShMCreate: allocated appc_ca_adm at 0639C488
M DpShMCreate: allocated comm_adm at 0639CAC8
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 0641D988
M DpShMCreate: allocated gw_adm at 0641D9C8
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 0641D9F8
M DpShMCreate: allocated wall_adm at 0641DA00
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
Y *** ERROR => ztta/cua_area is 180000. [sapinit.c 975]
Y *** ERROR => ztta/cua_area adjusted to 500000. [sapinit.c 979]
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X
X Fri Nov 19 10:48:35 2010
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Fri Nov 19 10:48:36 2010
M ThInit: running on host nspvm
M calling db_connect ...
C
C DBSDBSLIB : version 700.08, patch 0.024 (Make PL 0.29)
C MAXDB shared library (dbsdbslib) patchlevels (last 10)
C (0.024) Default value for max. input variables is 2000 (note 655018)
C (0.024) Profile parameter to define max. input variables (note 655018)
C (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841)
C (0.024) Input parameters for SQL statements increased (note 655018)
C (0.018) Create index serial for MaxDB 7.6 (note 1267841)
C (0.018) More trace in case of packed to string conversion error (note 1262799)
C (0.016) R3trans export aborts with signal 6 (note 1262245)
C (0.009) IA64 alignment errors (note 1245982)
C (0.007) Support DB-Type 'SAP DB' by UPDSTAT (note 1225668)
C
C
C Loading SQLDBC client runtime ...
C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 002-121-083-965
C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 011-123-196-300
C SQLDBC client runtime is MaxDB 7.6.5.011 CL 196300
C SQLDBC supports new DECIMAL interface : 0
C SQLDBC supports VARIABLE INPUT data : 1
C SQLDBC supports keepAlive indicator : 0
C INFO : SQLOPT= -I 0 -t 0 -S SAPR3
C Try to connect (DEFAULT) on connection 0 ...
C
C Fri Nov 19 10:48:37 2010
C Attach to SAP DB : Kernel 7.7.06 Build 007-123-197-046
C Database release is SAP DB 7.7.06.007
C INFO : Database 'NSP' instance is running on 'nspvm'
C DB max. input host variables : 2000
C INFO : SAP DB Packet_Size = 131072
C INFO : SAP DB Min_Reply_Size = 4096
C INFO : SAP DB Comm_Size = 126976
C INFO : DBSL buffer size = 126976
C INFO : SAP DB MaxLocks = 300000
C INFO : Connect to DB as 'SAPNSP'
C Command info enabled
C Now I'm connected to SAP DB
C 00: nspvm-NSP, since
101119104836, ABAP= <unknown> (0)
B Connection 0 opened (DBSL handle 0)
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20101119 104836 nspvm
C INFO : SAP RELEASE (DB) = 701
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,*.swc,*.swf
I
I Fri Nov 19 10:48:45 2010
I MtxInit: 0 0 0
M SHM_PRES_BUF (addr: 08D30040, size: 350000)
M SHM_ROLL_AREA (addr: 7FEE0040, size: 819200)
M SHM_PAGING_AREA (addr: 08D90040, size: 819200)
M SHM_ROLL_ADM (addr: 08E60040, size: 169118)
M SHM_PAGING_ADM (addr: 05F30040, size: 5152)
M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 08E90040
M ThCreateNoBuffer index size: 3000 elems
M
M Fri Nov 19 10:48:46 2010
M ThCreateVBAdm allocated 12160 bytes (50 server) at 05F40040
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X ES initialized.
B dbntab: NTAB buffers attached
B dbntab: Buffer FTAB(hash header) (addr: 08FB0088, size: 536)
B dbntab: Buffer FTAB(anchor array) (addr: 08FB02A0, size: 40028)
B dbntab: Buffer FTAB(item array) (addr: 08FB9F00, size: 180000)
B dbntab: Buffer FTAB(data area) (addr: 08FE5E20, size: 3072000)
B dbntab: Buffer IREC(hash header) (addr: 092E0088, size: 536)
B dbntab: Buffer IREC(anchor array) (addr: 092E02A0, size: 40028)
B dbntab: Buffer IREC(item array) (addr: 092E9F00, size: 45000)
B dbntab: Buffer IREC(data area) (addr: 092F4EC8, size: 1024000)
B dbntab: Buffer STAB(hash header) (addr: 093F0088, size: 536)
B dbntab: Buffer STAB(anchor array) (addr: 093F02A0, size: 40028)
B dbntab: Buffer STAB(item array) (addr: 093F9F00, size: 45000)
B dbntab: Buffer STAB(data area) (addr: 09404EC8, size: 102400)
B dbntab: Buffer TTAB(hash header) (addr: 09420088, size: 1472)
B dbntab: Buffer TTAB(anchor array) (addr: 09420648, size: 40028)
B dbntab: Buffer TTAB(item array) (addr: 0942A2A8, size: 120000)
B dbntab: Buffer TTAB(data area) (addr: 09447768, size: 1460000)
B db_con_shm_ini: WP_ID = 0, WP_CNT = 9, CON_ID = -1
B dbstat: TABSTAT buffer attached (addr: 095B6E90)
B dbtbxbuf: Buffer TABL (addr: 09F600C8, size: 3000000, end: 0A23C788)
B dbtbxbuf: Buffer TABLP (addr: 0A2400C8, size: 512000, end: 0A2BD0C8)
B dbexpbuf: Buffer EIBUF (addr: 0A2C00D0, size: 2097152, end: 0A4C00D0)
B dbexpbuf: Buffer ESM (addr: 0A4D00D0, size: 4194304, end: 0A8D00D0)
B
B Fri Nov 19 10:48:47 2010
B dbexpbuf: Buffer CUA (addr: 0A8E00D0, size: 512000, end: 0A95D0D0)
B dbexpbuf: Buffer OTR (addr: 0A9600D0, size: 1024000, end: 0AA5A0D0)
B dbcalbuf: Buffer CALE (addr: 0AA60040, size: 300000, end: 0AAA9420)
M CCMS: alert/MONI_SEGM_SIZE = 0 monitoring and alerting switched off.
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 05B4EF20
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
S Fri Nov 19 10:48:48 2010
S found processing queue enabled
S found spool memory service RSPO-RCLOCKS at 0C1900A8
S doing lock recovery
S setting server cache root
S found spool memory service RSPO-SERVERCACHE at 0C190330
S using messages for server info
S size of spec char cache entry: 297028 bytes (timeout 100 sec)
S size of open spool request entry: 2236 bytes
S immediate print option for implicitely closed spool requests is disabled
A ***GENER* Trace switched on ***
A
A ---PXA |
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  D. Caddick
SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Related Content Most Popular White Papers
In the Spotlight  _.____.__ |
Mark as helpful
