on 02-09-2009 5:16 AM
HiAll,
I have performing the system export import process.During the import process i am getting an error in
"import ABAP" phase.
cat import_monitor.java.log
java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 2.2)
IBM J9SE VM (build 2.2, J2RE 1.4.2 IBM J9 2.2 Linux amd64-64 j9xa64142ifx-20070808 (JIT enabled)
J9VM - 20070807_1500_LHdSMr
JIT - r7_level20070315_1745)
Import Monitor jobs: running 1, waiting 1, completed 27, failed 0, total 29.
Loading of 'DDLOG' import package: ERROR
Import Monitor jobs: running 0, waiting 1, completed 27, failed 1, total 29.
cat DDLOG.TSK
T DDLOG C xeq
P DDLOG~0 C xeq
I DDLOG~DB2 C xeq
cat DDLOG.log
/usr/sap/SLO/SYS/exe/run/R3load: START OF LOG: 20090206193226
/usr/sap/SLO/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP
/usr/sap/SLO/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Apr 1 2006 00:08:29
/usr/sap/SLO/SYS/exe/run/R3load -ctf I /usr/bwexport/ABAP/DATA/DDLOG.STR /tmp/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/DDLORA.TPL DDLOG.TSK ORA -l DDLOG.log
/usr/sap/SLO/SYS/exe/run/R3load: job completed
/usr/sap/SLO/SYS/exe/run/R3load: END OF LOG: 20090206193226
can any help me regarding this issue.
Regards,
Amit
Can you try to apply the latest lib_dbsl library for basis release 7.00
Also As per Note 928474 try checking following entries in DDLOG.CMD and DDLOG.TSK
tsk: "<path to the export INSTDIR>/DDLOG.TSK"
icf: "<export dump directory>/DATA/DDLOG.STR"
dcf: "<export dump directory>/DB/DDLORA.TPL"
dat: NULL
dir: NULL
ext: NULL
Let us know if anything
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Thanx for kind response !|
one more thing , can you tell me at what location I go for create this file DDLOG.cmd
can you explain the terms given below :
tsk: "<path to the export INSTDIR>/DDLOG.TSK"
icf: "<export dump directory>/DATA/DDLOG.STR"
dcf: "<export dump directory>/DB/DDLORA.TPL"
dat: NULL
dir: NULL
ext: NULL
Regards,
Amit
hi,
Now I am phasing new error that you have no tsk entry in DDLOG.cmd file.
cat DDLOG.log
/usr/sap/SLO/SYS/exe/run/R3load: START OF LOG: 20090209115303
/usr/sap/SLO/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP
/usr/sap/SLO/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Apr 1 2006 00:08:29
/usr/sap/SLO/SYS/exe/run/R3load -i DDLOG.cmd -dbcodepage 4103 -l DDLOG.log -stop_on_error
DbSl Trace: ORA-1403 when accessing table SAPUSER
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(RC) ERROR: missing "tsk:" entry at line 1 in file DDLOG.cmd
(DB) INFO: disconnected from DB
/usr/sap/SLO/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/SLO/SYS/exe/run/R3load: END OF LOG: 20090209115303
cat DDLOG.TSK
T DDLOG C xeq
P DDLOG~0 C xeq
I DDLOG~DB2 C xeq
D DDLOG E ok
cat DDLOG.cmd
tsk:"/usr/bwexport/DDLOG.TSK"
icf:"/usr/bwexport/DATA/DDLOG.STR"
dcf:"/usr/bwexport/DB/DDLORA.TPL"
dat: NULL
dir: NULL
ext: NULL
Regards,
Amit
I think before that you have got Oracle error 1403
DbSl Trace: ORA-1403 when accessing table SAPUSER
Did you checked environment variable dbs_ora_schema=SAP<SID> where SAP<SID> is the owner of the tables in the database?
Also as per Note 400241
ORA-01403: no data found
Log entries: Logon as OPS$ user to get <sapowner>'s password
Connecting as /@<sid> on connection 0 ...
Now I'm connected to ORACLE
ERROR => ORA-1403 when accessing table SAPUSER
The main cause of ORA-01403 is that the table SAPUSER does not contain any entries. Therefore, proceed as follows:
Use the following BRCONNECT call (BRCONNECT 6.10 or higher) to set the password consistently in SAPUSER and in the Oracle DDIC:
brconnect -u system/<password> -f chpass -o <sapowner> -p <password>
Alternatively, you can insert it in SAPUSER manually.
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');
Another possible cause is that SAPUSER contains incorrect entries. The system always uses the user name to select from SAPUSER. Therefore, you must ensure that the user name is always uppercase (SAPR3 or SAP<sid>) and that it corresponds exactly to the value of the environment variable dbs_ora_schema if SAP<sid> is used.
If the system continues to issue ORA-01403, see the "General checks"section once again.
I think it might last reason - contain incorrect entries
Check this and let us know....
Hi All,
now I m getting following error :
TRACE: 2009-02-09 17:35:22 com.sap.inst.migmon.LoadTask run
Loading of 'DDLOG' import package is started.
ERROR: 2009-02-09 17:35:22 com.sap.inst.migmon.LoadTask run
Loading of 'DDLOG' import package is interrupted with exception.
java.io.FileNotFoundException: DATA/DDLOG.TOC
at com.sap.inst.migmon.LoadTask.writePathEntry(LoadTask.java:988)
at com.sap.inst.migmon.LoadTask.createCommandFile(LoadTask.java:698)
at com.sap.inst.migmon.LoadTask.processPackage(LoadTask.java:287)
at com.sap.inst.migmon.LoadTask.run(LoadTask.java:189)
at java.lang.Thread.run(Thread.java:838)
at com.sap.inst.lib.util.ThreadDispatcher$ThreadWrapper.run(ThreadDispatcher.java:113)
WARNING: 2009-02-09 17:35:52
Cannot start import of packages with views because not all import packages with tables are loaded successfully.
WARNING: 2009-02-09 17:35:52
1 error(s) during processing of packages.
INFO: 2009-02-09 17:35:52
Import Monitor is stopped.
regards,
Amit
Hi,
If you check SAP Note [547314|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=547314]
TOC = Table of Contents.
One of the important file in export/import.
Question 4 : will explain what is a use of this file...
Check & inform if you have such file in your export?
If you have that file
Also check this Note [674033|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=674033]
As per this note check if you have any blank space character in your eport/import path location.
Looks like something is wrong with Export....
Regards!
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.