Problem with extract data ODP - Dataservices

[former_member824462]

Hi,

I am trying to use the 0UC_SALES_STATS_02 extractor with Dataservices but I have problems in initializing the first launch (See ODQMON) This error appears in the attachment.

The job launch is with initial load = YES.

Is the Budat format correct in the consumer details?

Am I doing something wrong?

Thank you

Thank you

[harald_lesche-holzbecher]

Your screen shot for query and the job log don't match.

A job with extraction mode 'F' is issued from a query with extraction mode 'Query'. Within your screen shot extraction mode is 'Changed data capture (CDC)'. This will result in a job with extraction mode 'C'.

Steps to use 0UC_SALES_STATS_02 extractor with Dataservices are:

1. DS: Import extractor with “Extraction mode” = ‘Changed-data capture (CDC)’ and initial load = “Yes” and BUDAT condition

Result: Subscription created

2. DS: Import extractor with “Extraction mode” = ‘Query’ and condition BUDAT with '>=' '<='

Results:

Data Snapshot with restriction for BUDAT created

No records returned to DS but entries created in DBESTA_BWTRIG (DBESTA_BWPROT for IS-UT < 605) . This will as well delete non processed entries from a former full request (check with transaction EBW_SS_MON)

3.IS-U: Run EBW_DQ_SS to write ODQDATA

Result:

Entries in DBESTA_BWTRIG are processed. The number of entries are decreased depending on EBW_DQ_SS parameters

In ODQMON you’d see new units

4.Run the job for “Extraction mode” = ‘Changed-data capture (CDC)’ with initial load = “No”

Delta is fetched from DS. 1^st call will get data from full request.

[former_member738872]

Colleagues, good afternoon! Did you manage to resolve this issue?