on 04-26-2012 7:34 AM
Hello All,
Process chain to load the hierarchy is getting failed which runs weekly.
Few months before it was running perfectly fine but once it was migrated to a new box it started giving problem. Every week it fails at the same point i.e. at Save Hierarchy.
Below is the error which I got every time.
------------------------------------------------------------------------
Subseq. processing (messages): Errors Occurred
Start update of master data hierarchy
End update of master data hierarchy
Table /BI0/ICOORDER locked; cannot save hierarchy
------------------------------------------------------------------------
Process Chains: Errors occurred
0COORDER HIERARCHY LOADS "ABCD"
What is more surprising, when it is triggered by some tool it gets fail but when i run it manually it process it successfully. I had also changed the scheduling time but didn't got any success.
Experts, Please help me.
Thanks in advance!!!
Manish
Hi Manish,
check following thread and all suggestions
http://scn.sap.com/thread/2051713
check RSRV and a,lso check if any object is locked?check if any data load is still going on in SM37
Check RSMO for 0COORDER fopr all datasources for longer 3-4 month selection and see the last load..
Thanks and regards
Kiran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All,
As suggested by every one to use interrupt, I am having some questions before using it.
I have attached my existing process chain image with this file. If you see the image there are four infopackages getting triggered at the same time and with always link.
Please see the image once and guide me whether I need to change anything else in the process chain before implementing the interrupt.
Thanks,
Manish
Hi,
Before using the interrupt process have you checked if its working if u set up the debug loop of some 5 mins.
Right click on your AND process in Process chain -- select debug loop --set it as 3000 Secs and activate & schedule it back and check if it works or not.
If you want to use the interrupt process use it in b/n AND and your Save hierarchy process.
Regards
KP
Hi Manish,
All the infopackages are connected through Success/failure. There is a chance that when Extraction/further processing of Infopackage is still in progress locking the tables when the Save hierarchy step in PC is running. Hence check that no Infopackage process in running while Save hierarchy is running
Regards
Chandu
Hi Chandu,
Infopackages are connected through "always" link.
Is there anyways through which we can check whether any infopackage is running at background while the "Save Hierarchy" is triggered.
While lot of Experts has suggested to implement Interrupt.
Just a thought, If I change the link from "always" to "successful" will it help ?
Thanks,
Manish
Hi Manish,
If you find any Infopackage failed ang trigger passed to next step being the connector ALWAYS, you can give a try changing the link to SUCCESSFUL
While Save hierarchy is running, call T/A SM66 and check if any processes are running. In the table field, check if you can find any table related to 0COORDER.
Regards
Chandu
Hi,
first if u turn it successful then process chain will not move forward without that load it will stop at that point.. but you need to be really sure that next loads are dependent on this hierarchy load successful..
try to check the log in SM66 or SLG1 for this process..
study the process log in SM37 and check ST22 dump..
try manually running the pacakge and debug and see where it throws dump..is there anything which is inactive and u need to activate it?
Thanks and regards
Kiran
Hello All,
As suggested by you all, I have implemented the Interrupt with debug loop for 900 secs but even then it got failed.
Below is the list from the job log.
Hierarchy AMO2008 successfully saved for basic characteristic 0COORDER |
Hierarchy , loaded with request REQU_4PUAVXXGUJC4BLMQSXR0P1QE1, cannot be activated |
Hierarchy ASIAN successfully saved for basic characteristic 0COORDER |
Hierarchy , loaded with request REQU_4PU62T8UUJS31KH0E0OZA9DY1, cannot be activated |
Hierarchy CORPRETAIL successfully saved for basic characteristic 0COORDER |
Hierarchy , loaded with request REQU_4PU6JJLU7YIO2RW33DWFFC2XL, cannot be activated |
Hierarchy ENTER8615 successfully saved for basic characteristic 0COORDER |
Hierarchy , loaded with request REQU_4PU6JQ7YJR7N46N049X030Z4P, cannot be activated |
When process chain was running, I was checking the locked objects. Below is the objects which were locked not sure if it is really related. Once process started showing and again I checked the locked objects I couldn't find any there in the list.
UserName | Time | LockMode | TableName | LockArgument | Cumulative Counter | Use Count |
BIWREMOTE | 0:11:27 | E | RSHIEDIR | 4C95R1CYNX65JPQNV783XML3W# | 1 | 1 |
BIWREMOTE | 0:11:27 | E | RSHIEDIR | 4C95R4RV3ATHTQDUGK9KEI0KC# | 1 | 1 |
BIWREMOTE | 0:11:27 | E | RSHIEDIR | 4C95R86RIOGU3R111XB0VDG0S# | 1 | 1 |
BIWREMOTE | 0:11:27 | E | RSHIEDIR | 4C95RBLNY246DRO7NACHC8VH8# | 1 | 1 |
BIWREMOTE | 0:11:27 | E | RSHIEDIR | 4C95RI03QW7FWJVOICAPPVSYK# | 1 | 1 |
BIWREMOTE | 0:11:27 | E | RSPCENQUEUE | HIERSAVE Z01A | 1 | 1 |
BIWREMOTE | 0:11:27 | E | RSRHIEDIR_SHORT | 12 0COORDER | 0 | 1 |
BIWREMOTE | 0:11:27 | E | RSRHIEDIR_SHORT | 13 0COORDER | 0 | 1 |
BIWREMOTE | 0:11:27 | E | RSRHIEDIR_SHORT | 14 0COORDER | 0 | 1 |
BIWREMOTE | 0:11:27 | E | RSRHIEDIR_SHORT | 15 0COORDER | 0 | 1 |
BIWREMOTE | 0:11:27 | E | RSRHIEDIR_SHORT | 17 0COORDER | 0 | 1 |
BIWREMOTE | 0:14:49 | E | RSRHIEDIR_SHORT | ###########!ALLCHABAS | 0 | 1 |
Please help me folks.
Thanks,
Manish
Did you checked for locks in SM12 if any exists on 0COORDER?
check in the system at that what are all the processes running and also as you have said above, BI0/ICOORDER is the SID Heirarchy table. When this is not available it cannot complete the save hierarchy step.
If that table is locked by any other means, this step will fail.
NOTE: Whenever this object is used in any program which doesnt insert to this table , an exclusive lock is set.
Or else you can set a time delay for the IP for ex say 5mins(300Secs) or make use of interrupt process in PC in b/n IP n Hierarchy save step.
Regards
KP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prashanth,
Thanks for your reply.
Did you checked for locks in SM12 if any exists on 0COORDER?
Ans:- Yes, I had checked in T-Code SM12 but didn't found any entry for 0COORDER.
check in the system at that what are all the processes running and also as you have said above, BI0/ICOORDER is the SID Heirarchy table. When this is not available it cannot complete the save hierarchy step.
Ans:- When this process chain is running there are no any other process chain running.
Or else you can set a time delay for the IP for ex say 5mins(300Secs) or make use of interrupt process in PC in b/n IP n Hierarchy save step.
Ans:- Can you please guide me how can I put time delay for any InfoPackage.
Appreciate your time and help.
Thanks,
Manish
steps to setup the delay or use the interrupt process.
to set the time delay ...
--> right click on the IP (which is prior to save hirerarchy step) --> select debug loop --> enter there for ex 300Secs (5Mins).
even if the IP is finished successfully , due to debug loop of 300secs the next process will not get triggered. save hierarchy step will trigger after 5mins of the completion of IP load.
Next process is to use Interrupt process in Process chain.
We have Interrupt process in General setting area.
here you need to create events for the above process, event will check if the above process is completed or not then it will trigger the next process
Interrupt process will not work in your case .... use the debug loop option inorter to delay ur process.
Regards
KP
Hi Manish,
Please try the below points,
1. Please check T Code RSH1 and see that hierarchy in M state, try activating that particular hierarchy.
2. Also check if the timeout time of Infopackage in RSA1 and also see the time taken by process chain Infopackage load step to get completed. Process chain may fail when PSA load step takes more time than Infopackage time out time. Plese increase the time out time of Infopackage and try runnig PC.
Thanks,
Vinod
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinod,
Please find my comments inline for below points as suggested by you.
1. Please check T Code RSH1 and see that hierarchy in M state, try activating that particular hierarchy.
Ans:- I have checked in the system, there are no objects which are in 'M' state. I have re-run the process chain manually,perhaps this is the reason why any object is not in 'M' state.
2. Also check if the timeout time of Infopackage in RSA1 and also see the time taken by process chain Infopackage load step to get completed. Process chain may fail when PSA load step takes more time than Infopackage time out time. Plese increase the time out time of Infopackage and try runnig PC.
Ans:- Can you please explain how can i check these details?
Thing which is baffling me is why it fails at the first place when it is being triggered by third party tool and it run successfully when I run it manually.
I have even rescheduled the process chain but even then it is getting failed.
Regards,
Manish
Hi Vinod,
Hope you are doing good and had a gr8 weekend. Sorry for replying late but it was deliberate as I was waiting for the process chain to run and follow the steps which you have suggested.
Please find my comments inline for below points as suggested by you.
1. Please check T Code RSH1 and see that hierarchy in M state, try activating that particular hierarchy.
Ans:- I have checked in the RSH1 and found three hierarchy in 'M' state.
2. Also check if the timeout time of Infopackage in RSA1 and also see the time taken by process chain Infopackage load step to get completed. Process chain may fail when PSA load step takes more time than Infopackage time out time. Plese increase the time out time of Infopackage and try runnig PC.
Ans:- I have checked the "timeout" time of infopackage and it is 7 hours.
Regarding the time taken by the process chain to complete it took only 3 mins.
Regards,
Manish
Hi,
Hey i'm not talking about the timeout setting that we set for IP in infopackage screen.
I'm talking about how to delay the next process in PC once the above process is completed.
Inorder to find out where all the areas your hierarchy is used, run a where used list and check where its being used.
Did you checked the option debug loop in PC and check if you this helps or not?
Regards
KP
Hi Vinod,
Hope you are doing good.
I have observed that process chains fails because it is not able to change the status of objects from 'M' to 'A'.
Every time the process chain fails it is the same objects whose status are not changed and this is happening every week.
Is this any kind of bug? What could be the possible solution to resolve this issue?
Thanks,
Manish
Please just let me know what is process chain steps to load InfoObject '0COORDER'.
Like Master data attribute -> text load -> Hier load etc.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Experts,
Please help me. This is a urgent issue for me.
Thanks,
Manish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
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.