on 07-02-2012 3:06 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is it possible that EU_IMPORT2 is using upgrade directory abap/exe/ files to try to connect to DB?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
14 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.