How to fill the data in extraction queue (LBWQ)?

[Former Member]

Hi,

I modified the structure of datasource 2LIS_02_SCL (change an append structure), since an error occurs when I check the datasource, I deleted the the deltaqueue in RSA7, before that, I also checked the extractorqueue, it was empty.

But when I excute OLI3BW to fill the extractor queue, it happens nothing.

How can I fill the data in extractor queue so that I can extract data from R3 to BW?

Thanks .

Regards

[Former Member · Accepted solution]

hi

delete the setup table in LBWG and fill it using appropriate OLI*BW transaction.

Regards

Dina

[Former Member · Accepted solution]

How about the extractor queue and delta queue in this case. I didn't see any data in these two queues during the whole loading

[Former Member · Accepted solution]

Once u do the init in the BW side then the delta queu will be created in the R3 side in RSA7.. After init if any transactions happens then the delta queu will be updated with the records.... to pick the records from the delta queu u have to run the job in LBWE....

Khaja

[Former Member · Accepted solution]

Thanks Khaja, I have to read documents to understand the whole stuff...

[former_member189599 · Accepted solution]

Hi Khaja!
I need to know, how to stop the job that collect delta queue for 2lis_02_scl in R3.
I see in R3 t-code LBWE that the "Update Mode" is set in "Queued delta"

thanks

LUCAS

[Former Member]

hi

check whether the datasource contains any data in RSA3. delete the datas in the setup table and fill it up again in r/3 side.try it.

Regards

Dina

[Former Member]

Thanks Dina,

yes, there is 991 Data in RSA3.

"delete the datas in the setup table": you mean, I should delete data in LBWG?

"fill it up again in r/3 side": What should I do for that?

[Former Member]

It works. But I don't understand totally the logic.

[Former Member]

Whta u have done is Filling setup tables not the extractor queu......

Could you please tell whether ur load is delta load or Full load?

Khaja

[Former Member]

Delta Load actually. But to test, I use full load. So that's say full load.

How can I fill the extrator queue then?

Edited by: Youyou Wong on Jan 17, 2008 10:13 AM

[Former Member]

Go to LBWE there u will find the option as Job control.. You have to run the job... To pick the data from the extractor queu to delta queu.... extractor queu will be updated if any transactions happens in the r3 side.... If u run the delta then the data will be pickedup from the delta queu not from the extract queu...

Khaja

[Former Member]

Thanks Khaja. Sure, data will be picked up from delta queue, instead of extract queue.

But my problem is: I can not see any data in my extractor queue after excuted OLI3BW. So whatever it happens (LBWE), there is no data can be loaded to delta queue, and no data can be picked up to BW...