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.

[lalitinmbd]

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.

[vijay_iitkgp]

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

[lalitinmbd]

Thanks alot Sir..