Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am new to Qlikview, We have data been extracted from SAP into Qlikview on daily bases.
from last 2 days SAP qvd generator is failing with following error.
This job never failed before and this is the first time it failed and nothing was changed in system or in the source system.
Thank you in advance.
Regards
Chakri
Can you post the complete script? One thing you might want to check is the table names should have the same case as above as QlikView is case sensitive.
Hi ,
Kindly check the table name that you have given at the store command (QVD Generator) and table name extracting from database are same or not..
Hi,
Please check the script it is something like below.
COPA_o03:
select * from COPA_o03;
COPA_o03_Budget.QVD;
Store COPA_o03 into QVD\DSO\COPA_o03_Budget.qvd (qvd);
Or else use the below script.
Store * from COPA_o03 into QVD\DSO\COPA_o03_Budget.qvd;
Hope this will help you.
Considering you said, it was working before and you did not change anything, it could be that the table in SAP has changed. Check your logs to see if the table COPA_o03 has been loaded successfully.
I would suggest same as above - in the screenshot of your log file I can't see (qvd) file format, that may cause a problem. Your store command should look like:
STORE COPA_003 into QVD\DSO\COPA_003_Budget.qvd (qvd);
Double check if your folder path is valid.