topic Re: failing qvd while storing in QlikView

failing qvd while storing

saradhi_it — Wed, 15 Feb 2017 05:58:47 GMT

we don't have publisher we are running all jobs in task scheduler but one dashboard getting failed at randomly times ,when i check the log file while saving qvd it was getting failed and showing error message GENERAL SCRIPT ERROR ,but when i run manually it was running successfully i didn't see any error occurs

2/15/2017 7:30:50 AM: 0970 DROP Table Order_BOOK1

2/15/2017 7:31:17 AM: 0973 STORE Order_BOOK into (qvd)

2/15/2017 7:32:04 AM: General Script Error

2/15/2017 7:32:05 AM: Execution Failed

2/15/2017 7:32:05 AM: Execution finished.

Regards

Pardhu

Re: failing qvd while storing

Wed, 15 Feb 2017 06:00:48 GMT

Hi ,

Ur existing qvd might be locked , so that it was not able to overwrite the qvd

this is one possible case

delete that qvd and re run it

Re: failing qvd while storing

saradhi_it — Wed, 15 Feb 2017 07:05:55 GMT

hi manoj

but when we try to reload the dashboard manually the reload was successful ...can you explain how the QVD will be locked

Re: failing qvd while storing

Anil_Babu_Samineni — Wed, 15 Feb 2017 07:18:44 GMT

As i assume, When it goes to qvd issue on server - Might be error in the path. Check whether the path is good or not

Re: failing qvd while storing

vardhancse — Wed, 15 Feb 2017 07:23:40 GMT

1.What is the table name?

2. Before Store only there was a drop , once can please check the same

Re: failing qvd while storing

kamielrajaram — Wed, 15 Feb 2017 07:38:51 GMT

Hi,

I have had this issue before, delete and re-created the job in Task Scheduler.

Kind Regards

Kamiel

Re: failing qvd while storing

saradhi_it — Thu, 16 Feb 2017 03:14:06 GMT

hi guys

i tried all things which you suggested none of them working ..

Re: failing qvd while storing

vishsaggi — Thu, 16 Feb 2017 03:28:03 GMT

Is your D Drive on your Qlikview server?

May be use the UNC paths like

STORE Order_Table INTO \\yourservername\d$\Qlikview\SourceDocuments\DEV\Application\QVD\Order_Book_Onwardsdec.qvd (qvd);

Re: failing qvd while storing

Anil_Babu_Samineni — Thu, 16 Feb 2017 03:33:17 GMT

Can you send the Log files of QVW i mean whole log file / Script. And try to remove Square Bracket

STORE Order_BOOK into D:\DEV\Application\QVD\Order_Book_Onwardsdec.qvd (qvd)

Re: failing qvd while storing

Thu, 16 Feb 2017 05:14:19 GMT

when ever ur refreshing the dashboard manually ,is it referring to the same location qvd ?

I mean to say both manually and automation process is picking from the same location .

Try to regenerate the qvd or overwrite the qvd from some other location ... Try it once

Re: failing qvd while storing

avinashelite — Thu, 16 Feb 2017 06:20:20 GMT

Do you have access for the path

from the server ? in local you have the complete access to this path but in the server while reloading Qlikview service account will used for reload and this account should have the access to this path . Check this ...and share the log file it will be in the .qvw file location with .log extension

Re: failing qvd while storing

sdmech81 — Thu, 16 Feb 2017 06:49:08 GMT

HI,

Plss share the log.

Re: failing qvd while storing

saradhi_it — Fri, 17 Feb 2017 07:51:14 GMT

@manoj kumar : your right ...at the same time this qvd was using in other dashboard ,,, the worst thing was it was happening at the same time saving and reloading the same qvd in the other dashboard