Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad
Contributor III
Contributor III

Qlikview Sap Extractor Delta load issue

Hi All,

We are using Sap Extractor Connector to get data from Sap Erp DataSource ([0FI_GL_14])

We have loaded Intial Extraction, to be followed by Delta Extractions.(Updmode C) in one Template and stored on A.Qvd. 

Now we are trying to run Delta load(Updmode D) and stored into one B.qvd.

Ques: if we run next Delta loads, should the qvd be same as B.qvd or can be any timestamp qvd. 

or if we find Delta corrupted can we use Upmode R to run from the intial load instead of running full load.

Thanks! in Advance.

Regards,
Prasad

 

 

 

 

Labels (1)
1 Reply
Hakan_Ronningberg

Hi Prasad,

I can answer your last question. UPDMODE R is used to resend the most recent delta load. Not used to start from the initial load.

From the online help:

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Clients...

To resend the most recent delta load:

  1. Re-comment the UPDMODE D statement.
  2. Uncomment the UPDMODE R statement.
  3. Perform a reload.

This works for both tRFCand IDoc transfer methods. The repeat delta load retrieves both the most recently extracted delta and any new delta records that have been added to the delta queue since the previous delta load.

Regards,
Håkan