cancel
Showing results for 
Search instead for 
Did you mean: 

BI Statistics - Process Chains

Former Member
0 Kudos

Hi Guys,

I am back with another question. 2 of the statistics process chains seem incomplete to me. Is there a way to check if the process chains are complete?

Any help will be greatly appreciated.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Govind,

Logid gets generated only if the process chain have executed.

What do you mean by the process chain incomplete is that the structure you are reffering to? or the execution details.

Related to BI stat's we have 6 process chains

2 PC for master data load

2 for Query runtime stat's

2 for Data load stat's

You can check the details of the structure in table RSPCCHAIN by giving the process chain Technical name.

Hope it helps.

Regards,

Srilatha

Former Member
0 Kudos

Use the Function Module "RSPC_API_CHAIN_GET_STATUS"

The function module "RSPC_API_CHAIN_GET_STATUS" gives you the Status of the process chain, when you pass the Chain Name and the Log ID.

If you get an output

G or F - Report that the Chain is Successfully Completed.

A - The chain is Currently running

R or X - Report that the chain has ended with Errors.

RFC target sys would be the technical name of your BI system,you can find it on RSA1>Sourcesystem or RSA1>Mapping of source systems

Hope it Helps

Chetan

@CP..

Former Member
0 Kudos

You can also put ur Process chain in RSPCM (Monitor the process chain) & give ur mail id & give an Interface it will give daily report on that process chain ( If scheduled Daily).

Go to RSPCM.

Click on Add chain( It is just like create button) select ur process chain which u want to get details daily

Hope it Helps

Chetan

@CP..

Former Member
0 Kudos

Hello Chetan,

What value should I pass to Log ID parameter in the function module? There are no logs for this process chain.

Any help will be greatly appreciated.

Former Member
0 Kudos

goto table - <b>RSPCLOGCHAIN</b>

This should give all LOG_ID for one chain_id.

Take the last one (date and time of the run is available)

Hope it Helps

Chetan

@CP..

Former Member
0 Kudos

Goto transaction code SE11, give table name RSPCPROCESSCHAINLOG...Give the chain name & date of the status you would like to know.Additionally, you could provide the Instance/log id from the log view of the process chain(Displayed in the Left Pane).

Former Member
0 Kudos

The table RSPSPROCESSLOG shows start and end time ,you can also use this alternatively.

Hope it Helps

Chetan

@CP..

Former Member
0 Kudos

What do you mean give an interface? I need to get the mail to have some context in it that gives status of the Pc. i'm having trouble getting the text of the e-mail to have meaning.

Thanks!