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.