cancel
Showing results for 
Search instead for 
Did you mean: 

Delete Index is not triggering in Process Chain?

Former Member
0 Kudos

Hello All

One of our team member is facing a problem like he is using Process Chain and loading to Cube?In this,the delete index is not triggering and its not displaying any messages?

What will be the problew and how to rectify this?

Many Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Balaji,

There are two ways of droping indexes.

1. In the process chain, when you pull the INFOPACKAGE for InfoCube load, it automatically gets the DELETE / CREATE of indexes.

2. Go to the MANAGE Screen of the InfoCube. Click on the PERFORMANCE Tab. Now click on CREATE INDEXES. This pops a dialog box. In this check the required entry and this should also take care of it.

Let me know, if this doesnt work out. Usually, DELETION of Indexes doesnt cause an issue like this.

Regards,

Praveen.

Former Member
0 Kudos

Praveen

Really sorry for posting a wrong query? Its not "Delete Index" its "Create Index"

The create Index Process is not triggering in the PC?can anyone come out with the reason and solution?

Many Thanks

balaji

Answers (1)

Answers (1)

Former Member
0 Kudos

How many data have the cube?

if there are many data (i.e.> 5.000.000) the drop index is an activity very delicate, moreover this operation is very long, it is not advised to insert this step in the PChain. There are many OSS note.

Chek the job by Sm37, if this is stopped, the chain is in stand by mode and it does not go ahead...

Bye

Alessandro

Former Member
0 Kudos

Hi

Alessandro

thanxz for your reply.Iam not authorized to OSS notes can u give me that notes details?

Sorry,for posting wrong Query?

Its not "Delete Index its "Create index"

Many Thanks

balaji

Former Member
0 Kudos

Alessandro,

Could you give us please those note numbers? I'm facing a problem when creating an index on an InfoCube of about 8,5 milion records.

Thanks,

David.

Former Member
0 Kudos

Hi,

look at e.g. 323090

/manfred