cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

error during Support pack import sap nw 7.01

Former Member

on ‎11-20-2012 8:08 AM

0 Kudos

Hi,

during import i got stuck at Import phase:    DDIC_ACTIVATION ,if i run it again as background job it get scheduled and get finished successfully.

I also checked notes related to those but could not correct,

1) should i import note by resting status of queue,

2)during implementing note-it shows object locked by ocs_...

kindly suggest,any log need to be posted ??

Thanks & Regards,

Rohidass

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
‎11-27-2012 7:13 PM
0 Kudos

Thanks to all of you,

corrected error  with ref to sap note,related to ops$...

Thanks & Regards,

Rohit

Show replies
Show replies
Former Member
‎11-26-2012 10:18 AM
0 Kudos

trans.log

4 ETW000 R3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 21.11.2012 - 11:44:47

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000  [     dev trc,00000]  Wed Nov 21 11:44:47 2012                                                 144  0.000144

4 ETW000  [     dev trc,00000]  db_con_init called                                                        45  0.000189

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        46  0.000235

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                 136  0.000371

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dboraslib.dll' ...                                    26  0.000416

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

4 ETW000                                                                                                 326  0.000742

4 ETW000  [     dev trc,00000]      using "E:\usr\sap\BPC\SYS\exe\uc\NTAMD64\dboraslib.dll"                9  0.000751

4 ETW000  [     dev trc,00000]  Library 'dboraslib.dll' loaded                                            10  0.000761

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dboraslib.dll                    11  0.000772

4 ETW000  [     dev trc,00000]  Version of 'dboraslib.dll' is "720.00", patchlevel (0.215)                85  0.000857

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dboraslib.dll                   13  0.000870

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dboraslib.dll                  20  0.000890

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  37  0.000927

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  26  0.000953

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

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  15  0.000978

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                           9  0.000987

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  21  0.001008

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', userid='[default usr]')

4 ETW000                                                                                                  26  0.001034

4 ETW000  [     dev trc,00000]  DIR_CLIENT_ORAHOME is not set as profile nor env. parameter.             471  0.001505

4 ETW000                        Assuming using instant client with unspecified location.

4 ETW000  [     dev trc,00000]  Register application info.                                               150  0.001655

4 ETW000  [     dev trc,00000]  Oracle client version: 10.2.0.5.0, (dbsl 720 220612, UNICODE[2])       22410  0.024065

4 ETW000  [     dev trc,00000]  Detailed Oracle client (patch) info not available.                        23  0.024088

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='BPC'                                      81  0.024169

4 ETW000  [     dev trc,00000]  -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2

4 ETW000                                                                                                  29  0.024198

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000                                                                                                3884  0.028082

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=02892310)                 88  0.028170

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=02895AD8)                 57  0.028227

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=41004D00450052004900430041004E00                 241  0.028468

4 ETW000  [     dev trc,00000]                     terr=41004D0045005200490043004100                      20  0.028488

4 ETW000  [     dev trc,00000]                     char=55005400460031003600                              12  0.028500

4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000                                                                                                  17  0.028517

4 ETW000  [     dev trc,00000]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE                      13  0.028530

4 ETW000  [     dev trc,00000]  Logon as OPS$-user to get SAPSR3's password                               19  0.028549

4 ETW000  [     dev trc,00000]  Connecting as /@BPC on connection 0 (nls 0) ... (dbsl 720 220612, UNICODE[2])

4 ETW000                                                                                                  17  0.028566

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=02895998)                32  0.028598

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          14  0.028612

4 ETW000  [     dev trc,00000]  Attaching to database server BPC (con=0, svchp=02895998, srvhp=02896218)

4 ETW000                                                                                                 161  0.028773

4 ETW000  [     dev trc,00000]  Assigning server context 02896218 to service context 02895998          27252  0.056025

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=028A4B70)               53  0.056078

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='/', svc=02895998, srv=02896218, usr=028A4B70)

4 ETW000                                                                                                  22  0.056100

4 ETW000  [     dev trc,00000]  Assigning user session 028A4B70 to service context 02895998            18111  0.074211

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected                          55  0.074266

4 ETW000  [     dev trc,00000]  -->oci_prepare_stmt(con=0,len=39,stp=028A1BB8)                            16  0.074282

4 ETW000  [     dev trc,00000]         SELECT SID FROM V$MYSTAT WHERE ROWNUM<2                                                                                  

4 ETW000                                                                                                  76  0.074358

4 ETW000  [     dev trc,00000]  -  oci_define  ( 0: SQLT_INT , l=  4, con=0, stp=028A1BB8, pv=0202E970, in=0202E974,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  71  0.074429

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected, new transaction         32  0.074461

4 ETW000  [     dev trc,00000]  -->oci_execute_stmt(#1: con=0,stp=028A1BB8,itr=1,off=0,bat=0)             15  0.074476

4 ETW000  [     dev trc,00000]  before OCIStmtExecute(svchp=02895998, errhp=02892310): [dur. 0,000s]

4 ETW000                                                                                                  86  0.074562

4 ETW000  [     dev trc,00000]  after  OCIStmtExecute(rpc=0): [dur. 0,000s]                              452  0.075014

4 ETW000  [     dev trc,00000]  <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s]               19  0.075033

4 ETW000  [     dev trc,00000]  Now '/@BPC' is connected: con=0, nls=0, session=149, time='2012-11-21 11:44:47'

4 ETW000                                                                                                  33  0.075066

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected                          17  0.075083

4 ETW000  [     dev trc,00000]  -->oci_prepare_stmt(con=0,len=33,stp=028A1BB8)                            12  0.075095

4 ETW000  [     dev trc,00000]         ALTER SESSION SET NLS_SORT=BINARY                                                                                        

4 ETW000                                                                                                  19  0.075114

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected, new transaction         22  0.075136

4 ETW000  [     dev trc,00000]  -->oci_execute_stmt(#2: con=0,stp=028A1BB8,itr=1,off=0,bat=0)             14  0.075150

4 ETW000  [     dev trc,00000]  before OCIStmtExecute(svchp=02895998, errhp=02892310): [dur. 0,000s]

4 ETW000                                                                                                  17  0.075167

4 ETW000  [     dev trc,00000]  after  OCIStmtExecute(rpc=0): [dur. 0,000s]                              265  0.075432

4 ETW000  [     dev trc,00000]  <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s]               18  0.075450

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected                          28  0.075478

4 ETW000  [     dev trc,00000]  -->oci_prepare_stmt(con=0,len=59,stp=028A1BB8)                            13  0.075491

4 ETW000  [     dev trc,00000]         SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)                                                              

4 ETW000                                                                                                  24  0.075515

4 ETW000  [     dev trc,00000]  -  oci_bind    ( 0: SQLT_STR , l=256, con=0, stp=028A1BB8, pv=0202EDE0, in=0000NULL,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  42  0.075557

4 ETW000  [     dev trc,00000]  -  oci_bind    ( 1: SQLT_STR , l=256, con=0, stp=028A1BB8, pv=0202E890, in=0000NULL,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  38  0.075595

4 ETW000  [     dev trc,00000]  -  oci_define  ( 0: SQLT_STR , l=512, con=0, stp=028A1BB8, pv=0202EA90, in=0202E3FC,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  26  0.075621

4 ETW000  [     dev trc,00000]  -  oci_define  ( 1: SQLT_AFC , l=512, con=0, stp=028A1BB8, pv=0202E690, in=0202E3F4,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  25  0.075646

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected, new transaction         18  0.075664

4 ETW000  [     dev trc,00000]  -->oci_execute_stmt(#3: con=0,stp=028A1BB8,itr=1,off=0,bat=0)             12  0.075676

4 ETW000  [     dev trc,00000]  before OCIStmtExecute(svchp=02895998, errhp=02892310): [dur. 0,000s]

4 ETW000                                                                                                  18  0.075694

4 ETW000  [     dev trc,00000]  OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data          344  0.076038

4 ETW000  [     dev trc,00000]     -> rc=1403=OCI_ERR_NOT_FOUND                                           16  0.076054

4 ETW000  [     dev trc,00000]  after  OCIStmtExecute(rpc=0): [dur. 0,000s]                               44  0.076098

4 ETW000  [     dev trc,00000]  <--oci_execute_stmt(rc=1403, iters-errors = 1-0) [dur. 0,000s]            15  0.076113

4 ETW000  [    dbsloci.,00000]  *** ERROR => ORA-1403 when accessing table SAPUSER                        27  0.076140

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL code 1403                                           12  0.076152

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1403)                                        10  0.076162

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1403                                    71  0.076233

4 ETW000  [     dev trc,00000]     ORA-01403: no data found                                                                                                 

4 ETW000                                                                                                  25  0.076258

4 ETW000  [     dev trc,00000]  Disconnecting from connection 0 ...                                       13  0.076271

4 ETW000  [     dev trc,00000]  Rolling back transaction                                                  15  0.076286

4 ETW000  [     dev trc,00000]  Closing user session (con=0, svc=02895998, usr=028A4B70)                 193  0.076479

4 ETW000  [     dev trc,00000]  Disconnected (con=0) from ORACLE.                                        337  0.076816

4 ETW000  [     dev trc,00000]  Info: 99=DBSL_ERR_DB, oerr=1403, try to connect with default password.

4 ETW000                                                                                                  22  0.076838

4 ETW000  [     dev trc,00000]  Connecting as SAPSR3/<pwd>@BPC on connection 0 (nls 0) ... (dbsl 720 220612, UNICODE[2])

4 ETW000                                                                                                  18  0.076856

4 ETW000  [     dev trc,00000]  Assigning username to user session: con=0, usrhp= 028A4B70                13  0.076869

4 ETW000  [     dev trc,00000]  Assigning password to user session: con=0, usrhp=028A4B70                 22  0.076891

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=02895998, srv=02896218, usr=028A4B70)

4 ETW000                                                                                                  92  0.076983

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR                4641  0.081624

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:               76  0.081700

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                       

4 ETW000                                                                                                  79  0.081779

4 ETW000  [    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '1017'                         19  0.081798

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 1017                                     10  0.081808

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1017)                                        10  0.081818

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1017                                    63  0.081881

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                       

4 ETW000                                                                                                  20  0.081901

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            11  0.081912

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 1017   performing CON                               62  0.081974

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied            17  0.081991

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'BPC'"

Show replies
Show replies
Former Member
‎11-26-2012 12:29 PM
0 Kudos

You need to repair SAP password of SAP owner user with
brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

The ORA-1403 is risen when the SAPUSER table of the ops$user is there but does not contain a row with the schema set in the environment in the userid-column.

Regards,

Roman

Former Member
‎11-26-2012 10:18 AM
0 Kudos

trans.log

4 ETW000 R3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 21.11.2012 - 11:44:47

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000  [     dev trc,00000]  Wed Nov 21 11:44:47 2012                                                 144  0.000144

4 ETW000  [     dev trc,00000]  db_con_init called                                                        45  0.000189

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        46  0.000235

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                 136  0.000371

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dboraslib.dll' ...                                    26  0.000416

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

4 ETW000                                                                                                 326  0.000742

4 ETW000  [     dev trc,00000]      using "E:\usr\sap\BPC\SYS\exe\uc\NTAMD64\dboraslib.dll"                9  0.000751

4 ETW000  [     dev trc,00000]  Library 'dboraslib.dll' loaded                                            10  0.000761

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dboraslib.dll                    11  0.000772

4 ETW000  [     dev trc,00000]  Version of 'dboraslib.dll' is "720.00", patchlevel (0.215)                85  0.000857

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dboraslib.dll                   13  0.000870

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dboraslib.dll                  20  0.000890

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  37  0.000927

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  26  0.000953

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

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  15  0.000978

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                           9  0.000987

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  21  0.001008

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', userid='[default usr]')

4 ETW000                                                                                                  26  0.001034

4 ETW000  [     dev trc,00000]  DIR_CLIENT_ORAHOME is not set as profile nor env. parameter.             471  0.001505

4 ETW000                        Assuming using instant client with unspecified location.

4 ETW000  [     dev trc,00000]  Register application info.                                               150  0.001655

4 ETW000  [     dev trc,00000]  Oracle client version: 10.2.0.5.0, (dbsl 720 220612, UNICODE[2])       22410  0.024065

4 ETW000  [     dev trc,00000]  Detailed Oracle client (patch) info not available.                        23  0.024088

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='BPC'                                      81  0.024169

4 ETW000  [     dev trc,00000]  -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2

4 ETW000                                                                                                  29  0.024198

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000                                                                                                3884  0.028082

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=02892310)                 88  0.028170

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=02895AD8)                 57  0.028227

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=41004D00450052004900430041004E00                 241  0.028468

4 ETW000  [     dev trc,00000]                     terr=41004D0045005200490043004100                      20  0.028488

4 ETW000  [     dev trc,00000]                     char=55005400460031003600                              12  0.028500

4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000                                                                                                  17  0.028517

4 ETW000  [     dev trc,00000]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE                      13  0.028530

4 ETW000  [     dev trc,00000]  Logon as OPS$-user to get SAPSR3's password                               19  0.028549

4 ETW000  [     dev trc,00000]  Connecting as /@BPC on connection 0 (nls 0) ... (dbsl 720 220612, UNICODE[2])

4 ETW000                                                                                                  17  0.028566

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=02895998)                32  0.028598

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          14  0.028612

4 ETW000  [     dev trc,00000]  Attaching to database server BPC (con=0, svchp=02895998, srvhp=02896218)

4 ETW000                                                                                                 161  0.028773

4 ETW000  [     dev trc,00000]  Assigning server context 02896218 to service context 02895998          27252  0.056025

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=028A4B70)               53  0.056078

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='/', svc=02895998, srv=02896218, usr=028A4B70)

4 ETW000                                                                                                  22  0.056100

4 ETW000  [     dev trc,00000]  Assigning user session 028A4B70 to service context 02895998            18111  0.074211

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected                          55  0.074266

4 ETW000  [     dev trc,00000]  -->oci_prepare_stmt(con=0,len=39,stp=028A1BB8)                            16  0.074282

4 ETW000  [     dev trc,00000]         SELECT SID FROM V$MYSTAT WHERE ROWNUM<2                                                                                  

4 ETW000                                                                                                  76  0.074358

4 ETW000  [     dev trc,00000]  -  oci_define  ( 0: SQLT_INT , l=  4, con=0, stp=028A1BB8, pv=0202E970, in=0202E974,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  71  0.074429

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected, new transaction         32  0.074461

4 ETW000  [     dev trc,00000]  -->oci_execute_stmt(#1: con=0,stp=028A1BB8,itr=1,off=0,bat=0)             15  0.074476

4 ETW000  [     dev trc,00000]  before OCIStmtExecute(svchp=02895998, errhp=02892310): [dur. 0,000s]

4 ETW000                                                                                                  86  0.074562

4 ETW000  [     dev trc,00000]  after  OCIStmtExecute(rpc=0): [dur. 0,000s]                              452  0.075014

4 ETW000  [     dev trc,00000]  <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s]               19  0.075033

4 ETW000  [     dev trc,00000]  Now '/@BPC' is connected: con=0, nls=0, session=149, time='2012-11-21 11:44:47'

4 ETW000                                                                                                  33  0.075066

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected                          17  0.075083

4 ETW000  [     dev trc,00000]  -->oci_prepare_stmt(con=0,len=33,stp=028A1BB8)                            12  0.075095

4 ETW000  [     dev trc,00000]         ALTER SESSION SET NLS_SORT=BINARY                                                                                        

4 ETW000                                                                                                  19  0.075114

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected, new transaction         22  0.075136

4 ETW000  [     dev trc,00000]  -->oci_execute_stmt(#2: con=0,stp=028A1BB8,itr=1,off=0,bat=0)             14  0.075150

4 ETW000  [     dev trc,00000]  before OCIStmtExecute(svchp=02895998, errhp=02892310): [dur. 0,000s]

4 ETW000                                                                                                  17  0.075167

4 ETW000  [     dev trc,00000]  after  OCIStmtExecute(rpc=0): [dur. 0,000s]                              265  0.075432

4 ETW000  [     dev trc,00000]  <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s]               18  0.075450

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected                          28  0.075478

4 ETW000  [     dev trc,00000]  -->oci_prepare_stmt(con=0,len=59,stp=028A1BB8)                            13  0.075491

4 ETW000  [     dev trc,00000]         SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)                                                              

4 ETW000                                                                                                  24  0.075515

4 ETW000  [     dev trc,00000]  -  oci_bind    ( 0: SQLT_STR , l=256, con=0, stp=028A1BB8, pv=0202EDE0, in=0000NULL,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  42  0.075557

4 ETW000  [     dev trc,00000]  -  oci_bind    ( 1: SQLT_STR , l=256, con=0, stp=028A1BB8, pv=0202E890, in=0000NULL,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  38  0.075595

4 ETW000  [     dev trc,00000]  -  oci_define  ( 0: SQLT_STR , l=512, con=0, stp=028A1BB8, pv=0202EA90, in=0202E3FC,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  26  0.075621

4 ETW000  [     dev trc,00000]  -  oci_define  ( 1: SQLT_AFC , l=512, con=0, stp=028A1BB8, pv=0202E690, in=0202E3F4,rl=0000NULL,rc=0000NULL)

4 ETW000                                                                                                  25  0.075646

4 ETW000  [     dev trc,00000]     time 2012-11-21 11:44:47, con=0 not connected, new transaction         18  0.075664

4 ETW000  [     dev trc,00000]  -->oci_execute_stmt(#3: con=0,stp=028A1BB8,itr=1,off=0,bat=0)             12  0.075676

4 ETW000  [     dev trc,00000]  before OCIStmtExecute(svchp=02895998, errhp=02892310): [dur. 0,000s]

4 ETW000                                                                                                  18  0.075694

4 ETW000  [     dev trc,00000]  OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data          344  0.076038

4 ETW000  [     dev trc,00000]     -> rc=1403=OCI_ERR_NOT_FOUND                                           16  0.076054

4 ETW000  [     dev trc,00000]  after  OCIStmtExecute(rpc=0): [dur. 0,000s]                               44  0.076098

4 ETW000  [     dev trc,00000]  <--oci_execute_stmt(rc=1403, iters-errors = 1-0) [dur. 0,000s]            15  0.076113

4 ETW000  [    dbsloci.,00000]  *** ERROR => ORA-1403 when accessing table SAPUSER                        27  0.076140

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL code 1403                                           12  0.076152

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1403)                                        10  0.076162

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1403                                    71  0.076233

4 ETW000  [     dev trc,00000]     ORA-01403: no data found                                                                                                 

4 ETW000                                                                                                  25  0.076258

4 ETW000  [     dev trc,00000]  Disconnecting from connection 0 ...                                       13  0.076271

4 ETW000  [     dev trc,00000]  Rolling back transaction                                                  15  0.076286

4 ETW000  [     dev trc,00000]  Closing user session (con=0, svc=02895998, usr=028A4B70)                 193  0.076479

4 ETW000  [     dev trc,00000]  Disconnected (con=0) from ORACLE.                                        337  0.076816

4 ETW000  [     dev trc,00000]  Info: 99=DBSL_ERR_DB, oerr=1403, try to connect with default password.

4 ETW000                                                                                                  22  0.076838

4 ETW000  [     dev trc,00000]  Connecting as SAPSR3/<pwd>@BPC on connection 0 (nls 0) ... (dbsl 720 220612, UNICODE[2])

4 ETW000                                                                                                  18  0.076856

4 ETW000  [     dev trc,00000]  Assigning username to user session: con=0, usrhp= 028A4B70                13  0.076869

4 ETW000  [     dev trc,00000]  Assigning password to user session: con=0, usrhp=028A4B70                 22  0.076891

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=02895998, srv=02896218, usr=028A4B70)

4 ETW000                                                                                                  92  0.076983

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR                4641  0.081624

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:               76  0.081700

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                       

4 ETW000                                                                                                  79  0.081779

4 ETW000  [    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '1017'                         19  0.081798

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 1017                                     10  0.081808

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1017)                                        10  0.081818

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1017                                    63  0.081881

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                       

4 ETW000                                                                                                  20  0.081901

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            11  0.081912

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 1017   performing CON                               62  0.081974

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied            17  0.081991

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'BPC'"

Show replies
Show replies
premsukh_bishnoi
Contributor
‎11-24-2012 7:21 PM
0 Kudos

Hello,

Please implement correction from note manually by editing corresponding program/class.

Regards, Premsukh

Show replies
Show replies
former_member189797
Active Contributor
‎11-20-2012 9:25 AM
0 Kudos

Hello Rohi,

Could you please provide the error message from the log.

Regards,

Gaurav

Show replies
Show replies
Former Member
‎11-20-2012 12:04 PM
0 Kudos

if you have to implement any note in the middle of upgrade then only way is to make changes at program level.You'd need developer key access for that.

Former Member
‎11-20-2012 9:04 AM
0 Kudos

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

Import phase 'DDIC_ACTIVATION' (20.11.2012, 13:44:06)

Error during executing the tp command 'tp ACT ALL sid ...'

tp return code: '0008' , tp message: 'A tool used by tp produced errors' , tp output:

   This is tp version 380.04.07 (release 720, unicode enabled)

   standard output from tp and from tools called by tp:

Details of the error situation can also be found in the import logs

Abort the import due to an error situation (20.11.2012, 13:44:12)

----------------------error portion in log ---

Show replies
Show replies
Former Member
‎11-20-2012 9:22 AM
0 Kudos

paste the error logs for

trans.log

also try getting a latest Tp, r3trans from SMP compatible to your verison.

Former Member
‎11-20-2012 9:27 AM
0 Kudos

Hi,

Give trans.log and slog file and log of import queue.

Thanks,

Venkat

Ask a Question