ORA-02158: invalid CREATE INDEX option at the time of IMPORT ABAP phase

[Former Member]

Hi

I am getting Error for SAPDFACT.TSK at the time of import,

ORA-02158: invalid CREATE INDEX option.

I have done the BIW Upgrade from BW 3.1 content to BI 7.0 and also all

the required Prerequiste steps for Unicode Conversion.

I am able to generate export and same when i try to start with import,

in Import ABAP phase i am getting error for the following SAPDFACT.TSK

as ORA-02158: invalid CREATE INDEX option.Also only 1 job is failing

out of 43.

I tried with Kernel Upgrade but still getting the same error.

If i edit the SAPDFACT.TSK file and replace the 'err' with 'ign' it

will complete the installation, do that needs to be done and if so what steps needs to be taken after successful completing of installation ?

LOGS :-

import_monitor.log

-

---

ERROR: 2008-06-24 17:44:39 com.sap.inst.migmon.LoadTask run

Loading of 'SAPDFACT' import package is interrupted with R3load error.

Process '/usr/sap/ABQ/SYS/exe/run/R3load -i SAPDFACT.cmd -dbcodepage 4102 -l SAPDFACT.log -stop_on_error' exited with return code 2.

For mode details see 'SAPDFACT.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

-

---

SAPDFACT.log

-

---

/usr/sap/ABQ/SYS/exe/run/R3load: START OF LOG: 20080624174414

/usr/sap/ABQ/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/ABQ/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jul 14 2007 03:33:39

/usr/sap/ABQ/SYS/exe/run/R3load -ctf I /DB_EXPORT/ABAP/DATA/SAPDFACT.STR /tmp/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/DDLORA.TPL SAPDFACT.TSK ORA -l SAPDFACT.log

/usr/sap/ABQ/SYS/exe/run/R3load: job completed

/usr/sap/ABQ/SYS/exe/run/R3load: END OF LOG: 20080624174414

/usr/sap/ABQ/SYS/exe/run/R3load: START OF LOG: 20080624174430

/usr/sap/ABQ/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/ABQ/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jul 14 2007 03:33:39

/usr/sap/ABQ/SYS/exe/run/R3load -i SAPDFACT.cmd -dbcodepage 4102 -l SAPDFACT.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

(GSI) INFO: dbname = "ABQ20080624050617 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "sinblrbw002 "

(GSI) INFO: sysname = "AIX"

(GSI) INFO: nodename = "sinblrbw002"

(GSI) INFO: release = "3"

(GSI) INFO: version = "5"

(GSI) INFO: machine = "00538AFD4C00"

(DB) INFO: /BI0/E0BWTC_C02 created #20080624174433

(IMP) INFO: import of /BI0/E0BWTC_C02 completed (0 rows) #20080624174433

(DB) INFO: /BI0/E0BWTC_C02~0 created #20080624174433

(DB) INFO: /BI0/E0BWTC_C02~01 created #20080624174434

(DB) INFO: /BI0/E0BWTC_C02~02 created #20080624174434

(DB) INFO: /BI0/E0BWTC_C02~04 created #20080624174434

(DB) INFO: /BI0/E0BWTC_C02~05 created #20080624174434

(DB) INFO: /BI0/E0BWTC_C02~06 created #20080624174434

(DB) INFO: /BI0/E0BWTC_C02~07 created #20080624174434

DbSl Trace: Error 2158 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-2158 occurred when executing SQL stmt (parse error offset=322)

(DB) ERROR: DDL statement failed

( CREATE INDEX "/BI0/E0BWTC_C02~P" ON "/BI0/E0BWTC_C02" ("KEY_0BWTC_C02P", "KEY_0BWTC_C02T", "KEY_0BWTC_C02U", "KEY_0BWTC_C021", "KEY_0BWTC_C022", "KEY_0BWTC_C023", "KEY_0BWTC_C024") PCTFREE 10 INITRANS 002 TABLESPACE STORAGE (INITIAL 0000000016 K NEXT 0000000016 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 004) )

DbSlExecute: rc = 99

(SQL error 2158)

error message returned by DbSl:

ORA-02158: invalid CREATE INDEX option

(DB) INFO: disconnected from DB

/usr/sap/ABQ/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/ABQ/SYS/exe/run/R3load: END OF LOG: 20080624174434

-

---

SAPDFACT.TSK

-

---

T /BI0/E0BWTC_C02 C ok

D /BI0/E0BWTC_C02 I ok

P /BI0/E0BWTC_C02~0 C ok

I /BI0/E0BWTC_C02~01 C ok

I /BI0/E0BWTC_C02~02 C ok

I /BI0/E0BWTC_C02~04 C ok

I /BI0/E0BWTC_C02~05 C ok

I /BI0/E0BWTC_C02~06 C ok

I /BI0/E0BWTC_C02~07 C ok

I /BI0/E0BWTC_C02~P C err

T /BI0/E0BWTC_C03 C xeq

D /BI0/E0BWTC_C03 I xeq

P /BI0/E0BWTC_C03~0 C xeq

I /BI0/E0BWTC_C03~01 C xeq

I /BI0/E0BWTC_C03~02 C xeq

I /BI0/E0BWTC_C03~04 C xeq

I /BI0/E0BWTC_C03~05 C xeq

I /BI0/E0BWTC_C03~P C xeq

T /BI0/E0BWTC_C04 C xeq

D /BI0/E0BWTC_C04 I xeq

P /BI0/E0BWTC_C04~0 C xeq

I /BI0/E0BWTC_C04~01 C xeq

I /BI0/E0BWTC_C04~02 C xeq

I /BI0/E0BWTC_C04~04 C xeq

I /BI0/E0BWTC_C04~05 C xeq

I /BI0/E0BWTC_C04~06 C xeq

.

.

.

.

.

.

.

-

---

Reply awaited..

Thanks & Best Regards

Ashish

[markus_doehr2 · Accepted solution]

> I have done the BIW Upgrade from BW 3.1 content to BI 7.0 and also all

> the required Prerequiste steps for Unicode Conversion.

Did you execute SMIGR_CREATE_DDL before the export?

Markus

[Former Member]

Hi Markus

Thanks for your Reply,

Yea i had Run the Report SMIGR_CREATE_DDL, and also the Genrated DDL files vi.z., *.SQL file i have copied to the EXPORT Installation directory /DB_EXPORT/ABAP/DB/ORA/

I got the solution for this problem with help of Note :- Note 885441 - Common Migration Errors.

Afterwards, the indexes can be generated manually by runing program SAP_INFOCUBE_INDEXES_REPAIR for all cubes

This error can be ignored and can be rebuild the index after installation.

I did the same and refered to this note.

Also this error mostly can be occur in DEV & QA Environment as of my experience in BI upgrade due to indexes in Dev and QA are not always rebuild.

..

Regards

Ashish