R3trans error

[angel_trevejo1]

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!

[former_member209962]

Hi,

Did you able to resolve this issue??

Please share ..

Thanks

Tabrayz

[JamesZ]

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

[angel_trevejo1]

Hi

Yes, This is a java instance of solution manager 7.2

The instance start-up without problem but i can not do an update with SUM

[JamesZ]

hmm, if it is JAVA, then it is design that "R3trans -d" is not working for java.

Are you using the latest SUM? Because I think "R3trans -w ..." should not be called by SUM as well since this is JAVA system. Can you please share several other traces?

[angel_trevejo1]

Hi James

That was also my thought

I'm using Software Update Manager 1.0 SP21 (PL6) version.

Java Kernel Version:7.40.3301.399480.20160316104215

--------------------
disp+work information
--------------------


kernel release                749
kernel make variant           749_REL
compiled on                   Linux GNU SLES-11 x86_64 cc4.8.5 use-pr171202 for linuxx86_64
compiled for                  64 BIT
compilation mode              UNICODE
compile time                  Dec  2 2017 21:35:12


Tue Feb 13 11:57:36 2018
Loading DB library '/usr/sap/SLJ/SYS/exe/run/dbsdbslib.so' ...
Library '/usr/sap/SLJ/SYS/exe/run/dbsdbslib.so' loaded
Version of '/usr/sap/SLJ/SYS/exe/run/dbsdbslib.so' is "749.05", patchlevel (0.401)


<br>

Regards!

[JamesZ]

looks like already the latest SUM, can you please share other traces? Maybe we can get more info then.

[angel_trevejo1]

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 <= 😎 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!!

[JamesZ]

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