Update Mode R is not supported by the Extraction API

[Former Member]

Hey All,

I know there are several posts out here concerning this error, but I need to get something clear.

Error: Update Mode R is not supported by the Extraction API

We experienced the error the other night, and could not do a repeat delta. I reinitialized the delta, but I did it WITH DATA TRANSFER. This basically did a Full Load of the data, and took several hours. I want to avoid this in the future.

Now, here's my question:

- Would I have been able to do a reinit WITHOUT DATA TRANSFER, and rerun the Delta (since the Change Pointers with the changes still existed)???? Or, would those changes be gone, once I did the reinit???

Please let me know. Easy points will be rewarded.

Thanks,

John

[former_member345199 · Accepted solution]

Hi,

Yes you can perform init without Data transfer and deltas will follow.

Do a Full repair for lost records.

General Info on this error

Update mode R is not supported by the extraction API

You need to do a reinit for this data and set up the delta load again.

It will fix the issue. The message means that a Repeat delta is not supported.

Generally this happens for Master data / some of the Generic DS.

As far as I understand it happens because the DS does not support R or Repeat of delta.

For more information on Update mode:

Go to SE12, write data type as “RODMUPDMOD”. Read the documentation given there.

Initialize the Delta - INIT

Search for the init IP

1. Double click in the IP

2. Scheduler menu

3. Click in Initialization options for source system

Delete the only request that appear

Click in Yes in this window

Close the window

Run the Init IP without data transfer.

Then run the Delta IPs.

OR

Simply set the QM status of the last failed delta to GREEN and reload your master data with Full Repair.

Refer

Thanks,

JituK

[Former Member · Accepted solution]

Thanks man.

Full points given.

[former_member345199 · Accepted solution]

Hi,

Thanks for that Nice gesture.

JituK

[Former Member · Accepted solution]

I looked at that link you have in your post, and one person says that if you don't run a reinit WITH DATA TRANSFER, that you'd lose all the changes that were waiting to be loaded into BW. Is this true??? After the reinit is run, and I run a Delta immediately, will it not have those changes that were there just before the reinit????

[former_member345199 · Accepted solution]

Hi,

I think you have mistaken it.

Read the post by Dheeraj or Sam in that link.

Once you perform Init without DT, you follow that with a Full which will bring in all the data from Tables, so you dont stand the cahnce of losing data.

You can very well perform Init with DT, but the down side is the amount of time it takes and in a Prod environment that is not acceptable.

Both options produce the same result.

Hope I made it clear.

Thanks,

JituK

[Former Member]

HI John

You need to do a reinit for this data and set up the delta load again.

It will fix the issue. The message means that a Repeat delta is not supported.

Generally this happens for Master Data / some of the Generic DS.

As far as I understand it happens because the DS does not support R or Repeat of delta.

Please check previous targets any red request delete them, if your targets are fine. Check in rsa7

How many deltas are there and there we can do repeat delta .

RSA7 choose your datasource  Display icon ->there is find 2 options 1. Repeat delta , 2.delta update

Choose repeat delta and extract once into BI .

initialize the Delta - INIT

Search for the init IP

1. Double click in the IP

2. Scheduler menu

3. Click in Initialization options for source system

Delete the only request that appear

Click in Yes in this window

Close the window

Run the Init IP without data transfer.

Then run the Delta IPs.

Hope it helps u2026

By,

Praveen Yagnamurthy,

SAP BI Consultant,

Blue Marlin Systems-INDIA.

http://bluemarlinsys.com/bi.

[Former Member]

Hi,

This cause that Init flag is currupted by the system...this will happen some times due to the technical problem. so this will happen to only Delata Update. So inprder to solve this problem first run the

1.Delete the Init flag in the IP scree >>Scheduler menu>>>Initialization options for the sourcesystem Then...Run Init without Data transfer ..it will pick the 1 empty record. then Run the Delta Periodically.

2.If u do Init Without Data transfer there may be a chance to loss the Data if u are working in the Final production Box i suggest u that Run the Initialization with data transfer By deleting the Old data first then run the Delta update.

Thanx

vittal