Question:
Hi can anyone help with a EBP/BW problem.
BW 3.0B, EBP 3.5.
I am trying to load data from EBP to BW and am having problems with the transactional data loads using Delta-inits.
When I run the Delta-init on 0BBP_TD_CONF_1, 0BBP_TD_INV_1, 0bbp_PO_1 and 0BBP_TD_SC_1, it works for the first date selection, but the second Delta-init errors with ‘Data still in delta queue - no init possible RSQU 19’. I need to load several Delta-inits with various date range selections because I need to load data from 01.11.2003 up to present date.
First Init Delta selection 01.11.2003 – 31.12.2003
Second Init Delta selection 01.01.2004 – 31.03.2004 etc.
I have run the delta init selections in Development and they work, so I has wondering if it is something in production I haven't got set either on BW or EBP. In production I can run one init delta followed by a delta and that works.
Thanks.
Answer:
Hi,
you can run multiple inits as you plan as long as the selection criteria do not overlap. However, this does not mean that you can run them without system down time. Each init should be done when no users can make changes to the system. This is because you have 1 queue for your multiple inits and the system puts ALL changes into the queue, whether they correspond to your delta or init selections or not. It is at extraction time when the records in the queue will be brought to bw or not based on your infopackage selection. Bottom line, if you have records in the queue, you cannot do an init; this is a basic rule for all extractors using a queue.
You probably don't have the problem in Dev because you don't have active users clogging up your queue constantly!
Sandy
_________________
Sandy
Answer:
Thanks for the reply. Because of what you said I managed to repicate the problem in development.
1) Ran a delta-init,worked.
2) Made a change in EBP dev.
3) Ran a delta-init, failed with the same error as in production.
How do I get round this in production, because if I run a delta init at night, so there is no activity in EBP. Then run a second delta init the second night, there has been activity in EBP so surely the second delta init will fail.
Many thanks for all your help.
Jane
Answer:
Hi Jane,
can't you run both inits back-to-back in the same night? If not, just make sure that you schedule 2 deltas on the second night before you run the second init. This will clear your queue and allow you to do the init. You need to run 2 deltas even though the second one will return 0 records, for technical reasons which I don't want to try and remember. If you search hard enough you will likely find the answer somewhere on the forum
_________________
Sandy
Answer:
Do you still have activities changing the content of records in periods 2003/2004/2005 ?
If no, what you can do is to load historical data with full loads, and then only do an init for 2006-9999 ?
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.