topic loading from excel file in QlikView

loading from excel file

stonecold111 — Sun, 11 Mar 2018 04:46:24 GMT

Hi Qlikss,

i have dashboard which got scheduled 10 times in a day. it is getting refreshed normally, but every once in a week its getting failed with following error. i am restarting this task manually, then it refreshes without any error. what could be the possible reasons.

Error: Excel file format error

2018-03-10 20:01:00 General Script Error

2018-03-10 20:01:00 Execution Failed

2018-03-10 20:01:00 Execution finished.

Re: loading from excel file

vishsaggi — Sun, 11 Mar 2018 06:12:40 GMT

Did you check the document log for this specific qvw file.

Does your qvw file access any SQL database tables? Are those tables were used by some other application or some read write happening on those tables at that point of time every week?

Re: loading from excel file

stonecold111 — Sun, 11 Mar 2018 08:05:09 GMT

Yeah some other SQL tables are but those are fine.

Yes you maybe right,even I thought same that these excel file is getting updated whenever refresh happens