topic Reload Failed through Scheduler. in QlikView

Reload Failed through Scheduler.

lalitinmbd — Thu, 24 Nov 2011 12:24:40 GMT

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.

Re: Reload Failed through Scheduler.

sbaldwin — Thu, 24 Nov 2011 15:06:08 GMT

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

Reload Failed through Scheduler.

lalitinmbd — Fri, 25 Nov 2011 06:51:40 GMT

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

Reload Failed through Scheduler.

sbaldwin — Fri, 25 Nov 2011 07:23:29 GMT

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

Reload Failed through Scheduler.

lalitinmbd — Fri, 25 Nov 2011 07:35:41 GMT

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.

Reload Failed through Scheduler.

sbaldwin — Fri, 25 Nov 2011 07:58:42 GMT

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

Reload Failed through Scheduler.

lalitinmbd — Fri, 06 Jan 2012 05:09:10 GMT

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

Reload Failed through Scheduler.

vijay_iitkgp — Fri, 06 Jan 2012 05:18:14 GMT

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

Reload Failed through Scheduler.

lalitinmbd — Fri, 06 Jan 2012 05:28:15 GMT

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.

Reload Failed through Scheduler.

vijay_iitkgp — Fri, 06 Jan 2012 05:37:16 GMT

Why are you not using bacekets while calling subroutine.

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

Regards

Vijay

Reload Failed through Scheduler.

lalitinmbd — Fri, 27 Jan 2012 05:54:02 GMT

Dear Vijay Sir,

I have now used the brackets while calling the subroutine.

Failure does not occur all the time it happens suddenly.

Below is the error that is thrown when reload is failed.

1/27/2012 09:37:14.2999567 Information 1/27/2012 9:37:14 AM: 0053 ACT_VoucherLine:

1/27/2012 09:37:14.3077695 Information 1/27/2012 9:37:14 AM: 0054

1/27/2012 09:37:14.3146057 Information 1/27/2012 9:37:14 AM: 0055 SQL SELECT *,

1/27/2012 09:37:14.3204653 Information 1/27/2012 9:37:14 AM: 0056 'INDIA' as Flag12

1/27/2012 09:37:14.3273015 Information 1/27/2012 9:37:14 AM: 0057 FROM Xplor.dbo."ACT_VoucherLine"

1/27/2012 09:37:14.3331611 Information 1/27/2012 9:37:14 AM: 39 fields found: VoucherLineID, VoucherXID, CompanyCode, VoucherNo, VoucherCode, VoucherTypeXCode, AccXCode, CurrAmt, CurrCode, DocType, DocNo, ExchangeRate, VoucherAmt, SledXCode, CostCenterXCode, Remarks, DocDate, BillPassingXID, BillNo, BillDate, AssetTranDate, Perc, SlNo, InternalRemarks, ACTIVE, ISDELETED, CREATEDBY, CREATEDDATE, MODIFIEDBY, MODIFIEDDATE, VoucherXCode, Bill_NO, CurrXCode, CostCenterCode, VoucherTypeCode, AccCode, SledCode, accCodeDup,

1/27/2012 09:39:41.6718265 Information Flag12,

1/27/2012 09:39:41.8212463 Information 1/27/2012 9:39:41 AM: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 01000, ErrorCode: 10054, ErrorMsg: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).

1/27/2012 09:39:41.8349187 Information 1/27/2012 9:39:41 AM: Error: ODBC read failed

1/27/2012 09:39:41.9784768 Information 1/27/2012 9:39:41 AM: General Script Error

1/27/2012 09:39:41.9784768 Information 1/27/2012 9:39:41 AM: Execution Failed

1/27/2012 09:39:41.9941021 Information 1/27/2012 9:39:41 AM: Execution finished.

Reload Failed through Scheduler.

vijay_iitkgp — Tue, 31 Jan 2012 09:51:26 GMT

Hey Lalit,

This is not Qlikview error.There is something happening with your database and connection breaks with database. try to check with them if any maintenance task or anything else running at time of reload.

Vijay

Reload Failed through Scheduler.

lalitinmbd — Tue, 31 Jan 2012 10:24:03 GMT

Thanks alot Sir..