Skip to Content

R3trans error

I have an error with SUM

The errror is:

# /usr/sap/SLJ/SUM/abap/log/R710VPE.SLJ:
4 ETW000 > buffersync =yes
4 ETW000 > commit =1048576
4 ETW000 > importtruncated =yes
4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/SLJ/SUM/abap/tmp/R710VPE.SLJ -u 1 /usr/sap/SLJ/SUM/abap/tmp/PREIMPTRANS.CTL
4 ETW000 active unconditional modes: 1
2EETW000 sap_dext called with msgnr "4": 
2EETW000 ---- db call info ----
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len (char): 5
2EETW000 key: TADIR
2EETW000 retcode: 4


complete log :

4 EPU201XBEGIN OF SECTION BEING ANALYZED LASTOFFSET                 1018 NOW BEGIN OF PREIMP ===================
4 ETW000 R3trans version 6.26 (release 749 - 24.03.17 - 20:17:03).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000 
4 ETW000 date&time   : 06.02.2018 - 19:19:31
4 ETW000 control file: /usr/sap/SLJ/SUM/abap/tmp/PREIMPTRANS.CTL
4 ETW000 > import
4 ETW000 > file='/usr/sap/SLJ/SUM/abap/bin/R710VPE.SAP'
4 ETW000 > safeandslow=yes
4 ETW000 > buffersync =yes
4 ETW000 > commit     =1048576
4 ETW000 > importtruncated =yes
4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/SLJ/SUM/abap/tmp/R710VPE.SLJ -u 1 /usr/sap/SLJ/SUM/abap/tmp/PREIMPTRANS.CTL
4 ETW000 active unconditional modes: 1
2EETW000 sap_dext called with msgnr "4": 
2EETW000 ---- db call info ----
2EETW000 function:   db_ntab
2EETW000 fcode:      NT_RDTDESCR
2EETW000 tabname:    TADIR
2EETW000 len (char): 5
2EETW000 key:        TADIR
2EETW000 retcode:    4
4 ETW690 ROLLBACK "0" "0"
4 EPU202XEND OF SECTION BEING ANALYZED END OF PREIMP =======================================================




The xuser list:

solmanager:sljadm 139> xuser list
-----------------------------------------------------------------
XUSER Entry  1
--------------
Key           :DEFAULT
Username      :SAPSLJDB
UsernameUCS2  :S.A.P.S.L.J.D.B. . . . . . . . . . . . . . . . . . . . . . . . .
Password      :?????????
PasswordUCS2  :?????????
PasswordUTF8  :?????????
Dbname        :SLJ
Nodename      :solmanager
Sqlmode       :SAPR3
Cachelimit    :-1
Timeout       :0
Isolation     :0
Charset       :<unspecified>
-----------------------------------------------------------------
XUSER Entry  2
--------------
Key           :c_J2EE
Username      :CONTROL
UsernameUCS2  :C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .
Password      :?????????
PasswordUCS2  :?????????
PasswordUTF8  :?????????
Dbname        :SLJ
Nodename      :solmanager
Sqlmode       :SAPR3
Cachelimit    :-1
Timeout       :-1
Isolation     :-1
Charset       :<unspecified>
-----------------------------------------------------------------
XUSER Entry  3
--------------
Key           :w
Username      :SAPSLJ
UsernameUCS2  :S.A.P.S.L.J. . . . . . . . . . . . . . . . . . . . . . . . . . .
Password      :?????????
PasswordUCS2  :?????????
PasswordUTF8  :?????????
Dbname        :SLJ
Nodename      :solmanager
Sqlmode       :<unspecified>
Cachelimit    :-1
Timeout       :-1
Isolation     :-1
Charset       :<unspecified>
-----------------------------------------------------------------
XUSER Entry  4
--------------
Key           :c
Username      :CONTROL
UsernameUCS2  :C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .
Password      :?????????
PasswordUCS2  :?????????
PasswordUTF8  :?????????
Dbname        :SLJ
Nodename      :solmanager
Sqlmode       :<unspecified>
Cachelimit    :-1
Timeout       :-1
Isolation     :-1
Charset       :<unspecified>


This is a java instance of solution manager 7.2

sql_execute select * from users
END     
'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20170314';'00192516';'20170314';'00192516';'20170314';'00192516';'SLJ';'solmanager';0;'NO';(null)
'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20170314';'00192516';'20170314';'00192516';'20180206';'00103020';'SLJ';'solmanager';10;'NO';(null)
'SUPERDBA';'';'SAPSLJDB';'DBA';'MULTIPLE';(null);(null);(null);'UNICODE';'20170314';'00192538';'20170314';'00192538';'20170314';'00192538';'SLJ';'solmanager';27;'NO';(null)


 

Any idea?

Regards!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 08 at 12:53 AM

    Hi ,

    Can you attach the complete trans.log file?

    Also please do a quick xuser test:

    dbmcli -U w db_state

    or

    dbmcli -U w

    Best regards
    James

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 03:56 PM

    Hi

    R3trans -d complete log

    4 ETW000 R3trans version 6.26 (release 749 - 24.03.17 - 20:17:03).
    4 ETW000 unicode enabled version
    4 ETW000 ===============================================
    4 ETW000 
    4 ETW000 date&time   : 12.02.2018 - 16:49:27
    4 ETW000 control file: <no ctrlfile>
    4 ETW000 R3trans was called as follows: R3trans -d
    4 ETW000  trace at level 1 opened for a given file pointer
    4 ETW000  [     dev trc,00000]  Mon Feb 12 16:49:27 2018
    4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/SLJ/SYS/exe/run/dbsdbslib.so' ...
    4 ETW000  [     dev trc,00000]  Library '/usr/sap/SLJ/SYS/exe/run/dbsdbslib.so' loaded
    4 ETW000  [     dev trc,00000]  Version of '/usr/sap/SLJ/SYS/exe/run/dbsdbslib.so' is "749.05", patchlevel (0.401)
    4 ETW000  [     dev trc,00000]  DBSDBSLIB : version 749.05, patch 0.401 (Make PL 0.401)
    4 ETW000  [     dev trc,00000]  MAXDB shared library (dbsdbslib) patchlevels (last 10)
    4 ETW000  [     dev trc,00000]    (0.401) SAP Support Package Stack Kernel 7.49 Patch Level 401 (note 2573063)
    4 ETW000  [     dev trc,00000]    (0.400) SAP Support Package Stack Kernel 7.49 Patch Level 400 (note 2555639)
    4 ETW000  [     dev trc,00000]    (0.315) Avoid trunction on numeric datatypes (note 2346984)
    4 ETW000  [     dev trc,00000]    (0.301) SAP Support Package Stack Kernel 7.49 Patch Level 301 (note 2514637)
    4 ETW000  [     dev trc,00000]    (0.300) SAP Support Package Stack Kernel 7.49 Patch Level 300 (note 2494149)
    4 ETW000  [     dev trc,00000]    (0.215) SQLDBC_SUCCESS_WITH_INFO and duplicate handling (note 2459473)
    4 ETW000  [     dev trc,00000]    (0.210) Hint SUBSTITUTE_LITERALS corrected (note 2431643)
    4 ETW000  [     dev trc,00000]    (0.200) SAP Support Package Stack Kernel 7.49 Patch Level 200 (note 2435328)
    4 ETW000  [     dev trc,00000]    (0.101) SAP Support Package Stack Kernel 7.49 Patch Level 101 (note 2407681)
    4 ETW000  [     dev trc,00000]    (0.100) SAP Support Package Stack Kernel 7.49 Patch Level 100 (note 2384355)
    4 ETW000  [     dev trc,00000]  
    4 ETW000  [     dev trc,00000]  Loading SQLDBC client runtime (pid=29850)...
    4 ETW000  [     dev trc,00000]  SQLDBC Module  : /sapdb/clients/SLJ/lib/libSQLDBC77.so
    4 ETW000  [     dev trc,00000]  SQLDBC SDK     : SQLDBC.H  7.9.8    BUILD 031-123-252-954
    4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBC 7.9.8    BUILD 035-123-254-630
    4 ETW000  [     dev trc,00000]  SQLDBC client runtime is 7.9.8.035 CL 254630
    4 ETW000  [     dev trc,00000]  SQLDBC supports VARIABLE OUTPUT data  : 1
    4 ETW000  [     dev trc,00000]  SQLDBC supports BATCH STREAM          : 1
    4 ETW000  [     dev trc,00000]  SQLDBC supports BULK SELECT with LOBS : 1
    4 ETW000  [     dev trc,00000]  INFO : SQLOPT= -I 0 -t 0 -S SAPR3
    4 ETW000  [     dev trc,00000]  Try to connect (DEFAULT) on connection 0 ...
    4 ETW000  [     dev trc,00000]  Attach to SAP DB : Kernel    7.9.09   Build 004-123-257-835
    4 ETW000  [     dev trc,00000]  Database release is MaxDB 7.9.09.004
    4 ETW000  [     dev trc,00000]  INFO : Database 'SLJ' instance is running on 'solmanager'
    4 ETW000  [     dev trc,00000]  INFO : Connect to DB as 'SAPSLJDB', session=109821, task=59
    4 ETW000  [     dev trc,00000]  DB max. input host variables  : 2000
    4 ETW000  [     dev trc,00000]  DB max. statement length      : 1048576
    4 ETW000  [     dev trc,00000]  DB max. array size            : 100000
    4 ETW000  [     dev trc,00000]  DB supports UPSERT SQL syntax : 1
    4 ETW000  [     dev trc,00000]  DB supports LOB locators      : 1
    4 ETW000  [     dev trc,00000]  UPSERT is disabled for : WBCROSSGT
    4 ETW000  [     dev trc,00000]  use IGNORE DUPLICATES
    4 ETW000  [     dev trc,00000]  use DBSL marker map
    4 ETW000  [     dev trc,00000]  INFO : SAP DB Comm_Size = 126976
    4 ETW000  [     dev trc,00000]  INFO : SAP DB MaxLocks = 1200000
    4 ETW000  [     dev trc,00000]  INFO : DBSL buffer size = 126976
    4 ETW000  [     dev trc,00000]  Command info enabled
    4 ETW000  [     dev trc,00000]  Now I'm connected to MaxDB
    4 ETW000  [     dev trc,00000]  00: solmanager-SLJ, since=20180212164927, ABAP= <unknown> (0)
    4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)
    4 ETW000  [dbsdbsql.cpp,00000]  *** ERROR =>   prepare() of C_0000, rc=1, rcSQL=-942
    4 ETW000  [dbslsdb.cpp ,00000]  *** ERROR => PREPARE C_0000 on connection 0, rc=-942
    4 ETW000  [     dev trc,00000]  SQLCODE    : -942
    4 ETW000  [     dev trc,00000]  SQLERRTEXT : POS(28) Unknown table name:SVERS
    4 ETW000  [     dev trc,00000]  sc_p=7f04cacea020,no=0,idc_p=(nil),con=0,act=0,slen=34,smax=256,#vars=0,stmt=27a1390,table=SVERS                         
    4 ETW000  [     dev trc,00000]  SELECT VERSION INTO ? FROM SVERS  ;
    4 ETW000  [    dblink  ,00000]  ***LOG BZA=>table SVERS does not exist on database           
    4 ETW000  [dbsdbsql.cpp,00000]  *** ERROR =>   prepare() of C_0000, rc=1, rcSQL=-942
    4 ETW000  [dbslsdb.cpp ,00000]  *** ERROR => PREPARE C_0000 on connection 0, rc=-942
    4 ETW000  [     dev trc,00000]  SQLCODE    : -942
    4 ETW000  [     dev trc,00000]  SQLERRTEXT : POS(16) Unknown table name:DDNTT
    4 ETW000  [     dev trc,00000]  sc_p=7f04cacea020,no=0,idc_p=(nil),con=0,act=0,slen=46,smax=256,#vars=0,stmt=27a1390,table=DDNTT                         
    4 ETW000  [     dev trc,00000]  SELECT * FROM "DDNTT" WHERE TABNAME = 'SVERS' ;
    4 ETW000  [dbntab.c    ,00000]  *** ERROR => NTAB: get_ntab_db_structure(): ddntt_column_check() returned dbsl error 103
    4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 4
    4 ETW000  [dbsdbsql.cpp,00000]  *** ERROR =>   prepare() of C_0000, rc=1, rcSQL=-942
    4 ETW000  [dbslsdb.cpp ,00000]  *** ERROR => PREPARE C_0000 on connection 0, rc=-942
    4 ETW000  [     dev trc,00000]  SQLCODE    : -942
    4 ETW000  [     dev trc,00000]  SQLERRTEXT : POS(16) Unknown table name:XXXXT
    4 ETW000  [     dev trc,00000]  sc_p=7f04cacea020,no=0,idc_p=(nil),con=0,act=0,slen=46,smax=256,#vars=0,stmt=27a1390,table=XXXXT                         
    4 ETW000  [     dev trc,00000]  SELECT * FROM "XXXXT" WHERE TABNAME = 'SVERS' ;
    4 ETW000  [dbntab.c    ,00000]  *** ERROR => NTAB: get_ntab_db_structure(): ddntt_column_check() returned dbsl error 103
    4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 4
    2EETW000 sap_dext called with msgnr "4": 
    2EETW000 ---- db call info ----
    2EETW000 function:   db_ntab
    2EETW000 fcode:      NT_RDTDESCR
    2EETW000 tabname:    TADIR
    2EETW000 len (char): 5
    2EETW000 key:        TADIR
    2EETW000 retcode:    4
    4 ETW690 ROLLBACK "0" "0"
    

    Software Update Manager error

    Severe error(s) occurred in phase PREP_EXTRACT/PREIMP!
    Last error code set:
    Single errors (code <= 8) found in logfile 'PREIMP.ELG'
    
    
    
    
    
    
    ERROR:Detected the following errors:
    # /usr/sap/SLJ/SUM/abap/log/R710VPE.SLJ:4 ETW000 > buffersync =yes4 ETW000 > commit =10485764 ETW000 > importtruncated =yes4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/SLJ/SUM/abap/tmp/R710VPE.SLJ -u 1 /usr/sap/SLJ/SUM/abap/tmp/PREIMPTRANS.CTL4 ETW000 active unconditional modes: 12EETW000 sap_dext called with msgnr "4": 2EETW000 ---- db call info ----2EETW000 function: db_ntab2EETW000 fcode: NT_RDTDESCR2EETW000 tabname: TADIR2EETW000 len (char): 52EETW000 key: TADIR2EETW000 retcode: 4
    
    
    
    Trouble Ticket Generation
    
    
    
    
    

    Complete /usr/sap/SLJ/SUM/abap/log/R710VPE.SLJ log

    4 EPU202X====MARK ANALYZED SECTION==== END OF PREIMP ================== BEGIN OF PREIMP ====================
    4 ETW000 R3trans version 6.26 (release 749 - 24.03.17 - 20:17:03).
    4 ETW000 unicode enabled version
    4 ETW000 ===============================================
    4 ETW000 
    4 ETW000 date&time   : 12.02.2018 - 16:48:28
    4 ETW000 control file: /usr/sap/SLJ/SUM/abap/tmp/PREIMPTRANS.CTL
    4 ETW000 > import
    4 ETW000 > file='/usr/sap/SLJ/SUM/abap/bin/R710VPE.SAP'
    4 ETW000 > safeandslow=yes
    4 ETW000 > buffersync =yes
    4 ETW000 > commit     =1048576
    4 ETW000 > importtruncated =yes
    4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/SLJ/SUM/abap/tmp/R710VPE.SLJ -u 1 /usr/sap/SLJ/SUM/abap/tmp/PREIMPTRANS.CTL
    4 ETW000 active unconditional modes: 1
    2EETW000 sap_dext called with msgnr "4": 
    2EETW000 ---- db call info ----
    2EETW000 function:   db_ntab
    2EETW000 fcode:      NT_RDTDESCR
    2EETW000 tabname:    TADIR
    2EETW000 len (char): 5
    2EETW000 key:        TADIR
    2EETW000 retcode:    4
    4 ETW690 ROLLBACK "0" "0"
    4 EPU202XEND OF SECTION BEING ANALYZED END OF PREIMP =======================================================
    
    
    

    solmanager:sljadm 61> dbmcli -U w db_state

    Error! Connection failed to node solmanager for database SLJ:
    -24950,ERR_USRFAIL: User authorization failed

    Regards!!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13 at 05:23 AM

    trans.log =>
    4 ETW000 [ dev trc,00000] Now I'm connected to MaxDB

    4 ETW000  [     dev trc,00000]00: solmanager-SLJ, since=20180212164927,ABAP=<unknown>(0)4 ETW000  [     dev trc,00000]Connection0 opened (DBSL handle0)4 ETW000  [dbsdbsql.cpp,00000]*** ERROR =>prepare()of C_0000,rc=1, rcSQL=-9424 ETW000  [dbslsdb.cpp ,00000]*** ERROR =>PREPARE C_0000 onconnection0,rc=-9424 ETW000  [     dev trc,00000]  SQLCODE    :-9424 ETW000  [     dev trc,00000]  SQLERRTEXT :POS(28) Unknown tablename:SVERS
    4 ETW000  [     dev trc,00000]  sc_p=7f04cacea020,no=0,idc_p=(nil),con=0,act=0,slen=34,smax=256,#vars=0,stmt=27a1390,table=SVERS                          

    4 ETW000 [ dev trc,00000]SELECTVERSIONINTO?FROM SVERS ;

    Is it JAVA system?
    Because according to the trace, SAPSLJDB user is used to connect database.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded