Changes in extract structure

[Former Member]

Hello All,

The extract structure for 2lis_11_vaitm has been changed and since then whenever I try to execute the datasource using RSA3.

I get an error Import_mismatch_error.

The extractor was working fine in dev. So I collected one structure which was missing in quality.

After releasing the same in quality, I deleted the setup tables and did run RSA3 - I got 0 records.

As per the SAP note 328181 - the old Sales orders are not compatible with the new structure and so we get the same error.

If any new documents are posted they will come in RSA3. How do I make sure that in Production I dont miss any data?

Regards,

Nikekab

[Former Member]

HI,

You need not worry about setup tables in Production as setup tables are not needed for delta loads. Just make sure the extraction queue and delta queue do not have data when you move the transports. Run V3 updates and delta loads couple of time in quick succession so that the queues do not have any data. Make sure there will not be postings for few min so that you could import the changes. This way you shall not miss any data.

If data exists in the queues when you import the changes, you would not be able to extract that data and the extraction gives error. you would have to clear the queues, repair the lost data....

[Former Member]

Hi

When you execute RSA3 for LO data source it will pick data from setup tables. As you don't have any data in setup tables, it is showing 0 records.

please fill the setup tables and execute RSA3, your data source will show records.

Regards,

Venkatesh

[Former Member]

Hello Vinod/Venkat,

Thanks for the info.I filled the setup tables using OLI7BW and RSA3 worked. It did fetch data.

Now when I try to replicate the DS 2LIS_11_VAITM in BI system, I get an error that 'DS 2LIS_11_VAITM could not be activated'.

What can be the possible reason for this?

Regards,

NIKEKAB

[Former Member]

Do you get this error while replicating the datasouce or are you trying to activate it?

If it is 3.x flow you are using, after replicating the DS activate the transfer rules, you cannot activate a 3.x datasource.

[Former Member]

Hi

Use program

RSDS_DATASOURCE_ACTIVATE_ALL -- to activate data source and

RS_TRANSTRU_ACTIVATE_ALL --- to activate transfer structure

without data source being replicated in BI system, you will not get data.

Regards,

Venkatesh

[Former Member]

Hello Venkat,

I tried to run RSDS_DATASOURCE_ACTIVATE_ALL but I got errors while trying to do so.

The errors pertaining to 2LIS_11_VAITM are

- Post processing/checking the activation for datasource 2LIS_11_VAITM is RED

There are not much details given though.

Is it possible that I need to do some settings in R/3 side to get this replicated? Whereall can I check what the problem is?

Regards,

NIKEKAB

[Former Member]

Hi

Check if your data source in LBWE has green symbol and exctraion structure is active.

can you drill down the post processing erros, so that we can get some details,.

Regards,

Venkatesh

[Former Member]

Hello Venkat,

LBWE shows MC11VA)ITM as active. There is no drill down available for the post processing errors.

Thats the problem.

Regards,

NIKEKAB

[Former Member]

Hello Venkat,

I found one error description though:

Error when resetting DataSource 2LIS_11_VAITM OKQCLNT332 to the active version

Message no. RSO410

Diagnosis

Errors arose when activating DataSource 2LIS_11_VAITM. An active version already existed before theactivation.

System Response

DataSource 2LIS_11_VAITM could not be resetto the old active version. Since the generated objects no longer correspond to the old active version, they were reset to inactive.

Procedure

The old active version of DataSource 2LIS_11_VAITMcan no longer be used. Remove the cause ofthe activation error and activate DataSource 2LIS_11_VAITM anew.

Regards,

NIKEKAB

[Former Member]

HI

datasource is already in active, why you want to activate it again. are you getting any problem while loading data.

just check in table ROOSOURCE, if data source is in active (A) version, then no need to do bother about this.

Regards,

Venaktesh

[Former Member]

Hello Venkat,

ROOSOURCE shows 2 entries for this DS.

One is A with Delta process ABR and another one D with delta process ABR.

But when I try to do a INIT without data transfer, I get an error message

'A Caller 01,02 or equal to or greater than 20 contains an error message;.

and the error message is 'DS 2LIS_11_VAITM must be activated' (ID: RSDS).

And the Details tab shows Requests: Error occurred

-> Error in data request.

Regards,

NIKEKAB

[Former Member]

Try deleting the data from the datasource/PSA and then activate it. This would not be a problem, but not sure with different versions/higher SP levels, may be this check is introduced.

[Former Member]

Hello Murali and Venkat,

I went to the DS ->Manage and got this error:

Invalid DataStore object name /BIC/B0002246: Reason: No valid entry in table RSTS

Message no. RSM1294

Regards,

NIKEKAB

[Former Member]

I guess you are using the 3.x flow, datasource --> TR --> Infosource --> UR --> target. I see 3.x structures in RSTS.

Activate the transfer rules.

[Former Member]

Hello Murali,

No its not 3.x because I dont see any 'small square' near this datasource.

I want to get this activated somehow!!

and I have activated the transfer rules as well. but no luck....

When I go to display datasource I can see the Active version status as Not executable and when I try to activate it...I get the same postprocessing error as mentioned in above replies.

Regards,

NIKEKAB

Edited by: NIKEKAB on Jan 31, 2012 8:59 AM

[former_member182346]

After deletion, did you tried to fill the set up table.

I hope it should work i.e. RSA3 should works fine and you should get all records after filling set up table.

Use T.Code OLIBW in source system, give some name TEST as name of run and execute it.

Thank-You.

Vinod