Hi, Check this out: M *** WARNING => big time diff 3095296176 [1200039229 368109] for stamp STAT_READDIR, correct ?
| | | ---------------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 | | Snowy SAP Basis Enthusiast
Contributed 1,000 posts in a group to earn a Gold Achievement Related Content Most Popular White Papers In the Spotlight _.____.__ |