topic Re: Automated Reload through QEMC in QlikView

Automated Reload through QEMC

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I am having trouble with reloading automatically through the Qlikview Management Console. When I manually reload, the script is executed successfully. However, when trying to reload automatically, the source document log file shows that the file path cannot be found (I use data files in a specific location and not a database). How is this possible? If the manual reload executes successfully, shouldn’t the automatic process also?

Please advise.

Kind regards,

Hennie

Re: Automated Reload through QEMC

Wed, 05 Sep 2012 10:54:29 GMT

You may have access to the required folders, are you sure the server has permissions? Is the path the server would follow the same as the path you would follow? i.e. the server won't be able to access your desktop or personal drives..

Re: Automated Reload through QEMC

Wed, 05 Sep 2012 11:17:25 GMT

As per Felim's comment ...

Are you loading info fro a database or from files? This sounds like you've put in a hard coded file path like Q:\QVDfolders\QVDFiles\Loadthisfile.qvd when in fact you perhaps need to use a relative path. Is it a very long script or can you paste it in here so we can have a peek?

Thanks,

Emma

Re: Automated Reload through QEMC

Wed, 05 Sep 2012 11:43:38 GMT

Hi Emma,

Thank you for your reply. As I've mentioned to Felim, all files and models are on the server. Please see below part of the script (This is the first segment of my script and also were the error occurs)

TXN:

LOAD
//@1 as ORG,
    @2 as ACCOUNT,
    @3 AS [STORE NR],
    @4 AS PLAN,
    @5 AS [TXN CODE],
    @6/100 AS AMOUNT,

DATE(date#(@7,'YYYYMMDD')) AS [EFF DATE],
DAY(DATE(date#(@7,'YYYYMMDD'))) AS [EFF DAY],

if(@8=20120610,DATE(DATE#(20120609,'YYYYMMDD'),'YYYY/MM/DD'),DATE(DATE#(@8,'YYYYMMDD'))) AS [POSTING DATE],
date(MonthStart(IF(Day(if(@8=20120610,DATE(DATE#(20120609,'YYYYMMDD'),'YYYY/MM/DD'),DATE(DATE#(@8,'YYYYMMDD'))))>=10,addmonths(if(@8=20120610,DATE(DATE#(20120609,'YYYYMMDD'),'YYYY/MM/DD'),DATE(DATE#(@8,'YYYYMMDD'))),1),if(@8=20120610,DATE(DATE#(20120609,'YYYYMMDD'),'YYYY/MM/DD'),DATE(DATE#(@8,'YYYYMMDD'))))),'MMM-YY') as [STATEMENT MONTH],

DAY(DATE(date#(@8,'YYYYMMDD'))) AS [POSTING DAY],
MONTH(DATE(date#(@8,'YYYYMMDD'))) AS [POSTING MONTH],
YEAR(DATE(date#(@8,'YYYYMMDD'))) AS [POSTING YEAR],
DATE(MonthStart(date#(@8,'YYYYMMDD')),'MMM-YY') AS [CALENDAR MONTH],

    @9 AS REFERENCE,
    @10 AS LOGO,
    @11 AS [STORE ORG],
    FILENAME() AS FILENAME,
    1 AS TXNCOUNT

FROM

(txt, codepage is 1252, no labels, delimiter is '|', msq, header is 1 lines)
where left(@1,1)<>'T';

Re: Automated Reload through QEMC

Wed, 05 Sep 2012 11:44:52 GMT

Hi Felim,

Thank you for your reply. All files and models are on the server. I.e. the server has full access to all files and models.

Regards,

Re: Automated Reload through QEMC

Wed, 05 Sep 2012 11:46:53 GMT

My vote would be that the part of your script that''s causing problems is

FROM

If the .qvw file is in the Reports folder, try replacing it with this

FROM
[.\RawData\TXN\*txn_dly.txt]

If that doesn't work, redo the FROM part of the load statement using the table script wizard, but make sure you have the relative pathway option ticked.

Cheers,

Emma

Re: Automated Reload through QEMC

dde — Wed, 05 Sep 2012 17:42:06 GMT

Also ensure that the Windows user which is running the QlikView services has enough permissions to read all source folders. If you are using Section Access ensure that the same user has full access to the entire data model.

I agree with Emma though; hard coded paths is generally a bad idea, use relative paths wherever possible.

Re: Automated Reload through QEMC

Thu, 06 Sep 2012 13:44:39 GMT

Hi,

Thank you for all the replies. They were all correct and very helpful. The server has the necessary permissions, so it was definitely the hard coded paths creating my problem. Before we end the discussion, could you please explain why relative paths are preferred over hard coded paths? I would like to impart the knowledge to my fellow users.

Thanks again.

Kind regards,

Hennie