cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade problems with EHP5 upgrade - EU_IMPORT2 stuck

Former Member
0 Kudos

Hi,

I'm doing EHP5 upgrade on dev machine. Problem is that SAPUp gets stuck on Step 5 - preprocessing.

I have tried to search in notes and google - still no answer.

Conf and logs as follows:

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

SapUp error:

Severe error(s) occured in phase MAIN_SHDCRE/EU_IMPORT2!

Last error code set: 8 error during parallel execution of processes, check 'EU_IMP2.ELG' for details 16 processes failed, check 'EU_IMNDB.*' for details

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

EU_IMP2.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000014.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000015.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000001.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000002.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000003.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000004.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000005.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000006.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000010.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000011.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000012.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000016.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000017.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000018.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000019.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000021.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000022.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000023.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANALYSIS OF LOG FILE '/mnt/data/upg/abap/log/EX000024.DPR'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

EX000015.DPR

/mnt/data/upg/abap/exe/R3load: START OF LOG: 20120702150836

/mnt/data/upg/abap/exe/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

/mnt/data/upg/abap/exe/R3load: version R7.20/V1.4 [UNICODE]

Compiled May  6 2010 20:24:53

/mnt/data/upg/abap/exe/R3load -i /mnt/data/upg/abap/exchange/compack/EX000015.COD -p /mnt/data/upg/abap/log/EX000015.DPR -s /mnt/data/upg/abap/log/EX000015.DST -dbcodepage 4103 -nametab DDNTT~ DDNTF~

DbSl Trace: CONNECT failed with sql error '1017'

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) ERROR: could not find regular export directory

(SQL) INFO: Searching for SQL file SSEXC.SQL

(SQL) INFO: SSEXC.SQL not found

(SQL) ERROR: could not find regular export directory

(DB) INFO: REPOSRC~ created #20120702150836

(IMP) ERROR: DbSlPrepare/BegModify failed

  rc = 99, table "REPOSRC~"

  (SQL error 24315)

  error message returned by DbSl:

ORA-24315: illegal attribute type

(DB) INFO: REPOSRC^0 created #20120702150836

(DB) INFO: REPOSRC^SPM created #20120702150836

(DB) INFO: disconnected from DB

/mnt/data/upg/abap/exe/R3load: job finished with 1 error(s)

/mnt/data/upg/abap/exe/R3load: END OF LOG: 20120702150836

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

EU_IMNDB.SAV

#--------------------------------------------------------------

#---- MASKING file EU_IMNDB.EC2 from /mnt/data/upg/abap/tmp

#---- TIME: 20120702000116  PHASE: EU_IMPORT1

#--------------------------------------------------------------

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 27339 at 20120701234536

ENV: DIR_LIBRARY=/mnt/data/upg/abap/exe

ENV: LD_LIBRARY_PATH=/mnt/data/upg/abap/exe:/mnt/data/upg/jvm/jre/lib/amd64/server:/mnt/data/upg/jvm/jre/lib/amd64:/mnt/data/upg/jvm/jre/../lib/amd64:/usr/sap/TAU/SYS/exe/run:/oracle/TAU/112_64/lib

ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV: ORACLE_BASE=/oracle

ENV: ORACLE_HOME=/oracle/TAU/112_64

ENV: ORACLE_PSRV=TAU

ENV: ORACLE_SID=TAU

ENV: ORA_NLS33=/oracle/TAU/112_64/ocommon/nls/admin/data

ENV: PATH=/mnt/data/upg/abap/exe:/oracle/TAU/112_64/bin:.:/home/tauadm:/usr/sap/TAU/SYS/exe/run:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin

ENV: SAPSYSTEMNAME=TAU

ENV: auth_shadow_upgrade=0

ENV: dbms_type=ORA

ENV: dbs_ora_schema=SAPXXX

ENV: dbs_ora_tnsname=TAU

EXECUTING /mnt/data/upg/abap/exe/R3load (/mnt/data/upg/abap/exe/R3load) -i /mnt/data/upg/abap/exchange/compack/EX000000.COD -p /mnt/data/upg/abap/log/EX000000.DPR -s /mnt/data/upg/abap/log/EX000000.DST -dbcodepage 4103 -upg_nametab DDNTT~ DDNTF~

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

#--------------------------------------------------------------

#---- MASKING file EU_IMNDB.EC1 from /mnt/data/upg/abap/tmp

#---- TIME: 20120702000116  PHASE: EU_IMPORT1

#--------------------------------------------------------------

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 27332 at 20120701234535

ENV: DIR_LIBRARY=/mnt/data/upg/abap/exe

ENV: LD_LIBRARY_PATH=/mnt/data/upg/abap/exe:/mnt/data/upg/jvm/jre/lib/amd64/server:/mnt/data/upg/jvm/jre/lib/amd64:/mnt/data/upg/jvm/jre/../lib/amd64:/usr/sap/TAU/SYS/exe/run:/oracle/TAU/112_64/lib

ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV: ORACLE_BASE=/oracle

ENV: ORACLE_HOME=/oracle/TAU/112_64

ENV: ORACLE_PSRV=TAU

ENV: ORACLE_SID=TAU

ENV: ORA_NLS33=/oracle/TAU/112_64/ocommon/nls/admin/data

ENV: PATH=/mnt/data/upg/abap/exe:/oracle/TAU/112_64/bin:.:/home/tauadm:/usr/sap/TAU/SYS/exe/run:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin

ENV: SAPSYSTEMNAME=TAU

ENV: auth_shadow_upgrade=0

ENV: dbms_type=ORA

ENV: dbs_ora_schema=SAPXXX

ENV: dbs_ora_tnsname=TAU

EXECUTING /mnt/data/upg/abap/exe/R3load (/mnt/data/upg/abap/exe/R3load) -i /mnt/data/upg/abap/exchange/compack/EX000009.COD -p /mnt/data/upg/abap/log/EX000009.DPR -s /mnt/data/upg/abap/log/EX000009.DST -dbcodepage 4103 -upg_nametab DDNTT~ DDNTF~

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

EX000009.DPR

/mnt/data/upg/abap/exe/R3load: START OF LOG: 20120701234535

/mnt/data/upg/abap/exe/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

/mnt/data/upg/abap/exe/R3load: version R7.20/V1.4 [UNICODE]

Compiled May  6 2010 20:24:53

/mnt/data/upg/abap/exe/R3load -i /mnt/data/upg/abap/exchange/compack/EX000009.COD -p /mnt/data/upg/abap/log/EX000009.DPR -s /mnt/data/upg/abap/log/EX000009.DST -dbcodepage 4103 -upg_nametab DDNTT~ DDNTF~

DbSl Trace: CONNECT failed with sql error '1017'

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) ERROR: could not find regular export directory

(SQL) INFO: Searching for SQL file SDIC.SQL

(SQL) INFO: SDIC.SQL not found

(SQL) ERROR: could not find regular export directory

(DB) INFO: DDNTF~ created #20120701234536

(IMP) INFO: import of DDNTF~ completed (771331 rows) #20120701235252

(DB) INFO: DDNTF^0 created #20120701235253

(DB) INFO: DDNTF_CONV_UC~ created #20120701235253

(IMP) INFO: import of DDNTF_CONV_UC~ completed (771445 rows) #20120702000012

(DB) INFO: DDNTF_CONV_UC^0 created #20120702000015

(DB) INFO: DDNTT~ created #20120702000015

(IMP) INFO: import of DDNTT~ completed (845460 rows) #20120702000045

(DB) INFO: DDNTT^0 created #20120702000047

(DB) INFO: DDNTT_CONV_UC~ created #20120702000047

(IMP) INFO: import of DDNTT_CONV_UC~ completed (845460 rows) #20120702000114

(DB) INFO: DDNTT_CONV_UC^0 created #20120702000116

(DB) INFO: disconnected from DB

/mnt/data/upg/abap/exe/R3load: job completed

/mnt/data/upg/abap/exe/R3load: END OF LOG: 20120702000116

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

tp -V

This is tp version 340.16.67 (release 640, unicode enabled)

--------------------

tp information

--------------------

kernel release                640

kernel make variant           640_EX2

DBMS client library           OCI_102

DBSL shared library version   640.00

compiled on                   Linux GNU SLES-10 x86_64 cc4.1.2 for "linuxx86_64"

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  May 29 2011 20:00:39

update level                  0

patch number                  370

source id                     0.378

---------------------

supported environment

---------------------

database (SAP, table SVERS)   610

                              620

                              630

                              640

DBMS server

   ORACLE 8.1.7.*.*

   ORACLE 9.2.0.*.*

   ORACLE 10.1.0.*.*

   ORACLE 10.2.0.*.*

   ORACLE 11.2.0.*.*

operating system

Linux 2.6

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Can anybody have any ideas?

(regarding to sql error: 1017 - I have even checked and modified SAPUSER entries and changed passwords to default - still no go - maybe Im doing sth wrong?)

Br,

Kristjan T.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi and thank you for anyone that helped/viewed this thread.

Fix that solved the problem was that R3load and dboraslib.so were needed to be updated on '/usr/sap/SID/upg/abap/exe/' directory - for reasons unknown. What was my mistake was that I updated local instance exe directory for R2load and dboraslib - but that was for 640 version - however as SAPUp uses programs from its own directory and upgrade was to 702 then upgrade directory R3load and dboraslib.so needed update. After update SAPUp continued with no errors.

So thanks again for quick reply.

Br,

Kristjan T.

Former Member
0 Kudos

Had same problem on Solaris 10 when installing NW 7.0 EhP2 except table name was BADIIMPL_SORT.   Same SQL error 24315 and FYI, the ORA-1403 was not  a problem. 

If you implement Note 1642058, this is a possible (real for us) side effect:

These problems can occur with either of the above methods:

  • SAPINST fails in the step runMigrationMonitor

           Error: CJS-30022  Program 'Migration Monitor' exits with error code 103

           In the SAP*log files from the aborted packages, you see this error:

                    (IMP) ERROR: DbSlPrepare/BegModify failed

                    rc = 99, table "SPROXSVARDAT"

                    (SQL error 24315)

                    error message returned by DbSl:

                    ORA-24315: illegal attribute type

                    DB) INFO: disconnected from DB

           Reason:

           The dboraslib.* is too old.

           Solution:

Solution was to install newest dboraslib.  Thanks to Kristjan T for posting his experience.  It was helpful...

Cheers,

Rick M.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello

Looks like the issue is with the export directory. Please check this error message.

SQL) INFO: SQLFiles.LST not found

(SQL) ERROR: could not find regular export directory

are you sure your export directory which has been specified is available , mounted correctly and you read and write to it.

Please check and update us.

Thanks

Amit Padmawar

Former Member
0 Kudos

Hi - As my brain currently refuses to cooperate anymore - please specify sample export directory tree and to what user should I check it against (sidadm)?

Br,

KT.

Former Member
0 Kudos

Is it possible that EU_IMPORT2 is using upgrade directory abap/exe/ files to try to connect to DB?