on 02-26-2015 2:46 PM
Dear Experts,
I have a planning sequence for which I have configured it to run by Packages.
Even after multiple configurations, the planning sequence fails.
For e.g, if I set packaging with no. values 5000, for running a planning sequence for 1000 records, it processed with 966 records and the remaining 34 is not processed.
If I reduce the data to be processed via planning sequence is 600, still 570 alone is processed and the planning sequence fails.
I would like to know the background of packaging and would need to know how to set optimal packaging for a successful planning sequence execution.
Your inputs are highly appreciated.
Many thanks in advance!
Br, Harish
Hello Harish,
we are facing with same issue. can you please let us know, if you have manged to find the root cause or solution for the issue.
Thanks in advance,
Dharnesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harish,
I never used the functionality, though I thought you have to set the packages via master data values.
So I don´t really understand, what you mean by no. of values. Are you counting data records or master data records?
Is there any aggregation done before the sequence runs?
Does the sequence run with your expected no. of records = 1000 in planning modeler?
regards
Cornelia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Cornelia,
Many thanks for your reply.
I have set the packages with dimension tables instead of master data. I don't have any concrete grounds on this setting though.
The No. values is the automatic proposal given for my planning sequence.
How to define aggregation before executing planning sequence?
Yes, my sequence automatically distributes the number of records equally to number of packages I have specified.
In spite of many settings I have tried, No Packaging, Packaging (no/automatic/default configuration), the sequence fails.
I have gone through the below URL for understanding.
Still, I'm not sure what is the optimal setting for executing a planning sequence
Could you please advise on this?
Br, Harish
Hi Harish,
if I understan dit right, the difference between master data and dimension is, that the packages are created either by the master data table of the selected characteristic or by the values already booked in the info provider.
to influence what the system is doing, I would not choose the automatic packaging, but I would choose a characteristic manually. as described in SAP help, it has to be one, that is not changing in any of your planning functions. What is it, what you are planning? It´s hard to suggest which char to take, maybe a customer, or cost center ...
how many functions are in your sequence? could you try to start with a sequence and just one function? and then if that one runs, add the other functions one by one.
also check again your locking characteristics. In SAP help it describes something about a join of filters by a master process. And your error message suggests, that there is something wrong with this master process.
Also make sure, that there are no locks by any users while you are running the sequence.
And make sure that you do have enough background proceses for the process chain.
That´s pretty much all the ideas that I have so far. But don´t hesitate to give a bit more information about what the functions are doing, maybe I get some additioanl ideas.
good luck
Cornelia
Hello Cornelia,
Many thanks for you response and the hints. It's quite helpful.
To answer your questions,
1. I'm using single planning function in my sequence. The PF is standard copy
I copy a set of opportunities against which manual planning is made.
The copy is from source real time cube to target infocube
2. I used this opportunity number as my packaging characteristic and i also ensure that there are no locks by end users during this copy.
3. I quite don't understand about the master process. What I'm thinking is, if my master process is wrong, the entire planning sequence should fail. But it has processed successfully for some opportunities.
4. Also, before executing the planning function, i deactivated my data slice and then activate it after completion of planning function.
Let me know if you need any more details on this.
Br, Harish
Hi Harish,
Can you provide the more information about the error (error message or dump information)?
Best Regards,
Sheldon.
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 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.