Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qvd file does not exists while updating updating oracle tables using qlik incremental generator

Hi Expert,

I am trying to create a dash board from Oracle EBS using qlikview.

Everything is working fine. Uploaded the qvc file and all the qvd files are also getting generated. I am getting an error

27/09/2015 2:58:23 PM: 1686     'INFO' as [Qvc.LogMessage_Level],
27/09/2015 2:58:23 PM: 1687          num(7, '00000') & ' ' & now(1) & '; ' & 'QVD ..\QVDs\\XX_AP_INVOICE_LINES_ALL.qvd does not exist. Doing full reload where IL_LAST_UPDATE_DATE >= TIMESTAMP ''1990-01-01 00:00:00''.' as [Qvc.LogMessage]

27/09/2015 2:58:23 PM: 1688          AUTOGENERATE 1

I can see that XX_AP_INVOICE_LINES_ALL.qvd is getting generated under XX_AP_INVOICE_LINES_ALL.qvd then also i am getting an error it does not exist.

I am using the below to upload invoice tables.

CALL Qvc.Log('>>>  Incremental Load of AP Invoices All with inserts & updates');

// Calling parameters are Tablename, UpdateColumn, QVD_PrimaryKey.

CALL Qvc.IncrementalSetup ('XX_AP_INVOICES_ALL', 'IH_LAST_UPDATE_DATE', 'INVOICE_ID');

Directory;

[$(Qvc.Loader.v.Tablename)]: // vTablename is set by the IncrementalSetup routine.

LOAD *;

SQL SELECT *

      FROM XX_AP_INVOICES_ALL

    WHERE  $(Qvc.Loader.v.IncrementalExpression); // IncrementalExpression is set up the Qvc.IncrementalSetup routine.                        

Call Qvc.Log ('AP Invoices All Incremental Expression = ' & '$(Qvc.Loader.v.IncrementalExpression)');

// Log the ending stats

Call Qvc.Log ('$(Qvc.Loader.v.Tablename) loaded, rows=' & num(NoOfRows('$(Qvc.Loader.v.Tablename)'), '#,##0'));

// Update the QVD with the changed rows

CALL Qvc.IncrementalStore;

I don't where i am making a mistake.

Please suggest.

I have attached a log file.

Thanks

5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Just to clarify, the message will appear (it's not an error message) the first time the QVD is generated. Are you getting the message on subsequent runs?

I note that you are running a rather old version of QVC (8.2), The current version is 10.2.

I understand you are getting the message that the QVD does not exist even though it does. The only thing I can see wrong is that your

SET Qvc.Loader.v.QvdDirectory = '..\QVDs\'

should not have a trailing '\'. It should be:

SET Qvc.Loader.v.QvdDirectory = '..\QVDs'

Please try that and let me know if it fixes the problem

-Rob

sasiparupudi1
Master III
Master III

I think you have an extra \ in your path.

27/09/2015 2:58:22 PM: 0145  CALL Qvc.IncrementalSetup ('XX_AP_INVOICES_ALL', 'IH_LAST_UPDATE_DATE', 'INVOICE_ID')

27/09/2015 2:58:22 PM: 1113    UNQUALIFY "_qvctemp.*"

27/09/2015 2:58:22 PM: 1116    LET _vForceFullReload=if(len('')= 0,'0', '')

27/09/2015 2:58:22 PM: 1119    IF len('IH_LAST_UPDATE_DATE')=0 AND NOT 0 THEN

27/09/2015 2:58:22 PM: 1125    SET _Qvc.Loader.v.ForceFullReload = '0'

27/09/2015 2:58:22 PM: 1127    SET Qvc.Loader.v.Tablename = 'XX_AP_INVOICES_ALL'

27/09/2015 2:58:22 PM: 1128    SET _Qvc.Loader.v.Tablename = 'XX_AP_INVOICES_ALL'

27/09/2015 2:58:22 PM: 1129    SET _Qvc.Loader.v.QvdFile = '..\QVDs\\XX_AP_INVOICES_ALL.qvd'

27/09/2015 2:58:22 PM: 1130    SET _Qvc.Loader.v.PrimaryKey = 'INVOICE_ID'

hth

Sasi

Not applicable
Author

Hi Rob,

I am getting the message on the first run.

I ran the second it went fine

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Ok, this is normal expected behavior. The message is informing you that the QVD is not found and a full reload will be done. It's not an error.

By the way, the best place to ask questions about using QVC (QlikView Components) is the QVC Forum at

Google Groups

-Rob

Not applicable
Author

Thanks Rob,

Its working fine. Please let me know if can schedule the QVD incremental load generator.