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: 

R3 Trans finished 0012

Go to solution
Former Member

on ‎06-03-2013 1:10 PM

0 Kudos

Hi All,

While upgrading ERP 6.0 EHP 6 ready system through SUM toll unexpectedly Database has been down.R3 trans -d finished RC=0012

C:\Users\devadm>r3trans -d

This is r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).

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).

R3 Trans LOg

4 ETW000 r3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 03.06.2013 - 17:38:17

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 Jun 03 17:38:17 2013                                                  92  0.000092

4 ETW000  [     dev trc,00000]  db_con_init called                                                        41  0.000133

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000                                                                                                  69  0.000202

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

4 ETW000                                                                                                  37  0.000239

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbsybslib.dll' ...                                    55  0.000319

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

4 ETW000                                                                                                 937  0.001256

4 ETW000  [     dev trc,00000]      using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll"               25  0.001281

4 ETW000  [     dev trc,00000]  Library 'dbsybslib.dll' loaded                                            26  0.001307

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbsybslib.dll                    30  0.001337

4 ETW000  [     dev trc,00000]  Version of 'dbsybslib.dll' is "720.00", patchlevel (0.430)               477  0.001814

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbsybslib.dll                   36  0.001850

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbsybslib.dll                  26  0.001876

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  35  0.001911

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                                                                                                  55  0.001966

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

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

4 ETW000                                                                                                  35  0.002026

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          22  0.002048

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                                                                                                  49  0.002097

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): reading connect info for connection R/3             23  0.002120

4 ETW000  [     dev trc,00000]  con_info_ext_support(): DBSL supports extended connect protocol           45  0.002165

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

4 ETW000  [     dev trc,00000]  con_info_ext_support(): auth/shadow_upgrade = undefined                   47  0.002212

4 ETW000                         ==> Using default key set to get connect info from ssfs

4 ETW000  [     dev trc,00000]  read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000                                                                                                 110  0.002322

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858]          64  0.002386

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000                                                                                                 121  0.002507

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]

4 ETW000                                                                                                1017  0.003524

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000                                                                                                 545  0.004069

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]

4 ETW000                                                                                                1199  0.005268

4 ETW000  [     dev trc,00000]  read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs

4 ETW000                                                                                                  43  0.005311

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    24  0.005335

4 ETW000  [     dev trc,00000]  read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000                                                                                                  34  0.005369

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858]          32  0.005401

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000                                                                                                 114  0.005515

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]

4 ETW000                                                                                                 868  0.006383

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000                                                                                                 517  0.006900

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 919]

4 ETW000                                                                                                 981  0.007881

4 ETW000  [     dev trc,00000]  read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs

4 ETW000                                                                                                  43  0.007924

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    23  0.007947

4 ETW000  [     dev trc,00000]  read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000                                                                                                  34  0.007981

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858]          32  0.008013

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000                                                                                                 114  0.008127

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\data\SSFS_DEV.DAT" opened for read [rsecssfs.c 2359]

4 ETW000                                                                                                 867  0.008994

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "\\KBINDEV01\sapmnt\DEV\SYS\global\security\rsecssfs\key\SSFS_DEV.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000                                                                                                 517  0.009511

4 ETW000  [     dev trc,00000]  RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]

4 ETW000                                                                                                 422  0.009933

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage) [rsecssfs.c 919]

4 ETW000                                                                                                 435  0.010368

4 ETW000  [     dev trc,00000]  read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage

4 ETW000                                                                                                  51  0.010419

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    24  0.010443

4 ETW000  [     dev trc,00000]  database is local: connect_timeout: 3                                 135554  0.145997

4 ETW000  [     dev trc,00000]  Thread ID:1820                                                            57  0.146054

4 ETW000  [     dev trc,00000]  lib_dbsl 720 05/22/2013 09:05:00                                          31  0.146085

4 ETW000  [     dev trc,00000]  720_EXT build                                                             24  0.146109

4 ETW000  [     dev trc,00000]  Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbsybslib.dll'

4 ETW000                                                                                                  53  0.146162

4 ETW000  [     dev trc,00000]  dbsybslib.dll patch info                                                  89  0.146251

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       25  0.146276

4 ETW000  [     dev trc,00000]    SAP patchno  430                                                        24  0.146300

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                           28  0.146328

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchno         430                                    29  0.146357

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchcomment SYB: Short dump -  SAPSQL_ARRAY_INSERT_DUPREC (1861476)

4 ETW000                                                                                                  43  0.146400

4 ETW000  [     dev trc,00000]  lpc:(local) connection used on KBINDEV01                                  60  0.146460

4 ETW000  [     dev trc,00000]  Mon Jun 03 17:38:18 2013                                              197916  0.344376

4 ETW000  [     dev trc,00000]  lpc:(local) connection used on KBINDEV01                                  45  0.344421

4 ETW000  [     dev trc,00000]  spid 40 comm rd ODBC                                                   95302  0.439723

4 ETW000  [     dev trc,00000]  spid 41 unc rd ODBC                                                      791  0.440514

4 ETW000  [     dev trc,00000]  Driver: Adaptive Server Enterprise Driver release: 15.7.0.105           1126  0.441640

4 ETW000  [     dev trc,00000]  Driver full version: Sybase ASE ODBC Driver/15.7.0/ESD#1/P/x86/Windows/drvmain/Build 105/32-bit/Normal/Wed Feb 15 UTC 18:35:16 2012

4 ETW000                                                                                                  93  0.441733

4 ETW000  [     dev trc,00000]  GetServerInfo version: Adaptive Server Enterprise/15.7.0/EBF 20076 SMP ESD#01 Refresh#1/P/X64/Windows Server/aseasap/2926/64-bit/OPT/Thu May 24 01:24:50 2012

4 ETW000                                                                                                 780  0.442513

4 ETW000  [     dev trc,00000]  GetServerInfo release: 15.7.0.012                                        800  0.443313

4 ETW000  [     dev trc,00000]  GetServerInfo architecture: x86_64                                        51  0.443364

4 ETW000  [     dev trc,00000]  GetServerInfo edition: P                                                  27  0.443391

4 ETW000  [     dev trc,00000]  GetServerInfo byte width: 64 bit                                          25  0.443416

4 ETW000  [     dev trc,00000]  ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 29662]

4 ETW000                                                                                                1688  0.445104

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DBPROPERTIES not found. Specify

4 ETW000                                                                                                  55  0.445159

4 ETW000  [     dev trc,00000]   owner.objectname or use sp_help to check whether the object exists (sp_help may

4 ETW000                                                                                                  41  0.445200

4 ETW000  [     dev trc,00000]   produce lots of output).                                                 24  0.445224

4 ETW000  [     dev trc,00000]  DbSlConnect hdl: 0                                                      1484  0.446708

4 ETW000  [     dev trc,00000]  trace file set                                                            67  0.446775

4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)                                       29  0.446804

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20185]                3585  0.450389

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]SVERS not found. Specify owner.

4 ETW000                                                                                                  74  0.450463

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  41  0.450504

4 ETW000  [     dev trc,00000]  e lots of output).                                                        24  0.450528

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT VERSION FROM SVERS                            36  0.450564

4 ETW000                        /* R3::0 T:SVERS */

4 ETW000  [    dblink  ,00000]  ***LOG BZA=>table SVERS      does not exist on database                   71  0.450635

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20185]                2043  0.452678

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000                                                                                                  61  0.452739

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  41  0.452780

4 ETW000  [     dev trc,00000]  e lots of output).                                                        22  0.452802

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT                                                          52  0.452854

4 ETW000  [     dev trc,00000]   */                                                                       38  0.452892

4 ETW000  [     dev trc,00000]  NTAB: SELECT COMPCNT, UNICODELG FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                 129  0.453021

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20185]                1671  0.454692

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000                                                                                                  60  0.454752

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  40  0.454792

4 ETW000  [     dev trc,00000]  e lots of output).                                                        22  0.454814

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT */                                                       50  0.454864

4 ETW000  [     dev trc,00000]   */                                                                       20  0.454884

4 ETW000  [     dev trc,00000]  NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' FAILED            28  0.454912

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20185]                1642  0.456554

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000                                                                                                  59  0.456613

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  41  0.456654

4 ETW000  [     dev trc,00000]  e lots of output).                                                        22  0.456676

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT */                                                       50  0.456726

4 ETW000  [     dev trc,00000]   */                                                                       20  0.456746

4 ETW000  [    dbntab.c,00000]  *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                  60  0.456806

4 ETW000  [    dbntab  ,00000]  ***LOG BZY=>unexpected return code 103        calling NTAB                38  0.456844

4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 2                            72  0.456916

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20185]                1670  0.458586

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000                                                                                                  59  0.458645

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  41  0.458686

4 ETW000  [     dev trc,00000]  e lots of output).                                                        21  0.458707

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT                                                          51  0.458758

4 ETW000  [     dev trc,00000]   */                                                                       20  0.458778

4 ETW000  [     dev trc,00000]  NTAB: SELECT COMPCNT, UNICODELG FROM XXXXT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                  46  0.458824

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20185]                1627  0.460451

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000                                                                                                  59  0.460510

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  41  0.460551

4 ETW000  [     dev trc,00000]  e lots of output).                                                        23  0.460574

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT */                                                       61  0.460635

4 ETW000  [     dev trc,00000]   */                                                                       21  0.460656

4 ETW000  [     dev trc,00000]  NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' FAILED            28  0.460684

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 20185]                1633  0.462317

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000                                                                                                  59  0.462376

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  40  0.462416

4 ETW000  [     dev trc,00000]  e lots of output).                                                        23  0.462439

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT */                                                       50  0.462489

4 ETW000  [     dev trc,00000]   */                                                                       21  0.462510

4 ETW000  [    dbntab.c,00000]  *** ERROR => NTAB: SELECT VERSION/DBASE FROM XXXXT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                  53  0.462563

4 ETW000  [    dbntab  ,00000]  ***LOG BZY=>unexpected return code 103        calling NTAB                36  0.462599

4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 2                            34  0.462633

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)                   4631  0.467264

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

former_member184473
Active Contributor
‎06-03-2013 6:44 PM
0 Kudos

Hello,

Ensure you have the following variables set for user <sid>adm:

dbs_syb_port = <port>

dbs_syb_schema = <schema>

dbs_syb_server = <server>

dbs_syb_dbname = <SID>

dbms_type = syb


Regards,

Eduardo Rezende

Show replies
Show replies
Former Member
‎06-07-2013 5:30 AM
0 Kudos

Hi All,

Requirement of SUM tool is DBSL 430 ,becuse of this issue DBSL 430,I have raised with this SAP,sap confimed me the issue becuse of DBSL.

THey will relse DBSL 431 soon

Answers (2)

Answers (2)

former_member185954
Active Contributor
‎06-03-2013 2:47 PM
0 Kudos

Hello,

You mentioned database is down while upgrading, if its down, R3trans won't be able to connect, what are you trying to do and what is the issue?

Regards,

Siddhesh

Show replies
Show replies
AtulKumarJain
Active Contributor
‎06-03-2013 1:22 PM
0 Kudos

Hi ,

Have you updated  kernel  ?

PLease check Note 1643080 and Note 1639578

Best Regrads,

Atul

Show replies
Show replies
Former Member
‎06-03-2013 1:28 PM
0 Kudos

I already upgraded kernel 721

AtulKumarJain
Active Contributor
‎06-03-2013 1:33 PM
0 Kudos

Please check those note.

former_member188883
Active Contributor
‎06-03-2013 2:07 PM
0 Kudos

Hi,

Incase your database is up and running, please check whether database schema is defined in the environment variables.

Regards,

Deepak Kori

Former Member
‎06-03-2013 2:16 PM
0 Kudos

Hi Deepak,

Env already set to SAPSR3

dbs_syb_schema=SAPSR3

Please sugegst any idea to resolve the issue

former_member188883
Active Contributor
‎06-03-2013 2:42 PM
0 Kudos

Hi ,

Based on SAP Note 1643080 - SYB: Database connect information for Sybase ASE

set the parameter value rsdb_ssfs_connect = 1

Hope this helps.

Regards,

Deepak Kori

Ask a Question