on 06-10-2014 10:35 AM
Hi All,
I have a situation with Delete Index in my process chain.
Delete Index step, before loading data to cube, is taking around 2Hr to complete but some times it completes within 5 mins.
Anyone faces such issue? If yes, how can I fix it?
Thanks and Regards,
Alok
It might be batch process problem. First find out how many Background batch processes (BGD) allocated for the client you are working on. Check in SM50 whether there are enough backgroud processes (BGD) left for your process chain. You can kill any less priority BGD processes. This will give your particular process in the process chain enough air to breath.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Karan & Gaurav.
How will I check/create statistics for the cube?
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hii,
If your cube is not on delta and has full load try to delete data and recreate the index after load.
This might be affective and faster.
Regards,
Akshay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alok,
Usually, Index creation and Index deletion steps take long time if statistics are not updated correctly. So, recheck once your process chain gets completed whether the database statistics are created or not and updated properly or not.
Thanks,
Karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alok,
Please check the tcode 'changerunmoni' to see if for any infoobject which is present in this cube is attribute change run is being executed or not.
If So, please kill ACR and see if delete index steps completes soon.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If Statistics are not maintained for the cube then also it might casue the high run time in index deletion.
if its urgent then, can u try doing it manually form performance tab....
or once process chain step is complete, create statistics for the cube. Next run should take less time
Please try.
Regards,
Gaurav
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.