Process chain errors

[Former Member]

Hi all,

I have a process chain in which an ODS (ODSA) gets loaded from a Datasource. This ODSA then loads an Infocube (CubeA) and another ODS (ODSB). This ODSB then loads another Infocube (CubeB).

The steps i followed in the process chain:

1. start process

2. Execute InfoPackage for delta data to be loaded into ODSA.

3. Activate ODSA.

4. Update ODS object data (Further Update).

5. Execute InfoPackage for loading ODSA delta data (I chose a ingle infopackage since this infopackage will have both CubeA and ODSB as its datatargets in the infopackage scheduler).

6. Activate ODSB.

7. Execute InfoPackage for loading ODSB delta data into CubeB.

The foll. are the errors which i get.

1. Error: InfoPackage ZPAK_3XXX is generated; NOT able to be used as loading variant.

2. Error: A type "Update ODS Object data (Further Update)" Process Cannot precede process "Execute InfoPackage" var. ZPAK_3XXX.

3. Warning: A type "generate index" process has to follow process "Execute InfoPackage" var. ZPAK_3XXX in the chain.

could you please tell me what sequence do i follow for the above scenario.

Thanks a lot.

[Former Member · Accepted solution]

Hi sachin!!

I guess Anil is right.

But i would advice you not to use the further update process and go for the load infopackage(single) for both the datatargets.The steps would theb be as follows:

1) Start process.

2) Load data into ODS A.

3) Activate ODS A

4) Load data(single infopackage) to datatargets IC 1 and ODS B.

5) Activate ODS B.

6) Delete index.

7) load data into IC 2.

😎 create index..

One more thing ! when you drag an infopackage(suppose that it is updating data to an infocube), then you will get the processes delete and create indices also.

If you want to avoid getting them, you can set the option by going to settings in RSPC -default chainstick mark the checkbox --do not suggest process.

hope it helps!!

MM

[somnathkumar]

Hi Sachin,

'Further Update' step will load delta data from ODSA to ODSB as well as the CubeA as long as there are active update rules to these to data targets. I am assuming that all you want to do is delta load and not full load from the ODS.

The ideal sequence should be.

1. Start Process

2. Execute InfoPackage for delta data to be loaded into ODSA.

3. Activate ODSA.

4. Delete Index for CubeA and CubeB.

5. Further Update for ODSA. (This will also load CubeA).

6. Activate ODSB.

7. Further Update for ODSB. (This will load CubeB).

8. Create Index for CubeA and CubeB.

This will remove all 3 errors.

[Former Member]

Hi,

What is the significance of step 5 , if you already started the upload from ODSA to further Data targets using step 4. I hope you have to remove any one of the step from 4 and 5 .

i.e Further Update means uploading the data from the ODSA to further datatargets.

With rgds,

Anil