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.
SAP Knowledge Base Article - Preview