Application Reload error

[#1]

Dear All,

Thanks for your kind help and support.

I am having an issue with reloading the application through QlikView enterprise management console.

I have scheduled two applications one is to retrive data from database and store it into qvd format,

while other is an application to reload data from QVDs.

First one reloads successfully but the other to reload data for the application fails daily from last 1 week.

Due to this I have to reload it manually through Qlikview desktop application. then it reloads successfully.

I am unable to find out the reason why error comes .

I am attaching the log file for the same.

Kindly suggest what step should be followed to recover the error.

[#2]

Kindly help me out regarding the issue

[SunilChauhan]

open your application(.qvw which fail)

go document properties -> check generatelogfile

ten see the error

this log file will available at location of your application

[#4]

Dear Sunil,

Thanks for showing interest, I got the error point but now again is the issue,

We are retrieving data from one of the network location.

When I use to reload manually, the error do not come while through management console the error persists,

Please refer to the below log data:

9/21/2011 3:04:11 PM: 0372  LOAD Year as Year_SA,

9/21/2011 3:04:11 PM: 0373       Month as Month_SA,

9/21/2011 3:04:11 PM: 0374       [Large Group] as large_group_code_SA ,

9/21/2011 3:04:11 PM: 0375       CostUsage as COST_USAGE_SA,

9/21/2011 3:04:11 PM: 0376       [Domestic(Amt)],

9/21/2011 3:04:11 PM: 0377       [Export(Amt)],

9/21/2011 3:04:11 PM: 0378       Total

9/21/2011 3:04:11 PM: 0379  FROM

9/21/2011 3:04:11 PM: 0380  \\192.168.224.9\data\PALIB\Propac\BaseLine\SPD_Sales_Target.xls

9/21/2011 3:04:11 PM: 0381  (biff, embedded labels, table is Sales$)

9/21/2011 3:04:11 PM:       Error: Cannot open file '\\192.168.224.9\data\PALIB\Propac\BaseLine\SPD_Sales_Target.xls' The operation completed successfully.

9/21/2011 3:04:11 PM:       General Script Error

9/21/2011 3:04:11 PM:       Execution Failed

9/21/2011 3:04:11 PM:      Execution finished.

[SunilChauhan]

general script error is due to ONE OF BELOW

1) OTHER APP USING SAME DATA

2) DATA UPDATING AT THE TIME OF RELOAD

3)  NETWWORK PROBLEM

CHECCK THEM .

FOLLOW THE ABOVE POST ALSO .

IT WILL  SHOW YOU SYNTAX ERROR IN PERTICULAR .QVW FILE

IF ANY.

[#6]

Hi,

Sounds to me like it is a problem with the server being able to find your excel file.  Do you have the file path hard coded or is it a relative file path?

Is the qvw document saved in the same location as your excel file?

If they are in very different locations it could be as simple as the server needing to be given access to the correct folder or something like that.

Without seeing the script it's a bit difficult to take a better guess than that I'm afraid.

Cheers,

Emma

[#7]

Hello,

As you specified, please check the script as following,

LOAD Year as Year_SA,

    Month as Month_SA,

     [Large Group],

     CostUsage,

     [Domestic(Amt)],

     [Export(Amt)],

     Total,

     F8

FROM

\\192.168.224.9\data\PALIB\Propac\BaseLine\SPD_Sales_Target.xls

(biff, embedded labels, table is Sales$);

The access rights are provided and the file can be accessed from the location.

When I use to reload through Qlikview desktop no error comes ,

QVW file is at different server while excel is at different.

[SunilChauhan]

there is no issue with path in excel .

this will not give any error

[#9]

Have you previously been able to run this from the server or has this only recently been tried?

When you run the application through desktop have you logged in as yourself to the server or as admin?  Remember, when the file is run through EMC it will not be looking at your access rights but the rights of the server.

You could have a quick test by saving the excel file that seems to be causing the problem in the same folder as the qvw file then try to load it from that location instead.  If this solves the problem you at least know where to focus your attention.

Cheers,

Emma

[#10]

I'm sure you know best - but when I've had an error in the log stating it cannot open a file it's generally been a problem with access to that file.  Maybe that's just applications I've worked with.