Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

 

 

 

 

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