Reload Failed through Scheduler.

[lalitinmbd]

Dear All,

I am working on QlikView 10 SR3 (64 bit) which is installed on Windows Server 2008 R2(64 bit)

and i am extracting the data from the SQL Server which is installed on 32 bit machine. When i

extract the data from the database by manually reloading the application it works perfectly. But when

i run the application through the windows schedular or through QV Server reload fails. Do anyone have any

Idea why i am facing tis problem.

Thanx In Advance.

[sbaldwin]

Hi, it may be an obvious one but what username are you using in your connection, is it trusted? if so does the service account have permissions to the database?

Thanks

Steve

[lalitinmbd]

Yes the username i am using in connection string is trusted one

and have permissions to the database.

When i manually run the extraction application it runs perfectly.

If there is problem in the permissions or username then it should not reload

manually also.

Thanks

Lalit

[sbaldwin]

so are you saying that the account you are logging on and reloading is the same one that is running your publisher service?

Thanks

Steve

[lalitinmbd]

yes i am using the same account.

But i am reloading the Applications through batch file that is scheduled through

windows scheduler. I am not using QlikView Publisher.

[sbaldwin]

have you put logging on the document? what is in that after a failed reload?

I would just try using a SQL account to log on as this has solved these sorts of issues for me in the past.

Thanks

Steve

[lalitinmbd]

It gives an error Unexpected end of data and mostly it fails at one transaction table

that contains the transactional data of the invoices raised..

[vijay_iitkgp]

Please check in windows task scheduler is there any qv.exe is still running. if yes then kill it and then try to run with scheduler.

regards

vijay

[lalitinmbd]

There is no qv.exe running in task schedular.

I have scheduled the Application reload through

QlikView Server when extraction process takes

place a qvb.exe runs.

I have written a subroutine to store and drop which is below

set SchedulePathMaster="D:\Qlikview\QVD\Stage0\Xplore-XploreNepal\Master";

set SchedulePathTransaction="D:\Qlikview\QVD\Stage0\Xplore-XploreNepal\Transaction";

sub StoreAndDrop (pathname, tablename)

          Store $(tablename) into $(pathname)\$(tablename).qvd;

          drop table $(tablename);

end sub

And the script of the table where reload fails is

Let Starttime=now();

ACT_VoucherLine:

SQL SELECT *

FROM Xplor.dbo."ACT_VoucherLine";

let endtime=now();

let ACT_VoucherLine=noofrows('ACT_VoucherLine');

CALL StoreAndDrop '$(SchedulePathTransaction)', 'ACT_VoucherLine';

load * inline

[

TableName,StartTime,EndTime,NoofRows

ACT_VoucherLine,'$(Starttime)','$(endtime)','$(ACT_VoucherLine)'

];

Mostly reload fails at this table all other tables are fetched and stored perfectly.

[vijay_iitkgp]

Why are you not using bacekets while calling subroutine.

CALL StoreAndDrop('$(SchedulePathTransaction)', 'ACT_VoucherLine');

Regards

Vijay