BI PROCESS CHAIN FINISHES

[Former Member]

Our BI team says their process chains fails. They believe the background work process needs to be increased but the process chains worked before with the same number of background work process. Below are the logs. Please advise what the issue could be?

Job log overview for job: BI_PROCESS_ODSACTIVAT / 04151805

-

---

Date

Time

Message text

Message class

Message no.

Message type

-

---

01/18/2011	04:20:48	Job started	00	516	S
01/18/2011	04:20:48	Step 001 started (program RSPROCESS, variant &0000000060062, user ID RFC_USER)	00	550	S
01/18/2011	04:20:49	Start process ODSACTIVAT 0FIGL_O10_ACTIVATE in run D9P5M2U4CXUVAA6FL27KQ4D1K of chain ZNGK_GL_TRANS_LOAD	RSPC	156	S
01/18/2011	04:20:50	Activation is running: Data target 0FIGL_O10, from 58,007 to 58,007	RSM	744	S
01/18/2011	04:20:53	Overlapping check with archived data areas for InfoProvider 0FIGL_O10	RSDA	230	S
01/18/2011	04:20:53	Data to be activated successfully checked against archiving objects	RSMPC	153	S
01/18/2011	04:20:54	RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_INSTANCE_FOR_RNR 58007 LINE 43	RSAR	051	S
01/18/2011	04:20:54	RSS2_DTP_RNR_SUBSEQ_PROC_SET GET_TSTATE_FOR_RNR 2 LINE 243	RSAR	051	S
01/18/2011	04:20:55	Status transition 2 / 2 to 7 / 7 completed successfully	RSBK	222	S
01/18/2011	04:20:55	RSS2_DTP_RNR_SUBSEQ_PROC_SET SET_TSTATE_FURTHER_START_OK LINE 261	RSAR	051	S
01/18/2011	04:20:58	Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIBCTL_D9P5N9L4OY3UWHC1ZYW0FFU2W with ID 04205800	RSM	703	S

1/18/2011|04:22:17|Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIBCTL_D9P5N9L4OY337V0AOFGED0FT4 with ID 04221700| RSM | 703 | S |

01/18/2011	04:22:18	Parallel processes (for Activation); 000003	RSODSO_TOOLS	018	S
01/18/2011	04:22:18	Timeout for parallel process (for Activation): 000300	RSODSO_TOOLS	019	S
01/18/2011	04:22:18	Package size (for Activation): 020000	RSODSO_TOOLS	020	S
01/18/2011	04:22:18	Task handling (for Activation): Backgr Process	RSODSO_TOOLS	021	S
01/18/2011	04:22:18	Server group (for Activation): No Server Group Configured	RSODSO_TOOLS	022	S
01/18/2011	04:22:18	Parallel processes (for SID Gener.); 000003	RSODSO_TOOLS	018	S
01/18/2011	04:22:18	Timeout for parallel process (for SID Gener.): 000600	RSODSO_TOOLS	019	S
01/18/2011	04:22:18	Package size (for SID Gener.): 020000	RSODSO_TOOLS	020	S
01/18/2011	04:22:18	Task handling (for SID Gener.): Backgr Process	RSODSO_TOOLS	021	S
01/18/2011	04:22:18	Server group (for SID Gener.): No Server Group Configured	RSODSO_TOOLS	022	S
01/18/2011	04:22:18	Activation started (process is running under user RFC_USER)	RSODSO_PROCESSING	029	S
01/18/2011	04:22:18	All data fields updated in mode "overwrite"	RSODSO_TOOLS	023	S
01/18/2011	04:22:18	Process 000001 for determining SID for InfoObject 0CO_AREA started	RSODSO_PROCESSING	045	S

RSODSO_TOOLS	023	S
01/18/2011	04:22:19	Process 000001 for determining SID for InfoObject 0CO_AREA started	RSODSO_PROCESSING	045	S
01/18/2011	04:22:19	Process 000002 for determining SID for InfoObject 0CHRT_ACCTS started	RSODSO_PROCESSING	045	S
01/18/2011	04:22:19	Process 000003 for determining SID for InfoObject 0CURRENCY started	RSODSO_PROCESSING	045	S
2011	04:22:19	SID determination finished for InfoObject 0CO_AREA	RSODSO_PROCESSING	033	S

18/2011|04:22:19|Process started |RSODSO_PROCESSING| 031 | S |

01/18/2011	04:22:19	Process started	RSODSO_PROCESSING	031	S
01/18/2011	04:22:19	Process completed	RSODSO_PROCESSING	032	S
01/18/2011	04:22:19	Process completed	RSODSO_PROCESSING	032	S
01/18/2011	04:22:19	Activation ended	RSODSO_PROCESSING	030	S
01/18/2011	04:22:19	Data pkgs 000001; Added records 1; Changed records 0; Deleted records 0	RSMPC	137	S
01/18/2011	04:22:19	Data pkgs 000002; Added records 1; Changed records 0; Deleted records 0	RSMPC	137	S
01/18/2011	04:22:19	Log for activation request ODSR_D9P5N86EQQSSBKFT1LWB9FSW8 data package 000001...000002	RSMPC	136	S
01/18/2011	04:22:19	Activation of records from DataStore object 0FIGL_O10 sucessfully finished	RSM1	103	S
01/18/2011	04:22:22	SQL: 01/18/2011 04:22:22 RFC_USER	DBMAN	099	I
01/18/2011	04:22:22	TRUNCATE TABLE "/BI0/AFIGL_O1040"	DBMAN	099	I
01/18/2011	04:22:23	SQL-END: 01/18/2011 04:22:23 00:00:01	DBMAN	099	I
01/18/2011	04:22:23	U table for DataStore object 0FIGL_O10 deleted successfully	RSM1	192	S
01/18/2011	04:22:23	No active PSA table for DataSource 80FIGL_O10 and source system BIPCLNT300 found	RSBATCH	012	I
01/18/2011	04:22:24	Internal session terminated with a runtime error (refer to ST22)	00	671	A
01/18/2011	04:22:24	Job cancelled	00	518	A

[TomCenens · Accepted solution]

Dear

Your job log sais what went wrong:

No active PSA table for DataSource 80FIGL_O10 and source system BIPCLNT300 found

You should find a shortdump of this event in transaction ST22.

Kind regards

Tom

[nirmal_konchada]

Hi,

This is not the case of unavailability of background WP as it clearly shows that the job has been sarted and ended in errors.

Read the log carefully.

Regards,

Nirmal.K