Discussion Board for collaboration related to QlikView Deployment.
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: 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');
[$(Qvc.Loader.v.Tablename)]: // vTablename is set by the IncrementalSetup routine.
SQL SELECT *
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
I don't where i am making a mistake.
I have attached a log file.
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
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'
I am getting the message on the first run.
I ran the second it went fine
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
Its working fine. Please let me know if can schedule the QVD incremental load generator.