cancel
Showing results for 
Search instead for 
Did you mean: 

Error on import ABAP for installing of SAP ERP 6.0 EHP7

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member182657
Active Contributor
0 Kudos

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 !!

Former Member
0 Kudos

Start DB if already installed then continue with Installation.

You can check weather Db is up or not.

Former Member
0 Kudos

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

Former Member
0 Kudos

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)

1898521 - Process list grows after ORA-01017; ORA-00020

Former Member
0 Kudos

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

JamesZ
Advisor
Advisor
0 Kudos

Hi Surendra,

Please increase PROCESSES database parameters to solve ORA-00020.

Best regards,
James

JamesZ
Advisor
Advisor
0 Kudos

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

former_member182657
Active Contributor
0 Kudos

Hi,

Could you share sapinst_dev.log as well as logs of SAPDFACT, SAPVIEW, SAPDDOS


Thanks,

Former Member
0 Kudos

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