cancel
Showing results for 
Search instead for 
Did you mean: 

Process type - Activate ODS Object

Former Member
0 Kudos

Hi All,

I have a small error and request some input from you guys..

Issue : R/3 to ODS A and then to ODS B loading via a process chain.

ODS B is having other ODS & cubes connected.. there is another process chain which pushes the data from ODS B to connected targets.

Steps are as follows:-

1) R/3 packet loaded to PSA then to ODS A.

2) Activate the REQ and further processing - loading the request to ODS B.

3) Activate ODS OBJECT DATA - fails at this point.

Monitor screen - displays Data loaded successfully to ODS B.(green lights)

ODS B - Manage request screen. Request activated but QM status lights are RED.

When I went and checked the details tab for ODS B load monitor -

Subsequent procesing

error: Request REQU_46LMNFLCKR9YC7PWI0OF6LA8N , data package 000010 incorrect with status 9

Can anybody give me some helpful hints.

Points will be rewarded.

Thanks

Rao

Accepted Solutions (1)

Accepted Solutions (1)

former_member195940
Active Contributor
0 Kudos

Rao,

whats the exact error message you see on ODS B in monitor screen!!

give us the "long text"

You said there another PC which pushes data from ODS B to other data targets.

for this purpose are you using a "event"?

kalyan

Former Member
0 Kudos

Kalyan.

When I went and checked the details tab for ODS B load monitor -

Subsequent procesing

long txt error: Request REQU_46LMNFLCKR9YC7PWI0OF6LA8N , data package 000010 incorrect with status 9

Process chain 2 - will push the data from ODS B to all the reporting objects...but this is a seperate process which runs on daily basis.

my job is to get the data loaded from R/3 -ODS A - data mart to ODS B.

thanks

Rao

Former Member
0 Kudos

Kalyan - NO EVENT used..

former_member195940
Active Contributor
0 Kudos

Rao,

1. If the ODS A is active and available for reporting then

2. Delete the request from ODS B.

3.Do a manual load from ODS A to ODS B and make sure you activate it. (I assume you have fixed the error)

4. As this is a part of process chain, we need to keep the delta ponters in Sync.

so, go to ODS A info package and do a INIT without data transfer load (If you are in prod sys, create a copy of the info pak)

5. Do the same (Init w/o data transfer) for ODS B info pacakge load.

tomorrow morning when your delta runs, they will be in sync..

assign points if this helps

kalyan

Former Member
0 Kudos

Kalyan.

Thanks for your reply!

Just to give an overview of my problem.

1) ODS A(Support ODS- for emergency loads to fix any corrupt data.)

2) R/3 to ODS B(current deltas configured) loads to further reporting cubes (All this works fine and no issues)

3) For example we have to load an old data packet to fix corrupt data via transfer rules.. we re-load a packet into Support ODS(A) using full-update.

-- ODS A - always gets emptied before doing this process as it send full-updates and not deltas.

-- LOAD R/3 data (old packet 011.2007) to - ODS A - full update.

-- via a data mart interface we push this period to ODS B(Current ODS). thats it rest all works as it is!

So i built a process chain only to do an emergency/support load if required at any given time. Steps are -

1) Delete ODS A data

2) Load 1 period into PSA and then into ODS A

3) Activate the request

4) Further update into ODS B

5) Activate the req in ODS B

Aanyways I will try as you said and see if it works.

Thanks

Rao

Answers (1)

Answers (1)

Former Member
0 Kudos

Check the Settings in the second ODS object I feel the second ODS object setting should be Activate ODS object automatically.

Please check the settings of the second ODS. If u are using in the Process chain i think the option should be Update in data targets not activation for the second ODS.

Message was edited by:

Shahid Syed

Message was edited by:

Shahid Syed

Former Member
0 Kudos

Hi Shahid,

these are the settings for both the objects.

ODS A

-


Set quality status to 'OK' automatically = YES

Activate ODS object data automatically = YES

Update data targets from ODS object automatically = NO

ODS B

======

Set quality status to 'OK' automatically = YES

Activate ODS object data automatically =YES

Update data targets from ODS object automatically =NO

In my process chain I used "Update in data targets" as mentioned. this way its loads my request from A to B..but it wont activate my request in ODS B??hence I included the Activate ODS OBJ process type for my ODS B as a last step.

thanks

Rao

Former Member
0 Kudos

For the first ods do the full update and keep the three settings check box.

ODS A

-


Set quality status to 'OK' automatically = YES

Activate ODS object data automatically = YES

Update data targets from ODS object automatically = YES

ODS B

======

Set quality status to 'OK' automatically = YES

Activate ODS object data automatically =YES

Update data targets from ODS object automatically =NO

for the second ods do the initilization and check the two options data will come to second ods object. if u want to do the further update check the third option also.

Former Member
0 Kudos

take the process types in this sequence

load data into first ods with the same options mentioned in the above mail

load data into second ods with the same options

activate 1st ods

activate 2nd ods

Update from 1st ods to 2nd ods.

regards

shahid

Former Member
0 Kudos

Thanks for valueable hints..

I would follow your instructions, but 1 quick question regd the activation for both the ODS objects.

my case...

ODS A sends data to ODS B in a datamart function and hence I am not sure if the DATA from A will move further without activating the request in ods A?? am just a newcommer in this field but i wll try as u said.

thanks

rao