Cancel initialization of data source

[Former Member]

I have submitted an infopackage to initialize a data source.  The data source will have about 7.5 million records and when the infopackage was created, they did not create it properly with no data selections for this item, so we could not break it down like some of the other infopackages.  In Quality Assurance, it processed 100,000 records per hour but in PROD it is only doing 20,000 per hour.  My questions are:

1) Can it be cancel with no repartations?

2) Will there need to be any cleanup after the cancellation?

[Former Member]

Hi Bruce,

Basically, quality system don't have busy compare to PRD. So, QA system data loading is faster then PRD.It may be the case that your system don't have background job to process  or idoc is stuck in SM58 at that time. Try to run the DS when your system is free like after business hour of R/3 users.

Is this DS is generic or standard?

If generic DS, it is based on the FM or View based. If FM based please check the ABAP code where DS is taking time.

Try to follow ABAP coding standard to improve the performance of the Data Source.

For canceling the job, follow the step,

1) Go to IP Log, In Menu goto Environment --> Job Overview --> In source System or  Take request id from IP log of Header tab and Goto SM37 and cancel the R/3 request

2) Red the technical status of request

3) Delete the PSA request

4) Create new IP with your selection and initialize the DS .

Hope this helps.

Chandresh

[RamanKorrapati]

Hi,

In general, Quality is won't be busiest system like prod. so while doing the extraction at prod system will slow than quality.

To speed up loads at prod, please check ECC SM58, if any luws are stuck here, need to process them by manual. Need to cross check available free application servers at SM50/51.

if ECC /BW prod servers busy during your load then load will take more time to finish.

please  check at info pack  default settings for data transfer, if if it showing 20000 then try to increase that count.

Go to info pack, Menu Scheduler-->data settings for default transfer--> here we can increase data packet size(>20000).

is it LO data source or other one?

Even though if you need to cancel then follow below ways.

Mean first cancel ECC job which is related to init info pack.

Later make request technical status to red. Delete PSA Request and delete the init option if exist at Info pack, menu Scheduler-->init options for source system.

But as long as no init seceded then there won't be any init.

Once you can cancel, you can create new info pack and use possible/required selections to speed up your load.

Thanks