RSPC

[#1]

In RSPC, I have 15 Process chain.

1) How do I know which one is running and which one is not?

2) How do we know if the Process Chain is finished running successfully, including what time it complete?

3) Also, is there a way for us to see the number of records being extracted?

Please advise, thank you.

[Former Member]

1) How do I know which one is running and which one is not?

Go to RSPCM, the yello status of the process chain indicates that this is still running.

2) How do we know if the Process Chain is finished running successfully, including what time it complete?

If the status of the PC in RSPCM is green, it indicates that it is completed sucessfully. You can see the time against your PC in rspcm.

3) Also, is there a way for us to see the number of records being extracted?

Go to the data target from the process chain log to see the number of records extracted. Else, the log details of the process chain step also shows the no of extrated records

[pmoh]

Hi,

In RSPCM, the time is actually the start time, not stop time of the process chain.

In RSPC, I double-click on the Process Chain and go to View Log.

There, I can see what also the Start Time of the Process Chain, not the stop time.

How can we see the Stop Time of the Process Chain???

Please advise, thanks.

[Former Member]

Hi,

The solution would some hard.but you might find some clues.

I think if we know the process chain job name, we can know the when the job is stoped.

which in turn means the process chain has stoped.

Am i right?

As all the process chain jobs start with BI_PROCESS .

GO TO SM 37

give

job name= bi_proces*

date the date on which the proces chain stared.(as u can see in RSPCM)

Execute.

you get list of jobs

select one and clik on job log

Here you should find the to which chain the job belongs to?

Note:to know the start date .

I don't have BW 3.5 version so i could not tell about it.as already ourexperts told that some tcode you can get it from that.

Regards

Naresh.

[pmoh]

Naresh,

I have checked that before but in SM37, I can only see the job time only!

What I noticed is the Job stop time does not mean the Process Chain's completion time!!!

Please advise.

[Former Member]

table RSPCLOGCHAIN : this will give you for a given process chain the logid's for every run of the chain

the field RSPCLOGCHAIN-ANALYZED_STATUS will give you the actual status of the process chain (for every logid, meaning for every run time)

table RSPCPROCESSLOG : for every logid found for your process chain in the above table, you 'll have the start and end timestamp of all the different steps. the latest end timestamp is the end timestamp of your chain.

if you need this info on a regular basis, you're better off writing a small abap report. this is easily done and you'll gain a lot of tlme.

M.

[Former Member]

while you're developping your program, you can add the table RSREQDONE.

field RSPCPROCESSLOG-INSTANCE = RSREQDONE-RNR. the field RSREQDONE-RECORDS gives you the number of records extracted from R/3

M.

[pmoh]

Mti,

Thanks for the tips. I will try to see the table.

Just curious, is it really no way in any transaction (RSPC, RSA1 etc) in BW system we can see the Process Chain start and stop time easily?

[Pravender]

Instead you can use tcode RSPCM, include your process chain here (create button) if its not available here and see the timing.

[pmoh]

Pravendar,

As mentioned, RSPCM only tells us the START TIME of the Process Chain, and its STATUS.

What we want to know is the STOP TIME of the Process Chain, and also, the number of record be extracted by this Process Chain.

Possible?

Please advise, thank you.