on 11-29-2011 5:22 AM
HI ALL,
when i doing below step creation of process chain i am getting below error.
1. Delete indexes
2. Delete request in cube(pervious request)
3. Load data (full load)
4. Load data (delta load)
5. Create indexes
I get an error message below.
Process LOADING variant PAK_BF is referenced but is not a predecessor
Message no. RSPC061
Diagnosis
Process LOADING, variant PAK_BF must precede process REQUDEL ZFWCRC03 in the chain. However, there is no connection between these two proceses.
System response
The system is unable to activate the process chain.
Procedure
Change process REQUDEL ZFWCRC03 so that it no longer references LOADING PAK_BF, or schedule process LOADING PAK_BF in the chain so that it precedes REQUDEL ZFWCRC03.
i have checked below link but no answer.
Please help me on this.
Thanks,
prasantha.k
Edited by: kumar reddy on Nov 29, 2011 6:23 AM
You design it self is not the best one.
use the below design
-> Start -> Delete index -> IP load ->DTP ->create index -> delete overlapping request -> aggregate roll up(if any aggregates are build on this IC).
First perform Full manually then later you can trigger the process chain for delta loads.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would suggest to go to RSPC change mode for this process chain. Check if everything of fine?
Activate it and rerun the Chain again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Process chain design you need to keep Cube deletion with overlaping options at the end i.e. after your loading process.
Example:
1. Start
2. Delete index
3. Delete PSA
4. IP execution
5. DTP
6. Delete cube data with overlaping option.
try with this.
Regards
Jagadeesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.