cancel
Showing results for 
Search instead for 
Did you mean: 

Severe error(s) ocurred in Phase MAIN_SHDRUN/START_SHDI_FIRST

Former Member
0 Kudos

Hi,

I am upgrading SOLMAN 7.1 sr1 to lates SPS 14

During PreProcessing>ABAP>MAIN_SHDRUN/START_SHDI_FIRST i m getting this error

tail DEVTRACE.LOG:

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

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

[Thr 2332] Tue Mar 15 13:34:11 2016

[Thr 2332] ms/http_max_clients = 500 -> 500

[Thr 2332] MsSSetTrcLog: trc logging active, max size = 52428800 bytes

systemid   562 (PC with Windows NT)

relno      7210

patchlevel 0

patchno    622

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

pid        6084

[Thr 2332] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 6084) [msxxserv.c   2326]

[Thr 2332] MsInitAclInfo: acl file U:\SUM\abap\system\SMD\SYS\global\ms_acl_info.DAT not found, unrestricted access

[Thr 2332] MsGetOwnIpAddr: my host addresses are :

[Thr 2332]   1 : [172.16.0.104] ABCKHIHO12.ppl.com.pk (HOSTNAME)

[Thr 2332]   2 : [127.0.0.1] ABCKHIHO12 (LOCALHOST)

[Thr 2332] MsHttpInit: full qualified hostname = ABCKHIHO12

[Thr 2332] HTTP logging is switch off

[Thr 2332] *** I listen to port 3604 (3604) ***

[Thr 2332] *** I listen to internal port 3904 (3904) ***

[Thr 2332] CUSTOMER KEY: >X0595937261<

[Thr 2332] build version=721.2015.10.21

[Thr 2332] Tue Mar 15 13:34:34 2016

[Thr 2332] LOGIN: ABCKHIHO12_SMD_04 [172.16.0.104] (DIA UPD BTC SPO )

[Thr 2332] Tue Mar 15 13:35:31 2016

[Thr 2332] LOGOUT: ABCKHIHO12_SMD_04 [172.16.0.104] (DIA UPD BTC SPO )

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

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

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

Tue Mar 15 13:34:34 2016

***LOG S00=> GwInitReader, gateway started ( 5912) [gwxxrd.c     1797]

systemid   562 (PC with Windows NT)

relno      7210

patchlevel 0

patchno    622

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

pid        5912

gateway runs with dp version 148000(ext=124000) (@(#) DPLIB-INT-VERSION-148000-UC)

gateway (version=721.2016.01.21)

GwLogGetName: not found or invalid value for gw/logging_secure, set to 0

gw/reg_no_conn_info = 1

gw/local_addr : 0.0.0.0

gw/sim_mode : set to 0

***LOG S1I=> GwSetSimMode, Simulation Mode deactivated () [gwxxprf.c    4194]

* SWITCH TRC-RESOLUTION from 1 TO 1

CCMS: initialize CCMS Monitoring for ABAP instance with J2EE addin.

CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

Bind service sapgw04 (socket) to port 3304

GwIRegInitRegInfo: reg_info file U:\SUM\abap\system\SMD\DVEBMGS04\data\reginfo.DAT not found

GwPrintMyHostAddr: my host addresses are :

  1 : [172.16.0.104] ABCKHIHO12 (HOSTNAME)

  2 : [127.0.0.1] ABCKHIHO12 (LOCALHOST)

Full qualified hostname = ABCKHIHO12

DpSysAdmExtCreate: ABAP is active

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

Tue Mar 15 13:34:35 2016

DpIPCInit2: read dp-profile-values from sys_adm_ext

DpShMCreate: sizeof(wp_adm) 67616 (2504)

DpShMCreate: sizeof(tm_adm) 5796848 (28840)

DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1392064/1392080

DpShMCreate: sizeof(comm_adm) 1392080 (2768)

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

DpShMCreate: sizeof(slock_adm) 0 (296)

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

DpShMCreate: sizeof(file_adm) 0 (80)

DpShMCreate: sizeof(vmc_adm) 0 (2160)

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

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: sizeof(j2ee_adm) 3952

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000F650050, size: 7487424)

DpShMCreate: allocated sys_adm at 000000000F650060

DpShMCreate: allocated wp_adm_list at 000000000F6530E0

DpShMCreate: allocated wp_adm at 000000000F6532D0

DpShMCreate: allocated tm_adm_list at 000000000F663B00

DpShMCreate: allocated tm_adm at 000000000F663B50

DpShMCreate: allocated appc_ca_adm at 000000000FBFA960

DpShMCreate: allocated comm_adm at 000000000FC0A370

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000FD5E150

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated gw_adm at 000000000FD5E200

DpShMCreate: allocated j2ee_adm at 000000000FD5E240

DpShMCreate: allocated ca_info at 000000000FD5F1C0

DpCommAttachTable: attached comm table (header=000000000FC0A370/ft=000000000FC0A380)

MtxInit: -2 0 0

DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

Tue Mar 15 13:35:29 2016

GwISigint: received SIGINT (2), start shutdown phase

***LOG S30=> GwStopGateway, gateway stopped () [gwxxrd.c     13414]

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      04

M sid        SMD

M systemid   562 (PC with Windows NT)

M relno      7210

M patchlevel 0

M patchno    622

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    U:\SUM\abap\system\SMD\SYS\profile\SMD_DVEBMGS04_ABCKHIHO12

M pid        7896

M

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

M  length of sys_adm_ext is 596 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 7896) [dpxxdisp.c   1381]

I  MtxInit: 0 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) 67616 (2504)

M  DpShMCreate: sizeof(tm_adm) 5796848 (28840)

M  DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

M  DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1392064/1392080

M  DpShMCreate: sizeof(comm_adm) 1392080 (2768)

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 (2160)

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: 0000000000220050, size: 7487424)

M  DpShMCreate: allocated sys_adm at 0000000000220060

M  DpShMCreate: allocated wp_adm_list at 00000000002230E0

M  DpShMCreate: allocated wp_adm at 00000000002232D0

M  DpShMCreate: allocated tm_adm_list at 0000000000233B00

M  DpShMCreate: allocated tm_adm at 0000000000233B50

M  DpShMCreate: allocated wp_ca_adm at 00000000007BAF50

M  DpShMCreate: allocated appc_ca_adm at 00000000007CA960

M  DpShMCreate: allocated comm_adm at 00000000007DA370

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 000000000092E150

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated gw_adm at 000000000092E200

M  DpShMCreate: allocated j2ee_adm at 000000000092E240

M  DpShMCreate: allocated ca_info at 000000000092F1C0

M  DpShMCreate: allocated wall_adm at 000000000092F250

M  DpCommAttachTable: attached comm table (header=00000000007DA370/ft=00000000007DA380)

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 0 initializing ....

X  <ES> EsILock: use Mutex 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 192 MB

X  mm.dump: set global maximum dump mem to 192 MB

X  EsRegisterEmCheck: Register EmGetEsHandles at 00007FF790CC5410

M  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M Tue Mar 15 13:34:35 2016

M  ThStart: taskhandler started

M  ThTHPInit: thp initialized

M  ThInit: initializing DIA work process W0

M Tue Mar 15 13:34:38 2016

M  ThInit: running on host ABCKHIHO12

I  MtxInit: 0 0 0

M  calling db_connect ...

B  Loading DB library 'U:\SUM\abap\exe\dboraslib.dll' ...

B  Library 'U:\SUM\abap\exe\dboraslib.dll' loaded

B  Version of 'U:\SUM\abap\exe\dboraslib.dll' is "721.02", patchlevel (0.600)

B  con_info_ext_support(): DBSL supports extended connect protocol

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

B  con_info_exp_support(): profile parameter auth/shadow_upgrade is set

B  con_info_ext_support(): DBSL supports extended connect protocol for shadow instance

B   ==> Using shadow upgrade key set to get connect info from ssfs

C Tue Mar 15 13:34:39 2016

C  dbs/ora/stmt_cache_size = 250

C  Register application info.

C  Oracle client version: 11.2.0.3.0, (dbsl 721 180915, UNICODE[2])

C  Detailed Oracle client (patch) info not available.

C Tue Mar 15 13:34:40 2016

C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

C  Connecting as SAPSR3SHD/<pwd>@SMD on connection 0 (nls 0) ... (dbsl 721 180915, UNICODE[2])

C  OCIHandleAlloc(con=0): Service svc=05D6BBC0 created, rc=0

C  OCIServerAttach(con=0, svc=05D6BBC0): New server hdl. srv=05D6C030 attached to 'SMD'

C  OCISessionBegin(con=0, svc=05D6BBC0, srv=05D6C030='SMD'): start session usr=05D7B2C0='SAPSR3SHD', rc=0

C  Now 'SAPSR3SHD/<pwd>@SMD' is connected: con=0, nls=0, session=198, time='2016-03-15 13:34:40'

C  DB instance SMD is running on ABCKHIHO12 with ORACLE version 11.2.0.4.0 since MAR 11, 2016, 16:25:46.

C Tue Mar 15 13:34:41 2016

C  con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8

C   # CharacterSet                   NCharSet   envhp            errhp            er2hp            bathp          

C   0 UTF16                          AL16UTF16  05D5DEE0         03CCDBA8         05D68C68         05D69D48       

B  Connection 0 opened (DBSL handle 0)

C  check2: OCIStmtExecute() failed with -1=OCI_ERROR

C          SQL error 942:

C     statement for table 'SVERS                         ':

C         SELECT VERSION FROM SVERS                                                                                                

C     stmt_fetch() -> orc=942, 103=DBSL_ERR_DBOBJECT_UNKNOWN

B  ***LOG BZA=> table SVERS does not exist on database  [dblink       1327]

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

M  in_ThErrHandle: 1

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

M  Info for wp 0

M    pid = 7896

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 0

M    locked semaphores (), locking ()

M    act_cs_count = 1

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  ThIErrHandle: current request:

M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1

M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -   

M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1

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

M  *

M  *  LOCATION    SAP-Server ABCKHIHO12_SMD_04 on host ABCKHIHO12 (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Tue Mar 15 13:34:41 2016

M  *  RELEASE     721

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        11979

M  *  COUNTER     1

M  *

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

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M  ThIErrHandle: 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 (Workp. 0 7896) [dpnttool.c   339]

Please suggest the solution.

Regards

Qazi

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185239
Active Contributor
0 Kudos

Hi Qazi,

You need to check the SVERS table in the shadow database.It is the first table which SAP looks for to start the system.

Follow the below steps

1. logon to sqlplus of oracle

    sqlplus /nolog

sql> connect SAPSR3DB/<password>  <password will be the same as SAPSR3 schema>

select count(*) from SVERS;

and paste the output

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi Ashutosh,

Actually before the step I was tried to start SHW instance 04. When I stop SHD instance and letting SUM start this error resolved now SHD instance running since 1 and half hours.

Currently it is giving error in DDIC_UPG

DDICUPG Log

former_member185239
Active Contributor
0 Kudos

Hi Qazi,

Kindly paste the below log DDICUPG.ELG and SAPHA70214.SMD file.

The connection between the oracle and SAP is getting broken frequently.

Just retry the below steps.

Stop SAP and Database

Take a reboot of the server

Start DB , SAP and SUM once again.

Also check the alert_SID.log file for the oracle system.

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi

DDICUPG.LOG

DDIC IMPORT ERRORS and RETURN CODE in SAPH-70212INSAPBSFND.SMD

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 ETW000  [     dev trc,00000]  0 AND "TRKORR"=:A1 AND "AS4POS_FRM"=:A2;

4 ETW000  [    dbtrtab ,00000]  ***LOG BY4=>sql error 3135   performing SEL on table TRBAT3                       

4 ETW000  [    dbtrtab ,00000]  ***LOG BY0=>ORA-03135: connection lost contact

4 ETW000                        Process ID: 7120

4 ETW000                        Session ID: 63 Serial number: 1773

2EETW000 sap_dext called with msgnr "1":

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

2EETW000 function:   db_rtab

2EETW000 fcode:      RT_READ_ONLY

2EETW000 tabname:    TRBAT3                       

2EETW000 len (char): 358

2EETW000 key:        PSAPK-70212INSAPBSFND000783999999R    20160315153343U:\SUM\abap\tmp\SAPH-70212INSAPBSFND_08448_08448_000783.SMD                                                            

2EETW000 retcode:    1

2EETW000 sql error:  3135 ORA-03135: connection lost contact

2EETP000 Process ID: 7120

2EETP000 Session ID: 63 Serial number: 1773

2EETW125 SQL error "3135" during "" access: "ORA-03135: connection lost contact"

1 ETP111 exit code           : "12"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDIC IMPORT ERRORS and RETURN CODE in SAPHNA7031.SMD

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3135 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03135: connection lost contact

4 ETW000                        Process ID: 8032

4 ETW000                        Session ID: 203 Serial number: 7645

2EETW000 SQL error 3135 occured: ORA-03135: connection lost contact

2EETP000 Process ID: 8032

2EETP000 Session ID: 203 Serial number: 7645

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  ME = :A1 ;

4 ETW000  [     dev trc,00000]  head_p=00007FF7405737C0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1200

4 ETW000  [dbdsoci.c   ,00000]  *** ERROR => ^^ Ds_fetch(cid=0) -> err=1=DS_SQLERR

4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error 3114 performing FET

4 ETW000  [    dbds    ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 SQL error 3114 occured: ORA-03114: not connected to ORACLE

4 ETW000  [     dev trc,00000]  UPDATE "TRBAT3" SET "AS4POS_TO"=:A0,"STATUS"=:A1,"RETCODE"=:A2,"TIMESTMP"=:A3,"LOGNAME"=:A4,"PID"=:A\

4 ETW000  [     dev trc,00000]  5,"CLIDEPDT"=:A6,"CLIINDEPDT"=:A7,"MODIFIED"=:A8,"HOSTNAME"=:A9,"ERROR_CNT"=:A10,"WARN_CNT"=:A11 WHE\

4 ETW000  [     dev trc,00000]  RE "FUNCTION"=:A12 AND "TRKORR"=:A13 AND "AS4POS_FRM"=:A14;

4 ETW000  [    dbtrtab ,00000]  ***LOG BY4=>sql error 3114   performing UPD on table TRBAT3                       

4 ETW000  [    dbtrtab ,00000]  ***LOG BY0=>ORA-03114: not connected to ORACLE

2EETW000 sap_dext called with msgnr "1":

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

2EETW000 function:   db_rtab

2EETW000 fcode:      RT_MODIFY

2EETW000 tabname:    TRBAT3                       

2EETW000 len (char): 358

2EETW000 key:        PSAPKNA7031          000008000008B                                                                                                                                         

2EETW000 retcode:    1

2EETW000 sql error:  3114 ORA-03114: not connected to ORACLE

2EETW125 SQL error "3114" during "" access: "ORA-03114: not connected to ORACLE"

1 ETP111 exit code           : "12"

tail SAPHB702.15.SMD

4 ETW690 COMMIT "13924" "8220394"

3 ETW677 "R3TRWDCANO_SCREEN_SEQUENCE              02" not imported in this step.

3 ETW677 "R3TRWDCANO_SECIAL_SEC_NO                02" not imported in this step.

3 ETW677 "R3TRWDCASCREEN_SEQUENCE                 02" not imported in this step.

3 ETW677 "R3TRWDCASRALCONFIG                      02" not imported in this step.

3 ETW677 "R3TRWDCATEST_WITH_ALL_FIELDS            02" not imported in this step.

3 ETW677 "R3TRWDCCNO_SCREEN_SEQUENCE              00" not imported in this step.

3 ETW677 "R3TRWDCCNO_SECIAL_SEC_NO                00" not imported in this step.

3 ETW677 "R3TRWDCCSCREEN_SEQUENCE                 00" not imported in this step.

3 ETW677 "R3TRWDCCSRALCONFIG                      00" not imported in this step.

3 ETW677 "R3TRWDCCTESTJH                          00" not imported in this step.

3 ETW677 "R3TRWDCCTEST_WITH_ALL_FIELDS            00" not imported in this step.

3WETW000 different nametabs for table WDY_APPLICATION (field SESSION_KIND).

4 ETW000       Field is not in NTAB.

4 ETW000      table WDY_APPLICATION: entry in DB is 4 bytes smaller than in file.

4 ETW000      table WDY_APPLICATION: entry in DB has 1 field less than in file.

4 ETW000      ... ignoring such differences.

3 ETW677 "R3TRWDYAC_SRT_WS_SEARCH_DEMO" not imported in this step.

3 ETW677 "R3TRWDYARAL_WD_TEST" not imported in this step.

3 ETW677 "R3TRWDYASRALCONFIG" not imported in this step.

3 ETW677 "R3TRWDYASRALMANAGER" not imported in this step.

3 ETW677 "R3TRWDYASRALMONITOR" not imported in this step.

3 ETW677 "R3TRWDYAWDR_TEST_ALL_UI_ELEMENTS" not imported in this step.

3 ETW677 "R3TRWDYAWDR_TEST_APPL_PAR" not imported in this step.

3 ETW677 "R3TRWDYAWDR_TEST_FLASH_ISLAND" not imported in this step.

3 ETW677 "R3TRWDYAWDR_TEST_LIFECYCLE_AC_FI" not imported in this step.

3 ETW677 "R3TRWDYAWDR_TEST_RAL_MAIN" not imported in this step.

3WETW109 table "WDY_UI_PROP_RAL" does not exist in nametab.

4 ETW000 no entries for WDY_UI_PROP_RAL will be imported in this step.

3 ETW677 "R3TRWDYLGENERIC_ACTIVE_COMP" not imported in this step.

3 ETW677 "R3TRWDYLSTANDARD" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_ADMIN_LOG" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_ADV_SEARCH_PARAM" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_BLACKLIST" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_CLIENT_SWITCH" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_CONFIG" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_HELP_AND_BACK_LINK" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_LOG_DOMAIN" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_MANAGER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_MONITOR" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_PURPOSE" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_RECORDER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_TRANSPORT" not imported in this step.

3 ETW677 "R3TRWDYNC_SRAL_WD_TEST" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_CONFIG_TEMPLATE" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_LOGON_DATA_ASSIGN" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WSDL_UPLOAD_VH" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_ADMIN_MAIN" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_BNG_WIZARD" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_CONFIG_CONSUMER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_CONFIG_PROVIDER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_CONFIG_SEARCH" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_CONSUMER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_CONSUMER_SEC" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_EVENT_PROVIDER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_LP_WIZARD" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_PROVIDER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_PROVIDER_SEC" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_SEARCH" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_SEARCH_CONSUMER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_SEARCH_PROVIDER" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_SEARCH_SRV_GROUP" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_SERVICE_GROUP" not imported in this step.

3 ETW677 "R3TRWDYNC_SRT_WS_WSDL_FLAVOUR" not imported in this step.

3 ETW677 "R3TRWDYNSALV_WD_FILTER_UI" not imported in this step.

3 ETW677 "R3TRWDYNSIQ_DASHBOARD_PLUGINS" not imported in this step.

3 ETW677 "R3TRWDYNSIQ_DBFILE_CREATE" not imported in this step.

3 ETW677 "R3TRWDYNSRAL_TRANSPORT" not imported in this step.

3 ETW677 "R3TRWDYNSRAL_TRANSPORT" not imported in this step.

3 ETW677 "R3TRWDYNSYB_HADR_OVERVIEW" not imported in this step.

3 ETW677 "R3TRWDYNWDR_TEST_ALL_UI_ELEMENTS" not imported in this step.

3 ETW677 "R3TRWDYNWDR_TEST_LIFECYCLE_AC_FI" not imported in this step.

3 ETW677 "R3TRWDYNWDR_TEST_RAL" not imported in this step.

3 ETW677 "R3TRWDYNWDR_TEST_RAL_MAIN" not imported in this step.

3 ETW677 "R3TRWEBIBANKACCOUNTCONTRACTPROCESSIN59" not imported in this step.

3 ETW677 "R3TRWEBIBANKINGTESTWS" not imported in this step.

3 ETW677 "R3TRWEBIDEMO_SERVICE_PROVIDER_REUSE" not imported in this step.

3 ETW677 "R3TRWEBIREADACCESSLOGGINGTESTSERVICE" not imported in this step.

3 ETW677 "R3TRWEBISRAL_RFC_TEST_PARAM_VARIETY" not imported in this step.

3 ETW677 "R3TRWEBISRAL_TEST_SERVICE" not imported in this step.

3 ETW677 "R3TRWEBISRTG_TEST" not imported in this step.

3 ETW677 "R3TRWEBIUDDI_INQUIRY_V3" not imported in this step.

3 ETW677 "R3TRWEBIUDDI_PUBLICATION_V3" not imported in this step.

3 ETW677 "R3TRWEBIUDDI_SECURITY_V3" not imported in this step.

3 ETW677 "R3TRWTAGGRAPHICS" not imported in this step.

3 ETW677 "R3TRXSLTDB2_FAILOVER_CONFIG_XML" not imported in this step.

3 ETW677 "R3TRXSLTDBA_GRAPHIC_COMP_SAPGUI_DATA" not imported in this step.

3 ETW677 "R3TRXSLTLAW2_USMMRESULT2XML" not imported in this step.

3 ETW677 "R3TRXSLTMSS_MEMCMP_CUSTOMIZING" not imported in this step.

3 ETW677 "R3TRXSLTMSS_MEMCMP_DATA" not imported in this step.

3 ETW677 "R3TRXSLTSEC_STS_CLAIM_TYPES" not imported in this step.

3 ETW677 "R3TRXSLTSTC_TM_SESSION_EXTXML_2_HTML" not imported in this step.

3 ETW677 "R3TRXSLTST_XMS_RUN_TIME_ENV" not imported in this step.

4 ETW690 COMMIT "0" "8220394"

4 ETW000 child process 7192 - objects from 019149 to 999999 successfully imported (date&time: 15.03.2016 - 15:34:56)

4 ETW000 end of log fragment of child 00000007192

4 ETW000 child process rc = 4

4 ETW690 COMMIT "8220522" "88648600"

4 ETW690 COMMIT "0" "88648600"

4 ETW690 COMMIT "128" "88648728"

4 ETW000 SAPKB70215           touched.

4 ETW690 COMMIT "128" "88648856"

4 ETW000 221362566 bytes read.

4 ETW000 Transport overhead 0.0 %.

4 ETW000 Duration: 2:36 min (1418990 bytes/sec).

3 ETW710 "1" "0"

4 ETW000

4 ETW000 Summary:

4 ETW000

4 ETW000 88648856 bytes modified in database.

4 ETW000  [     dev trc,00000]  Tue Mar 15 15:34:59 2016

4 ETW000  [     dev trc,00000]  Disconnecting from ALL connections:

4 ETW000  [     dev trc,00000]  dbcon[db_con_disconnect_all]: disconnecting from connection 0 ...

4 ETW000  [     dev trc,00000]  Disconnecting con=0

4 ETW000  [     dev trc,00000]  OCISessionEnd(con=0, svc=03E1B860, srv=03E1C040='SMD'): Close session usr=03E2B150, rc=0

4 ETW000  [     dev trc,00000]  OCIServerDetach(stale1 con=0, svc=03E1B860, srv=03E1C040='SMD') successfully detached

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0, svc=03E1B860): Server handle srv=03E1C040 freed

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0): Service hdl. svc=03E1B860 freed.

4 ETW000  [     dev trc,00000]  dbcon[db_con_disconnect_all]: disconnected from connection 0

4 ETW000  [     dev trc,00000]  statistics db_con_commit (com_total=17, com_tx=14)

4 ETW000  [     dev trc,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0004).

4 ETW000 date&time: 15.03.2016 - 15:34:59

4 ETW000 108 warnings occured.

1 ETP153 DICTIONARY IMPORT

1 ETP110 end date and time   : "20160315153459"

1 ETP111 exit code           : "4"

1 ETP199 ######################################

4 EPU202XEND OF SECTION BEING ANALYZED END OF DDIC_UPG =====================================================

Now suggest if i retry directly SUM does it complete tp in next step ???

Regards

former_member185239
Active Contributor
0 Kudos

Hi Qazi,

Is your database is up and running?

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi

Yes DB is running r3trans output is 0000

If i retry SUM on this error then????

Regards

Former Member
0 Kudos

Hello Ashutosh,

Hope your are fine.

I am stucked on new step. Please help your suggestions are valuable.

Check this thread: