Process Overdue

[Former Member]

Hi All,

I have a load contains huge data (25lak). Started yesterday it took 22 hrs, finished with time out error.(Process Overdue)

How to make the load fast and load with minimum less time?.

Please let me know step wise. Advise me

Thanks in advance.

[Former Member]

Hi,

Yes, process Overdue error is occurring due to huge data volume. In addtion of splitting data, create index on data targets.

Hope it helps.

Regards,

Aditya

[edwin_harpino]

hi Srilaxmi,

whenever possible, try to extract the data in several loads in smaller volume by filtering the value in infopackage.

review

Note 567747 - Composite note BW 3.x performance: Extraction & loading

'SAP BW Data Load Performance Analysis and Tuning'

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/media/uuid/10b589ad-0701-0010-0299-e5c28...

hope this helps.

[Former Member]

Hello Srilaxmi,

Try to load data in smaller packets. You can specify, the selection condition and create several InfoPackages to load all data. You also need to ensure that your datapacket size is optimal.

Check in table ROOSPRMS table and update the MAXSIZE, STATFRQU, MAXPROCS and MAXDPAKS values accordingly.

This table will help u to overwrite current system settings for data transfer process.

-- Plz assign points if helpful --

Thanks,

Mainak

[Former Member]

in Addition, drop indexes of the cube before loading, and create indexes after load completes.

Keep optimal packet sizes and load the infopackages in parallel. This saves a lot of time.

Assign points if useful!

Regards

GSK