topic Re: Qlikview QVD reload failed in QlikView

Qlikview QVD reload failed

Mon, 14 Sep 2015 04:51:27 GMT

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

Re: Qlikview QVD reload failed

sunny_talwar — Mon, 14 Sep 2015 08:50:07 GMT

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.

Re: Qlikview QVD reload failed

krishna20 — Mon, 14 Sep 2015 08:58:26 GMT

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..

Re: Qlikview QVD reload failed

qlikviewwizard — Mon, 14 Sep 2015 09:02:45 GMT

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.

Re: Qlikview QVD reload failed

quwok — Mon, 14 Sep 2015 10:21:39 GMT

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.

Re: Qlikview QVD reload failed

kuczynska — Mon, 14 Sep 2015 11:00:13 GMT

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.