Error Job getting cancelled

[Former Member]

Hi all,

I am doing Stock initialization for 2lis_03_bx DS.It is extracting data but job is getting cancelled. the log is as follows

" Job started

Step 001 started (program RMCBINIT_BW, variant &0000000000005, user ID KRISHNA)

197.516 stock data records were selected for BW extraction

Timed out: 5.000 stock receipts were updated

Job cancelled "

any ideas ??

Regrds

KK

[Former Member]

is the Job in R/3 finished and all the packets arrived in BI ??

If yes than its timing out prolly due to the process update in DIALOG mode,try executing the job in background with the infopackage option .

PSA only and then Data target.

Hope it Helps

Chetan

@CP..

[Former Member]

Hi chetan,

This the problem that we discussed with inventory in my last psot.Now Iam getting values but job is getting cancelled .I have displayed the job log above .

<b>In Stock initilization I have more than 197 thousand records...</b>

Regards

KK

[Former Member]

The recommended setting in the RMCBINIT_BW report for 'Number of data records per LUW' is 5000.

You can reduce an extremely long runtime by setting up the stock individually for each plant. For more information, see Note 728360

When you run the report, the "Transfer Zero Stocks" option must NOT be active, because this will significantly increase the runtime

Solution for Poor performance stock initialization

1. Datasets and transaction handling

Of course, the runtime of the transaction increases if very large datasets have to be processed. It therefore does not make sense to start the transaction for the complete dataset.

Depending on the data constellation, the data should be restricted on the input screen of the transaction. We recommend that you start the transaction separately for each plant. However, this recommendation cannot be considered to be universally valid because different SAP customers may also have very different data constellations.

For example, the system may have a large number of plants but a small number of materials or a large number of materials but a small number of plants. We therefore recommend that you check the performance of the stock initialization beforehand, using different selection variants.

2. Unnecessary data enhancements

If, in addition to BW, you are still using the Retail Information System (RIS), you generally have to activate the RIS-specific data enhancement for material documents. However, this is not necessary for the stock initialization for BW. We therefore recommend that you deactivate exactly this enhancement in the Customizing during stock initialization.

This can be executed using transaction MCH_ in which the indicator for enhancing the goods movements is deactivated. After you complete stock initialization, you should reactivate this indicator to ensure a correct update of the RIS.

If, in any event, the RIS should not be used, we recommend that you use MCH_ to deactivate the complete RIS enhancement.

3. Zero stock selected

We recommend that you do not use the indicator for considering zero stock in transaction MCNB since this greatly increases the runtime. For more information, see note 655798.

Note 728360 - PLUG: Performance of stock initialization

Hope it Helps

Chetan

@CP..

[Former Member]

Hi Chetan ,

Before doing this I have referred all the notes ,what you have mentiond.I have not seelcted the checkbox that is there in MCNB ,I have kept 5000 DP for extraction. As I am extracting retail data huge number of materials are there .... so obviously performance will be down I updated the same to basis also once to check will update you on further progress.

Regards

KK

[Former Member]

Good homework- I like that.

Appreciate for the benefit of others to share the same - put the steps done earlier on the forum.

Hope it Helps

Chetan

@CP..

[Former Member]

Hi Chetan,

Thanks .

As I am new to inventory I aware that Ineed to do some settings in R3 and in BI( if exists ) .I have a How to .......document on inventory ( got it from market place ) and gone through that.In that SAP has mentiond all the necessary SAPnotes to be reviewed and to be impleented if necessary I have gone through those notes and the document and started doing it in R3 DEV and Quality got a problem ie . with out activating BF/UM structure started extracting BX data,this will surly impacted by job and I got 0 records in Rsa3,kept it in forumns as per your guidence I done the rest and got it solved now facing some monor problem in extracting but that is realed to basis and informed them it will get solved.

Thanks Chetan for all your support.

Regards

KK

[Former Member]

most welcome and good luck.

Chetan

@CP..