Problem in generating BI Cube

[former_member337858]

Dear All,

I am facing the problem on our Dev BI server. We are using SAP on windows 2003 server and database is Oracle.

Our job for creating purchase cube is continuously failing. The error log is as below. Kindly suggest some appropriate solution of the problem.

08.12.2010 11:46:31 SQL Error: ORA-01418: specified index does not exist DBMAN 257 I

08.12.2010 11:46:31 SQL: 08.12.2010 11:46:31 BASIS DBMAN 099 I

08.12.2010 11:46:31 DROP INDEX "/BI0/E0PUR_C04~0" DBMAN 099 I

08.12.2010 11:46:31 SQL-END: 08.12.2010 11:46:31 00:00:00 DBMAN 099 I

08.12.2010 11:46:31 SQL Error: ORA-01418: specified index does not exist DBMAN 257 I

08.12.2010 11:46:31 SQL: 08.12.2010 11:46:31 BASIS DBMAN 099 I

08.12.2010 11:46:31 DROP INDEX "/BI0/E0PUR_C04~P" DBMAN 099 I

08.12.2010 11:46:31 SQL-END: 08.12.2010 11:46:31 00:00:00 DBMAN 099 I

08.12.2010 11:46:31 SQL Error: ORA-01418: specified index does not exist DBMAN 257 I

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 STDO: Log could not be written on output device T D0 524 S

08.12.2010 11:46:31 SQL: 08.12.2010 11:46:31 BASIS DBMAN 099 I

08.12.2010 11:46:31 CREATE VIEW "/BI0/V0PUR_C04F" ( "KEY_0PUR_C04P", DBMAN 099 I

08.12.2010 11:46:31 "KEY_0PUR_C04T", "KEY_0PUR_C04U", DBMAN 099 I

08.12.2010 11:46:31 "KEY_0PUR_C041", "KEY_0PUR_C042", DBMAN 099 I

08.12.2010 11:46:31 "KEY_0PUR_C043", "KEY_0PUR_C044", DBMAN 099 I

08.12.2010 11:46:31 "KEY_0PUR_C045", "KEY_0PUR_C046", "CONTR_ITEM", DBMAN 099 I

08.12.2010 11:46:31 "DELIVERIES", "DEL_SCHEDS", "INVCD_AMNT", DBMAN 099 I

08.12.2010 11:46:31 "NO_PUR_ORD", "NO_REQ_QUT", "ORDER_VAL", DBMAN 099 I

08.12.2010 11:46:31 "PO_ITEMLNS", "PO_ITEMS", "QUOT_ITEMS", DBMAN 099 I

08.12.2010 11:46:31 "RFQ_ITEMS", "SCHED_AGR", "SCH_AGR_IT", DBMAN 099 I

08.12.2010 11:46:31 "CONTRACTS" ) AS ( SELECT "KEY_0PUR_C04P", DBMAN 099 I

Thanks In advance

[Nibu]

Hi

Did you check to repair the index. In RSRV you will be able to do that.

Also, a checkdb initiation can resolve this I guess.

Regards,

Nibu Antony

[former_member337858]

Thanks for your reply.

Reffered Index in error log actually does not exist, so how can we rebuild it.

We have also tried checkdb option already but no success.

Kind Regards

[former_member337858]

Thanks for your reply.

Reffered Index in error log actually does not exist, so how can we rebuild it.

We have also tried checkdb option already but no success.

Kind Regards