Entry 70 still missing

[#1]

Hello Experts,

I have browsed these forums on the matter at hand, but was unable to find a solution to my problem, hence my post.

We are retreiving data from our XI system. This is done via Web Service (Push) adapter (data is being pushed to BI from XI).

While launching a test packages into BI, we have come across a strange situation: the data is being saved to PSA (and is physically present there) almost instantly but the process, when checked in the monitor, is still "Yellow" and a message

Data Package 1 : arrived in BW ; Processing : Processing not yet finished, entry 70 still missing

can be found in the Transfer (IDocs and TRFC) part of the Details tab of the process monitor.

I've read on SDN that this is because the process still continues due to large amount of data and I can let it roll and it should eventually complete (turn "Green') or I could manually set the status to "Green" myself - however - in our case, we are talking about 130 records taking... 18 days 20 hours to finish (sic!) - at least that's what the header of the process monitor is stating, and I don't see why it would lie

While I could understand that large volumes take some time to finish loading properly to BI, I am disoriented as to why it would take almost 3 weeks to load 130 (one hunder and thirty) records.

Could anyone point me in the direction of the probable cause of this situation? I would be deeply thankful.

Best regards,

Aleksander

[Former Member]

Hi,

Same error message when loading from a file. In our case, this a 7 years process which always get success. In tCode st22 (ABAP Runtime Error), I see the error was related with an unstable index. Once the index has been fixed, the processing return to normal.

Regards,

Andre

[Former Member]

Whenever we deal with Million of records loading to cube, Always drop the index and recreate it after load completes.