on 08-22-2016 12:27 PM
Hi all,
we are doing heterogenous copy from :
LINUXX86_64
Databse ORacle 10.2.0.4
SAP NW 7.0 SP3
To win2008 EER2
Databse ORacle 10.2.0.4
SAP NW 7.0 SP3
Import fails for TABLE ACCTIT
Log says :
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: ACCTIT deleted/truncated #20160822095612
(IMP) INFO: import of ACCTIT completed (305816807 rows) #20160822124937
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file H:\export\ABAP\DB/SQLFiles.LST
(SQL) INFO: H:\export\ABAP\DB/SQLFiles.LST not found
(SQL) INFO: Searching for SQL file USER2.SQL
(SQL) INFO: USER2.SQL not found
(SQL) INFO: Searching for SQL file H:\export\ABAP\DB/ORA/USER2.SQL
(SQL) INFO: H:\export\ABAP\DB/ORA/USER2.SQL not found
(DDL) ERROR: no tablespace for TABART USER2
(DB) INFO: disconnected from DB
E:\usr\sap\PPS\SYS\exe\nuc\NTAMD64\R3load.exe: job finished with 1 error(s)
E:\usr\sap\PPS\SYS\exe\nuc\NTAMD64\R3load.exe: END OF LOG: 20160822124937
Thank you
Hi Pavol,
Along with wiki which Pavol mentioned, please confirm if you ran report SMIGR_CREATE_DDL in your source system and generated the SQLFiles.LST because in logs provided by you above it seems that this file is missing.
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file H:\export\ABAP\DB/SQLFiles.LST
(SQL) INFO: H:\export\ABAP\DB/SQLFiles.LST not found
This report execution and SQL file generation is one of the important step which needs to be done in Source System.
Thanks,
Manish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Pavol,
You need to adjust TAORA, IAORA and TSORA for TABART USER2. You can read more in the wiki page below:
http://wiki.sdn.sap.com/wiki/x/v41RCw
Best regards,
Thiago
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.