Processing is Overdue

[Former Member]

Hi BW Experts,

I have a problem in my process chain.

We r loading HR processs chain (Full Load) daily.

Today i got a problem in HR Process Chain.

The message has shown like this.

Request still running

Diagnosis

No errors found. The current process has probably not finished yet.

System Response

The ALE inbox of BI is identical to the ALE outbox of the source system

or

the maximum wait time for this request has not yet been exceeded

or

the background job has not yet finished in the source system.

Current status

in the source system

But iam unable to understand this problem.

Could u pls anyone solve this problem.

Iam very helpless here.

Thanks & Regarsd

Anjali

[srinivas_anilkumar · Accepted solution]

Hi,

Has the load picked up any records till now? If so, let it finish. I would also suggest you to check the job overview in source system. if it got cancelled then check what the error is.

Regards

Srini

[Former Member · Accepted solution]

Hi Srinivas, Good afternoon.

It shows

01:51:39 ( 100029 From 0 Records ) .

I checked the Job overview in Source System and it showed ACTIVE

What should i do now.

Pls give me the reply very soon.

Thanks & Regards

Anjali

[Former Member · Accepted solution]

Hi Anjali,

The job in the source system has not finished, so have to wait for the job in the source system to get over.

And there are many reasons why it gets delayed , like unavaialbility of system server resources, un availability of the background processes.

You can also check the tcode sm37 and for your job see the delay field , this will indicate the seconds job had to wait before it started execution..

Still if you fill something is wrong you can definitely stop the job in source system and restart the process from BW end . and for that you have to delete the existing request from Cube/ODS.

And the overdue time out is at infopackage level . Click on infopackage -> scheduler -> Time out time .Increase this time if you get this error frequently.

Hope that helps.

Regards

Kapadia

***Assigning points is the way to say thanks in SDN.***

Message was edited by:

Mr Kapadia

[Former Member · Accepted solution]

Hi Mr.Kapadia,

Thanks for the good response.

Can you please tell me process how to delete the request and how to reload the data into my CUBE.

This is Full Load.

I hope that u will give the reply.

Thanks & Regards

Anjali

[purvang_zinzuwadia · Accepted solution]

Hi Anjali,

to delete the request follow the steps.

right click cube -> select mange -> request -> select request no to delete -> click delete button.

regards,

purvang

• Assigning Point is to say Thanks in SDN *

[Former Member · Accepted solution]

Hi Shankar ,

Thanks for your help.

i deleted the request from infocube.

Pls tell me the process how to reload the data into INFO CUBE.

Pls give me reply very urgent.

I am very helpless here.

Thanks & Regards

Anjali

[purvang_zinzuwadia · Accepted solution]

Hi Anjali,

As u have said, u are doin full load. so run the info package for the info cube load.

just make sure that in the update tab of info package "Full Update" radio button is selected.

Also in data target tab page, your cube is selected. then from the schedule tab page click on start button.

your load will start, you can also monitor your load thruogh RSMO.

hope this helps.

Regards,

Purvang

• Assigning Point is to say Thanks in SDN *

[Former Member]

Hi

Please check whether job is finished at the source system

Environment -> Job Overview -> Source System..if it is finished...

check all data packages in the details tab of the RSMO...if you find that data is correct and passed to update rules and there it is saying that missing messages...then do manual update for all data packages...before doing this make the request as red and after completion of all manual update of the packages..change to 'back to technical status'...

Hope it helps

Thanks

Teja

[Former Member]

Hi Teja,

Thanks for the good response .

But when iam trying to do Manually Update, but its not working.

Iam unable to do Manually Update.

Then what should i do.

The message displays like this.

(Green) Requests (messages): Everything OK

-

---

>> (Red) Extraction (messages): Missing messages

(Green) Data request received

(Green) Data selection scheduled

(Yellow)Missing message: Number of sent records

(Yellow)Missing message: Selection completed

-

---

>> (Red) Transfer (IDocs and TRFC): Errors occurred

(Red) Data Package 1 : arrived in BW ; Processing : Selected number does not agree with transferred n

-

---

>>(Green) Processing (data packet): Everything OK

-

---

>(Green) Data Package 1 ( 100029 Records ) : Everything OK

(Green)Update PSA ( 100029 Records posted ) : No errors

(Green) Transfer rules ( 100029 -> 100029 Records ) : No errors

(Green) Update rules ( 100029 -> 200058 Records ) : No errors

(Green) Update ( 200058 new / 0 changed ) : No errors

(Green) Processing end : No errors

-

---

>> (Red) Process Chains : Errors occurred

Please tell me process

Thanks & Regards

Anjali

[purvang_zinzuwadia]

Hi Anjali,

first you have to make sure that job is finished in source system. you can check this by Environment -> Job Overview -> Source System.

If it is not finished, then there is nothing to worry, wait till it gets finished.

If the job is finished, then check the details tab of the load in RSMO. tell me what is it showing.

Regards,

Purvang

[Former Member]

Hi Shankar, Good Afternoon.

Thanks for the good response.

I have already checked in JOB OVERVIEW --> SOURCE SYSTEM

It displays ACTIVE

X

Pls tell me what should i do next.

Thanks & Regards

Anjali

[purvang_zinzuwadia]

Hi Anjali,

So the job is active in the source system.

now tell me if it is taking the usual time or taking much more time than regular one.

if the job is active in the source sytem for unusually long time then check in ST22 if there is any system dump related to your load is there or not ?

if there is no system dump then check in SM21. it maintains application logs, see there if any message is there with reference to the time when your load is running.

hope this helps.

Regards,

Purvang

• Assigning Point is to say Thanks in SDN *