on 03-31-2015 2:47 PM
Dear Team,
I am trying to install SAP ERP 6.0 EHP 7 with Oracle database. but I am getting error on import ABAPs. Error is 3 files failed on import ABAP.
File names: SAPDFACT, SAPVIEW, SAPDDOS
SAP installation details:
Installation_Master: 51043756
Kernal: Kernal_7.42_windows_server_onx64nit_51049350_10
Installation Exports: 51048312_1 to 14
Oracle DB: 11.2.0
Java Environmental variables: 1.8.0.40 latest with JRE and JDK tools
OS: windows 2008 server R2
RAM: 8 GB
Swap memory: 45 GB
HDD: 1TB (C: 100 Gb, 😧 500 Gb (SAP), E: 350 Gb (for softwares))
Can you please solve this issue?
Thanks & Regards,
Surendra
Hi,
DbSl Trace: Error 439 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-00439 occurred at SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
( CREATE BITMAP INDEX "/B364/ECPFP_R01~03" ON "/B364/ECPFP_R01" ("KEY_CPFP_R01U") INITRANS 002 TABLESPACE PSAPSR3FACT )
DbSlExecute: rc = 99
(SQL error 439)
Could you check with SAP KBA 1703672 - PCM : Error in OracleSchema.log "ORA-00439: feature not enabled: Bit-mapped indexes"
Hope this will help you.
Good luck !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dears,
Thanks for your reply. I am attaching screen shot and files.
import_moniter.java.log
java version "1.6.0_85"
Java(TM) SE Runtime Environment (build 6.1.072)
SAP Java Server VM (build 6.1.072 24.71-b13, Oct 23 2014 00:36:04 - 61_REL - optU - windows amd64 - 6 - bas2:227531 (mixed mode))
Import Monitor jobs: running 1, waiting 1, completed 162, failed 0, total 164.
Loading of 'SAPDFACT' import package: ERROR
Import Monitor jobs: running 0, waiting 1, completed 162, failed 1, total 164.
----------
SAPDFACT.log
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20150401054546
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: version R7.42/V1.8 [UNICODE]
Compiled Nov 26 2014 19:43:53
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe -ctf I E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DATA\SAPDFACT.STR C:\Program Files\sapinst_instdir\BS2013SR2\ERP607SR2\ORA\INSTALL\STD\ABAP\DDLORA_LRG.TPL SAPDFACT.TSK ORA -l SAPDFACT.log
-------------------- Start of patch information ------------------------
patchinfo (patches.h): (0.023) R3load: Memory overwrite when converting cluster tables (note 2074445)
DBSL patchinfo (patches.h): (0.025) ORA-00020: too many Oracle shadow processes (2) (note 1898521)
--------------------- End of patch information -------------------------
process id 4020
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(RDI) WARNING: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DATA\SAPDFACT.STR: cannot find version token "ver:" at line 1
(RDI) WARNING: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DATA\SAPDFACT.STR: unknown file format, assuming version 2
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: job completed
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20150401054546
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20150401054546
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: version R7.42/V1.8 [UNICODE]
Compiled Nov 26 2014 19:43:53
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error -loadprocedure fast
-------------------- Start of patch information ------------------------
patchinfo (patches.h): (0.023) R3load: Memory overwrite when converting cluster tables (note 2074445)
DBSL patchinfo (patches.h): (0.025) ORA-00020: too many Oracle shadow processes (2) (note 1898521)
--------------------- End of patch information -------------------------
process id 3984
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(RDI) WARNING: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DATA\SAPDFACT.STR: cannot find version token "ver:" at line 1
(RDI) WARNING: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DATA\SAPDFACT.STR: unknown file format, assuming version 2
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST
(SQL) INFO: found E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST
(SQL) INFO: Trying to open E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST
(SQL) INFO: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST opened
(SQL) INFO: Searching for SQL file DFACT.SQL
(SQL) INFO: DFACT.SQL not found
(SQL) INFO: Searching for SQL file E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL
(SQL) INFO: found E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL
(SQL) INFO: Trying to open E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL
(SQL) INFO: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL opened
(DB) INFO: /B364/ECPFP_R01 created #20150401054549
(IMP) INFO: import of /B364/ECPFP_R01 completed (0 rows) #20150401054549
DbSl Trace: Error 439 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-00439 occurred at SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
( CREATE BITMAP INDEX "/B364/ECPFP_R01~03" ON "/B364/ECPFP_R01" ("KEY_CPFP_R01U") INITRANS 002 TABLESPACE PSAPSR3FACT )
DbSlExecute: rc = 99
(SQL error 439)
error message returned by DbSl:
ORA-00439: feature not enabled: Bit-mapped indexes
(DB) INFO: disconnected from DB
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20150401054551
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20150401093624
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: version R7.42/V1.8 [UNICODE]
Compiled Nov 26 2014 19:43:53
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error -loadprocedure fast
-------------------- Start of patch information ------------------------
patchinfo (patches.h): (0.023) R3load: Memory overwrite when converting cluster tables (note 2074445)
DBSL patchinfo (patches.h): (0.025) ORA-00020: too many Oracle shadow processes (2) (note 1898521)
--------------------- End of patch information -------------------------
process id 3280
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(RDI) WARNING: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DATA\SAPDFACT.STR: cannot find version token "ver:" at line 1
(RDI) WARNING: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DATA\SAPDFACT.STR: unknown file format, assuming version 2
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST
(SQL) INFO: found E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST
(SQL) INFO: Trying to open E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST
(SQL) INFO: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/SQLFiles.LST opened
(SQL) INFO: Searching for SQL file DFACT.SQL
(SQL) INFO: DFACT.SQL not found
(SQL) INFO: Searching for SQL file E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL
(SQL) INFO: found E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL
(SQL) INFO: Trying to open E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL
(SQL) INFO: E:\SAP_Apps\ERP6_EHP7\INSTALLATION_EXPORTS\51048312_1\DATA_UNITS\EXPORT1\DB/ORA/DFACT.SQL opened
(DB) ERROR: DDL statement failed
(DROP INDEX "/B364/ECPFP_R01~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 439 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-00439 occurred at SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
( CREATE BITMAP INDEX "/B364/ECPFP_R01~03" ON "/B364/ECPFP_R01" ("KEY_CPFP_R01U") INITRANS 002 TABLESPACE PSAPSR3FACT )
DbSlExecute: rc = 99
(SQL error 439)
error message returned by DbSl:
ORA-00439: feature not enabled: Bit-mapped indexes
(DB) INFO: disconnected from DB
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
D:\usr\sap\EH7\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20150401093625
Regards,
Surendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
DBSL patchinfo (patches.h): (0.025) ORA-00020: too many Oracle shadow processes (2) (note 1898521)
Please follow solution mentioned in the note(displayed above)
Hi Surendra,
From the error The Bitmap index creation is failing. Please find below for reference from error:-
DbSl Trace: ORA-00439 occurred at SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
( CREATE BITMAP INDEX "/B364/ECPFP_R01~03" ON "/B364/ECPFP_R01" ("KEY_CPFP_R01U") INITRANS 002 TABLESPACE PSAPSR3FACT )
DbSlExecute: rc = 99
(SQL error 439)
error message returned by DbSl:
ORA-00439: feature not enabled: Bit-mapped indexes
(DB) INFO: disconnected from DB
So do verify if the index is already got created, Also do check if Bitmap index creation is enabled in your DB which can be checked by Below command. Also the output value should be true.
SELECT * FROM V$OPTION WHERE PARAMETER LIKE 'Bit-mapped%
select * from v$option; check for partitioning
Do refer to below oss notes: for same.
370819 - ORA-439: Feature not enabled: Partitioning
http://service.sap.com/sap/support/notes/1703672
Do verify with your DBA whether it has been install.
Also Do take a restart of the Database and give a retry.
Let us know the outcome.
Regards,
Ram
Hi Surendra,
Please provide sapinst.log and sapinst_dev.log. Also please do let us know why do you think you are
encountering the problem that may be related to oracle.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could you share sapinst_dev.log as well as logs of SAPDFACT, SAPVIEW, SAPDDOS
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Surendra,
Can you provide us with the Error logs like sapinstdev.log and the screenshot So that we will be able to help you more.
Regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.