Skip to Content
1
Mar 18, 2019 at 05:02 PM

Error repeat delta extraction from datasource standard into SAP BODS

524 Views Last edit Mar 18, 2019 at 05:14 PM 3 rev

Hi,
we have a BODS job that extract from 2lis_12_vcitm. This job is gone in error for system problem.

If we want repeat the extraction in BODS jobs, we add a global variable type of datetime '$g_DATETIME' into field "Extract from datetime" of datasource:
immagine-1.jpg

then we go to the transaction ODQMON in ECC system and we catch the last composite request of 2lis_12_vcitm extractor:
immagine-2.jpg
that we want repeat the delta execution.

We go in the content of the table RODPS_REPL_RID filtering with this composite request retrieved and take the value of the field pointer:
immagine-3.jpg
this value is insert in the execution of the job in the global variable of type datetime, this value is writed without "braces":
immagine-4.jpg
The value of the global Variable '$g_INITIAL_LOAD' = 'R' represent that the job executes the dataflow that contains the global variable '$g_DATETIME' into field 'Extract from datetime'.

This execution doesn't repeat the extraction, but it executes a new delta of this extractor.
This wrong execution is represented from the creation of a new request in transaction ODQMON and not the repetion of the request underlines over:
immagine-5.jpg

Why?

Best regards.
Luca

Attachments

immagine-2.jpg (143.8 kB)
immagine-1.jpg (50.3 kB)
immagine-3.jpg (57.8 kB)
immagine-4.jpg (39.5 kB)
immagine-5.jpg (161.3 kB)