Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Rob,
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
-Rob
Thanks Rob,
Its working fine. Please let me know if can schedule the QVD incremental load generator.