SAP Knowledge Base Article - Preview

3274981 - SUM DMO error of phase PREP_EXTRACT/PREIMP - SAP ASE

Symptom

  • You are using SUM DMO option to migrate source SAP ASE DB to target SAP HANA DB, based on java only system.
  • Below error is seen at phase PREP_EXTRACT/PREIMP:
    1 ETQ201 Entering upgrade-phase "PREP_EXTRACT/PREIMP"
    2 ETQ367 Connect variables are set for standard instance access
    4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'
    1 ETQ200 Executing actual phase 'PREP_EXTRACT/PREIMP'.
    1 ETQ399 Phase arguments:
    2 ETQ399 Arg[0] = 'R710VPT.SAP'
    2 ETQ399 Arg[1] = 'R710VPE.SAP'
    1 ETQ399 Using error summary log 'PREIMP.ELG'.
    3 ETQ399 Creating R3trans control file '/usr/sap/SID/SUM/abap/tmp/PREIMPTRANS.CTL':
    4 ETQ399 >>> import
    4 ETQ399 >>> file='/usr/sap/SID/SUM/abap/bin/R710VPE.SAP'
    4 ETQ399 >>> safeandslow=yes
    4 ETQ399 >>> buffersync =yes
    4 ETQ399 >>> commit     =1048576
    4 ETQ399 >>> importtruncated =yes
    3 ETQ120 20221122151608: PID 42280 execute '/usr/sap/SID/SYS/exe/uc/linuxx86_64/R3trans -w ~/tmp/R710VPE.SID -u 1 ~/tmp/PREIMPTRANS.CTL', output written to '/usr/sap/SID/SUM/abap/tmp/R3trans.out'.
    3WETQ122 20221122151608: PID 42280 exited with status 16 (time:     0.0/    0.0/    0.0/32MB real/usr/sys/maxmem)
    1 ETQ124 Scanned file 'log/R710VPE.SID' from offset 4857 to 5934 for errors.
    4EETQ399 Some errors found during the log scan!
    1EETQ399 Last error code set is: Non single errors (code > 8) found in logfile 'PREIMP.ELG'
    1EETQ204 Upgrade phase "PREIMP" aborted with severe errors ("20221122151608")
  • The logfile "PREIMP.ELG" shows below errors:
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    R3trans preimport and RETURN CODE in R710VPE.SID
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    4 ETW000 > commit     =1048576
    4 ETW000 > importtruncated =yes
    4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/SID/SUM/abap/tmp/R710VPE.SID -u 1 /usr/sap/SID/SUM/abap/tmp/PREIMPTRANS.CTL
    4 ETW000 active unconditional modes: 1
    4 ETW000
    2EETW000 I have some problems during TADIR access.
    4 ETW000 Connected to DBMS = SYBASE ---  --- SYSTEM = '???'.
    3WETW000 The HEAD entry in TADIR is missing.
    1AETW000 ERROR: first character of SAP-Release is not a digit, but '
    2EETW000 Please contact the SAP support.
  • trans.log shows below error, though R3trans -x returns 0000:
    4 ETW000  [     dev trc,00000]  ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 47145]
    4 ETW000  [     dev trc,00000]  (208) [42000] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]DBPROPERTIES not found. Specif
    4 ETW000  [     dev trc,00000]  y owner.objectname or use sp_help to check whether the object exists (sp_help ma
    4 ETW000  [     dev trc,00000]  y produce lots of output).
    4 ETW000  [     dev trc,00000]  DbSlConnect hdl: 0 
    4 ETW000  [     dev trc,00000]  trace file set
    4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)
    4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 30116]
    4 ETW000  [     dev trc,00000]  (208) [42000] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]SVERS not found. Specify owner
    4 ETW000  [     dev trc,00000]  .objectname or use sp_help to check whether the object exists (sp_help may produ
    4 ETW000  [     dev trc,00000]  ce lots of output).
    4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT VERSION FROM SVERS 
    4 ETW000                        /* R3::0 T:SVERS */
    4 ETW000  [    dblink  ,00000]  ***LOG BZA=>table SVERS does not exist on database           
    4 ETW000 Connected to database.


Read more...

Environment

  • SAP Adaptive Server Enterprise (SAP ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) 7.4, 7.5x java stack only
  • SL Toolset - SUM SPAM latest SP

Keywords

migration, SUM DMO, SQL208, DBPROPERTIES, SVERS, R3trans -x , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.