on 01-25-2006 1:03 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.