Reg: SAP ERP 6.0 Upgrade EhP5(Downtime Error)

Hi Experts,

I am update ECC6.0 to EhP5 almost completed, but "Downtime Phase" Disp+work" could not started, RFC Connection Error also came in Ehpi Tool.

Checks after phase MAIN_SWITCH/STARTSAP_TRANS were negative!

Last error code set: RFC call to subst_get_uvers failed with key RFC_ERROR_COMMUNICATION (open):

       >>> RfcOpenEx ...
       Got following connect_param string:
       CLIENT=000 USER=DDIC PASSWD=******* LANG=E ASHOST=ITEANZER1 SYSNR=12 GWHOST=ITEANZER1 GWSERV=sapgw12
       <<< RfcOpenEx failed

System start failed.

1. Disp+work status ok

2. r3trans -d Displaying this message

This is r3trans version 6.23 (relase 720 - 31.10.12 - 20:12:06).

unicode enabled version

R3trans =>sapparam(1c): No profile used.

R3trans =>sapparam: SAPSYSTEMNAME neither in Profile nor in commandline

2EETW000 sap dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function : db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char):5

2EETW000 key: TADIR

2EETW000 retcode: 2

r3trans finished (0012).

please can anybody help me.

SAP Managed Tags:
SAP enhancement package for SAP ERP

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)

Hi,

have you tried to manually start the shadow instance as described in SAP Note 525677.

If it doesnot help then please attach the dev* logs..

Rgds,

Sachin

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

Comment

Hi Sachin,

Thanks for your response, Shadow instance automatically was gone. now running original instance. Bellow I mentioned all logs files. pls check it. kernal the latest vertion: 400

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

trc file: "dev_disp", trc level: 1, release: "701"

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

sysno 12

sid ER1

systemid 562 (PC with Windows NT)

relno 7010

patchlevel 0

patchno 122

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 41604

Mon Dec 31 11:50:14 2012

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

length of sys_adm_ext is 576 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (12 41604) [dpxxdisp.c 1287]

shared lib "dw_xml.dll" version 122 successfully loaded

shared lib "dw_xtc.dll" version 122 successfully loaded

shared lib "dw_stl.dll" version 122 successfully loaded

shared lib "dw_gui.dll" version 122 successfully loaded

shared lib "dw_mdm.dll" version 122 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3912

Mon Dec 31 11:50:20 2012

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 6 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5534]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >ITEANZER1_ER1_12 <

DpShMCreate: sizeof(wp_adm) 31536 (1752)

DpShMCreate: sizeof(tm_adm) 5912704 (29416)

DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

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

DpShMCreate: sizeof(comm_adm) 552080 (1088)

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

DpShMCreate: sizeof(slock_adm) 0 (104)

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

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1864)

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

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000BA60050, size: 6615888)

DpShMCreate: allocated sys_adm at 000000000BA60050

DpShMCreate: allocated wp_adm at 000000000BA62270

DpShMCreate: allocated tm_adm_list at 000000000BA69DA0

DpShMCreate: allocated tm_adm at 000000000BA69E00

DpShMCreate: allocated wp_ca_adm at 000000000C00D680

DpShMCreate: allocated appc_ca_adm at 000000000C013480

DpShMCreate: allocated comm_adm at 000000000C0153C0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000C09C050

DpShMCreate: allocated gw_adm at 000000000C09C0D0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000C09C100

DpShMCreate: allocated wall_adm at 000000000C09C110

MBUF state OFF

DpCommInitTable: init table for 500 entries

DpRqQInit: Parameter rdisp/queue_lock_level = 2

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

ThTaskStatus: rdisp/reset_online_during_debug 0

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

<ES> Info: em/initial_size_MB( 16371MB) not multiple of em/blocksize_KB( 4096KB)

<ES> Info: em/initial_size_MB rounded up to 16372MB

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 4092 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

*** WARNING => System running without ICM - check rdisp/start_icman [dpxxdisp.c 13382]

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1682]

***LOG Q0K=> DpMsAttach, mscon ( ITEANZER1) [dpxxdisp.c 12696]

DpStartStopMsg: send start message (myname is >ITEANZER1_ER1_12 <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 7010, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048]

DpMsgAdmin: Set patchno for this platform to 122

Release check o.K.

Mon Dec 31 11:51:00 2012

my types changed after wp death/restart 0x2f --> 0x2e

my types changed after wp death/restart 0x2e --> 0x2c

my types changed after wp death/restart 0x2c --> 0x28

my types changed after wp death/restart 0x28 --> 0x20

my types changed after wp death/restart 0x20 --> 0x0

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1101

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 31 11:51:10 2012

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Mon Dec 31 06:21:10 2012

========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

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

0 DIA 64116 Ended no 1 0 0

1 DIA 62064 Ended no 1 0 0

2 UPD 41356 Ended no 1 0 0

3 UPD 40552 Ended no 1 0 0

4 ENQ 1440 Ended no 1 0 0

5 BTC 41576 Ended no 1 0 0

6 BTC 63036 Ended no 1 0 0

7 BTC 43500 Ended no 1 0 0

8 BTC 63136 Ended no 1 0 0

9 BTC 11416 Ended no 1 0 0

10 BTC 32332 Ended no 1 0 0

11 BTC 62920 Ended no 1 0 0

12 BTC 12688 Ended no 1 0 0

13 BTC 63312 Ended no 1 0 0

14 BTC 13988 Ended no 1 0 0

15 BTC 62668 Ended no 1 0 0

16 BTC 37608 Ended no 1 0 0

17 UP2 40980 Ended no 1 0 0

Dispatcher Queue Statistics Mon Dec 31 06:21:10 2012

===========================

+------+--------+--------+--------+--------+--------+

| Typ | now | high | max | writes | reads |

+------+--------+--------+--------+--------+--------+

| NOWP | 0 | 1 | 2000 | 1 | 1 |

+------+--------+--------+--------+--------+--------+

| DIA | 3 | 3 | 2000 | 3 | 0 |

+------+--------+--------+--------+--------+--------+

| UPD | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| ENQ | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| BTC | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| SPO | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| UP2 | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

max_rq_id 7

wake_evt_udp_now 0

wake events total 3, udp 3 (100%), shm 0 ( 0%)

since last update total 3, udp 3 (100%), shm 0 ( 0%)

Dump of tm_adm structure: Mon Dec 31 06:21:10 2012

=========================

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Mon Dec 31 06:21:10 2012

=============================

Slots: 300, Used: 1, Max: 1

+------+--------------+----------+-------------+

| id | owner | pid | eyecatcher |

+------+--------------+----------+-------------+

| 0 | DISPATCHER | -1 | *WPCAAD000* |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1101

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 31 11:51:15 2012

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >ITEANZER1_ER1_12 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes

Stop gateway

killing process (61460) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives (PID:61460 HANDLE:992)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1101

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Dec 31 11:51:16 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:61460 HANDLE:992)

DpStartStopMsg: send stop message (myname is >ITEANZER1_ER1_12 <)

DpStartStopMsg: Write AD_STARTSTOP message with type= 0, name=ITEANZER1_ER1_12 , sapsysnr=12, hostname=ITEANZER1

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 189 bytes

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIRead: read for hdl 2 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -

Received 4 bytes from MSG_SERVER

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

Mon Dec 31 11:51:17 2012

NiIPeek: peek for hdl 2 timed out (r; 1000ms)

NiIRead: read for hdl 2 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 13042]

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0

SiSelNSet: set events of sock 988 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 988 (pos=2)

SiSelNRemove: removed sock 988

NiSelIRemove: removed hdl 2

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/18

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpSemRq: key: 2, units: 1, timeout: -1

DpSemRel: key: 2, units: 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 9)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 988

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 41604) [dpxxdisp.c 11247]

Good Bye .....

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

trc file: "dev_ms", trc level: 1, release: "701"

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

[Thr 61924] Mon Dec 31 11:50:14 2012

[Thr 61924] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 562 (PC with Windows NT)

relno 7010

patchlevel 0

patchno 114

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 63240

[Thr 61924] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 63240) [msxxserv.c 1853]

[Thr 61924] load acl file = E:\usr\sap\ER1\SYS\global\ms_acl_info.DAT

[Thr 61924] MsGetOwnIpAddr: my host addresses are :

[Thr 61924] 1 : [192.168.1.100] ITEANZER1.MYITEANZ.COM (HOSTNAME)

[Thr 61924] 2 : [127.0.0.1] ITEANZER1 (LOCALHOST)

[Thr 61924] MsHttpInit: full qualified hostname = ITEANZER1

[Thr 61924] HTTP logging is switch off

[Thr 61924] set HTTP state to LISTEN

[Thr 61924] ms/icf_info_server : deleted

[Thr 61924] *** I listen to port sapmsER1 (3612) ***

[Thr 61924] *** I listen to internal port 3912 (3912) ***

[Thr 61924] *** HTTP port 8112 state LISTEN ***

[Thr 61924] CUSTOMER KEY: >Q1808298820<

[Thr 61924] build version=701.2009.12.02

[Thr 61924] Mon Dec 31 11:51:16 2012

[Thr 61924] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from ITEANZER1_ER1_12 [msxxserv.c 4731]

[Thr 61924] Mon Dec 31 12:01:37 2012

[Thr 61924] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.1.100) after 300 secs received [msxxserv.c 3217]

[Thr 61924] *** ERROR => MsSCheckConnections: disconnect now [192.168.1.100] [msxxserv.c 3221]

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

This is R3trans.exe version 6.14 (release 701 - 19.11.10 - 18:10:00).

unicode enabled version

R3trans.exe finished (0000).

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

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

trc file: "dev_w0", trc level: 1, release: "701"

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

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, MJ

M sysno 12

M sid ER1

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 122

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 64116

M Mon Dec 31 11:50:20 2012

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

M length of sys_adm_ext is 576 bytes

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

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

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

M DpShMCreate: sizeof(wp_adm) 31536 (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: 000000000DFC0050, size: 6615888)

M DpShMCreate: allocated sys_adm at 000000000DFC0050

M DpShMCreate: allocated wp_adm at 000000000DFC2270

M DpShMCreate: allocated tm_adm_list at 000000000DFC9DA0

M DpShMCreate: allocated tm_adm at 000000000DFC9E00

M DpShMCreate: allocated wp_ca_adm at 000000000E56D680

M DpShMCreate: allocated appc_ca_adm at 000000000E573480

M DpShMCreate: allocated comm_adm at 000000000E5753C0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000E5FC050

M DpShMCreate: allocated gw_adm at 000000000E5FC0D0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000E5FC100

M DpShMCreate: allocated wall_adm at 000000000E5FC110

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

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

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

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.

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

M ThInit: rdisp/cleanup_after_crash = 1

M ThInit: running on host ITEANZER1

M calling db_connect ...

B Loading DB library 'E:\usr\sap\ER1\DVEBMGS12\exe\dbdb6slib.dll' ...

B Library 'E:\usr\sap\ER1\DVEBMGS12\exe\dbdb6slib.dll' loaded

B Version of 'E:\usr\sap\ER1\DVEBMGS12\exe\dbdb6slib.dll' is "700.08", patchlevel (0.116)

C DbSl trace SM50: switch request to level 1

C Registering callback for dynamic profile parameters

C DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

C DB6 shared library (dbdb6slib) patchlevels

C (0.2) DB6: patch collection 06/08 (note 1172220)

C (0.9) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030)

C (0.9) IA64 alignment errors (note 1245982)

C (0.10) DB6: UR cursor with CC_RELEASE attribute (note 1244963)

C (0.10) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

C (0.11) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

C (0.19) DB6: patch collection 11/08 (note 1263885)

C (0.19) DB6: patch collection 11/08 (note 1264825)

C (0.21) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

C (0.33) DB6: patch collection 02/09 (note 1294443)

C (0.36) DB6: cobra enhancements (note 1315762)

C (0.40) DB6: configurable cc_release attribute for UR cursors (note 1324532)

C (0.41) DB6: unexpected token INLINE LENGTH (note 1334179)

C (0.42) DB6: cobra enhancements part 2 (note 1315762)

C (0.48) DB6: substitution of aliases in optguidelines (note 1352458)

C (0.53) DB6: login timeout for secondary connections (note 1364372)

C (0.57) DB6: revalidate views in status active=N (note 1376439)

C (0.57) DB6: create index with 9.7 and virtual tables (note 1371882)

C (0.58) DB6: optimized performance for R3load with DEF_CRT (note 1378018)

C (0.62) DB6: timeout for CREATE/DROP TRIGGER (note 1387865)

C (0.66) DB6: patch collection 10/09 (note 1397804)

C (0.69) DB6: Potentially unnoticed rollback during array operation (note 1406740)

C (0.74) DB6: client affinity support (note 1414616)

C (0.77) DB6: CLI TraceRefreshInterval during parallel import (note 1426985)

C (0.84) DB6: patch collection 03/10 (note 1447436)

C (0.92) Improved overflow error handling (note 1463647)

C (0.94) DB6: patch collection 05/10 (note 1364372)

C (0.94) DB6: patch collection 05/10 (note 1470824)

C (0.96) DB6: return original schema in shadow system (note 1474361)

C (0.99) ABAP: Return technical database PPMS information (note 1419552)

C (0.99) DB6: literals for decimal columns of value 0 (note 1482790)

C (0.101) MSSQL: database fingerprint (note 1405158)

C (0.102) DB6: tolerate client deletes on virtual tables (note 1484286)

C (0.111) DB6: SQLE_CLIENT_INFO_USERID including quotes (note 1508803)

C (0.112) DB6: revalidation of view failed (note 1376439)

C (0.113) DB6: DROP INDEX on virtual table ignored (note 1514380)

C (0.116) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

C Supported features:

C ..retrieving configuration parameters

C ..done

C DB2 library successfully loaded DB2 library 'E:\usr\sap\ER1\DVEBMGS12\exe/db6_clidriver\bin\db2app64.dll' successfully loaded

C Running with UTF-8 Unicode

C Mon Dec 31 11:50:21 2012

C Running with CLI driver.

C DB2 client driver version '09.07.0003'

C Connected to DB server type 'DB2/NT64'

C Connected to DB server version '09.07.0003'

C Connected to 'ER1' as 'SAPER1' schema 'SAPER1SHD' o.k.

C Connected: con_hdl=0 ; appl_hdl=58412; appl_id="fe80::a9b2:8f86:4006:82cc%11.60384.121231062021"

C Database code page is ok.

C Database collating sequence is ok.

C DB2_WORKLOAD=SAP is set in DB2 registry as required.

C CLI Insert Buffering is disabled on single partition databases.

C DbSl trace SM50: switch request to level 1

B Connection 0 opened (DBSL handle 0)

C *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN)

C &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.SVERS" is an undefined name.

C &+ SQLSTATE=42704

C &+

C &+ SELECT VERSION FROM SVERS WITH UR

C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

C &+

C *** ERROR in prepareStatement[dbdb6.c, 13774] (END)

B ***LOG BZA=> table SVERS does not exist on database [dblink#4 @ 1301] [dblink 1301 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1505]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10651]

M Info for wp 0

M pid = 64116

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

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

M *

M * LOCATION SAP-Server ITEANZER1_ER1_12 on host ITEANZER1 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Mon Dec 31 11:50:21 2012

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10916

M * COUNTER 1

M *

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

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 262]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 64116) [dpnttool.c 334]

Hi Sachin,

Any update.. Please can anybody help me.....

Hi Selva,

The problem you are facing might be because of Kernel not applied properly

Can you please re-apply the kernel again and restart the instance manually. Overwrite the previous kernel files and not delete and paste them.

I faced this issue previously and problem was due to kernel.

Regards,

Gaurav

Hi Gaurav,

I tried with Kernal update level 400, But still could not solved. Please check this image

Hi Selva,

Have you restarted the database manually.

Can you paste the latest trans.log contents ?

Regards,

Gaurav

Hi Gaurav,

Thanks for your Response, I start and stop database and services, sap server also.

but still I got the same error. I Mentioned trans log. Please check it

4 ETW000 R3trans version 6.14 (release 701 - 19.11.10 - 18:10:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 31.12.2012 - 17:17:51

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Dec 31 17:17:54 2012 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dbdb6slib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dbdb6slib.dll"), hdl 0, addr 0000000186840000

4 ETW000 80 0.000080

4 ETW000 [dev trc ,00000] using "E:\usr\sap\ER1\SYS\exe\uc\NTAMD64\dbdb6slib.dll" 14 0.000094

4 ETW000 [dev trc ,00000] Library 'dbdb6slib.dll' loaded 23 0.000117

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbdb6slib.dll 17 0.000134

4 ETW000 [dev trc ,00000] Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.116) 457 0.000591

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbdb6slib.dll 22 0.000613

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbdb6slib.dll 27 0.000640

4 ETW000 [dev trc ,00000] New connection 0 created 32 0.000672

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 45 0.000717

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 32 0.000749

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 14 0.000763

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 41 0.000804

4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt] 5487 0.006291

4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 29 0.006320

4 ETW000 [dev trc ,00000] (0.2) DB6: patch collection 06/08 (note 1172220) 19 0.006339

4 ETW000 [dev trc ,00000] (0.9) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030) 18 0.006357

4 ETW000 [dev trc ,00000] (0.9) IA64 alignment errors (note 1245982) 15 0.006372

4 ETW000 [dev trc ,00000] (0.10) DB6: UR cursor with CC_RELEASE attribute (note 1244963) 18 0.006390

4 ETW000 [dev trc ,00000] (0.10) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

4 ETW000 23 0.006413

4 ETW000 [dev trc ,00000] (0.11) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

4 ETW000 23 0.006436

4 ETW000 [dev trc ,00000] (0.19) DB6: patch collection 11/08 (note 1263885) 17 0.006453

4 ETW000 [dev trc ,00000] (0.19) DB6: patch collection 11/08 (note 1264825) 60 0.006513

4 ETW000 [dev trc ,00000] (0.21) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

4 ETW000 39 0.006552

4 ETW000 [dev trc ,00000] (0.33) DB6: patch collection 02/09 (note 1294443) 17 0.006569

4 ETW000 [dev trc ,00000] (0.36) DB6: cobra enhancements (note 1315762) 16 0.006585

4 ETW000 [dev trc ,00000] (0.40) DB6: configurable cc_release attribute for UR cursors (note 1324532)

4 ETW000 23 0.006608

4 ETW000 [dev trc ,00000] (0.41) DB6: unexpected token INLINE LENGTH (note 1334179) 17 0.006625

4 ETW000 [dev trc ,00000] (0.42) DB6: cobra enhancements part 2 (note 1315762) 16 0.006641

4 ETW000 [dev trc ,00000] (0.48) DB6: substitution of aliases in optguidelines (note 1352458)

4 ETW000 22 0.006663

4 ETW000 [dev trc ,00000] (0.53) DB6: login timeout for secondary connections (note 1364372)

4 ETW000 22 0.006685

4 ETW000 [dev trc ,00000] (0.57) DB6: revalidate views in status active=N (note 1376439) 17 0.006702

4 ETW000 [dev trc ,00000] (0.57) DB6: create index with 9.7 and virtual tables (note 1371882)

4 ETW000 22 0.006724

4 ETW000 [dev trc ,00000] (0.58) DB6: optimized performance for R3load with DEF_CRT (note 1378018)

4 ETW000 22 0.006746

4 ETW000 [dev trc ,00000] (0.62) DB6: timeout for CREATE/DROP TRIGGER (note 1387865) 17 0.006763

4 ETW000 [dev trc ,00000] (0.66) DB6: patch collection 10/09 (note 1397804) 16 0.006779

4 ETW000 [dev trc ,00000] (0.69) DB6: Potentially unnoticed rollback during array operation (note 1406740)

4 ETW000 23 0.006802

4 ETW000 [dev trc ,00000] (0.74) DB6: client affinity support (note 1414616) 16 0.006818

4 ETW000 [dev trc ,00000] (0.77) DB6: CLI TraceRefreshInterval during parallel import (note 1426985)

4 ETW000 23 0.006841

4 ETW000 [dev trc ,00000] (0.84) DB6: patch collection 03/10 (note 1447436) 16 0.006857

4 ETW000 [dev trc ,00000] (0.92) Improved overflow error handling (note 1463647) 16 0.006873

4 ETW000 [dev trc ,00000] (0.94) DB6: patch collection 05/10 (note 1364372) 16 0.006889

4 ETW000 [dev trc ,00000] (0.94) DB6: patch collection 05/10 (note 1470824) 16 0.006905

4 ETW000 [dev trc ,00000] (0.96) DB6: return original schema in shadow system (note 1474361)

4 ETW000 22 0.006927

4 ETW000 [dev trc ,00000] (0.99) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000 22 0.006949

4 ETW000 [dev trc ,00000] (0.99) DB6: literals for decimal columns of value 0 (note 1482790)

4 ETW000 22 0.006971

4 ETW000 [dev trc ,00000] (0.101) MSSQL: database fingerprint (note 1405158) 18 0.006989

4 ETW000 [dev trc ,00000] (0.102) DB6: tolerate client deletes on virtual tables (note 1484286)

4 ETW000 24 0.007013

4 ETW000 [dev trc ,00000] (0.111) DB6: SQLE_CLIENT_INFO_USERID including quotes (note 1508803)

4 ETW000 22 0.007035

4 ETW000 [dev trc ,00000] (0.112) DB6: revalidation of view failed (note 1376439) 17 0.007052

4 ETW000 [dev trc ,00000] (0.113) DB6: DROP INDEX on virtual table ignored (note 1514380) 17 0.007069

4 ETW000 [dev trc ,00000] (0.116) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

4 ETW000 23 0.007092

4 ETW000 [dev trc ,00000] Supported features: 13 0.007105

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 27 0.007132

4 ETW000 [dev trc ,00000] ..done 544 0.007676

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library 'E:\usr\sap\ER1\DVEBMGS12\exe/db6_clidriver\bin\db2app64.dll' successfully loaded

4 ETW000 48045 0.055721

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 17 0.055738

4 ETW000 [dev trc ,00000] Running with CLI driver. 55212 0.110950

4 ETW000 [dev trc ,00000] DB2 client driver version '09.07.0003' 157214 0.268164

4 ETW000 [dev trc ,00000] Connected to DB server type 'DB2/NT64' 58 0.268222

4 ETW000 [dev trc ,00000] Connected to DB server version '09.07.0003' 26 0.268248

4 ETW000 [dev trc ,00000] Connected to 'ER1' as 'SAPER1' schema 'SAPER1SHD' o.k. 117426 0.385674

4 ETW000 [dev trc ,00000] Connected: con_hdl=0 ; appl_hdl=21; appl_id="fe80::a9b2:8f86:4006:82cc%11.49216.121231114754"

4 ETW000 36 0.385710

4 ETW000 [dev trc ,00000] Database code page is ok. 47 0.385757

4 ETW000 [dev trc ,00000] Mon Dec 31 17:17:55 2012 248422 0.634179

4 ETW000 [dev trc ,00000] Database collating sequence is ok. 19 0.634198

4 ETW000 [dev trc ,00000] DB2_WORKLOAD=SAP is set in DB2 registry as required. 113234 0.747432

4 ETW000 [dev trc ,00000] CLI Insert Buffering is disabled on single partition databases. 33765 0.781197

4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN' 173 0.781370

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 31 0.781401

4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN' 5070 0.786471

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN) 5407 0.791878

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.SVERS" is an undefined name.

4 ETW000 40 0.791918

4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704

4 ETW000 33 0.791951

4 ETW000 [dev trc ,00000] &+

4 ETW000 40 0.791991

4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM SVERS WITH UR

4 ETW000 36 0.792027

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 41 0.792068

4 ETW000 [dev trc ,00000] &+

4 ETW000 37 0.792105

4 ETW000 [dev trc ,00000] &+

4 ETW000 31 0.792136

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] (END) 17 0.792153

4 ETW000 [dblink ,01301] ***LOG BZA=>table SVERS does not exist on database [dblink#4 @ 1301]

4 ETW000 57 0.792210

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN) 7419 0.799629

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.DDNTT" is an undefined name.

4 ETW000 38 0.799667

4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704

4 ETW000 30 0.799697

4 ETW000 [dev trc ,00000] &+

4 ETW000 40 0.799737

4 ETW000 [dev trc ,00000] &+ SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 30 0.799767

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 35 0.799802

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.799832

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.799862

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] (END) 17 0.799879

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 81 0.799960

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN) 456 0.800416

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.DDNTT" is an undefined name.

4 ETW000 36 0.800452

4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704

4 ETW000 31 0.800483

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.800513

4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 30 0.800543

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 34 0.800577

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.800607

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.800637

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] (END) 17 0.800654

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 21 0.800675

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN) 438 0.801113

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.DDNTT" is an undefined name.

4 ETW000 36 0.801149

4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704

4 ETW000 30 0.801179

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.801209

4 ETW000 [dev trc ,00000] &+ SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 30 0.801239

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 34 0.801273

4 ETW000 [dev trc ,00000] &+

4 ETW000 35 0.801308

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.801338

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] (END) 17 0.801355

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 30 0.801385

4 ETW000 [dbntab ,01273] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#9 @ 12739]

4 ETW000 31 0.801416

4 ETW000 [twdydbacc.c ,00571] i:0 54 0.801470

4 ETW000 [twdydbacc.c ,00572] db_fd_p[i].fname: PGMID 12 0.801482

4 ETW000 [twdydbacc.c ,00573] db_fd_p[i].is_key: 0 10 0.801492

4 ETW000 [twdydbacc.c ,00574] db_fd_p[i].offset: 0 10 0.801502

4 ETW000 [twdydbacc.c ,00575] db_fd_p[i].db_length: 0 9 0.801511

4 ETW000 [twdydbacc.c ,00576] db_fd_p[i].fixed_length:4 10 0.801521

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN) 3636 0.805157

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.XXXXT" is an undefined name.

4 ETW000 38 0.805195

4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704

4 ETW000 30 0.805225

4 ETW000 [dev trc ,00000] &+

4 ETW000 29 0.805254

4 ETW000 [dev trc ,00000] &+ SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 30 0.805284

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 34 0.805318

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.805348

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.805378

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] (END) 17 0.805395

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 27 0.805422

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN) 451 0.805873

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.XXXXT" is an undefined name.

4 ETW000 37 0.805910

4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704

4 ETW000 30 0.805940

4 ETW000 [dev trc ,00000] &+

4 ETW000 29 0.805969

4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 30 0.805999

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 34 0.806033

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.806063

4 ETW000 [dev trc ,00000] &+

4 ETW000 29 0.806092

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] (END) 17 0.806109

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 21 0.806130

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] CON = 0 (BEGIN) 436 0.806566

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPER1SHD.XXXXT" is an undefined name.

4 ETW000 37 0.806603

4 ETW000 [dev trc ,00000] &+ SQLSTATE=42704

4 ETW000 29 0.806632

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.806662

4 ETW000 [dev trc ,00000] &+ SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 30 0.806692

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 33 0.806725

4 ETW000 [dev trc ,00000] &+

4 ETW000 35 0.806760

4 ETW000 [dev trc ,00000] &+

4 ETW000 30 0.806790

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13774] (END) 16 0.806806

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 29 0.806835

4 ETW000 [dbntab ,01273] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#9 @ 12739]

4 ETW000 28 0.806863

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0) 159 0.807022

Hi Selva,

There are errors like below in the log:

Now please check, if SAP Profiles are available at path:

As you are using windows environment: Please check shared path if it's available:

\\<hostname>\sapmnt\<SID>profile

check SAPDBHOST parameter in the environment variables or check if DB host is defined in profile settings.

Regards,

Gaurav

Hi Gaurav,

Thanks for Response, Profile is available that directory. SAPDBHOST = DB2<SID> is available. I tried Kernal 201, 300, 400, 122. But still could not solved. last five days I cant find the solution.

Please give ur mail ID,

Hi Gaurav,

This is profile pls check it. anything is wrong pls update me.

#.******************************************************************************************************************************

#.* *

#.* Instance profile ER1_DVEBMGS12_ITEANZER1 *

#.* *

#.* Version = 000001 *

#.* Generated by user = DEVBASIS *

#.* Generated on = 11.12.2012 , 11:19:43 *

#.* *

#.******************************************************************************************************************************

SAPSYSTEMNAME = ER1

SAPGLOBALHOST = ITEANZER1

SAPSYSTEM = 12

INSTANCE_NAME = DVEBMGS12

DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTAMD64

DIR_EXECUTABLE = $(DIR_INSTANCE)\exe

# *** TEMPORARY 702 CHANGE ***"

#rdisp/wp_no_dia = 10

rdisp/wp_no_dia = 2

# *** TEMPORARY 702 CHANGE ***"

#rdisp/wp_no_btc = 3

rdisp/wp_no_btc = 12

icm/server_port_0 = PROT=HTTP,PORT=80$$

#-----------------------------------------------------------------------

# SAP Message Server parameters are set in the DEFAULT.PFL

#-----------------------------------------------------------------------

ms/server_port_0 = PROT=HTTP,PORT=81$$

# *** TEMPORARY 702 CHANGE ***"

#rdisp/wp_no_enq = 1

rdisp/wp_no_enq = 1

# *** TEMPORARY 702 CHANGE ***"

#rdisp/wp_no_vb = 1

rdisp/wp_no_vb = 2

rdisp/wp_no_vb2 = 1

# *** TEMPORARY 702 CHANGE ***"

#rdisp/wp_no_spo = 1

rdisp/wp_no_spo = 0

# *** TEMPORARY 702 CHANGE ***"

rdisp/btctime = 60

rdisp/btcname = ITEANZER1_ER1_12

rdisp/max_wprun_time = 0

rsdb/pmandt = 000

rdisp/bufrefmode = sendoff,exeauto

rdisp/TRACE = 1

ipc/shm_psize_40 = 10000000

transport/during_upgrade = ON

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

# *** TEMPORARY 702 CHANGE ***"

#DIR_TRANS = E:\software\ehptool\EHPI\abap

DIR_TRANS = E:\software\ehptool\EHPI\abap

DIR_PUT = E:\software\ehptool\EHPI\abap

ipc/shm_psize_10 = 200000000

rdisp/system_needs_spool = false

rspo/spool_id/use_tskh = 0

rec/client = OFF

abap/buffersize = 300000

rdisp/autoabaptime = 0

rdisp/j2ee_start = 0

rdisp/start_icman = false

vmcj/enable = off

Hi,

Thanks for glue... that problem is solved...I updated SAP recommeded Kernal 300 again. that phase is successfully finished.

Thanks for lot of Thanks.

Hi Selva,

That's good to hear...

THE BEST-RUN BUSINESSES RUN SAP

Regards,

Gaurav

Ask a Question

Top Q&A Solution Author

User

Count

101