cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL Error: ORA-01418: specified index does not exist

Go to solution
manju_manjunatha
Participant

on ‎04-21-2014 2:12 PM

0 Kudos


Hi,

   In process chain when doing drop index we are getting below error messages.

SQL: 21.04.2014 11:56:50 ALECPIC

DROP INDEX "/BIC/FZDD_k01~020"

SQL-END: 21.04.2014 11:56:50 00:00:00

SQL Error: ORA-01418: specified index does not exist

Entire chain now has status 'R'

Process Generate Index, variant Generated from LOADING ZPAK_43423423432432 has status Undefined (instance )

Process Execute InfoPackage, variant 8DD_k04 -> Delta load ZDD_k01 & ZDD_k02 has status Undefined (instance )

Process Roll Up Filled Aggregates/BWA Indexes, variant ZDD_k01_BIA aggregate has status Undefined (instance )

Process Start Process, variant Delta loading 2LIS_13_VDITM has status Completed (instance 4XKGVU0OO3R60TM1YM8LPD21G)

Process Execute InfoPackage, variant Delta, Billing: Condition Data has status Successfully completed (instance REQU_3423423423

Process Activate DataStore Object Data, variant Generated from LOADING ZPAK_2234324324234324 has status Successfully compl

Process Execute InfoPackage, variant 2LIS_13_VDITM -> Delta load ZDD_k01 has status Ended with errors (instance ERRO_34324234

Process Execute InfoPackage, variant 2LIS_13_VDITM -> Delta load ZDD_k01 has status Successfully completed (instance REQU_4XKP6L

Process Activate DataStore Object Data, variant Generated from LOADING ZPAK_4234234234234234 has status Successfully compl

Process Delete Index, variant Generated from LOADING ZPAK_12321321323213213213213 has status Ended with errors (instance DIDX_4XK

Process Delete Index, variant Generated from LOADING ZPAK_2321321323213213213213 has status Ended with errors (instance DIDX_4XK

Process Delete Index, variant Generated from LOADING ZPAK_2321321323213213213213 has status Ended with errors (instance DIDX_4XK

Process Delete Index, variant Generated from LOADING ZPAK_2321321323213213213213 has status Ended with errors (instance DIDX_4XL

Process Delete Index, variant Generated from LOADING ZPAK_2321321323213213213213 has status Ended with errors (instance DIDX_4XL

Message sent successfully

Job finished


Thanks,

Manjunatha

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Sriram2009
Active Contributor
‎04-21-2014 2:57 PM
0 Kudos

Hi Manju

Could you check this SAP Note

1094305 - BW indexes with incorrect names (only NW 2004s)


1945641 - Getting the error: <ORA-01418: specified index does not exist> - Data Services


BR

SS

Show replies
Show replies
manju_manjunatha
Participant
‎04-22-2014 7:35 AM
0 Kudos

Hi,

   I checking this process chain in test system. After deleting and creating index maunly, process chain repeated after that i got below error message.

Job started

Step 001 started (program RSPROCESS, variant &0000001341829, user ID ALECPIC)

Start process DROPINDEX ZPAK_2543542355435435454545BWN in run 4XKGVTT0555GI72LSS69FB3BO of chain ZDD_aaa_uu

SQL: 22.04.2014 08:55:40 ALECPIC

DROP INDEX "/BIC/FZDD_k01~010"

SQL-END: 22.04.2014 08:55:40 00:00:00

SQL: 22.04.2014 08:55:40 ALECPIC

DROP INDEX "/BIC/FZDD_k01~020"

SQL-END: 22.04.2014 08:55:41 00:00:01

SQL: 22.04.2014 08:55:41 ALECPIC

DROP INDEX "/BIC/FZDD_k01~040"

SQL-END: 22.04.2014 08:55:41 00:00:00

SQL: 22.04.2014 08:55:41 ALECPIC

DROP INDEX "/BIC/FZDD_k01~050"

SQL-END: 22.04.2014 08:55:42 00:00:01

SQL: 22.04.2014 08:55:42 ALECPIC

DROP INDEX "/BIC/FZDD_k01~060"

SQL-END: 22.04.2014 08:55:42 00:00:00

SQL: 22.04.2014 08:55:42 ALECPIC

DROP INDEX "/BIC/FZDD_k01~070"

SQL-END: 22.04.2014 08:55:42 00:00:00

SQL: 22.04.2014 08:55:42 ALECPIC

DROP INDEX "/BIC/FZDD_k01~080"

SQL-END: 22.04.2014 08:55:42 00:00:00

SQL: 22.04.2014 08:55:42 ALECPIC

DROP INDEX "/BIC/FZDD_k01~090"

SQL-END: 22.04.2014 08:55:43 00:00:01

SQL: 22.04.2014 08:55:43 ALECPIC

DROP INDEX "/BIC/FZDD_k01~100"

SQL-END: 22.04.2014 08:55:43 00:00:00

SQL: 22.04.2014 08:55:43 ALECPIC

DROP INDEX "/BIC/FZDD_k01~110"

SQL-END: 22.04.2014 08:55:44 00:00:01

SQL: 22.04.2014 08:55:44 ALECPIC

DROP INDEX "/BIC/FZDD_k01~120"

SQL-END: 22.04.2014 08:55:44 00:00:00

SQL: 22.04.2014 08:55:44 ALECPIC

DROP INDEX "/BIC/FZDD_k01~130"

SQL-END: 22.04.2014 08:55:44 00:00:00

SQL: 22.04.2014 08:55:44 ALECPIC

DROP INDEX "/BIC/FZDD_k01~140"

SQL-END: 22.04.2014 08:55:44 00:00:00

SQL: 22.04.2014 08:55:44 ALECPIC

DROP INDEX "/BIC/FZDD_k01~150"

SQL-END: 22.04.2014 08:55:45 00:00:01

SQL: 22.04.2014 08:55:45 ALECPIC

DROP INDEX "/BIC/FZDD_k01~160"

SQL-END: 22.04.2014 08:55:45 00:00:00

Indexes for InfoCube ZDD_k01 have been deleted successfully

SQL: 22.04.2014 08:55:46 ALECPIC

DROP INDEX "/BIC/FZDD_k02~010"

SQL-END: 22.04.2014 08:55:46 00:00:00

SQL: 22.04.2014 08:55:46 ALECPIC

DROP INDEX "/BIC/FZDD_k02~020"

SQL-END: 22.04.2014 08:55:47 00:00:01

SQL: 22.04.2014 08:55:47 ALECPIC

DROP INDEX "/BIC/FZDD_k02~040"

SQL-END: 22.04.2014 08:55:48 00:00:01

SQL: 22.04.2014 08:55:48 ALECPIC

DROP INDEX "/BIC/FZDD_k02~050"

SQL-END: 22.04.2014 08:55:48 00:00:00

SQL: 22.04.2014 08:55:48 ALECPIC

DROP INDEX "/BIC/FZDD_k02~060"

SQL-END: 22.04.2014 08:55:48 00:00:00

SQL: 22.04.2014 08:55:48 ALECPIC

DROP INDEX "/BIC/FZDD_k02~070"

SQL-END: 22.04.2014 08:55:49 00:00:01

SQL: 22.04.2014 08:55:49 ALECPIC

DROP INDEX "/BIC/FZDD_k02~080"

SQL-END: 22.04.2014 08:55:49 00:00:00

SQL: 22.04.2014 08:55:49 ALECPIC

DROP INDEX "/BIC/FZDD_k02~090"

SQL-END: 22.04.2014 08:55:50 00:00:01

SQL: 22.04.2014 08:55:50 ALECPIC

DROP INDEX "/BIC/FZDD_k02~100"

SQL-END: 22.04.2014 08:55:50 00:00:00

SQL: 22.04.2014 08:55:50 ALECPIC

DROP INDEX "/BIC/FZDD_k02~110"

SQL-END: 22.04.2014 08:55:51 00:00:01

SQL: 22.04.2014 08:55:51 ALECPIC

DROP INDEX "/BIC/FZDD_k02~120"

SQL-END: 22.04.2014 08:55:51 00:00:00

SQL: 22.04.2014 08:55:51 ALECPIC

DROP INDEX "/BIC/FZDD_k02~130"

SQL-END: 22.04.2014 08:55:51 00:00:00

SQL: 22.04.2014 08:55:51 ALECPIC

DROP INDEX "/BIC/FZDD_k02~140"

SQL-END: 22.04.2014 08:55:52 00:00:01

SQL: 22.04.2014 08:55:52 ALECPIC

DROP INDEX "/BIC/FZDD_k02~150"

SQL-END: 22.04.2014 08:55:52 00:00:00

Indexes for InfoCube ZDD_k02 have been deleted successfully

The roll up for InfoCube ZDD_k03 has terminated

SQL: 22.04.2014 09:03:30 ALECPIC

DROP INDEX "/BIC/FZDD_k04~010"

SQL-END: 22.04.2014 09:03:31 00:00:01

SQL: 22.04.2014 09:03:31 ALECPIC

DROP INDEX "/BIC/FZDD_k04~020"

SQL-END: 22.04.2014 09:03:31 00:00:00

SQL: 22.04.2014 09:03:31 ALECPIC

DROP INDEX "/BIC/FZDD_k04~040"

SQL-END: 22.04.2014 09:03:32 00:00:01

SQL: 22.04.2014 09:03:32 ALECPIC

DROP INDEX "/BIC/FZDD_k04~050"

SQL-END: 22.04.2014 09:03:32 00:00:00

SQL: 22.04.2014 09:03:32 ALECPIC

DROP INDEX "/BIC/FZDD_k04~060"

SQL-END: 22.04.2014 09:03:32 00:00:00

SQL: 22.04.2014 09:03:32 ALECPIC

DROP INDEX "/BIC/FZDD_k04~070"

SQL-END: 22.04.2014 09:03:33 00:00:01

SQL: 22.04.2014 09:03:33 ALECPIC

DROP INDEX "/BIC/FZDD_k04~080"

SQL-END: 22.04.2014 09:03:33 00:00:00

SQL: 22.04.2014 09:03:33 ALECPIC

DROP INDEX "/BIC/FZDD_k04~090"

SQL-END: 22.04.2014 09:03:33 00:00:00

SQL: 22.04.2014 09:03:33 ALECPIC

DROP INDEX "/BIC/FZDD_k04~100"

SQL-END: 22.04.2014 09:03:34 00:00:01

SQL: 22.04.2014 09:03:34 ALECPIC

DROP INDEX "/BIC/FZDD_k04~110"

SQL-END: 22.04.2014 09:03:34 00:00:00

SQL: 22.04.2014 09:03:34 ALECPIC

DROP INDEX "/BIC/FZDD_k04~120"

SQL-END: 22.04.2014 09:03:34 00:00:00

SQL: 22.04.2014 09:03:34 ALECPIC

DROP INDEX "/BIC/FZDD_k04~130"

SQL-END: 22.04.2014 09:03:35 00:00:01

SQL: 22.04.2014 09:03:35 ALECPIC

DROP INDEX "/BIC/FZDD_k04~140"

SQL-END: 22.04.2014 09:03:35 00:00:00

SQL: 22.04.2014 09:03:35 ALECPIC

DROP INDEX "/BIC/FZDD_k04~150"

SQL-END: 22.04.2014 09:03:36 00:00:01

SQL: 22.04.2014 09:03:36 ALECPIC

DROP INDEX "/BIC/FZDD_k04~160"

SQL-END: 22.04.2014 09:03:36 00:00:00

Indexes for InfoCube ZDD_k04 have been deleted successfully

Entire chain now has status 'R'

Process Generate Index, variant Generated from LOADING ZPAK_452542545443 has status Undefined (instance )

Process Execute InfoPackage, variant 8ZDD_D01 -> Delta load ZDD_k01 & ZDD_k02 has status Undefined (instance )

Process Roll Up Filled Aggregates/BWA Indexes, variant ZDD_k01_BIA aggregate has status Undefined (instance )

Process Start Process, variant Delta loading 2LIS_13_VDITM has status Completed (instance 4XKGVU0OO3R60TM1YM8LPD21G)

Process Execute InfoPackage, variant Delta, Billing: Condition Data has status Successfully completed (instance REQU_4XKF1SE9M8E

Process Activate DataStore Object Data, variant Generated from LOADING ZPAK_123232132132323444 has status Successfully compl

Process Execute InfoPackage, variant 2LIS_13_VDITM -> Delta load ZDD_k01 has status Ended with errors (instance ERRO_4XKGW3MCDCW

Process Execute InfoPackage, variant 2LIS_13_VDITM -> Delta load ZDD_k01 has status Successfully completed (instance REQU_4XKP6L

Process Activate DataStore Object Data, variant Generated from LOADING ZPAK_468YILV55UOP1SJBBAOPOO has status Successfully compl

Process Delete Index, variant Generated from LOADING ZPAK_2543542355435435454545 has status Ended with errors (instance DIDX_4XK

Process Delete Index, variant Generated from LOADING ZPAK_2543542355435435454545 has status Ended with errors (instance DIDX_4XK

Process Delete Index, variant Generated from LOADING ZPAK_2543542355435435454545 has status Ended with errors (instance DIDX_4XK

Process Delete Index, variant Generated from LOADING ZPAK_2543542355435435454545 has status Ended with errors (instance DIDX_4XL

Process Delete Index, variant Generated from LOADING ZPAK_2543542355435435454545 has status Ended with errors (instance DIDX_4XL

Process Delete Index, variant Generated from LOADING ZPAK_2543542355435435454545 has status Ended with errors (instance DIDX_4XK

Message sent successfully

Job finished

Please give your input.

Thanks,

Manjunatha.

Former Member
‎04-22-2014 10:30 AM
0 Kudos

Hi Manju,

from the log  i understand that index  deletion is the issue.  Please  ensure that no loading is happening into  Infocube when  index was getting    dropped. Also check whether this infocube is feeding any   upwards data flow.. In both the case,  index will fail as there will be lock on it.

Regards.

Rajesh

former_member202718
Active Contributor
‎04-24-2014 7:52 AM
0 Kudos

Hi Manju,

THis looks more like a basis issue.

Can you chck with your basis team.

rgds

SVU

manju_manjunatha
Participant
‎04-29-2014 6:30 AM
0 Kudos

Hi All,

   I getting above issue in test system because we don't have BWA is not avilable in test system. After de-activating BWA in RSDDV Tcode issue got resolved.

Thanks,

Manjunatha.

Answers (2)

Answers (2)

KodandaPani_KV
Active Contributor
‎04-21-2014 2:42 PM
0 Kudos

Hi,

your working the DEV or PRD?

if you working on the DEV create the one more PC for testing on same info cube.

create the index for the variant give the variant name.

Thanks,

Phani.

Show replies
Show replies
RamanKorrapati
Active Contributor
‎04-21-2014 2:19 PM
0 Kudos

Hi,

Please inform to basis or db team about your issue.

its ORA/SQL issues. need to take care by db team.

All of your previous process chains logs are green?

because error saying there is no index? mean yester day load may failed while creating the index.

Please check about your last yester day(last run) log of your process chain.

Thanks

Show replies
Show replies
Ask a Question